Information system: Mileage tracker - siddharthanegi/tyre-manager GitHub Wiki

Information system: Mileage tracker We want to create an information system which will track the total number of miles driven by tyres on a bus to know the right time to replace them Business process 1: Inventory Activities:

  1. Maintaining the stock of tyres of required brands
  2. replacing the tyre when a tyre reaches its threshold miles Requirement:
  3. Details of tyre: brand, purchased date, cost

Master table:

  1. Tyre master: Tyre ID, brand, max life of tyre
  2. bus master: Bus ID, no of tyres on each bus

Forms:

  1. inventory update form: should include all the details of the tyre, purchase date ( and can add some more details)
  2. back order request form: in case the tyre is not in stock, then a form to place an order with the vendor Reports: standard inventory report

Business process 2: Operations Activities:

  1. Tracking the trip distance of a bus and updating the total miles driven for each tyre on that bus Requirement: To run a logic in which it updates miles for each tyre and checks with max of the tyre. If the tyre has max life of 30k miles, then the threshold should be set at 29k miles, and the logic would check if the tyre has reached 29k; once the tyre reaches the threshold miles, the system should generate a notification to notify that its time to change the tyre Master Table: Bus-tyre master: Bus ID, Tyre ID, miles Form requirement: Mileage update form: should contain source, destination, total distance etc Reports: Current status report

Business Process 3: Analysis Once the tyre has reached its threshold, a notification is sent to the analytics team. Here the analytics team would get a report of all the tyre that has been used by the company, historic data to compare the performance of all tyres. Requirements: Master data: Observation/analysis master: tyre id, date of purchase etc (can add few more things, but just from a reporting point of view) Reports: current and final status of tyres, drop down option to choose the tyre, brand-wise, and check how many have already been worn out and how many are currently in use