Question
I need help with the constraints for a transportation model using Solver (Simplex LP). I have solved the problem but I'm not getting the correct
I need help with the constraints for a transportation model using Solver (Simplex LP). I have solved the problem but I'm not getting the correct value for total cost, as can be seen in my attached Excel file. A few of my constraints might be wrong or I am missing a few constraints. I'm not exactly sure.
Question:
Using Solver determine how many units should be produced at each company and shipped to each assembly plant so that total costs are minimized subject to the restrictions that:
- - each assembly plant will get all the engines that it requires
- - each company cannot not produce more than its capacity allows them to produce
- - Company Y must produce and ship its capacity of 2300
- - Company Y cannot ship any engines to Assembly Plant C
If you solved this problem correctly, your total cost should be $249,200.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started