Concrete Mixer Truck Carrier Financial Model
Description
The model replicates a ready-mix concrete carrier operating a fleet of mixer trucks. Revenue is driven by per-cubic-metre haul rates that vary with distance, load size, and minimum order charges. Seasonal construction activity, shift patterns, and daily plant-to-site cycles shape the utilisation envelope, while concrete’s limited working time forces strict dispatch discipline.
Concrete perishability is at the core: every trip has a window from batching to discharge. Delays beyond this window lead to rejected loads and full cost write-offs. The model captures drum rotation ageing, slump retention, and the probability of rejection based on transit time, site queuing, and discharge speed. Return trips, washout time, and water disposal are factored into the daily cycle.
The fleet is modelled with a dual‑asset view. The drum depreciates by operating hours (revolutions) while the chassis follows mileage. Fuel consumption responds to gross vehicle weight, drum rotation power, and terrain. Maintenance costs are driven by both mileage and drum‑hour intervals, with separate budgets for drum liners, blades, and hydraulic systems. Leasing and financing structures include operating leases with mileage caps, finance leases with balloon residuals, and outright purchase, so you can test the mix that suits your capital strategy.
Cash flow reflects contractor‑specific payment terms: net‑30 to net‑90 with retention percentages and late‑payment penalties. Working capital is built up from fuel inventories, receivables, and spare parts. The model produces full financial statements, loan schedules, and sensitivity tables for variables such as diesel price, utilisation rate, and average haul distance.
Modeling specifics
- Trip‑level revenue engine: each trip is modelled by haul distance, payload, drum rotation time during transit, site discharge time, return leg, and mandatory washout, giving utilisation figures that react to queue delays and concrete life.
- Concrete perishability curves: rejection probability increases as the time from batching approaches the mix‑specific slump‑life limit; the model automatically writes off the load cost when rejection occurs and logs lost revenue.
- Drum‑vs‑chassis asset split: two depreciation schedules — drum on drum‑hours, chassis on mileage — each with an independent residual value, so fleet replacement decisions are grounded in asset‑specific economics.
- Fuel model with load‑dependent consumption: fuel burn rate is a function of gross vehicle weight (empty, loaded, partial) and drum rotation demand, preventing the common error of a flat litre‑per‑km assumption.
- Washout cost centre: water consumption, disposal fees, and labour for drum cleaning are treated as a separate variable cost per trip, not buried in overheads, because they scale directly with the number of deliveries.
- Dispatch queue dynamics: plant loading time and site waiting time are adjustable, and the model calculates the maximum number of trips per truck per shift under different queue scenarios, showing how a few extra minutes per cycle erode daily revenue.
What's included in the base version
- Fleet configuration & trip revenue engine
- Concrete perishability & load rejection logic
- Driver scheduling & shift cost model
- Drum & chassis depreciation schedules
- Fuel, maintenance & washout cost calculators
- Leasing/financing block (operating & finance lease, loan)
- Financial statements (P&L, cash flow, balance sheet)
- Sensitivity & scenario manager
Common modeling mistakes
- Treating the mixer truck as one uniform asset with straight‑line depreciation — misstates the tax shield and overstates residual value by not accounting for the drum’s faster wear, inflating terminal value by 15–25%.
- Using a flat fuel rate per kilometre regardless of load and drum rotation — overestimates fuel efficiency on loaded legs by 15–25%, understating operating cost.
- Ignoring load rejection due to concrete perishability — overstates utilisation and revenue by 5–10% because late deliveries appear as successful trips.
- Failing to separate washout time and cost from general overhead — understates per‑trip variable costs and masks the real margin of short‑haul deliveries.
- Assuming all contractors pay within 30 days without retention — hides working capital stress; receivables can balloon by 30–50% of annual revenue, making the project appear more cash‑rich than it actually is.
