Spreadsheet: 095676db-a4a2-4df7-bebe-a9faa303166e
Sheet: Sheet1

Unnamed: 0 | OFMS Vehicle Justification Calculator | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 | A Vehicle Lifecycle Cost Comparison Tool
 | Vehicle Acquisition / Usage Data
 | Enter Acquisition Cost |  |  | 20246 |  |  |  |  |  |  |  |  |  | 1 | 0.565
 | Enter Annual Finance Percentage |  |  | 0 |  |  |  |  |  |  |  |  |  | 10 | 5.649999999999999 | 3.564196363636364
 | Enter Fuel Price per [NAME] |  |  | 2.72 |  |  |  |  |  |  |  |  |  | 100 | 56.49999999999999 | 35.64196363636364
 | Enter Annual Operational Cost |  |  | 1527.84 |  |  |  |  |  |  |  |  |  | 500 | 282.5 | 178.2098181818182
 | Enter the Estimated MPG |  |  | 25 |  |  |  |  |  |  |  |  |  | 1000 | 565 | 356.4196363636364
 | Enter Expected Monthly Mileage |  |  | 1486 |  |  |  |  |  |  |  |  |  | 1500 | 847.4999999999999 | 534.6294545454546
 | Enter One-way Commuting Distance |  |  | 10 |  |  |  |  |  |  |  |  |  | 2000 | 1130 | 712.8392727272727
 | Enter Commuting Days Per Week |  |  | 5 |  |  |  |  |  |  |  |  |  | 2500 | 1412.5 | 891.049090909091
 | Standard IRS Reimbursement Rate |  |  | 0.565 |  |  |  |  |  |  |  |  |  | 3000 | 1695 | 1069.258909090909
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3500 | 1977.5 | 1247.468727272727
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4000 | 2260 | 1425.678545454545
 | Summary |  |  |  |  |  |  |  |  |  |  |  |  | 4500 | 2542.5 | 1603.888363636364
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000 | 2825 | 1782.098181818182
 | Accumulated Mileage |  | 110000 |  |  |  |  |  |  |  |  |  |  | 5500 | 3107.5 | 1960.308
 | Life Cycle Max Months |  | 74 |  |  |  |  |  |  |  |  |  |  | 6000 | 3390 | 2138.517818181818
 | Years in Service |  | 6.166666666666667 |  |  |  |  |  |  |  |  |  |  | 6500 | 3672.5 | 2316.727636363637
 | Operational Cost |  | 9421.68 | 127.32 | Per Month |  |  |  |  |  |  |  |  | 7000 | 3955 | 2494.937454545455
 | Fixed Cost |  | 27238.16 | 0.2476196363636364 | Per Mile |  |  |  |  |  |  |  |  | 7500 | 4237.5 | 2673.147272727273
 | Fuel Cost |  | 11968 | 0.1088 | Per Mile |  |  |  |  |  |  |  |  | 8000 | 4520 | 2851.357090909091
 | Total Lifetime cost |  | 39206.16 | 6357.755675675676 | Per Year |  |  |  |  |  |  |  |  | 8500 | 4802.5 | 3029.566909090909
 | Monthly Cost |  | 529.8129729729731 | 26.49064864864865 | Daily Rate |  |  |  |  |  |  |  |  | 9000 | 5084.999999999999 | 3207.776727272727
 | Total Cost Per Mile |  | 0.3564196363636364 |  |  |  |  |  |  |  |  |  |  | 9500 | 5367.499999999999 | 3385.986545454546
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 | 5649.999999999999 | 3564.196363636364
 |  |  |  |  | At this Utlization Level - it is more economical to provide a Commonwealth-Owned Vehicle
 | For Commuting Approval Only
 |  | Monthly Cost of Commuting |  |  |  |  | Lifetime Commuting Use Costs
 | Monthly | Commuting Mileage |  | 400 |  | Fixed Cost |  | 10553.47510094213
 | Personal | Commuting Use |  | 0.2691790040376851 |  | Fuel Cost |  | 3221.534320323015
 | Monthly | Commuting Cost |  | 142.6145283911098 |  | Total Commuting Cost |  | 10553.47510094213
 |  | Monthly Cost of Business |  |  |  |  | Lifetime Business Use costs
 | Monthly | Business Mileage |  | 1086 |  | Fixed Cost |  | 16684.68489905787
 | Commonwealth | Business Use |  | 0.730820995962315 |  | Fuel Cost |  | 8746.465679676985
 | Monthly | Business Cost |  | 387.1984445818632 |  | Total Business Cost |  | 25431.15057873486
 |  |  |  |  | Commuting Assignment not Approved .