Your model was implemented in Excel with the output given in Figure 2. Use it to answer the questions that follow. Figure 2: Output from Attah & Sons Data B C G Banuro & Sons Problem H. 1 Supply/ Deman Fro Cos Node Net 2 Ship To t Flow Sekon 20000 1 6 di 30000 -30,000 6.5 1 10000 7 Kumasi 7.5 40000 -40,000 Sekon 40000 6 di 25000 -25,000 7 Kumasi 8. 35000 -35,000 Sekon 8.2 6 di 33000 -33,000 7.2 8. 25000 7 Kumasi 6 Sekondi 60000 60,000 Tamal 6.7 6. 8 e 7 Kumasi 63000 70,000 7.7 10 4 7 Kumasi 8 Tamale 40000 40,000 Tamal 11 35000 8 e 7. Total 12 28000 5 7 Kumasi 7.5 Cost Tamal 6.7 13 5000 8 e b) Determine the optimal solution to the Attah & Sons problem. 2. 3. 4. 5. 575 1. 2. 2. 3. 3. 3. 4. 3. 4. 5. 9,
Your model was implemented in Excel with the output given in Figure 2. Use it to answer the questions that follow. Figure 2: Output from Attah & Sons Data B C G Banuro & Sons Problem H. 1 Supply/ Deman Fro Cos Node Net 2 Ship To t Flow Sekon 20000 1 6 di 30000 -30,000 6.5 1 10000 7 Kumasi 7.5 40000 -40,000 Sekon 40000 6 di 25000 -25,000 7 Kumasi 8. 35000 -35,000 Sekon 8.2 6 di 33000 -33,000 7.2 8. 25000 7 Kumasi 6 Sekondi 60000 60,000 Tamal 6.7 6. 8 e 7 Kumasi 63000 70,000 7.7 10 4 7 Kumasi 8 Tamale 40000 40,000 Tamal 11 35000 8 e 7. Total 12 28000 5 7 Kumasi 7.5 Cost Tamal 6.7 13 5000 8 e b) Determine the optimal solution to the Attah & Sons problem. 2. 3. 4. 5. 575 1. 2. 2. 3. 3. 3. 4. 3. 4. 5. 9,
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter9: Decision Making Under Uncertainty
Section9.5: Multistage Decision Problems
Problem 17P
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,