Apple-of-Your-Eye Auto Company Inputs--Costs, Capacities, Demands Cash Fixed Costs ($K) Low Cash Fixed Costs High Demand Region Variable costs ($K) per unit Low capacity Capacity (units) High Capacity Capacity (units) Supply Region US Germany Japan India Germany Hong Kong Demand (M units) Decision Variables Demand Region Low Capacity High Capacity Supply Region US Germany Japan (1=Open) (1=Open) India Germany Hong Kong Constraints Supply Region Excess capacity India Germany Hong Kong US Germany Japan Unmet Demand Objective function Total Cost Can you insert the anwers into the excel as mentioned here using the excel solver i dont have it on my pc : Apple-of-Your-Eye Auto Company Inputs--Costs, Capacities, Demands Cash Fixed Costs ($K) Low Cash Fixed Costs High Demand Region Variable costs ($K) per unit Low capacity Capacity (units) High Capacity Capacity (units) Supply Region US Germany Japan India Germany Hong Kong Demand (M units) Decision Variables Demand Region Low Capacity High Capacity Supply Region US Germany Japan (1=Open) (1=Open) India Germany Hong Kong Constraints Supply Region Excess capacity India Germany Hong Kong US Germany Japan Unmet Demand Objective function Total Cost Second problem :

Alfa Company Network Model Inputs--Costs, Capacities, Demands Demand Region Delivered Variable Costs per 1m units Fixed Costs ($) Low Fixed Costs ($) High Supply Region N. America S. America Europe Asia Africa at low capacity Capacity at high capacity Capacity N. America 81 92 101 130 115 6,000 10 9,000 20 S. America 117 77 108 98 100 4,500 10 6,750 20 Europe 102 105 95 119 111 6,500 10 9,750 20 Asia 115 125 90 59 74 4,100 10 6,150 20 Africa 142 100 103 105 71 4,000 10 6,000 20 Demand (Ms units) 12 8 14 16 7 Decision Variables Demand Region Production Allocation (M units) Low capacity High capacity Supply Region N. America S. America Europe Asia Africa (1=open) (1-open) N. America 0 0 0 0 0 0 0 S. America 0 0 0 0 0 0 0 Europe 0 0 0 0 0 0 0 Asia 0 0 0 0 0 0 0 Africa 0 0 0 0 0 0 0 Constraints Supply Region Excess Capacity N. America 0 S. America 0 Europe 0 Asia 0 Africa 0 N. America S. America Europe Asia Africa Unmet Demand 12 8 14 16 7 Objective Function Cost= 0 Attempt to reproduce the result achieved in the lecture spreadsheet. The lecture takes us through the base case of the optimization process. (Make sure in Solver Settings, "Relax Integer Constraint" is unchecked.) Attempt, using the same spreadsheet, to calculate the new solution given one additional constraint: The N. American factory must be kept open at High capacity.