ROI Calculator Understanding the Cost of Poor Supplier Performance

Every supplier that delivers late or ships non-conforming material costs you real money — in rework, expediting, customer penalties, and administrative overhead. The LQATS ROI Calculator makes that invisible cost visible and projects how it changes over four quarters when your suppliers are actively managed through the Lyons Quality Audit System.

The model runs in two stages. First it establishes your baseline cost of poor supplier performance — what you are losing right now, expressed as a quarterly dollar figure. Then it projects how that cost declines quarter by quarter as LQATS drives measurable improvement, and calculates the net return on your Lyons Quality Audit Tracking System LQATS investment.

---

The Seven Inputs

The ROI calculator takes seven inputs. Four describe your supplier base and performance today; three describe the financial context. Each has a default value you can adjust in the ROI calculator.

Variable	Default	What It Means
Number of Critical Suppliers	32	Suppliers actively managed and scored under LQATS.
Avg. Quarterly Spend per Supplier	$50,000	Total quarterly procurement spend divided by supplier count.
Poor Performance-to-Cost Ratio	34%	The share of at-risk spend that becomes actual incurred cost when performance fails. Industry-validated default; adjust upward for high-penalty environments.
Current Delivery Performance	80%	Percentage of orders delivered on time and in full.
Current Quality Performance	85%	Percentage of delivered units conforming to specification on first inspection.
Annual LQATS Program Cost	$100,000	Total annual cost of deploying LQATS across your critical supplier base.
Normal Sales Margin	12.5%	Your net margin — used to convert annual losses into an equivalent “additional sales needed” figure.

Note on the Poor Performance-to-Cost Ratio: Not every delivery delay or quality failure costs you a full dollar per dollar of affected spend. The 34% default reflects the real-world fraction that converts into actual incurred cost — rework, premium freight, customer deductions, and administration. Organisations with contractual penalty clauses often experience 40–50%. Use internal data if available; otherwise 34% is a conservative and defensible default.

---

Section 1 — Baseline Cost Calculations in ROI Calculator

The baseline calculations answer one question: how much is poor supplier performance costing you right now, every quarter, with no intervention?

Step 1 — Total Quarterly Spend

Multiply the number of suppliers by the average quarterly spend per supplier.

Total Spend / Qtr  =  Suppliers × Avg Quarterly Spend

Example: 32 suppliers × $50,000 = $1,600,000 per quarter

Step 2 — Delivery Dollars Lost Per Quarter

For every percentage point that delivery performance falls below 100%, that share of total spend is at risk. Multiply the at-risk amount by the Poor Performance-to-Cost Ratio to get the actual dollar cost.

Delivery Lost / Qtr  =  ((100 − Delivery%) ÷ 100 × Total Spend) × Ratio

Example — 80% delivery performance:

• Shortfall: 100% − 80% = 20% at risk
• At-risk spend: 20% ÷ 100 × $1,600,000 = $320,000
• Apply ratio: $320,000 × 34% = $108,800 delivery cost per quarter

Step 3 — Quality Dollars Lost Per Quarter

The quality loss formula is identical in structure, substituting the quality performance shortfall.

Quality Lost / Qtr  =  ((100 − Quality%) ÷ 100 × Total Spend) × Ratio

Example — 85% quality performance:

• Shortfall: 100% − 85% = 15% at risk
• At-risk spend: 15% ÷ 100 × $1,600,000 = $240,000
• Apply ratio: $240,000 × 34% = $81,600 quality cost per quarter

Step 4 — Total Quarterly Loss

Total Lost / Qtr  =  Delivery Lost + Quality Lost

Example:

• Delivery lost: $108,800
• Quality lost: $81,600
• Total lost per quarter: $190,400
• Annual equivalent (× 4): $761,600

Step 5 — Additional Annual Sales Needed to Offset

This converts your annual loss into a sales revenue equivalent — how much new business your sales team would need to generate at your normal margin just to break even against these losses.

Additional Sales Needed  =  (Total Lost / Qtr × 4) ÷ Sales Margin

Example: $761,600 ÷ 12.5% = $6,092,800 in additional annual sales required

Why this number matters: A $761,600 procurement loss is easy for leadership to dismiss as a line item. Reframing it as “$6.1 million in new business your sales team must win every year just to break even” makes the cost of inaction impossible to ignore. Use this figure in board presentations and investment approval documents.

---

Section 2 — The LQATS Performance Improvement Curve in ROI Calculator

Once baseline losses are established, the model projects how supplier performance improves quarter by quarter when managed through LQATS. The improvement formula uses two different rates depending on the current performance level.

Suppliers with performance below 77.1% receive a fixed 6.05% compound improvement rate — large gains are achievable from low baselines. Suppliers at or above 77.1% improve proportionally to the gap remaining to the 98% practical ceiling, spread evenly across four quarters. The 98% ceiling reflects the real-world maximum sustainable performance for most supplier bases.

Below-Threshold Formula (performance < 77.1%)

New Performance  =  Previous × 1.0605

6.05% compound improvement is applied each quarter until the 77.1% threshold is crossed.

Above-Threshold Formula (performance ≥ 77.1%)

New Performance  =  Previous × (1 + ((98 − Baseline) ÷ 4) ÷ 100)

The improvement step is calculated once from the original baseline gap to 98%, then applied consistently each quarter.

Why the step uses the original baseline: Formula 6b uses the original baseline (e.g. 80%) to set the quarterly increment — not the updated quarterly value. This keeps the improvement step constant, producing a consistent and predictable progression toward 98% across all four quarters.

