Distribution Problem (part a)
Nashville San J ose Hous ton Production
Shipping Cost Warehouse Warehouse Warehouse Cost Capacity Costs
Atlanta Plant $30 $40 $50 $208 200 Shipping(P––>WH) $20,000
KC Plant $25 $45 $40 $214 300 Shipping(WH––>C) $12,875
Aberdeen Plant $45 $30 $55 $215 300 Production (P) $143,050
Austin Plant $30 $50 $30 $210 400 Variable (WH) $3,125
Total $179,050
Nashville San J ose Hous ton Total
Shipments Warehouse Warehouse Warehouse Produced Capacity
Atlanta Plant 200 0 0 200 <= 200
KC Plant 50 0 0 50 <= 300
Aberdeen Plant 0 300 0 300 <= 300
Austin Plant 0 0 125 125 <= 400
Total 250 300 125
Shipped
Variable
Shipping Cost Sears Best Buy Fry ‘s Comp USA Office Max Cost Capacity
Nashville WH $40 $45 $30 $25 $20 $4 300
San J ose WH $15 $50 $25 $15 $40 $5 500
Hous ton WH $50 $35 $15 $40 $50 $5 500
Total Total
Shipments Sears Best Buy Fry‘s Comp USA Office Max Shipped Out Shipped In Capacity
Nashville WH 0 0 0 100 150 250 <= 250 <= 300
San J ose WH 100 0 0 200 0 300 <= 300 <= 500
Hous ton WH 0 50 75 0 0 125 <= 125 <= 500
Total 100 50 75 300 150
>= >= >= >= >=
Demand 100 50 75 300 150
Distribution Problem (part b)
Nashville San J ose Hous ton Production Fixed Costs
Shipping Cost Warehouse Warehouse Warehouse Cost Capacity Cost Shipping(P––>WH) $21,750
Atlanta Plant $30 $40 $50 $208 200 $8,000 Shipping(WH––>C) $13,750
KC Plant $25 $45 $40 $214 300 $9,000 Production (P) $143,250
Aberdeen Plant $45 $30 $55 $215 300 $9,000 Variable (WH) $3,075
Austin Plant $30 $50 $30 $210 400 $10,000 Fixed (P) $19,000
Fixed (WH) $9,000
Nashville San J ose Hous ton Total Total $209,825
Shipments Warehouse Warehouse Warehouse Produced Capacity Open?
Atlanta Plant 0 0 0 0 <= 0 0
KC Plant 0 0 0 0 <= 0 0
Aberdeen Plant 0 300 0 300 <= 300 1
Austin Plant 300 75 0 375 <= 400 1
Total 300 375 0
Shipped
Variable Fixed
Shipping Cost Sears Bes t Buy Fry‘s Comp USA Office Max Cost Capacity Cost
Nashville WH $40 $45 $30 $25 $20 $4 300 $4,000
San J ose WH $15 $50 $25 $15 $40 $5 500 $5,000
Hous ton WH $50 $35 $15 $40 $50 $5 500 $5,000
Total Total
Shipments Sears Best Buy Fry‘s Comp USA Office Max Shipped Out Shipped In Capacity Open?
Nashville WH 0 50 75 25 150 300 <= 300 <= 300 1
San J ose WH 100 0 0 275 0 375 <= 375 <= 500 1
Hous ton WH 0 0 0 0 0 0 <= 0<= 0 0
Total 100 50 75 300 150
>= >= >= >= >=
Demand 100 50 75 300 150