Blog · Territory, capacity and quota planning · Supply chain
Compare a proposed supply chain change with baseline cash costs, implementation effort and measurable benefits. Build a spreadsheet appraisal, test the assumption that could change the decision and compare approved estimates with actual outcomes.
Cost benefit analysis in supply chain management compares a proposed change with the cash costs and operating outcomes expected without it. The decision rests on incremental benefits after implementation and ongoing costs, not on the largest headline saving. Each benefit needs a source, an owner and a condition under which it will occur.
Routine supply chain cost analysis establishes where current spending sits. Project appraisal asks a different question: will a particular change improve outcomes enough to justify its additional cost and risk?
Write down what happens without the project. Include committed changes already expected in that baseline, such as an agreed carrier rate reduction. Otherwise the project receives credit for an improvement that would happen anyway.
Choose a common evaluation period and service requirement for both options. A cheaper proposal that cannot handle the required throughput is not an equivalent alternative. Record implementation timing, expected demand, one-time spending, ongoing payments and any end-of-period value or obligation.
The NIST life-cycle costing handbook sets out a sequence of defining alternatives, establishing common assumptions, estimating costs and timing, and discounting future amounts. Its federal energy examples are a methodological reference here; the company's finance team must set the assumptions for its own supply chain decision.
Use freight invoices, warehouse payroll, damage claims and project quotations. Preserve cost-center and document identifiers, then label each row as baseline, proposed recurring cost or implementation cost. Keep quoted amounts separate from estimates based on operating assumptions.
A fictional US distributor considers a loading-area redesign. The screening appraisal uses a three-year horizon, a company-approved illustrative annual discount rate of 10%, and equal throughput under both options. It is pre-tax, assumes year-end operating cash effects, and excludes financing, inflation and residual value. A final approval appraisal would revisit those exclusions if material.
| Annual cost category | Baseline (USD) | Proposed (USD) | Annual reduction (USD) | Evidence to validate |
|---|---|---|---|---|
| Freight | 96,000 | 72,000 | 24,000 | Carrier invoices and revised load plan |
| Overtime | 60,000 | 30,000 | 30,000 | Payroll hours, paid rates and staffing plan |
| Damage | 20,000 | 8,000 | 12,000 | Claims and replacement payments |
| Added recurring support | 0 | 18,000 | -18,000 | Contracted maintenance and support |
| Total | 176,000 | 128,000 | 48,000 |
Gross annual benefits are 24,000 + 30,000 + 12,000 = $66,000. Added annual support costs $18,000, leaving net annual benefit of $48,000. These are approved scenario assumptions, not measured outcomes.
| Implementation item | Immediate payment (USD) |
|---|---|
| Equipment | 60,000 |
| Configuration | 25,000 |
| Training | 15,000 |
| Total | 100,000 |
Training includes incremental paid costs in this example. Existing salaried time should also be disclosed as an implementation resource requirement, but it is not automatically an additional cash outflow. Identify overtime, backfill or displaced work separately.
Annual net benefit = Baseline cash cost − Proposed cash cost
Net present value = Immediate cash flow + Sum of each future cash flow / (1 + Discount rate)^Year
Create the following sheet with year in column A, incremental cash flow in B and present value in C. Put the discount-rate assumption of 10% in E2.
| Row | Year | Incremental cash flow (USD) | Present value (USD) |
|---|---|---|---|
| 2 | 0 | -100,000 | -100,000 |
| 3 | 1 | 48,000 | 43,636 |
| 4 | 2 | 48,000 | 39,669 |
| 5 | 3 | 48,000 | 36,063 |
| Total | 44,000 | 19,369 |
In C2, fill down through C5:
=B2/(1+$E$2)^A2
Calculate the result either way:
=SUM(C2:C5)
=NPV($E$2,B3:B5)+B2
The Microsoft NPV function guidance explains the timing convention: an initial cash flow at the start is added separately rather than included among future-period flows. Covirage is not affiliated with Microsoft.
Net present value is $19,369, rounded to the nearest dollar. Calculations retain full precision; individually rounded present values may not sum to the rounded total. The undiscounted check is 48,000 × 3 − 100,000 = $44,000, which also equals total benefits of $198,000 less $54,000 of recurring support and $100,000 of implementation spending.
Simple payback is 100,000 / 48,000 = 2.08 years, assuming benefits accrue evenly within the year. Payback is a separate timing approximation; it does not replace the discounted appraisal.
Suppose the overtime reduction is only $15,000 annually, rather than $30,000. Keep every other input unchanged. Proposed overtime becomes $45,000, total proposed annual cost becomes $143,000, and net annual benefit falls to $33,000.
| Case | Annual net benefit (USD) | Immediate investment (USD) | Three-year NPV at 10% (USD) |
|---|---|---|---|
| Approved scenario | 48,000 | 100,000 | 19,369 |
| Lower overtime reduction | 33,000 | 100,000 | -17,934 |
The proposal changes from positive to negative NPV under that single assumption. Before approving it, operations should show how the redesign changes paid overtime, rather than merely reallocating work to regular hours. The separate cost-benefit sensitivity method covers wider assumption testing.
Assign freight to procurement, overtime to warehouse operations, damage to quality or claims, and reconciliation to finance. Save the approved version and identify the first operating period when benefits should appear.
Compare actual costs with an agreed baseline at comparable throughput. Track implementation payments separately from recurring outcomes. Use analytical methods for supply chain management to choose the operational comparisons that distinguish an intervention from changes in workload or mix.
Bring the approved scenario assumptions alongside freight, payroll, damage and implementation cost exports. Covirage maps the columns; its tools compute and check comparisons between supplied assumptions and actuals, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for supply chain teams for the supporting business context.
Include benefits that change company cash flows relative to the baseline, such as lower freight invoices, reduced overtime payments or fewer damage claims. Record service and resilience improvements separately when their cash effect cannot be supported, rather than assigning an unsupported dollar benefit.
Usually the reduction releases working capital once when purchases fall below consumption. Continuing lower stock may also reduce separate carrying expenses, but those expenses need their own evidence. Do not count the inventory balance reduction as a recurring annual operating saving.
Keep the approved baseline, volume assumptions, timing and benefit owner. Compare actual invoices, payroll or inventory movements with a baseline adjusted for agreed activity changes. Explain price, volume and timing differences separately so a favorable market movement is not automatically credited to the project.