Homework Help is Here – Start Your Trial Now!
Business
Operations Management
QUESTION Determine the optimal solution to the Attah & Sons problem.

QUESTION Determine the optimal solution to the Attah & Sons problem.

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question

1-ATTA & SONS OPTIMAL SOLUTION

Attah & Sons is a residential Internet Service Provider (ISP) in the central Accra area. Presently, the company operates one centralized facility that all of its clients call into for internet access. To improve service, the company is planning to open three satellite offices in the cities of Tamale, Kumasi and Secondi. The company has identified five different regions to be serviced by these three offices. Table 1 summarizes the number of customers in each region, the service capacity at each office, and the average monthly cost per customer of providing service to each region from each office. Table entries of "n.a." indicate infeasible region to service center combinations. Attah & Sons wants to determine how many customers from each region to assign to each service center in order to minimize cost. 99 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 A В C E F H. | 1 Banuro & Sons Problem Supply/ Fro Cos Node Net Deman 2 Ship То Flow d. Sekon 20000 1 6 di 6.5 1 30000 -30,000 4 10000 1 7 Kumasi 7.5 40000 -40,000 Sekon 40000 2 6 di 7 25000 -25,000 6. 2 7 Kumasi 8. 4 35000 -35,000 Sekon 8.2 7 6 di 33000 -33,000 7.2 8. 25000 7 Kumasi 6 Sekondi 60000 60,000 Tamal 6.7 9. 8 e 7 Kumasi 63000 70,000 7.7 10 4 7 Kumasi 8 Tamale 40000 40,000 Tamal 11 35000 4 8 e 7 Total 12 28000 7 Kumasi 7.5 Cost Tamal 6.7 13 5000 5 8 e 5 QUESTION Determine the optimal solution to the Attah & Sons problem. 2. 3. 3. 3. 3. 3.
Transcribed Image Text:Attah & Sons is a residential Internet Service Provider (ISP) in the central Accra area. Presently, the company operates one centralized facility that all of its clients call into for internet access. To improve service, the company is planning to open three satellite offices in the cities of Tamale, Kumasi and Secondi. The company has identified five different regions to be serviced by these three offices. Table 1 summarizes the number of customers in each region, the service capacity at each office, and the average monthly cost per customer of providing service to each region from each office. Table entries of "n.a." indicate infeasible region to service center combinations. Attah & Sons wants to determine how many customers from each region to assign to each service center in order to minimize cost. 99 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 A В C E F H. | 1 Banuro & Sons Problem Supply/ Fro Cos Node Net Deman 2 Ship То Flow d. Sekon 20000 1 6 di 6.5 1 30000 -30,000 4 10000 1 7 Kumasi 7.5 40000 -40,000 Sekon 40000 2 6 di 7 25000 -25,000 6. 2 7 Kumasi 8. 4 35000 -35,000 Sekon 8.2 7 6 di 33000 -33,000 7.2 8. 25000 7 Kumasi 6 Sekondi 60000 60,000 Tamal 6.7 9. 8 e 7 Kumasi 63000 70,000 7.7 10 4 7 Kumasi 8 Tamale 40000 40,000 Tamal 11 35000 4 8 e 7 Total 12 28000 7 Kumasi 7.5 Cost Tamal 6.7 13 5000 5 8 e 5 QUESTION Determine the optimal solution to the Attah & Sons problem. 2. 3. 3. 3. 3. 3.
Expert Solution
steps

Step by step

Solved in 2 steps with 7 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS