Method and system for managing a fleet of vehicles

• US 20060074702A1
• Filed: 10/06/2004
• Published: 04/06/2006
• Est. Priority Date: 10/06/2004
• Status: Abandoned Application

• Current Assignee: The Crawford Group Incorporated (Jack Taylor Family Voting Trust U A D 4 14 99)
• Original Assignee: The Crawford Group Incorporated (Jack Taylor Family Voting Trust U A D 4 14 99)
• Inventors: Kohler, Kurt Walter, Roxas, Glenn T., Stamps, David Keith, Fehr, John Dwight, Everson, Jeffrey Lee, Schuette, Thomas A., Ritzie, William Sean, Woods, Anthony Keith, Toh, Chee-Koon, Alkhas, Rebecca, Weas, Daniel Alan, Fehr, Milton
• Application Number:
  US10/959,925
• Publication Number:
  US 20060074702A1
• Time in Patent Office: Days
• US Class Current: 705/28
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

A system for providing a user with historical sales data for a plurality of vehicles comprising a fleet, the system comprising: (a) a database configured to store actual sales data for a plurality of vehicles that have previously been sold; and (b) a computer in communication with the database, the computer being configured to create a page for display to a user, the page including a display of a plurality of historical sales prices for at least one vehicle type that is similar to a user-selected vehicle type, wherein the displayed historical sales prices are calculated from the stored actual sales data and comprise historical sales prices for the at least one similar vehicle type that have been normalized to an average time of sale odometer reading. Also disclosed herein is a computer-implemented method for selecting which of a plurality of vehicles within a fleet are to be deleted from the fleet; the method comprising: (a) displaying, on an electronic page presented to a computer user, a value analysis for at least one type of vehicle within a rental vehicle fleet; (b) providing at least one link on the electronic page for selection by the user to initiate a deletion from the fleet of at least one fleet vehicle corresponding to the at least one vehicle type; and (c) responsive to user selection of the at least one link, displaying a list of fleet vehicles for selectable deletion from the fleet by the user, the listed fleet vehicles corresponding to vehicles of the at least one vehicle type.

Claims

1. A system for determining a normalized sales price as of a time period for a representative member of a selected vehicle type group, the system including a computer configured to access a database, the database storing historical sales data for members of said group, said historical sales data including actual sales prices, and said computer being further configured to normalize each of said actual sales prices to a representative member of said group and then combine said normalized actual sales prices to determine at least one normalized sales price for said representative member.

2. The system of claim 1 wherein said historical sales data for each member of said group includes an associated time of sale odometer reading, and wherein said representative member is determined by combining the time of sale odometer readings of said members.

3. The system of claim 2 wherein said computer is further configured to normalize said actual sales prices by adjusting each actual sales price corresponding to its associated time of sale odometer reading as compared said representative member.

4. The system of claim 3 wherein the selected vehicle type group is a YMMS.

5. The system of claim 3 wherein said computer is configured to combine said normalized actual sales prices by averaging them.

6. The system of claim 5 wherein said database further includes a cost per time of sale odometer reading table, and wherein said computer is configured to access said cost per time of sale odometer reading table to normalize said actual sales prices.

7. The system of claim 6 wherein said computer is further configured to display said normalized sales price to a user.

8. A method for determining a normalized sales price as of a time period for a representative member of a selected vehicle type group, the method comprising:

accessing stored historical sales data for members of said group, said historical sales data including actual sales prices;

normalizing each of said actual sales prices to a representative member of said group; and

combining said normalized actual sales prices to determine at least one normalized actual sales price for said representative member.

9. The method of claim 8 wherein historical sales data for each member of said group includes an associated time of sale odometer reading, and wherein the method further comprises:

determining said representative member by combining the time of sale odometer readings of said members.

10. The method of claim 9 wherein said normalizing step further comprises normalizing said actual sales prices by adjusting each actual sales price corresponding to its associated time of sale odometer reading as compared to the said representative member.

11. The method of claim 10 wherein the selected vehicle type group is a YMMS.

