Build a fleet cost model that operations can challenge

A spreadsheet can compare vehicle options convincingly while concealing the operating assumptions that determine its result. The most useful fleet cost model is understandable to dispatch, facilities and maintenance teams as well as finance. Their scrutiny helps establish whether the projected operation can actually be delivered.

Define the comparison first

Specify the service being supported and the period of assessment. Keep vehicle configuration, work demand and the treatment of support costs consistent across options. A comparison between an equipped commercial vehicle and an unconverted alternative creates a false impression before the energy calculation even begins. Record every important difference that cannot be normalised.

Decide whether the model covers a vehicle, a route group or the fleet programme. Infrastructure shared across several vehicles needs an allocation method that reflects the question being asked. A first deployment may carry installation work that later vehicles can use. Presenting that shared investment transparently is more helpful than forcing it into a misleading per vehicle figure.

Make operating inputs traceable

Use identifiable sources for mileage, energy consumption, tariffs, maintenance and financing assumptions. State the date and conditions of each input. Quotes and trial records should be distinguishable from editorial estimates or planning allowances. A reviewer needs to know which cells can be updated with better evidence and which represent a deliberate management judgement.

Include activities that can require additional time: charging diversions, bay movements, fault handling and replacement vehicle arrangements. Avoid assigning a cost to every activity without evidence, but do not erase an operational dependency because its cost is currently unknown. Keep unresolved items visible and explain how the organisation will investigate them.

Show the sensitivities

Change the inputs that materially influence the choice and show what happens to the recommendation. These may include utilisation, energy cost, charging mix, infrastructure expansion or disposal value. Test coherent operating scenarios rather than changing one number while leaving assumptions that would also be affected untouched. The result should describe plausible decisions.

Discuss those scenarios with the teams responsible for delivering them. If a favourable case depends on overnight depot charging, confirm that the parking and connection routine supports it. If it assumes shared vehicles, ask whether booking and cargo handling make sharing feasible. Financial attractiveness does not establish operational readiness by itself.

Keep a decision record

Write down why the preferred option was selected, which uncertainties were accepted and when they will be reviewed. This turns the spreadsheet into a management tool. It also prevents later changes in assumptions from being interpreted without the context of the original decision or the alternatives available at the time.

During deployment, compare recorded performance with the model's assumptions and investigate material differences. The aim is to improve the next decision, not to defend the original forecast at any cost. A fleet cost model earns trust when operations can challenge it, finance can trace it and the organisation can revise it as its understanding becomes stronger.