Calculation Methodology & Formula Boundaries
Mathematical definitions, capacity constraints, and anti-inflation principles governing this model.
Three Cardinal Principles of This Tool
- Volume is shop-wide: Total work orders represent the entire facility. Technician headcount defines total shop capacity, and is never used as a multiplier for repair orders.
- Capacity valuation is not immediate cash savings: Reclaiming 240 technician hours provides productive bandwidth, but salaried payroll does not decrease unless overtime or outside contractor hours are genuinely avoided.
- No double-counting downtime: Incremental equipment downtime costs must exclude technician loaded wages and parts expenditures already captured in labor and parts sections.
1. Labor Capacity & Search Friction Formulas
Manual information retrieval takes time away from actual wrench time. SMRP Metric 5.6.1 distinguishes active wrench time from waiting and preparation time. We calculate annual search friction as:
searchHours = shopWorkOrdersPerWeek × workingWeeks × searchPersonMinutesPerOrder / 60 availableHours = technicianCount × hoursPerTechWeek × workingWeeks laborCapacityValue = searchHours × loadedLaborCostPerHour recoveredHours = searchHours × laborTimeReduction recoveredCapacityValue = recoveredHours × loadedLaborCostPerHour laborCashBenefit = recoveredCapacityValue × laborCashRealization
If searchHours > availableHours, the engine halts calculations and reports a capacity limit violation.
2. Parts Wrong-Order Restocking Formulas
Ordering incorrect fittings, seals, or filters results in distributor restocking penalties (commonly 15%–25%) and freight costs. Nonreturnable dead stock is captured in a dedicated field to prevent double-counting:
annualWrongOrderSpend = monthlyPartsSpend × 12 × wrongOrderSpendShare annualRestockingCost = annualWrongOrderSpend × restockingFeeRate annualReturnCost = annualRestockingCost + 12 × (monthlyReturnFreight + monthlyNonreturnableWriteoff) returnCashBenefit = annualReturnCost × returnCostReduction
3. Equipment Downtime Friction Formulas
As detailed in USACE EP 1110-1-8 , equipment costs differ between ownership, standby, and operating rates. Downtime in this calculator tracks out-of-service asset-hours:
annualDowntimeCost = equipmentDowntimeHoursPerMonth × 12 × incrementalDowntimeCostPerHour downtimeCashBenefit = annualDowntimeCost × downtimeReduction
Unless the user explicitly checks downtimeCostsAreIndependent, downtime is reported as an isolated baseline and excluded from the total cash exposure to prevent double-counting technician labor.
4. Net Benefit, ROI, and Payback Timeline
The steady-state first-year model evaluates cash savings against total first-year software and implementation expenditures:
annualCashBenefit = laborCashBenefit + returnCashBenefit + independentDowntimeCashBenefit firstYearCost = annualRecurringCost + implementationCost firstYearNetBenefit = annualCashBenefit - firstYearCost firstYearRoiPercent = 100 × firstYearNetBenefit / firstYearCost monthlyNetBenefitBeforeSetup = (annualCashBenefit - annualRecurringCost) / 12 paybackMonths = implementationCost / monthlyNetBenefitBeforeSetup
When first-year cost is zero, ROI is reported as not-applicable (not infinity). When monthly net benefit is zero or negative, payback is reported as not-reached.