Example — Delivery, 80% baseline (above 77.1%):

• Gap to 98% ceiling: 98% − 80% = 18%
• Quarterly increment: 18% ÷ 4 = 4.5% → multiplier 0.045
• Q1: 80.00% × (1 + 0.045) = 83.60%
• Q2: 83.60% × (1 + 0.045) = 87.36%
• Q3: 87.36% × (1 + 0.045) = 91.29%
• Q4: 91.29% × (1 + 0.045) = 95.40%

Example — Quality, 85% baseline (above 77.1%):

• Gap to 98% ceiling: 98% − 85% = 13%
• Quarterly increment: 13% ÷ 4 = 3.25% → multiplier 0.0325
• Q1: 85.00% × (1 + 0.0325) = 87.76%
• Q2: 87.76% × (1 + 0.0325) = 90.61%
• Q3: 90.61% × (1 + 0.0325) = 93.56%
• Q4: 93.56% × (1 + 0.0325) = 96.60%

---

Section 3 — Quarterly Savings Calculations

As performance improves each quarter, the dollars lost fall. The difference between what you would have lost without LQATS and what you actually lose — minus the pro-rated quarterly LQATS cost — is your net quarterly saving.

Dollars Lost Each Quarter With LQATS

The same delivery and quality loss formulas from the baseline apply each quarter, now using the improved performance figure for that quarter:

Loss Qn  =  ((100 − Improved Performance Qn) ÷ 100 × Total Spend) × Ratio

Net Savings Per Quarter

Gross savings is the difference between the fixed baseline loss and this quarter’s improved loss. Net savings then deducts the pro-rated quarterly LQATS cost:

Net Savings Qn  =  (Baseline Loss/Qtr − Total Loss Qn) − (Annual LQATS Cost ÷ 4)

Example — Q1 net savings calculation:

• Q1 delivery loss (at 83.60%): ((100−83.60)/100 × $1.6M) × 34% = $89,216
• Q1 quality loss (at 87.76%): ((100−87.76)/100 × $1.6M) × 34% = $66,572
• Total Q1 loss: $155,788
• Gross savings: $190,400 − $155,788 = $34,612
• Pro-rated LQATS cost: $100,000 ÷ 4 = $25,000
• Q1 Net Savings: $34,612 − $25,000 = $9,612

Cumulative Net Savings

ROI Calculator Cumulative net savings is the running total of quarterly savings, tracking the growing Year-1 return on the LQATS investment:

Cumulative Savings Qn  =  Cumulative Savings Q(n−1) + Net Savings Qn

Why savings accelerate each quarter: The LQATS quarterly cost is fixed at $25,000 every quarter. But gross savings grow as performance keeps improving. Q1 improvement is modest — suppliers are just beginning to respond to audit findings. By Q4, performance has improved by 15+ percentage points and the avoided losses are large. This compounding effect is the core economic argument for sustained supplier quality management.

---

Section 4 — ROI Calculator Full Four-Quarter Projection

Applying all formulas in sequence to the default inputs produces the following projection. Losses shrink each quarter as performance improves; net savings and cumulative savings grow throughout the year.

Quarter	Delivery %	Quality %	Delivery Lost	Quality Lost	Total Lost	Net Savings	Cum. Savings
Baseline	80.00%	85.00%	$108,800	$81,600	$190,400	—	—
Q1	83.60%	87.76%	$89,216	$66,572	$155,788	$9,612	$9,612
Q2	87.36%	90.61%	$68,751	$51,056	$119,806	$45,594	$55,206
Q3	91.29%	93.56%	$47,365	$35,035	$82,399	$83,001	$138,206
Q4	95.40%	96.60%	$25,016	$18,494	$43,509	$121,891	$260,097

Year-1 result: Against a $100,000 annual LQATS investment, the default scenario projects $260,097 in cumulative net savings by end of Q4 — a 160% first-year ROI. Total quarterly losses fall from $190,400 to $43,509, a 77% reduction by Q4 run rate.

---

Section 5 — ROI Calculator Calculation Sequence Checklist

Every time you run the LQATS ROI Calculator, these nine steps execute in sequence:

1. Multiply suppliers by average quarterly spend to get total quarterly spend.
2. Calculate delivery dollars lost per quarter using the delivery shortfall and the poor-performance-to-cost ratio.
3. Calculate quality dollars lost per quarter using the quality shortfall and the same ratio.
4. Sum delivery and quality losses to get total baseline loss per quarter.
5. Multiply total quarterly loss by 4 and divide by your sales margin to get additional annual sales needed to offset losses.
6. Apply the performance improvement formula to project delivery and quality performance for Q1–Q4, using the 77.1% threshold to select the correct improvement rate.
7. Recalculate delivery and quality losses for each quarter using the improved performance values.
8. Subtract each quarter’s improved total loss from the baseline, then deduct the pro-rated LQATS quarterly cost, to get net savings per quarter.
9. Accumulate quarterly net savings into a running cumulative total through Q4 to produce the Year-1 ROI figure.

Highest-leverage inputs: The Poor Performance-to-Cost Ratio has the greatest single impact on your ROI figure — even a 5-point increase significantly changes the baseline loss. Next is the number of critical suppliers, which amplifies every percentage point of performance improvement. Finally, lower starting delivery and quality percentages mean more headroom for LQATS to deliver savings.