SUPPLY CHAIN MANAGMENT ( CASE STUDY )

profilehbouhamad
case_data_q1.xlsx
Home>Business & Finance homework help>Marketing homework help>SUPPLY CHAIN MANAGMENT ( CASE STUDY )

case_2

Transportation Costs Transportation cost multiplier
Supply Region Northwest Southwest Upper Midwest Lower Midwest Northeast Southeast 1 6.32 6.32 3.68 4.04 5.76 5.96
Chicago 6.32 6.32 3.68 4.04 5.76 5.96 6.6 6.6 5.76 5.92 3.68 4.08
Princeton 6.6 6.6 5.76 5.92 3.68 4.08 6.72 6.48 5.92 4.08 4.04 3.64
Atlanta 6.72 6.48 5.92 4.08 4.04 3.64 4.36 3.68 6.32 6.32 6.72 6.6
Los Angeles 4.36 3.68 6.32 6.32 6.72 6.6
Plant costs/Capacity
Wipes Ointment
Supply Region Fixed Cost Variable cost/u Capacity Fixed Cost Variable cost/u Capacity
Chicago 5000 10 5000 1500 20 1000
Princeton 2200 10 2000 1500 20 1000
Atlanta 2200 10 2000 1500 20 1000
Los Angeles 2200 10 2000 1500 20 1000
Demand Northwest Southwest Upper Midwest Lower Midwest Northeast Southeast Total
Wipes 500 700 900 800 1000 600 4500
Ointment 50 90 120 65 120 70 515
Wipes Variables
Supply Region Northwest Southwest Upper Midwest Lower Midwest Northeast Southeast Plant(s) Excess Capacity?
Chicago 0 0 0 0 0 0 0
Princeton 0 0 0 0 0 0 0
Atlanta 0 0 0 0 0 0 0
Los Angeles 0 0 0 0 0 0 0
Demand
Ointment Variables
Supply Region Northwest Southwest Upper Midwest Lower Midwest Northeast Southeast Plant(s) Excess Capacity?
Chicago 0 0 0 0 0 0 0
Princeton 0 0 0 0 0 0 0
Atlanta 0 0 0 0 0 0 0
Los Angeles 0 0 0 0 0 0 0
Demand
Objective Function