Vehicle downtime reporting tool

• US 20060085218A1
• Filed: 10/19/2005
• Published: 04/20/2006
• Est. Priority Date: 10/19/2004
• Status: Abandoned Application

• Current Assignee: Freightliner Limited (Genesee & Wyoming Incorporated)
• Original Assignee: Freightliner Limited (Genesee & Wyoming Incorporated)
• Inventors: DeBoard, Tom D.
• Application Number:
  US11/254,329
• Publication Number:
  US 20060085218A1
• Time in Patent Office: Days
• US Class Current: 705/305
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 10/20 Administration of product repair or maintenance

Abstract

A vehicle downtime reporting tool comprises a computer-implemented interface to a database, wherein the database contains time-related information pertaining to a repair order for a vehicle, a computer-implemented downtime calculator that calculates the vehicle downtime by determining the time from a triggering event to an ending event, and a computer-implemented report provider that provides a report of the calculated downtime for the vehicle.

Claims

1. A vehicle downtime reporting tool, comprising:

a computer-implemented interface to a database, wherein the database contains time-related information pertaining to a repair order for a vehicle;

a computer-implemented downtime calculator that calculates the vehicle downtime by determining the time from a triggering event to an ending event; and

a computer-implemented report provider that provides a report of the calculated downtime for the vehicle.

2. The vehicle downtime reporting tool of claim 1, further comprising a graphical user interface (GUI) that displays the calculated downtime for the vehicle.

3. The vehicle downtime reporting tool of claim 1, further comprising a data extraction tool that extracts the at least some of the time-related information in the database from the database.

4. The vehicle downtime reporting tool of claim 3, further comprising a SQL query that groups a plurality of attributes from the extracted information.

5. The vehicle downtime reporting tool of claim 1, wherein the interface to the database includes ODBC links.

6. The vehicle downtime reporting tool of claim 1, further comprising screen scraping software that extracts data from a file sent to be printed, wherein the calculated downtime for the vehicle is also based on the extracted data.

7. The vehicle downtime reporting tool of claim 1, further comprising an interface to a dealer management system.

8. The vehicle downtime reporting tool of claim 1, wherein the computer-implemented report provider is Crystal Reports.

9. The vehicle downtime reporting tool of claim 1, wherein the triggering event corresponds to creation of the repair order.

10. The vehicle downtime reporting tool of claim 1, wherein the ending event corresponds to completion of work for the repair order.

11. A computer-implemented method of monitoring vehicle downtime, comprising:

connecting to a database;

extracting from the database data corresponding to a repair order for a vehicle in a vehicle repair facility;

extracting from the database data corresponding to time clock entries made by at least one vehicle technician doing work corresponding to the repair order for the vehicle; and

performing a downtime calculation based on at least some of the data extracted from the database.

12. The computer-implemented method of claim 11, further comprising displaying the downtime calculation in a graphical user interface (GUI).

13. The computer-implemented method of claim 12, further comprising:

continually performing the downtime calculation after a time interval according to a refresh rate; and

refreshing the displayed downtime calculation according to the refresh rate.

14. The computer-implemented method of claim 11, wherein the act of connecting to a database comprises creating ODBC links to the database.

15. The computer-implemented method of claim 11, wherein the act of performing the downtime calculation comprises determining when the repair order was created.

16. The computer-implemented method of claim 15, wherein the act of performing the downtime calculation further comprises determining when a final time clock entry was made by the vehicle technician.

17. The computer-implemented method of claim 16, wherein the act of performing the downtime calculation further comprises determining the time difference between when the repair order was created and when the final time clock entry was made by the vehicle technician.

18. The computer-implemented method of claim 17, wherein the act of performing the downtime calculation further comprises subtracting at least one unit of time from the determined time difference.

19. The computer-implemented method of claim 17, further comprising evaluating efficiency of the vehicle repair facility based on at least one downtime calculation.

20. A vehicle downtime reporting tool system, comprising:

a computer-implemented interface to a database containing a plurality of data fields, the plurality of data fields comprising a first timestamp and a second timestamp, wherein the first timestamp corresponds to when a repair order for a vehicle was created and the second timestamp corresponds to when a final job associated with the repair order has been completed;

a computer-implemented downtime calculating tool that calculates a downtime for the vehicle by subtracting the first timestamp from the second timestamp; and

a computer-implemented interface that displays the calculated downtime for the vehicle.