Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started