Blog · Territory, capacity and quota planning · Manufacturing
Compare manufacturing profit and capacity under supplied customer, supplier and cost scenarios. Work from operating exports, separate lost sales from delayed sales, and reconcile each result to the baseline.
Manufacturing business resilience analysis compares profit and capacity under explicitly stated disruptions. It shows how much a business could lose, which assumptions drive that exposure and whether a proposed recovery action fits the available operating capacity.
The output is a set of conditional results. Procurement supplies interruption assumptions, sales supplies customer scenarios, operations confirms production constraints, and finance checks the economics. No scenario here is an estimate of the probability of a disruption.
Use one month and the same product definitions throughout. Bring a sales export by customer and product, production quantities, variable unit costs, fixed operating costs and usable production hours. Keep the source period and responsible manager beside each assumption.
Ready.gov's business impact analysis guidance separates operational and financial effects and explicitly includes supplier failure, lost or delayed sales, and increased expenses. That distinction matters: an order shifted to a later month has a different effect from an order permanently lost.
Consider an illustrative US manufacturer with these monthly inputs. Variable cost means cost avoided when a unit is not made; fixed costs remain during the scenarios below.
| Product | Units | Price per unit (USD) | Variable cost per unit (USD) | Fixed costs (USD) | Hours per unit |
|---|---|---|---|---|---|
| Pump assemblies | 1,000 | 500 | 320 | 60,000 | 1.50 |
| Valve kits | 2,000 | 150 | 90 | 40,000 | 0.25 |
Use columns A through F in that order. In columns G through J, enter these spreadsheet formulas and fill down:
G2 = B2*C2
H2 = B2*D2
I2 = G2-H2
J2 = B2*F2
| Product | Revenue (USD) | Variable costs (USD) | Contribution (USD) | Required hours |
|---|---|---|---|---|
| Pump assemblies | 500,000 | 320,000 | 180,000 | 1,500 |
| Valve kits | 300,000 | 180,000 | 120,000 | 500 |
| Total | 800,000 | 500,000 | 300,000 | 2,000 |
Operating profit is $300,000 less $100,000 of fixed costs, or $200,000. Check that revenue and costs reconcile to the planning ledger before applying shocks. Use manufacturing cost analysis to resolve the underlying cost definitions; the resilience exercise should reuse those definitions.
Assume operations supplies a month with 20 working days, a supplier interruption lasting eight working days and three working days of usable component inventory. Only pump assemblies depend on this supplier. Sales confirms that output missed in the uncovered interval cannot be shipped within the month.
Enter working days in L1, interruption days in L2 and inventory cover in L3. Calculate exposed pump units in L4:
=B2*MIN(1,MAX(0,$L$2-$L$3)/$L$1)
That is 1,000 × (8 − 3) / 20 = 250 units, leaving 750 pump assemblies. The formula assumes even daily output; use the actual production schedule when demand or shifts are uneven. Procurement also supplies $15,000 of incremental expediting expense.
Calculate interrupted revenue in N2, variable cost in N3 and operating profit in N4 from the remaining units:
N2 = (B2-L4)*C2+B3*C3
N3 = (B2-L4)*D2+B3*D3
N4 = N2-N3-SUM(E2:E3)-15000
The lost contribution is 250 × (500 − 320) = $45,000. Profit therefore falls by $45,000 plus $15,000, reaching $140,000. Contribution margin explains why losing revenue does not mean losing the same amount of profit.
Now add a separate assumption: all variable unit costs rise by 10%, with no price increase. For the combined scenario, apply that increase to the units actually produced after the interruption.
| Monthly scenario | Revenue (USD) | Variable costs (USD) | Fixed costs (USD) | Extra expense (USD) | Operating profit (USD) |
|---|---|---|---|---|---|
| Baseline | 800,000 | 500,000 | 100,000 | 0 | 200,000 |
| Supplier interruption | 675,000 | 420,000 | 100,000 | 15,000 | 140,000 |
| Variable costs rise 10% | 800,000 | 550,000 | 100,000 | 0 | 150,000 |
| Both together | 675,000 | 462,000 | 100,000 | 15,000 | 98,000 |
The combined profit is $675,000 − $462,000 − $100,000 − $15,000 = $98,000. Simply adding the separate profit reductions would give $90,000. That understates profit by $8,000 because the cost increase does not apply to the 250 pump assemblies no longer produced: 250 × $320 × 10% = $8,000.
This reconciliation is the check. Every difference must come from a volume change, a unit contribution change or an explicit additional expense.
Suppose the customer export shows the largest account buying 400 pump assemblies and 800 valve kits. Its revenue is 400 × $500 + 800 × $150 = $320,000, or 40% of baseline sales. Losing half its orders removes 200 pump assemblies and 400 valve kits, reducing contribution by $36,000 + $24,000 = $60,000 before any mitigation. Concentration should therefore be measured in contribution as well as sales.
Next consider recovery of the supplier interruption alone. Available monthly capacity is 2,400 compatible hours, leaving 400 hours above the baseline requirement of 2,000. This compares capacity with the original plan; the interrupted schedule uses fewer hours. Baseline capacity utilization is 83.3%, rounded to one decimal place.
Operations says 200 interrupted pump assemblies can be recovered within the month, after components arrive, with 300 compatible hours available in that remaining window. They require 200 × 1.5 = 300 hours and produce $36,000 of contribution. If the supplied incremental recovery expense is $10,000, the net benefit is $26,000; interrupted profit rises from $140,000 to $166,000. The existing expediting expense remains included.
Hours alone do not establish feasibility. The production owner must confirm timing, labor skills, material availability and acceptable output. Ready.gov's continuity planning guidance calls for a continuity team and a tested plan. Finance supplies the comparison; operating owners approve the recovery assumptions.
Profit exposure also differs from cash exposure. Follow the receipts, purchases and payment timing separately in cash flow scenario analysis.
Bring a sample of your own sales, production and cost files with a sheet of supplied disruption assumptions. Covirage maps the columns; its tools compute and check the scenario comparisons, and the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your own export.
See Covirage for manufacturers for the supporting industry context.
Use sales by customer and product, production quantities, variable unit costs, fixed operating costs and available production hours for the same period. Add an assumption sheet showing interruption duration, usable inventory cover and recovery costs supplied by the responsible managers.
No. Materials or other genuinely variable costs may fall with output, while rent, salaries and committed service costs can remain. Classify costs by their behavior within the scenario period rather than assuming every cost declines with production.
It supplies financial and operating evidence for continuity decisions. A continuity plan also assigns responsibilities, response procedures and recovery arrangements. The calculations cannot establish whether an alternate supplier, machine or recovery schedule is operationally acceptable.