| ← Back to Cover | ||||||||
| EXECUTIVE DASHBOARD | ||||||||
| KEY PERFORMANCE INDICATORS | ||||||||
| Total Demand 2026 | Avg TLC / Unit | 5-Year NPV | Avg Plant Util. | Avg DC Util. | Demand CAGR | |||
| 1,430,000 | $84.95 | $582.1 | 78.8% | 46.2% | 5.2% | |||
| units | per unit | $mm | target: 85% | target: 90% | 5-year | |||
| 5-YEAR DEMAND FORECAST BY REGION | ||||||||
| Region | 2026 | 2027 | 2028 | 2029 | 2030 | Growth | ||
| North America | 570,000 | 600,000 | 631,644 | 665,024 | 700,239 | 5.3% | ||
| Europe | 405,000 | 419,450 | 434,491 | 450,150 | 466,456 | 3.6% | ||
| Asia Pacific | 455,000 | 484,350 | 515,960 | 550,013 | 586,708 | 6.6% | ||
| Total | 1,430,000 | 1,503,800 | 1,582,095 | 1,665,187 | 1,753,403 | 5.2% | ||
| TLC COST WATERFALL ($/unit, Avg Across Lanes) | ||||||||
| Component | $/unit | % of TLC | Cumulative $ | |||||
| Production Cost | $52.86 | 62.2% | $52.86 | |||||
| Inbound Freight | $2.86 | 3.4% | $55.73 | |||||
| DC Handling | $17.51 | 20.6% | $73.23 | |||||
| Outbound Freight | $1.79 | 2.1% | $75.02 | |||||
| Duties | $0.30 | 0.4% | $75.32 | |||||
| Insurance | $0.26 | 0.3% | $75.59 | |||||
| Inventory Carry | $0.36 | 0.4% | $75.95 | |||||
| Overhead | $9.00 | 10.6% | $84.95 | |||||
| Total TLC | $84.95 | |||||||
| SCENARIO COMPARISON: TLC PER UNIT | ||||||||
| Scenario | TLC ($/unit) | vs. Base | vs. Base % | |||||
| Base Case | $84.95 | - | - | |||||
| Optimistic | $91.00 | $6.05 | 7.1% | |||||
| Pessimistic | $80.73 | ($4.23) | -5.0% | |||||
| Disruption | $78.42 | ($6.53) | -7.7% | |||||
| SUPPLY CHAIN LANE RANKING (Lowest TLC First) | ||||||||
| Lane | TLC ($/unit) | Rank | ||||||
| Lane 1: CHI>CHI>NE US | $81.15 | 5 | ||||||
| Lane 2: MTY>DAL>SE US | $63.26 | 2 | ||||||
| Lane 3: FRA>ROT>W.Eur | $113.74 | 7 | ||||||
| Lane 4: KRA>WAR>E.Eur | $67.58 | 3 | ||||||
| Lane 5: SHZ>SHN>China | $45.89 | 1 | ||||||
| Lane 6: OSA>TKY>Japan | $153.13 | 8 | ||||||
| Lane 7: SHZ>ROT>W.Eur | $70.41 | 4 | ||||||
| Lane 8: CHI>DAL>Mexico | $84.49 | 6 | ||||||
| Note: All dashboard values are dynamically linked. Update input sheets (Assumptions, Plant/DC Master, Demand, Transport, Tariffs) to refresh all metrics automatically. | ||||||||