Linear program transportation example
Not what you're looking for?
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?
Purchase this Solution
Solution Summary
Linear program transportation example is presented.
Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Probability Quiz
Some questions on probability
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.