To access the program, type FLTCST (RET) at any menu "OPTION:" field or the appropriate number on the Fleet Accounting Menu. The screen will then display:
| OPTION: FLEET COST REPORT 1 Start Date 10-03-05 2 End Date 10-04-05 3 Allow Tax Refund N 4 Allow Cashback N 5 Start Veh Number FIRST 6 End Veh Number LAST 7 Start License # FIRST 8 End License # LAST 9 Owning Location ALL 10 Class ALL 11 Make ALL 12 Model ALL 13 Model Year ALL 14 Legal Owner ALL 15 Purchase Dealer ALL 16 Sort Order 1 17 Detail/Summary S 18 Print/Display P 19 Printer prtspool 1PRINT 2 3ERASE 4 5 6 7HELP 8 |
Enter data as follows:
|
1. START DATE |
Using your selected date format, enter the starting date. Vehicles with a disposal date before this date are not included in the report. ("Disposal Date is defined as either the Sale Date, Accepted Date, or Eligible Date - whichever one is encountered first when checked in this sequence.) Press (RET) to default to yesterday's date. EXAMPLE: Press (RET) |
|
2. END DATE |
Using your selected date format, enter the End Date. Vehicles with an In-Service Date after this date will be excluded from the report. Press (RET) to default to the current date. EXAMPLE: Press (RET) |
|
3. ALLOW TAX REFUND |
A field in the Vehicle Inventory record is used by a particular CARS+ customer to calculate a tax refund based on a percentage. For that user, this field is used to indicate whether or not the Tax Refund amount should be deducted from the Loan Cost when calculating the Cost Per Day and Period Cost. Other users can ignore this field. |
|
4. ALLOW CASHBACK |
A field in the Vehicle Inventory record is used to record rebates. If it used, this field is used to indicate whether or not the Cashback amount should be deducted from the Loan Cost when calculating the Cost Per Day and the Period Cost. If the Cashback field has not been used in the Vehicle Inventory records, you can ignore this field. |
|
5. START VEH NUMBER |
Enter up to 6 alphanumeric characters to indicate the starting Vehicle Number. Press (RET) to default to the FIRST Vehicle Number. EXAMPLE: Type 5C0012 (RET) |
|
6. END VEH NUMBER |
Enter up to 6 alphanumeric characters to indicate the ending Vehicle Number. Press (RET) to default to the LAST Vehicle Number. EXAMPLE: Press (RET) |
|
7. START LICENSE # |
Enter up to 11 alphanumeric characters to indicate the starting License Plate Number. Press (RET) to default to the FIRST License Plate Number EXAMPLE: Press (RET) |
|
8. END LICENSE # |
Enter up to 11 alphanumeric characters to indicate the ending License Plate Number. Press (RET) to default to the LAST License Plate Number EXAMPLE: Press (RET) |
|
9. OWNING LOCATION |
For the vehicle owning location, enter:
EXAMPLE: Type TUS (RET) |
|
10. CLASS |
Enter up to 4 alphanumeric characters to select a single vehicle Class. Press (RET) to include all Classes. Or press Shift/F7 to view a list of vehicle Classes. Depending on the Classes that are set up for the user's location, the window will look something like this: SEARCH CLASSES BY DESCRIPTIONS ? Code Description Min Age Prc Code CCAR COMPACT 2 DR C CDAR COMPACT 4 DR C ECAR ECONOMY C FDAR FULL F IDAR MIDSIDE C MVAR MINIVAN 25 F XFAR SPORT UTILITY 25 L EXAMPLE: Press (RET) |
|
11. MAKE |
Enter up to 8 alphanumeric characters to select a single Make of vehicle. Or, press (RET) to include all Makes. EXAMPLE: Press (RET) |
|
12. MODEL |
Enter up to 8 alphanumeric characters to select a single Model of vehicle. Or, press (RET) to include all Models. EXAMPLE: Press (RET) |
|
13. MODEL YEAR |
Enter 2 numeric characters to select a single Model Year. Or, press (RET) to include all Model Years.. EXAMPLE: Press (RET) |
|
14. LEGAL OWNER |
To limit the report to vehicles with a particular legal owner, enter the Vendor Code for that owner. Or, press (RET) to include all vehicles regardless of Legal Owner. EXAMPLE: Type FMC (RET) |
|
15. PURCHASE DEALER |
To limit the report to vehicles that were purchased from a particular dealer, enter the Vendor Code for that owner. Or, press (RET) to include all vehicles regardless of where purchased. EXAMPLE: Type MORCHEV (RET) |
|
16. SORT ORDER |
Use the Shift/F7 keys to bring up a list of choices which are: 1 = Vehicle Number 2 = Vehicle License Plate 3 = Owning Location a 4 = Legal Owner 5 = Purchase Dealer 6 = Make/ Model 7 = In Service Dae 8 = Disposal Date EXAMPLE: Type 6 (RET) User tip: On sorts 3 -8, a subtotal prints after each sort change. Within the sort, the vehicles are listed by vehicle number. |
|
17. DETAIL/ SUMMARY |
Enter:
EXAMPLE: Type D (RET) |
|
18. PRINT/ DISPLAY |
Enter:
EXAMPLE: Type P (RET) |
|
19. PRINTER |
If this report should be printed at a printer other than the default printer shown here, enter the device name of the printer. EXAMPLE: Press (RET) |
PRESS "F1" AT "OPTION:" TO BEGIN .
Notes about this report:
Most the of the columns for this report are self-explanatory such as Vehicle Number, License Plate, Owning Location, Class, Make, Model, etc. The data in the following 2 columns, however, is derived from calculations:
Cost Per Day calculation:
For vehicle records with an Accepted Date, the difference between the In-Service Date and the Accepted Date is calculated to arrive at "days in fleet".
For vehicles without an Accepted Date, the difference between the In-Service Date and the Eligible Date is calcualted to arrive at "days in fleet".
If the "Allow Tax Refund" field (Field 3 of this report) is set to "Y", the Tax Refund field in the Inventory record is deducted from the Inventory Loan Amount.
If the "Allow Cashback" field (Field 4 of this report) is set to "Y", the Cashback field in the Inventory record is deducted from the Inventory Loan Amount.
Finally, the Loan Amount (which may be reduced by the Tax Refund and/or Cashback amounts) is divided by the "days in fleet" figure to arrive at the Cost Per Day calculation.
Period Cost calculation:
One day is added to all calculations in order to obtain a calendar day calculation rather than a 24hr rental day.
If the In Service Date is after the requested Start Date (Field 1 of this report), and the Accepted Date or Eligible Date is earlier than the End Date (Field 2 of this report), the difference is found between the In Service Date and the Accepted or Eligible Date. The result is multiplied by the Cost Per Day.
If the In Service Date is after the requested Start Date (Field 1 of this report), and the Accepted Date or Eligible Date is after than the End Date (Field 2 of this report), the difference is found between the In Service Date and the End Date. The result is multiplied by the Cost Per Day.
If the In Service Date is earlier than the requested Start Date (Field 1 of this report), and the Accepted Date or Eligible Date is earlier than the End Date (Field 2 of this report), the difference is found between the Start Date and the Accepted or Eligible Date. The result is multiplied by the Cost Per Day.
If the In Service Date is earlier than the requested Start Date (Field 1 of this report), and the Accepted Date or Eligible Date is after than the End Date (Field 2 of this report), the difference is found between the Start Date and the End Date. The result is multiplied by the Cost Per Day.
If the In Service Date field is blank, the word "ERROR" prints in the In Service Date column. Period Costs are not calculated for vehicles with a blank In Service Date field.
If both the Eligible Date and Accepted Date fields are blank, the word "ERROR" prints in the column. Period Costs are not calculated for vehicles where the Eligible Date and the Accepted Date fields are both blank,