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, Kumasiand 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 theaverage 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 inorder to minimize cost.99Your 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 DataAВCEFH.|1Banuro & Sons ProblemSupply/FroCos NodeNetDeman2 ShipТоFlowd.Sekon2000016 di6.5130000 -30,00041000017 Kumasi 7.540000 -40,000Sekon4000026 di725000 -25,0006.27 Kumasi8.435000 -35,000Sekon8.276 di33000 -33,0007.28.250007 Kumasi6 Sekondi6000060,000Tamal6.79.8 e7 Kumasi6300070,0007.71047 Kumasi8 Tamale4000040,000Tamal113500048 e7Total12280007 Kumasi7.5CostTamal6.713500058 e5QUESTIONDetermine the optimal solution to the Attah & Sons problem.2.3.3.3.3.3.

Find the Given details below: Given details Region Sekondi Kumasi Tamale Customers 1 6.50…

Answered: QUESTION Determine the optimal solution…

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

Similar questions

S1.16/The Willow Café is located in an open-air mall. Its lease expires this year and the restaurant owner has the option of signing a 1-, 2-, 3-, 4-, or 5-year lease. However, the owner is concerned about recent energy price increases (including the price of gasoline), which affect virtually every aspect of the restaurant operation, including the price of food items and materials, delivery costs, and its own utilities. The restaurant was very profitable when energy prices were lower, and the owner believes if prices remain at approximately their cur- rent level profits will still be satisfactory; however, if prices continue to rise he believes that he might be forced to close. In these latter circumstances a longer-term lease could be a financial disaster, but with a shorter-term lease the mall landlord could always rent the restaurant's space out from under it when the lease expires. Thus, the restaurant owner's estimates of future profits must also reflect the possibility that the…
Please do not give solution in image format thanku
Q. Hotel California has 160 rooms. The hotel has an ample low-fare demand at the room rate of $200 per night, but the demand from the high-fare class which pays $450 per night on average, is uncertain. Table below shows the number of high-fare rooms that were booked during the past 30 days. How many rooms should Hotel California protect for high-fare customers to maximize its expected revenue? Number of high-fare rooms Frequency 0 5 1 3 2 6 3 8 4 4 5 1 6 1 7 2 Total=30
1. The drug distribution company LOS PAISAS wants to build a new warehouse in Carretera a Masaya area in which they intend to store the following products: equipment and products for babies. With these products, they plan to serve a total of 10,000 pharmacies in Managua. Equipments Baby products Demand (quantity pharmacies served) 2,000 8,000 Cost per product $1,000.00 $30.00 To achieve balanced use of products, baby product must be equal to 60% of authorized product units. Additionally, the number of units requested in medical equipment must be at least 20% of the total authorized. There are a total of 10,000 pharmacies. The optimal plan needs to be determined to maximize the amount of products they must have to meet demand and maximize profits. Can you please explain it Step-by-step and typed? Thank you in advance!
Question 4) plz help
Question 36 Although network models are valuable tools in decision-making, we discussed how a transportation minimization model might distort a realistic decision. How? There is no alternative that will consistently provide optimal, integer solutions. Cost data will change over time. Only the cheapest markets to get to are fully satisfied which might leave other demand locations with reduced supply. Problem data may be wrong.
1
Moving to another question will save this response. Question 12 A channel consisting of one or more independent producers, wholesalers, or retailers that seek to maximize their own profits - even at the expense of profits for the channel as a whole - is a(n): O a. vertical marketing system O b. corporate VMS Oc administered vertical marketing system O d. conventional distribution channel O e. horizontal marketing system A Moving to another question will save this response. hp
Question 4 Carefully explain what is happening in the following markets. Indicate the impact if any on demand, supply, price and quantity Scenario 1: Market for 21 ft Ladders $21 FoOT LADDER RENTALS Fa BORDER FENCE OPE SCON Impact on demand Choose. Impact on supply Choose. Impact on price Choose. Impact on quantity Choose.
Question No. 01: You are planning to start a new restaurant by the name of “Chai Wageria” where you need to evaluate the macro environment, evaluate 4P’s, what will be your target market and segmentation and what value and usp you will provide to your customers.
Corporations are small percentage: however they earn the most revenue among U.S. busnesses
Q 7. Explain the importance of multi-channel marketplace models.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

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