12. The method of claim 10 wherein the step of combining said normalized actual sales prices comprises combining said normalized actual sales prices by averaging them.

13. The method of claim 12 wherein said normalizing step includes accessing a cost per time of sale odometer reading table to determine an adjustment for use in normalizing said actual sales prices.

14. The method of claim 13 further comprising displaying said normalized sales price to a user.

15. A system for providing a user with historical sales data for a plurality of vehicles comprising a fleet, the system comprising:

a database configured to store actual sales data for a plurality of vehicles that have previously been sold; and

a computer in communication with the database, the computer being configured to create a page for display to a user, the page including a display of a plurality of historical sales prices for at least one vehicle type that is similar to a user-selected vehicle type, wherein the displayed historical sales prices are calculated from the stored actual sales data and comprise historical sales prices for the at least one similar vehicle type that have been normalized to an average time of sale odometer reading.

16. The system of claim 15 wherein the stored actual sales data comprises stored actual sales data for a plurality of fleet vehicles, wherein the stored actual sales data comprises, for each fleet vehicle that has previously been sold, an identification of a vehicle type therefor, a sales price therefor, and an odometer reading therefor at the time of sale, and wherein the computer is further configured to calculate the historical sales prices by:

calculating an average odometer reading at the time of sale for a plurality of the previously sold vehicles of a vehicle type group, the vehicle type group comprising at least one vehicle type that is the same or similar to the user-selected vehicle type;

for each vehicle type of the vehicle type group, (1) normalizing the stored sales prices for a plurality of previously sold vehicles of that vehicle type such that the stored sales prices are normalized to the calculated average odometer reading, and (2) calculating an average normalized sales price from the normalized sales prices.

17. The system of claim 16 wherein the computer is further configured to normalize the stored sales prices using a cost per time of sale odometer reading data table.

18. The system of claim 17 wherein the vehicle types are specified in terms of a year, make, model, and series (YMMS).

19. The system of claim 18 wherein the user-selected vehicle type comprises a current year YMMS, wherein the vehicle type group is a YMMS group, and wherein the YMMS group comprises the current year YMMS and at least one other YMMS similar thereto.

20. The system of claim 19 wherein the stored actual sales data further comprises, for each fleet vehicle that has previously been sold, a month of sale, and wherein the computer is further configured to calculate the historical sales prices on a per month basis such that (1) each calculated average time of sale odometer reading represents the average time of sale odometer reading for a plurality of previously sold vehicles of the YMMS group that were sold in a particular month across a plurality of years of sale and (2) each YMMS'"'"'s average normalized sales price represents that average normalized sales price for a plurality of previously sold vehicles of that YMMS that were sold in a particular month.

21. The system of claim 20 wherein the computer is further configured to calculate, for a plurality of months, a month-to-month change in the average normalized sales price for each YMMS within the YMMS group.

22. The system of claim 21 wherein the page presents the calculated average normalized sales prices in a table comprising a plurality of rows and a plurality of columns, wherein each column corresponds to a month of the year, wherein at least one row displays the calculated average time of sale odometer reading for each month, and wherein at least one row corresponds to a previous year YMMS within the YMMS group and displays the average normalized sales price for that previous year YMMS for each month.

23. The system of claim 22 wherein at least one additional row of the table corresponds to another previous year YMMS within the YMMS group and displays the average normalized sales price for the another previous year YMMS for each month.

24. The system of claim 23 wherein the rows are arranged chronologically by the year corresponding to each row'"'"'s YMMS.

25. The system of claim 22 wherein the table further comprises a row for each YMMS within the YMMS group, these plurality of rows displaying the calculated month-to-month average normalized sales price changes.

26. The system of claim 25 wherein the computer is further configured to calculate, for a plurality of months, a year-to-year change in a given month'"'"'s average normalized sales price for a particular YMMS within the YMMS group relative to that given month'"'"'s average normalized sales price for a YMMS of the year previous to that particular YMMS.

27. The system of claim 26 wherein the table further comprises another row for each YMMS within the YMMS group, these plurality of another rows displaying the calculated year-to-year average normalized sales price changes.

