Spare Parts Attach Rate and Aftermarket Revenue Calculator
For many machine builders the installed base is worth more than the next sale. This calculator estimates parts revenue from machines already in the field and shows how much leaks away when customers buy elsewhere.
Your numbers
Minimum 1 percent. Based on a typical machine life of 15 to 20 years.
The rest leaks to distributors, copy-part makers and the customer's own stock.
Your results
Simplified model with constant spend per machine and constant retirement rate. Real spend rises with machine age and usage.
Parts revenue vs years ahead
Sweeps Years ahead from 1 to 15, holding your other inputs fixed.
Installed base analytics from your ERP
Optional: ask how serial number and parts history could drive an attach rate dashboard.
Optional. The tool and every export work without this. No spam.
How to use it
Enter the number of machines in service, how many you ship each year and the share that retire each year. Add the annual spend per machine on spare parts and consumables, and the share of that spend you currently capture. The attach rate is the key lever: it is the percentage of aftermarket demand that comes to you rather than to distributors or copy suppliers. Choose a horizon and read your parts revenue, gross profit, revenue lost to leakage and the value of one more point of attach rate. Compare today's installed base with the one in five or ten years to see the effect of growth and retirement.
The math
With a retirement rate r, the base after n years is the old base times (1 - r) to the power n, plus yearly additions times the sum of survivors, which is (1 - (1 - r) to the power n) divided by r. Market equals the future base times spend per machine. Revenue equals market times capture. Gross profit applies your parts margin. The retirement rate is limited to at least 1 percent because the closed form divides by r. If you have actual age data, use it instead: machines older than the warranty tend to spend much more than new ones.
How to read it
With the defaults, the base grows from 600 to roughly 800 in five years and the value of a single attach point is about 60,000 a year, which helps justify spending on a parts web shop, kitting or serial-number-based recommendations. If leakage is greater than revenue, prioritize availability and lead time, since customers usually buy elsewhere when your parts are slow or expensive. Remember that serial numbers captured at shipment and registered at installation make the base visible; without them you are estimating blind.
- Track parts sold per machine serial number.
- Bundle wear parts into annual kits.
- Quote from the parts list tied to the as-built BOM.
Common mistakes
Teams often assume the whole installed base is still alive and in service, which overstates the market. They also use a constant spend per machine even though older machines consume far more parts than new ones, and they confuse attach rate with fill rate. Another trap is counting warranty parts as aftermarket revenue. In an ERP, make sure installed base records, bill of materials as built and sales history by serial number are linked so this model can be fed from facts.
Frequently Asked Questions
What is a typical attach rate for OEM spare parts?
It varies widely by product, age of machine and how proprietary the parts are. Proprietary wear parts can reach very high capture, while standard catalog items such as bearings and filters are often bought elsewhere. Measure your own by machine serial number.
How do I estimate the retirement rate?
Divide one by the average expected life in years for a rough rate. A 16 year life gives about 6 percent. Better is to use survival data from your serialized shipments and service records if you have them.
Should consumables be included with spare parts?
Yes if you sell them, as they often form the most stable part of aftermarket demand. You can run the model twice, once for consumables and once for repair parts, because their margin and capture rates differ.
How can I raise the attach rate?
Typical levers are faster delivery, parts kits tied to a service plan, recommended parts lists by serial number, an easy online catalog and competitive pricing on the top items that customers compare. Test one lever at a time and measure.
Where installed base, as-built BOM and parts orders sit in an ERP, we can build a read-only agent that calculates attach rate by model and customer.
Related Tools
OEM Warranty Reserve Accrual Calculator
Turn units sold, claim rate and average claim cost into an expected warranty reserve, net of supplier recovery, with a sensitivity chart.
Maintenance & ReliabilityMachine Availability Guarantee MTBF MTTR Calculator
Compute inherent and operational availability from MTBF, MTTR, parts wait and planned maintenance, and compare it with a contractual guarantee.
Maintenance & ReliabilityCritical Spare Stockout Risk Calculator (Poisson)
Decide how many slow-moving critical spares to hold by comparing stockout risk and cost for each stock level.
Costing & FinanceMachinery Price from Target Margin and Contingency Calculator
Compute the selling price of a custom machine that still delivers your target margin after contingency, warranty reserve and sales commission.
More Costing & Finance tools
See all- Project Milestone Billing Worksheet for Machine Builders
- Machine Build Engineering Hours Estimate Worksheet
- Machine Warranty Reserve Calculator
- Percentage of Completion Cost-to-Cost Revenue Calculator
- Advance Payment Guarantee and Performance Bond Cost Calculator
- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template