← 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.