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: G H . J K L Shipping Costs ($/ton): Plant Farm 4. Indiana 5. Georgia 1. Ohio 16 21 2. Pennsylvania 18 16 3. New York 22 25 Shipped Shipping Costs (s/ton): B D E F F 1 Homework #6-32 2 3 4 Plant 5 Farm 4. Indiana S. Georgia Supply Shipped 6 1. Ohio 72 0 7 2. Pennsylvania 105 0 8 3. New York 83 0 9 0 0 10 11 12 Distribution Centers 13 Plant Virginia 7. Kentucky 8. Louisiana Shipped 14 4. Indiana 0 15 5. Georgia 0 16 Demand 90 80 120 17 Shipped 0 0 0 18 19 Transshipment flows: 20 Indiana 0 21 Georgia 0 22. 23 24 Cost - 0 Plant Indiana Georgia Distribution Centers 6. Virginia 7. Kentucky 8. Louisiana 23 15 29 20 17 24 HE 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 i to location j. The supply constraint for Pennsylvania is: A) X2,4 + X2,5 = 105 B) X2,4 + X2,5 105 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:B8) + sum(C14:E14) D) = sumproduct(B6:B8, C14:E14) 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:J8) B) = sumproduct(B6:B8, C14:E14) C) = sumproduct(B6:C8, 16:58) + sumproduct(C14:E15, J14:L15) D) = sumproduct(C14:E15, J14: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:C8 C) C14:E15 D) 16:19, 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) C17:E17 = C16:E16 B) C17:E17 105 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:B8) + sum(C14:E14) D) = sumproduct(B6:B8, C14:E14) 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:J8) B) = sumproduct(B6:B8, C14:E14) C) = sumproduct(B6:C8, 16:58) + sumproduct(C14:E15, J14:L15) D) = sumproduct(C14:E15, J14: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:C8 C) C14:E15 D) 16:19, 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) C17:E17 = C16:E16 B) C17:E17