Anonymous

### Question Description

The CoolAire Company manufacturers air conditioners that are sold to four 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 cost effective manner possible. The company produces air conditioners at five plants across the country and stocks these units at four warehouses before finally shipping to the retail locations.

### Unformatted Attachment Preview

Network Models The CoolAire Company manufacturers air conditioners that are sold to four 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 cost effective manner possible. The company produces air conditioners at five plants across the country and stocks these units at four warehouses before finally shipping to the retail locations. The cost of manufacturing and shipping a unit between plants and warehouses, cost of shipping between warehouses and retail locations, plant capacities, and retail location demands are shown below: Plant/Warehouse Warehouse Warehouse Warehouse Warehouse 1 2 3 4 Plant 1 \$700 \$1,000 \$900 \$1,200 Plant 2 \$800 \$500 \$600 \$700 Plant 3 \$850 \$600 \$700 \$500 Plant 4 \$600 \$800 \$500 \$600 Plant 5 \$500 \$600 \$400 \$700 Warehouse/Retail Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 Demand Retail 1 \$40 \$60 \$55 \$80 200 Retail 2 \$80 \$50 \$40 \$30 300 Retail 3 \$60 \$75 \$65 \$80 200 Retail 4 \$90 \$40 \$60 \$50 150 CoolAir would like to determine the optimal shipment plan across their supply chain network by minimizing cost. 1. Draw a network diagram showing the supply chain network for CoolAir. 2. Clearly define and list the decision variables and express objective function and all constraints in mathematical form. 3. Develop a decision model in EXCEL and identify the optimal shipment plan (Include all EXCEL reports) Plant Capacity 300 200 300 250 350 4. If there is a fixed cost of producing air conditioners at each of the plants as shown below: Plant 1- \$100,000 Plant 2- \$150,000 Plant 3- \$200,000 Plant 4- \$95,000 Plant 5- \$125,000 Revise the problem formulation to address the plant selection decisions in addition to optimal shipment decisions. Clearly define and list the decision variables and express objective function and all constraints in mathematical form. Solve the problem in EXCEL and discuss the solution ...
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.
Tags: ABC

This question has not been answered.

Create a free account to get help with this and any other question!

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors