Excel Consulting Services in Danville, VA

Cash cost of ownership, per asset, per year

The first build is a cash cost of ownership for each significant asset, and the point of it is that nothing in the accounts currently produces this. For a machine: maintenance and parts, power when running and standing, the insurance attributable to it, the floor space it occupies at whatever that space costs, any licensing or certification, and the finance still being paid on it. For a building: rates, insurance, heat, light, security and repairs. Depreciation is deliberately excluded, because it is not cash and because including it is what makes written-down assets look free to keep. What comes out is the annual amount leaving the bank to keep each thing available, and it is usually a surprise. That is where Excel consulting on an asset-heavy business starts.

What it earns has to be attributable

Second, the earning side has to be attributable to the asset rather than to the business. Which jobs ran on that machine, which revenue came out of that building, how many hours it was actually in use. For some assets this is straightforward from job records; for others it requires a field that does not currently exist and has to be added going forward. Where attribution is genuinely impossible, say so and treat the asset as shared infrastructure rather than inventing a split, because a made-up allocation produces a confident answer to the wrong question.

Idle and standby are different conditions

Third, idle and standby need separating, because they look identical in a utilization report and mean opposite things. A machine that runs twice a year because it is genuinely needed twice a year is standby capacity, and its cost is insurance against a situation the business has chosen to cover. A machine that runs twice a year because nobody has decided what to do with it is idle, and the cost is pure leakage. The distinction is a judgment somebody has to make and record, asset by asset, and once it is recorded the idle list is usually short, specific and actionable.

Keep or replace is a comparison of two cash streams

Fourth, keep-or-replace is a comparison between two cash streams rather than a comparison of prices, and setting it up that way removes most of the argument. Keeping means the current cash cost of ownership, rising as the asset ages, plus the downtime it causes. Replacing means the purchase or finance cost, a lower running and maintenance cost, probably better throughput, and whatever the old asset realizes on disposal. Laid out over five or seven years side by side, the answer is often clear and occasionally the opposite of what everyone assumed. It is a contained piece of financial modeling.

Sunk cost is the trap, and a model is the way past it

Fifth, the thing that most often prevents a good decision here is sunk cost, and the only reliable defense against it is a model that structurally cannot include it. What was paid for a machine years ago is not recoverable and is not relevant to whether to keep it; the only relevant figures are what it costs from today forward and what it earns from today forward. People know this and still find it very hard to act on, which is precisely why the comparison should be built on paper where the sunk figure has no cell to sit in. Reporting ownership cost against attributable earnings each year keeps the question live rather than letting it default to inertia, and that is routine Excel reporting.

This is structural rather than a purchase

None of this requires an asset management system. The fixed asset register, the maintenance records, the utility bills and the job history already hold the components; what is missing is the cash cost assembled per asset and the earnings attributed against it. An hour with the asset register open usually clears what is achievable, and the reasoning stays with you — which is what Excel expert help is for.