Question

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:

Answer 1

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