d) solve problem using northwest corner rule: Solution to Part D shown below:

PLEASE ANSWER QUESTIONS F and G BELOW:

A contractor, Susan Meyer, has to haul gravel to three building sites. She can purchase as much as 18 tons at a gravel pit in the north of the city and 14 tons at one in the south. She needs 10, 5, and 10 tons at sites 1, 2, and 3, respectively. The purchase price per ton at each gravel pit and the hauling cost per ton are given in the table below. Hauling Cost per Ton at Site Pit 1 2 3 Price per Ton North $100 $190 $160 $300 420 South 180 110 140 Iter 1 11750.00 D3 D4 ObiVal Name 3 4 v3=460.00 v4=-100.00 460.00 0.00 S1 1 u1=0.00 5 3 0.00 -100.00 530.00 560.00 0.00 S2 2 u2=100.00 7 -100.00 0.00 Demand 10 5 10 Iter 2 ObiVal = 11450.00 D1 D2 D3 D4 Name 1 2 3 4 |v1=400.00|v2=430.00 v3-460.00 v4--100.00 400.00 490.00 460.00 0.00 S1 1 u1=0.00 10 8 0.00 -60.00 0.00 -100.00 600.00 530.00 560.00 0.00 $2 2 u2=100.00 5 2 -100.00 0.00 0.00 0.00 Demand 10 5 10 The Optimal solution is X11=10, X13=8, X22=5, X23=2 and X24=7 Total cost is $11,450 D1 D2 1 2 |v1=400.00|v2=490.00 400.00 490.00 10 0.00 600.00 0.00 60.00 0.00 Supply 18 14 Supply 18 14 (f) Show that the Vogel's approximation method finds the optimal solution obtained in (d); (g) Formulate the transportation problem using LINGO'S modeling language: Define sets, such as sources, destinations and routes (origin-destination pairs) and solve. Verify the optimal solution by comparing it with the one obtained in (d). Generate the ranges report and verify the answer obtained in (e)