These questions deal with problem 6-32. This transshipment problem concerns a fruit company who contracts with farms, plants, and distribution centers. They want to determine the optimal shipments from farms to plants to distribution centers to minimize total transportation costs. The Excel spreadsheet, including transportation costs per ton from the farms to the plants and from the plants to the distributors, and the supply at the farms and demand at the distribution centers, is pasted below: B D F G M K Homework 15-32 2 3 4 5 8 pl non sono Shipped Form 1. Ohe Persyara 3. Yer Shaped 72 105 Shipping Cowho Part ndana 5. rogol 16 21 2. Pe 10 16 3 New York 22 25 1. Oh 0 0 9 0 Sipping Cost (ton: 9 10 10 12 13 14 15 16 17 18 Dibution Plan EVOLURDE 0 Song Demand 90 10 120 0 0 plan Insane George OTOVO og Kentucky Louisiana 23 15 29 20 17 20 0 0 24 Costa 1. T/F: This is a "balanced" transshipment problem? A) True B) False 2. Let xij represent the amount of fruit shipped in 1000's of tons) from location ito location j. The supply constraint for Pennsylvania is: A) X24 + x2 - 105 B) X24 + x23 S 105 C) X2,4 + X232105 D) Don't pick this one 3. The Excel formula for the amount of fruit shipped to Indiana is: A) = sum(B6:38) B) = sum(C14:E14) C) = sum(B6:38) + sum(C14:E14) D) - sumproduct(B6:38. C14:14) 4. The Excel formula for the transshipment flow for Indiana in cell C20 is calculated as: A) = sum(16:19) - sum(J14:L14) B) =B9-F14 C) = sum(D6:D8) - sum(C16:E16) D) = sum(E6:E8) - sum(C17:E17) 5. The Excel formula for the objective function in cell C24 is: A) = sumproduct(B6:C8, 16:58) B) = sumproduct(B6:B8, C14:E14) C) = sumproduct(B6:C8, 16:38) + sumproduct(C14:E15, J14:L15) D) = sumproduct(C14:E15, 14:L15) 6. The Excel formula that should be entered into the "By Changing Variable Cells" window in the Excel solver is: A) 6:C8, C14:E15 B) 'B6:08 C) C14:15 D) 16:9, J14:L15 7. The Excel formula that should be entered into the "Subject to the constraints" window in the Excel solver for the demand constraints is: A) C17E17 = C16:E16 B) C17:E17C16:16 C) E6:E8 = D6:D D) E6:E8