Answer all please and I'll give thumbs up!

. [12 Pt.) The Midlands Field Produce Company contracts with potato farmers in Colorado, Minnesota, North Dakota, and Wisconsin for monthly potato shipments. The company picks up the potatoes at the farms and ships by truck to its sorting and distribution centers in Ohio, Missouri, and lowa. At these centers the potatoes are cleaned, rejected and discarded, and the potatoes are sorted according to size and quality. They are then shipped to combination plants and distribution centers in Virginia, Pennsylvania, Georgia, and Texas, where the company produces a variety of potato products and distributes bags of potatoes to stores. Following are summaries of the shipping costs from the farms to the distribution centers and the processing and shipping costs from the distribution centers to the plants, as well as the available monthly supply at each farm, the processing capacity at the distribution centers, and the final demand at the plants (in bushels): Farm 1. Colorado 2. Minnesota 3. North Dakota 4. Wisconsin Processing Capacity (bushels) Distribution Center ($/bushel) 5. Ohio 6. Missouri 7. Iowa 1.20 1.09 1.26 0.89 1.32 1.17 0.78 1.22 1.36 1.19 1.25 1.42 1800 2200 1600 Supply (bushel) 1600 1100 1400 1900 Distribution Center 5. Ohio 6. Missouri 7. Iowa Demand (bushels) Plant ($/bushel) 8. Virginia 9. Pennsylvania 10. Georgia 4.56 3.98 4.94 3.43 5.74 4.65 5.39 6.35 5.70 1200 900 1100 11. Texas 5.10 5.01 4.87 1500 The company wants to determine the optimal monthly shipments from the farms to the distribution centers and from the distribution centers and the plants to minimize tot al shipping and processing costs. To solve the problem using the MS Excel solver, the given information is entered in a spreadsheet as follows. H J K M Shipped Supply 1600 1100 1400 1900 Shipping Costs ($/buahel): Distnbution Contor Farm 5 6 7 1 1.20 1.09 1 26 2 0.89 1.32 1.17 3 0.78 1.22 1.36 4 1.19 1.25 1.42 A B D 1 Problem 2 2 3 Distnbution Center 4 Farm 5 6 7 5 1 0 0 0 6 2 0 0 0 7 3 0 0 0 8 4 0 0 0 9 Capacity 1800 2200 1600 10 Shipped B 11 12 Transshipment flows 13 Distribution 5 C 14 center 6 15 7 16 17 18 Distribution Center 8 9 19 5 0 0 20 6 0 0 7 0 0 22 Demand 1200 900 Shipped E Plant Shipped 10 0 0 0 1100 11 0 0 0 1500 Shipping Costs (S/bushel); Distribution Plant Center 8 9 5 456 3.98 6 3.43 5.74 7 5.39 6.35 D 10 494 4.65 5.70 11 5.1 5.01 4.87 25 Total Cost = F (1) [12 Pt.: 2 pt. for each] For the blank cells in the spreadsheet, select appropriate functions from the functions in the following table: a) =SUM(C5:D5) i) =B10-G19 p) =SUM(C19:F19) b) =SUM(B6:D6) j) =C10-G20 q) =SUM(C20:F20) c) =SUM(B7:D7) k) =D10-G21 r) =SUM(C21:F21) d) =SUM(B8:D8) 1) =F5-C23 s) =SUM(C19:C21) f) =SUM(B5:B8) m) =F6-D23 t) =SUM(D19:D21) g) =SUM(C5:C8) n) =F7-E23 u) =SUM(E19:E21) h) =SUM(D5:D8) o)=F8-F23 v) =SUM(F19:F21) w) =SUMPRODUCT(B5:D8,5:L8) x) =SUMPRODUCT(C19:F21,J19:M21) y) =SUMPRODUCT(B5:D8,55:L8)+SUMPRODUCT(C19:F21,J19:M21) i. A (cell F6) for total shipments from Farm 2 to all the distribution centers: ii. B (cell D10) for total shipments from all the farms to Distribution Center 7: jil. C (cell C13) for the transshipment flow at Distribution Center 5: iv. D (cell G20) for total shipments from Distribution Center 6 to all the plants: V. E (cell C23) for total shipments from all the distribution centers to Plant 8: vi. F (cell C25) for the total shipment costs, i.e., the objective value