Fleet Cost Simulation Overview
This is a modified version of a simulation I built for a 5 year planning project.
The model has more triggers for interaction, but fewer assets and no historical
information for preset inputs. The project was a five year forecast for a deal.
This model uses an initial average annual cost rate and quantity. These variables are the cost and quantity on hand today (Year 0).
Sedans
Cost: $2,000
Quantity: 25
Pickup Trucks
Cost: $5,000
Quantity: 200
Medium Duty Trucks
Cost: $9,000
Quantity: 100
Trailers
Cost: $500
Quantity: 200
Backhoes
Cost: $1,200
Quantity: 50
The model then uses global and asset specific inputs to simulate the average annual costs for each asset and the combined fleet cost. The global input is average inflation and the standard deviation for inflation. Each asset has a growth rate and standard deviation for the growth rates, and growth rate and standard deviation for the cost. The model also provides inputs for number of simulations and number of years.
The model presents the final year cost for each asset cost and the combined cost. It also generates graphs for the indivial cost and the combined cost with uncertainity bands.
This model uses an initial average annual cost rate and quantity. These variables are the cost and quantity on hand today (Year 0).
Sedans
Pickup Trucks
Medium Duty Trucks
Trailers
Backhoes
The model then uses global and asset specific inputs to simulate the average annual costs for each asset and the combined fleet cost. The global input is average inflation and the standard deviation for inflation. Each asset has a growth rate and standard deviation for the growth rates, and growth rate and standard deviation for the cost. The model also provides inputs for number of simulations and number of years.
The model presents the final year cost for each asset cost and the combined cost. It also generates graphs for the indivial cost and the combined cost with uncertainity bands.