Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services

Authors: William MessierSteven Glover

7th Edition

0073527084, 9780073527086

More Books

Students also viewed these Accounting questions

Question

What conditions increase the demand for reliable information?

Answered: 1 week ago

Question

How is communication defi ned?

Answered: 1 week ago

Question

What are the benefi ts of studying communication?

Answered: 1 week ago