Filetype Excel XLS | Posted on 18 Aug 2022 | 3 years ago
Authentication
digital resources
154x Filetype XLS File size 0.05 MB Source: www.dfa.ms.gov
Sheet 1: Trip Optimizer System
| State Of Mississippi Trip Optimizer System: Car Rental vs Mileage Reimbursement Calculator | ||
| Traveler Name: Agency #: | Travel Dates: | |
| Input Variables | Chart Help: | |
| Total Miles to be Traveled During Trip | 240 | Input miles that exceed 100 miles per day (this example includes 2 days of travel at 120 miles per day) |
| Total Days in Trip (24-hr periods) | 4 | Use # of 24-hour periods (4 day trip = 4) |
| Total Miles to Rental Car location | 10 | Input only the distance to the rental car location (this mileage will be doubled in the total calculation formula) |
| Vehicle Rental Daily Price | $33.50 | Input price for rental vehicle using the vehicle rental rates (See Vehicle Rental Rates Tab) |
| Miscellaneous Fees* | $2.00 | Input any other fees charged including but not limited to sales tax, motor vehicle tax, and etc. to be charged due to form of payment |
| Cost of Gasoline per Gallon** | $1.95 | Input current pump price (Utilize the higher cost between city from which the travel will begin and the destination) |
| Mileage Reimbursement Rate (if pool car is available) | $0.17 | Current State Rate |
| Mileage Reimbursement Rate (if pool car is not available) | $0.535 | Current State Rate |
| Average Rental Car Gas Mileage (MPG) | 25 | Input average MPG for rental car type using the Average MPG chart (See Average MPG Tab) |
| Calculated Results | Calcuation Help: | |
| Personal Owned Vehicle Cost (No Pool Car Available) | ||
| Total Reimbursement Expense | $128.40 | = Total Miles to be Traveled X .535 |
| Personal Owned Vehicle Car Cost (Pool Car Available) | ||
| Total Reimbursement Expense | $40.80 | = Total Miles to be Traveled X .17 |
| Rental Car Cost | ||
| Rental Cost | $134.00 | = Total Days in Trip X Car Daily Rental Price |
| Taxes and Fees | $2.00 | = Total Amount of Additional Taxes and Fees |
| Refueling | $18.72 | = (Total Miles in Trip / Average MPG) X Cost of Gas per Gallon |
| Total Rental Cost | $165.42 | = Rental Cost + Taxes and Fees + Refueling + Distance from Home to Rental Car Location |
| Dollars Saved - No Pool Car Available | $37.02 | = Total Rental Cost - Total Reimbursement Expense @ .535/mi |
| Dollars Saved - Pool Car Available | $124.62 | = Total Rental Cost - Total Reimbursement Expense @ .17/mi |
| Special Conditions | ||
| * If the rental is not directly billed to the agency or charged on a Travel Card, sales and motor vehicle tax can be reimbursed. Contact the rental car company to obtain the added miscellaneous fees that will be added to the total, including tax from the city of which you will be renting. | ||
| ** Gas prices do fluctuate but an estimated price can be retrieved from sites such as www.gasbuddy.com. | ||
| David Dearman Auto Rentals: U - Save Car and Truck Rental | ||
| Contract # 8200015368 | Corporate ID: 1757/1785 | |
| Type | Daily | Weekly |
| Compact | $34.00 | $204.00 |
| Intermediate | $39.00 | $234.00 |
| Full Size | $44.00 | $264.00 |
| Luxury | $70.00 | $420.00 |
| Medium-Size Sport Utility | $69.00 | $414.00 |
| Mini-Van | $58.00 | $348.00 |
| Enterprise Rent - A - Car | ||
| Contract # 8200015385 | Corporate ID: XZ55012 | |
| Type | Daily | Weekly |
| Sub-Compact | $33.50 | $184.50 |
| Compact | $33.50 | $184.50 |
| Intermediate | $33.50 | $184.50 |
| Full Size | $43.00 | $236.50 |
| Luxury | $70.00 | $385.00 |
| Medium-Size Sport Utility | $59.00 | $324.50 |
| Mini-Van | $63.00 | $346.50 |
| Hertz Corporation | ||
| Contract # 8200015383 | Corporate ID: 68344 or 0068344 | |
| Type | Daily | Weekly |
| Sub-Compact | $34.00 | $204.00 |
| Compact | $34.00 | $204.00 |
| Intermediate | $34.00 | $204.00 |
| Full Size | $43.00 | $258.00 |
| Luxury | $75.00 | $450.00 |
| Medium-Size Sport Utility | $63.00 | $378.00 |
| Mini-Van | $63.00 | $378.00 |
| Landrum Enterprises: U - Save Car and Truck Rental (Meridian) | ||
| Contract # 8200015382 |
Corporate ID: 1413 | |
| Type | Daily | Weekly |
| Compact | $34.00 | $204.00 |
| Intermediate | $39.00 | $234.00 |
| Full Size | $44.00 | $264.00 |
| Luxury | $70.00 | $420.00 |
| Medium-Size Sport Utility | $69.00 | $414.00 |
| Mini-Van | $58.00 | $348.00 |
| One Source Enterprises: U - Save Car and Truck Rental (Starkville, Tupelo, Louisville) | ||
| Contract# 8200015361 | Corporate ID: MSU1 | |
| Type | Daily | Weekly |
| Sub-Compact | $34.00 | $204.00 |
| Compact | $34.00 | $204.00 |
| Intermediate | $38.00 | $234.00 |
| Full Size | $44.00 | $258.00 |
| Luxury | $69.00 | $415.00 |
| Medium-Size Sport Utility | $58.00 | $350.00 |
| Mini-Van | $60.00 | $360.00 |
| Vanguard/National Car Rental | ||
| Contract # 8200015367 | Corporate ID: XZ55012 |
|
| Type | Daily | Weekly |
| Sub-Compact | $39.50 | $217.25 |
| Compact | $39.50 | $217.25 |
| Intermediate | $37.50 | $217.25 |
| Full Size | $45.00 | $247.50 |
| Luxury | $70.00 | $385.00 |
| Medium-Size Sport Utility | $61.00 | $335.50 |
| Mini-Van | $65.00 | $357.50 |
no reviews yet
Please Login to review.
