Problem:
Linear program transportation example
Please solve the following transportation problem using Excel 97-2000 using solver. Please post the Excel spreadsheet that answers the following questions.
A logistic specialist for Wiethoff Inc. must distribute cases of parts from 3 factories to 3 assembly plants. The monthly supplies and demands, along with the per-case transportation costs are:
Destination Asembly Plant
1 2 3 Supply
___________________________________________
Source A 5 9 16 200
Factory B 1 2 6 400
C 2 8 7 200
___________________________________________
Demand 120 620 60
1)Using the optimal solution, how many cases of parts should be shipped from factory C to assembly plant 1?
2)What is the cost of shipping these units from factory B to assembly plant 1?
3)What is the objective function for the linear programming formulation of this problem?
4)What are the supply constraints for the factories?
5)What are the demand constraints for the assembly plants?
6)What are the total monthly transportation costs for the optimal solution?
7)Based on the optimal solution, how many cases of parts should be shipped from factory B to assembly plant 2?