28. The system of claim 24 wherein the table further includes, in a row corresponding to the user-selected YMMS, at least one field for user entry of a residual value estimate for the user-selected YMMS, wherein the residual value estimate is applicable to a current or future month.

29. The system of claim 28 wherein the page further includes a link selectable by the user for to display another page, the another page presenting a cost going forward (CGF) analysis to the user that is applicable to the user-selected YMMS, the CGF analysis being based at least in part upon the at least one user-entered residual value estimate.

30. The system of claim 29 wherein the CGF analysis is further based at least in part upon a user-specified projection period.

31. The system of claim 19 wherein the computer is further configured to limit which previously sold fleet vehicles are considered in the historical sales price calculations on the basis of at least one user-specified criteria.

32. The system of claim 31 wherein the at least one user-specified criteria comprises a geographical constraint.

33. The system of claim 15 wherein the computer is accessible to a plurality user computers via an intranet.

34. The system of claim 15 wherein the computer is accessible to a plurality user computers via the Internet.

35. An apparatus for providing a user with historical sales data for a plurality of vehicles comprising a fleet, the apparatus comprising:

a computer in communication with a database, the database being configured to store actual sales data for a plurality of vehicles that have previously been sold, wherein the computer is configured to create a page for display to a user, the page including a display of a plurality of historical sales prices for at least one vehicle type that is similar to a user-selected vehicle type, wherein the displayed historical sales prices are calculated from the stored actual sales data and comprise historical sales prices for the at least one similar vehicle type that have been normalized to an average time of sale odometer reading.

36. The apparatus of claim 35 wherein the stored actual sales data comprises stored actual sales data for a plurality of fleet vehicles, wherein the stored actual sales data comprises, for each fleet vehicle that has previously been sold, an identification of a vehicle type therefor, a sales price therefor, and an odometer reading therefor at the time of sale, and wherein the computer is further configured to calculate the historical sales prices by:

calculating an average odometer reading at the time of sale for a plurality of the previously sold vehicles of a vehicle type group, the vehicle type group comprising at least one vehicle type that is the same or similar to the user-selected vehicle type;

for each vehicle type of the vehicle type group, (1) normalizing the stored sales prices for a plurality of previously sold vehicles of that vehicle type such that the stored sales prices are normalized to the calculated average odometer reading, and (2) calculating an average normalized sales price from the normalized sales prices.

37. The apparatus of claim 36 wherein the computer is further configured to normalize the stored sales prices using a cost per time of sale odometer reading data table.

38. The apparatus of claim 37 wherein the vehicle types are specified in terms of a year, make, model, and series (YMMS).

39. The apparatus of claim 38 wherein the user-selected vehicle type comprises a current year YMMS, wherein the vehicle type group is a YMMS group, and wherein the YMMS group comprises the current year YMMS and at least one other YMMS similar thereto.

40. The apparatus of claim 39 wherein the stored actual sales data further comprises, for each fleet vehicle that has previously been sold, a month of sale, and wherein the computer is further configured to calculate the historical sales prices on a per month basis such that (1) each calculated average time of sale odometer reading represents the average time of sale odometer reading for a plurality of previously sold vehicles of the YMMS group that were sold in a particular month across a plurality of years of sale and (2) each YMMS'"'"'s average normalized sales price represents that average normalized sales price for a plurality of previously sold vehicles of that YMMS that were sold in a particular month.

41. The apparatus of claim 40 wherein the computer is further configured to calculate, for a plurality of months, a month-to-month change in the average normalized sales price for each YMMS within the YMMS group.

42. The apparatus of claim 41 wherein the page presents the calculated average normalized sales prices in a table comprising a plurality of rows and a plurality of columns, wherein each column corresponds to a month of the year, wherein at least one row displays the calculated average time of sale odometer reading for each month, and wherein at least one row corresponds to a previous year YMMS within the YMMS group and displays the average normalized sales price for that previous year YMMS for each month.

43. The apparatus of claim 42 wherein at least one additional row of the table corresponds to another previous year YMMS within the YMMS group and displays the average normalized sales price for the another previous year YMMS for each month.

