to compute the minimum shipping cost (all three methods). Please pay attention to the unit of demand, it should not have a $ sign | |||||||||||||
You need to put your total cost on the cell next to the red cell. Under solver, show your work (solver). I need to see the formula when I click your total cost (all three of them) |
B): Northwest-corner rule | ||||
Los Angeles | Calgary | Panam City | Factory capacity | |
Mexico City costs | $4.37 | $4.25 | $4.89 |
12000 |
Mexico City units | ||||
Detroit costs | $4.00 | $5.00 | $5.27 |
10000 |
Detroit units | ||||
Ottawa costs | $4.13 | $4.50 | $3.73 |
18000 |
Ottawa units | ||||
Demand | 6000 | 22000 | 12000 | |
Total cost: |
The solver model is shown below
The formulas that you should use are shown below
The solver parameters are shown below
The result is shown below
to compute the minimum shipping cost (all three methods). Please pay attention to the unit of...
Just need the ones not highlighted in blue completed. Makes sure you use the intuitive lowest cost method... thank you! The starting solution using the intuitive lowest-cost method is: (Note: You must enter a shipment in every cell, even if the shipment is 0.) To Los Angeles Calgary From Panama City $18 Supply Mexico City 160 140 20 $19 90 $13 $1 Detroit 10 $10 70 0 80 $20 $24 Ottawa 70 0 0 Demand 140 80 100 Enter your...