I could use some help!

SHOW ALL WORK FOR ALL PARTS*YOUR SOLUTION SHOULD BE INSTRUCTIONS THAT SOMEONE ELSE CAN FOLLOW TO SOLVE THE PROBLEM 1. (16 points) The Build-Em Fast Bicycle Company has three production plants in four cities. The following table summarizes the costs of transportation between each plant and city. Plant 1 Plant 2 Plant 3 DEMAND Atlanta 3 2 4 6 COSTS TO SHIP Boston Chicago 7 6 4 3 3 8 4 3 Detroit 4 2 5 5 SUPPLY 4 8 6 For each method, explicitly state the minimum total costs and number of items shipped from each from each source to each destination. (a) (4 points) Northwest Corner Rule. Show all intermediate work. Explicitly state the solution in sentence form. (b) (4 points) Vogel's approximation method. Show all intermediate work. Explicitly state the solution in sentence form. () (4 points) Least Cost method. Show all intermediate work. Explicitly state the solution in sentence form. (d) (4 points) Excel Solver. Use Excel Solver to find the optimal solution to the problem. In your solution, include a screen shot of your Excel worksheet showing row numbers and column letters, and a screen shot of the Solver Parameters window. Explicitly state the solution in sentence form