Please explain proper steps by Step and Do Not Give Solution In Image Format ? And Fast Answering Please ? Scenario 3: A manufacturer is considering alternatives for building new plants in order to belocated closer to three of its primary customers, with whom it intends to develop long-termrelationships. The net cost of manufacturing and transporting each unit of the product tothe customers will vary depending on where the plant is built and its production capacity.These costs are summarized in the following table:Plant12345Supply Cost in $ per UnitCustomer A Customer B Customer C304540506550452545453545702065The annual demand for products from customers A, B, and C is expected to be 40,000.25,000, and 35,000 units, respectively. The construction cost and annual production capacityfor each plant are:ConstructionCost$1,325.0002$1,100,0003 $1,500,0004$1,200,000$1,400,000Plant15ProductionCapacity40,00030,00050,00020,00040,000Write and solve a linear optimization model to help the company determine which plantsto build in order to satisfy customer demand at minimum total cost.9. What is the total cost? (in dollars)10. How many plants are built?11. How many units are being made at plant 2?12. How many units is plant 1 shipping to custober B?

Find the Given details below: Given details: Supplier cost Plant Customer A Customer B…

Scenario 3: A manufacturer is considering alternatives for building new plants in order to be located closer to three of its primary customers, with whom it intends to develop long-term relationships. The net cost of manufacturing and transporting each unit of the product to the customers will vary depending on where the plant is built and its production capacity. These costs are summarized in the following table: Supply Cost in $ per Unit Plant Customer A Customer B Customer C 1 30 40 65 2345 45 70 20 65 2345 Plant 1 45 45 The annual demand for products from customers A, B, and C is expected to be 40,000, 25,000, and 35,000 units, respectively. The construction cost and annual production capacity for each plant are: $1,325,000 $1,100,000 $1,500,000 $1,200,000 $1,400,000 Construction Production Cost Capacity 40,000 50 50 30,000 50,000 25 45 20,000 40,000

Scenario 3: A manufacturer is considering alternatives for building new plants in order to be located closer to three of its primary customers, with whom it intends to develop long-term relationships. The net cost of manufacturing and transporting each unit of the product to the customers will vary depending on where the plant is built and its production capacity. These costs are summarized in the following table: Supply Cost in $ per Unit Plant Customer A Customer B Customer C 1 30 40 65 2345 45 70 20 65 2345 Plant 1 45 45 The annual demand for products from customers A, B, and C is expected to be 40,000, 25,000, and 35,000 units, respectively. The construction cost and annual production capacity for each plant are: $1,325,000 $1,100,000 $1,500,000 $1,200,000 $1,400,000 Construction Production Cost Capacity 40,000 50 50 30,000 50,000 25 45 20,000 40,000

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

Need the correct answer to this practice question I found online please What budgetary considerations should a business make when using an outside production company? Based on recommendations from other companies, it should expect to save money. Based on the contracted terms, it should expect to pay the amount on which the two companies agree. Based on recommendations from other companies, it should expect to pay more money. Based on previous experience with the production company, it should include a buffer.
Please do not give solution in image format thanku Give your opinion of police officers who moonlight as private security personnel. Are they ever officially off duty? Explain your answer. Describe in detail the salient points of a comprehensive off duty plan that a department should hold their officers to.
Nine key elements of an e-commerce process architecture serve as the foundation for many companies' current e-commerce activity. At the very least, five of these procedures should be outlined and examined in detail.
Director of operation, warehouse manager, warehouse supervisor, warehouse officer, warehouse information officer, warehouse coordinator, warehouse clerk. Which of all the officer in the list has most complex or complicated job responsibilities and why? (Can name more than one)
One of the engineers at Clearwater Electronics is a devout Muslim and is required to attend prayer services at his mosque during the day on Friday for a short period. He has asked his direct supervisor in the past if he might take time off, but his supervisor said it would be too inconvenient. The engineer has now asked HR for help in determining if a reasonable accommodation could be made so he can attend the midday prayer service. Which of the following statements would be considered the best “reasonable accommodation” HR can present to the supervisor? The company could allow the engineer to take his lunch break to attend the prayer service. If he is late returning, he can make up the time at the end of the day. The company could remodel a storage area as a prayer space, which would require at least six thousand dollars for the remodel because of the need for washroom facilities. The company could ask another employee to cover for the time the engineer is gone and…
Please do not give solution in image format thanku The Muppet Company makes Monster Cookies in several large commercial bakeries across the United States. The process is the same in all the bakeries and consists of mixing the cookie dough, forming the cookies (called base cakes), baking and cooling them. The cooled cookies are then iced and packaged. The packaged cookies are then shipped hourly to a company warehouse. As part of a continuous improvement program, Henson Sullivan, the operations manager in one of these bakeries, wondered if the production process could be improved. To understand the process, she took a pencil and clipboard and drew a value stream map of the cookie process. Henson knew that the monthly production requirement was 12,000 cases. The bakery operated 20 days per month with one 8-hour shift per day with two 30 minute lunch break. Since the line is dedicated to Monster cookies, there is no changeover time or set up time and the current batch size equals one.…
please answer the question within 30 minutes with detailed explanation. Make sure the answers are in detailed manner for better understanding. Else i will give negative ratings.
I need the answer for all task. its humble request. Task A State how you could facilitate effective contributions to, and communications about, continuous improvement processes and outcomes with your staff and other stakeholders. Task B State how you would address sustainability requirements when working on continuous improvement projects. Task C Explain how continuous improvement systems and processes relate to other business systems and requirements including, knowledge management, quality, performance management and sustainability.
Provide examples of firms that have significant investments in technology that improve the customers’ experience with that firm. You can recount experiences with online purchases from Amazon or any firm that arranges for delivery through a parcel or express service that provides online package tracking. Your answer should be approximately 3 (3 firms) well written paragraphs (each paragraph about 50 words).
Response time, the number of transactions that work, and how often the system is available are some of the most important performance indicators for a website. Is this right or wrong?
Explain the benefits of a company automating its documents, specifically spreadsheets
based on the information solved please answer part d) & e)