Please do not solve using excel!

F G H 1 J K L M Shipped Shipping Costs (S/bushel): Distribution Center 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 E 1 Problem 2 2. 3 Distribution Center 4 Farm 5 6 7 Supply 5 1 0 0 0 1600 6 2. 0 0 0 0 1100 7 3 0 0 0 1400 8 4 0 0 0 1900 9 Capacity 1800 2200 1600 10 Shipped B 11 12 Transshipment flows: 13 Distribution 5 14 center 6 7 16 17 Plant 18 Distribution Center 8 9 10 19 5 0 0 0 20 6 0 0 0 21 7 0 0 0 22 Demand 1200 900 1100 23 Shipped E 15 Shipped 11 0 0 0 0 1500 Shipping Costs ($/bushel): Distribution Plant Center 8 8 9 5 4.56 3.98 6 3.43 5.74 7 5.39 6.35 10 4.94 4.65 5.70 11 5.1 5.01 4.87 D 24 25 OR Total Cost - F (i) (18 Pt.: 3 pts. for each) For the blank cells in the spreadsheet, select appropriate functions from the functions in the following table: (Don't need to solve the problem with Excel) a) =SUM(C5:D5) i) =B10-G19 p) =SUM(C19:F19) b) =SUM(B6:D6) j) =C10-620 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:08,55: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. (Which of the options is the answer? Choose one option from the table) ii. B (cell D10) for total shipments from all the farms to Distribution Center 7. (Which of the options is the answer? Choose one option from the table) iii. C(cell C13) for the transshipment flow at Distribution Center 5. (Which of the options is the answer? Choose one option from the table) iv. D (cell G20) for total shipments from Distribution Center 6 to all the plants. (Which of the options is the answer? Choose one option from the table) v. E (cell C23) for total shipments from all the distribution centers to Plant 8. (Which of the options is the answer? Choose one option from the table) vi. F (cell C25) for the total shipment costs, i.e., the objective value. (Which of the options is the answer? Choose one option from the table)