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.