Only algabric model with clear steps. no need for GAMSI just need the objective details, constriants, variables and inputsI do have GAMES free licene Case descriptionThe CoolAire Company manufactures air conditioners that are sold to five different retail customers across the United States. Thecompany is evaluating its manufacturing and logistics strategy to ensure that it is operating in the most efficient manner possible. Thecompany can produce air conditioners at six plants across the country and stock these units in any of four different candidatewarehouses. The cost of manufacturing and shipping a unit between each plant and warehouse is summarized in the following tablealong with the monthly capacity and fixed cost of operating each plant.Plant 1Plant 2Plant 3Plant 4Plant 5Plant 6Warehouse 1Warehouse 2Warehouse 3Warehouse 4Warehouse 1$700$800$850$600$500$700DemandWarehouse 2$1,000$500$600Customer 1$40$60$55$80$800$600$600Warehouse 3$900$600$700$500$450$750Customer 2$80$50$40$30Customer 3$60$75$65$80The monthly demand from each customer is summarized next:Customer 1200Customer 2300Warehouse 4$1,200$700$500Similarly, the per-unit cost of shipping units from each warehouse to each customer is given in the following table, along with themonthly fixed cost of operating each warehouse.$600$700$500Customer 4$90$40$60$50Fixed Cost$55,000$40,000$45,000$50,000$42,000$40,000Customer 3200Capacity300200300250350400Customer 5 Fixed Cost Capacity$40,000$50700$35$50,000500$80$35,000400$60$60,000600Customer 4150Impact onenvironment597689Impact onenvironment8795Customer 5250

The CoolAire Company manufactures air conditioners that are sold to five different retail customers across the United States. The company is evaluating its manufacturing and logistics strategy to ensure that it is operating in the most efficient manner possible. The company can produce air conditioners at six plants across the country and stock these units in any of four different candidate warehouses. The cost of manufacturing and shipping a unit between each plant and warehouse is summarized in the following table along with the monthly capacity and fixed cost of operating each plant. Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Plant 6 Warehouse 1 $700 $800 $850 $600 $500 $700 Warehouse 2 $1,000 $500 $600 $800 $600 $600 Warehouse 3 $900 $600 $700 $500 $450 $750 Warehouse 4 $1,200 $700 $500 $600 $700 $500 Fixed Cost $55,000 $40,000 $45,000 $50,000 $42,000 $40,000 Capacity 300 200 300 250 350 400 Impact on environment 5 9 7 6 8 9 Similarly, the per-unit cost of shipping units from each warehouse to each customer is given in the following table, along with the monthly fixed cost of operating each warehouse. Impact on

The CoolAire Company manufactures air conditioners that are sold to five different retail customers across the United States. The company is evaluating its manufacturing and logistics strategy to ensure that it is operating in the most efficient manner possible. The company can produce air conditioners at six plants across the country and stock these units in any of four different candidate warehouses. The cost of manufacturing and shipping a unit between each plant and warehouse is summarized in the following table along with the monthly capacity and fixed cost of operating each plant. Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Plant 6 Warehouse 1 $700 $800 $850 $600 $500 $700 Warehouse 2 $1,000 $500 $600 $800 $600 $600 Warehouse 3 $900 $600 $700 $500 $450 $750 Warehouse 4 $1,200 $700 $500 $600 $700 $500 Fixed Cost $55,000 $40,000 $45,000 $50,000 $42,000 $40,000 Capacity 300 200 300 250 350 400 Impact on environment 5 9 7 6 8 9 Similarly, the per-unit cost of shipping units from each warehouse to each customer is given in the following table, along with the monthly fixed cost of operating each warehouse. Impact on

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

Order qualifiers ________. Group of answer choices Possess the lowest price Possess the minimum of required agility, cost, delivery innovation and quality Possess unique value proposition characteristics None of these answers
1 Please answer in a ABCD Format Thank you!
It is _____________ to waste resources. A: ineffaceable B: ineffable C: inefficient D: ineffective
Demand Planning In a consensus meeting, who are the primary attendees? Marketing manager and sales Demand planner and production planner Demand planner and sales person None of the above
14. For which of the following variables will a log-form be least appropriate? OA. a. Sales in revenue B. b. Sales in units OC.c. Sales as percentage of industry sales D. d. Sale price in dollars.
40 ________ is a planning tool that relies on past data to predict the future demand: Select one: a. Forecasting b. Market analysis c. Supply planning d. Demand flow strategy
The following impacts product quality on corporate performance EXCEPT_____. a. product quality is determinant of business profitability b. high quality producers can usually charge premium prices c. quality improvement increased cost of production d. quality is related to higher return of investment
1 - An application software that can run on mobile phones is called ______. Rooting Apps Bids HTML
The negative relationship between prices and quantity demanded happens because of ______ Group of answer choices consumers acting rationally supply costs market equilibrium the downward sloping demand curve
A company can keep itself flexible by following a arises. Multiple Choice Non-equity, high-investment plan Non-equity, low-investment plan High-resource commitment plan Low-resource commitment plan which allows the firm to switch partners or exit the market altogether if the need
Characteristics of goods are that a. products are tangible. b. there are consistent definitions and specifications of the products. c. production is usually separate from consumption. d. products can be inventoried. e. they are all of the above.