44. The apparatus of claim 43 wherein the rows are arranged chronologically by the year corresponding to each row'"'"'s YMMS.

45. The apparatus of claim 42 wherein the table further comprises a row for each YMMS within the YMMS group, these plurality of rows displaying the calculated month-to-month average normalized sales price changes.

46. The apparatus of claim 45 wherein the computer is further configured to calculate, for a plurality of months, a year-to-year change in a given month'"'"'s average normalized sales price for a particular YMMS within the YMMS group relative to that given month'"'"'s average normalized sales price for a YMMS of the year previous to that particular YMMS.

47. The apparatus of claim 46 wherein the table further comprises another row for each YMMS within the YMMS group, these plurality of another rows displaying the calculated year-to-year average normalized sales price changes.

48. The apparatus of claim 44 wherein the table further includes, in a row corresponding to the user-selected YMMS, at least one field for user entry of a residual value estimate for the user-selected YMMS, wherein the residual value estimate is applicable to a current or future month.

49. The apparatus of claim 48 wherein the page further includes a link selectable by the user for to display another page, the another page presenting a cost going forward (CGF) analysis to the user that is applicable to the user-selected YMMS, the CGF analysis being based at least in part upon the at least one user-entered residual value estimate.

50. The apparatus of claim 49 wherein the CGF analysis is further based at least in part upon a user-specified projection period.

51. The apparatus of claim 39 wherein the computer is further configured to limit which previously sold fleet vehicles are considered in the historical sales price calculations on the basis of at least one user-specified criteria.

52. The apparatus of claim 51 wherein the at least one user-specified criteria comprises a geographical constraint.

53. The apparatus of claim 35 wherein the computer is accessible to a plurality user computers via an intranet.

54. The apparatus of claim 35 wherein the computer is accessible to a plurality user computers via the Internet.

55. A method for a providing a user with historical sales data related to a plurality of vehicles comprising a fleet, the method comprising:

receiving input from the user indicative of a vehicle type;

for each of a plurality of previously sold vehicles corresponding to the selected vehicle type, determining an actual sales price and an actual time of sale odometer reading therefor;

determining an average time of sale odometer reading from at least a plurality of the determined actual time of sale odometer readings;

normalizing at least a plurality of the determined actual sales prices to the determined average time of sale odometer reading;

averaging the normalized sales prices together; and

displaying the average of the normalized sales prices to the user.

56. The method of claim 55 wherein the previously sold vehicles comprise previously sold fleet vehicles, wherein the selected vehicle type has an associated vehicle type group, the vehicle type group comprising the selected vehicle type and at least one other vehicle type, and wherein:

the actual sales price and actual time of sale odometer reading determining step comprises, for each of a plurality of previously sold fleet vehicles corresponding to the vehicle type group associated with the selected vehicle type, determining an actual sales price and an actual time of sale odometer reading therefor;

the averaging step comprises categorizing the actual sales prices by vehicle type and averaging together the normalized sales prices that are commonly categorized to thereby create a plurality of average normalized sales prices, each average normalized sales price corresponding to a different vehicle type; and

the displaying step comprises displaying the averages of the normalized sales prices to the user.

57. The method of claim 56 wherein the user-selected vehicle type is a year, make, model, and series (YMMS).

58. The method of claim 57 wherein the normalizing step normalizes the actual sales prices to the determined average time of sale odometer reading using a cost per odometer reading data table.

59. The method of claim 58 wherein the cost per odometer reading data table relates a plurality of odometer readings for a vehicle type to a plurality of estimated values determined at least partially on the basis of a statistical model, wherein the average time of sale odometer reading step is performed on a per month basis across a plurality of years, and wherein the normalizing step and the averaging step are performed on a per month per year basis.

60. The method of claim 55 wherein the fleet comprises a plurality of rental vehicles.

61. The method of claim 55 wherein the fleet comprises a plurality of leased vehicles.

62. A computer-implemented method for selecting which of a plurality of vehicles within a fleet are to be deleted from the fleet;

the method comprising;

displaying, on an electronic page presented to a computer user, a value analysis for at least one type of vehicle within a vehicle fleet;

providing at least one link on the electronic page for selection by the user to initiate a deletion from the fleet of at least one fleet vehicle corresponding to the at least one vehicle type; and

responsive to user selection of the at least one link, displaying a list of fleet vehicles for selectable deletion from the fleet by the user, the listed fleet vehicles corresponding to vehicles of the at least one vehicle type.

63. The method of claim 62 wherein the vehicle fleet is a rental vehicle fleet, wherein the value analysis is a cost going forward (CGF) analysis, and wherein the vehicle type is a year, make, model, and series (YMMS).

64. The method of claim 63 wherein the displaying step comprises displaying, on the electronic page, a cost going forward (CGF) analysis for each YMMS within the fleet corresponding to a user-selected vehicle class.

65. The method of claim 64 wherein the displaying step further comprises displaying a count of vehicles within the fleet for each YMMS corresponding to the user-selected vehicle class.

66. The method of claim 65 wherein the providing step comprises providing a plurality of links, each link being associated with a different one of the YMMSs corresponding to the user-selected vehicle class and being selectable by the user to initiate a deletion of at least one vehicle from the fleet that corresponds to the link'"'"'s associated YMMS.

67. The method of claim 66 wherein the step of displaying a list of vehicles for selectable deletion from the fleet by the user comprises displaying a list of fleet vehicles within the YMMS corresponding to the selected link for selectable deletion by the user.

68. The method of claim 62 further comprising:

responsive to user selection of at least one vehicle from the list, sending an electronic message to a person having managerial control over that vehicle, wherein the message informs that person that that vehicle is to be deleted from the fleet.

69. The method of claim 62 further comprising:

responsive to user selection of at least one vehicle from the list, creating a flag in a fleet database that that vehicle is to be deleted from the fleet.

70. The method of claim 62 wherein the fleet comprises a plurality of rental vehicles.

71. The method of claim 62 wherein the fleet comprises a plurality of leased vehicles.

72. A method for creating a group of similar vehicle types to facilitate a historical sales price analysis of similar vehicles within a fleet of vehicles, the method comprising:

receiving an identification from user of at least one vehicle type;

receiving input from the user that indicates each identified vehicle type is deemed by the user to be similar to another vehicle type; and

responsive to the received user input, creating a vehicle type group comprising each identified vehicle type and the another vehicle type, the created group for use in performing a historical sales analysis of vehicle types that are similar to a user-selected vehicle type.

73. The method of claim 72 wherein the vehicle type is year, make, model, and series (YMMS).

74. The method of claim 73 wherein the identification receiving step further comprises receiving identifications of a plurality of YMMSs.

75. The method of claim 74 wherein the another vehicle type is a user-selected YMMS.

76. The method of claim 75 wherein at least two of the identified YMMSs are YMMSs of the same year.

77. A system for providing a user with data about a fleet comprising a plurality of vehicles, the apparatus comprising:

a database configured to store data relating to a plurality of vehicles comprising a fleet, the stored data including an identification of a vehicle classification for each fleet vehicle, the database being updated with vehicle data on a periodic basis, the periodic basis being either a regular periodic basis or an irregular periodic basis;

a computer in communication with the database, the computer being configured to;

process the stored data to (1) determine a total number of vehicles within the fleet, (2) determine a total count of fleet vehicles for each of a plurality of vehicle classifications, and (3) determine a mix percentage for each vehicle classification from the determined total number and the determined total counts, each mix percentage representing how much of the total fleet count is made up of fleet vehicles of a given vehicle class; and

create a page for display to a user that displays the determined total counts and the determined mix percentages together with their corresponding vehicle classes, the displayed counts and mix percentages being current as to the last time the database was updated each time that the page is created and displayed.

78. The system of claim 77 wherein the page includes a table, the table identifying the plurality of vehicle classes and identifying the determined total counts and the determined mix percentages for each vehicle class.

79. The system of claim 78 wherein the fleet comprises a plurality of rental vehicles.

80. The system of claim 78 wherein the fleet comprises a plurality of leased vehicles.