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 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 Warehouse 1 Warehouse 2 Warehouse 3 Warehouse + Fixed Cost Capacity Plant 1 $700 $1,000 $900 $1,200 $55,000 300 Plant 2 $800 $500 $600 $700 $40,000 200 Plant 3 $850 $600 $700 $500 $45,000 Plant 4 $600 $800 $500 $600 $50,000 250 Plant 5 $500 $600 $450 $700 $42.000 Plant 6 $700 $600 $750 $500 $40,000 400 300 350 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. Customer 1 Customer 2 Customer 3 Customer 4 Customer 5 Fixed Cost Warehouse 1 $40 $80 $60 $90 $50 $40,000 Warehouse 2 $60 $50 $75 $40 $35 $50,000 Warehouse 3 $55 $40 $65 $60 $80 $35,000 Warehouse 4 $80 $30 $80 $50 $60 $60,000 The monthly demand from each customer is summarized next: Customer 1 Customer 2 Customer 3 Customer 4 Customer 5 Demand 200 200 150 250 300 CoolAire would like to determine which plants and warehouses it should operate to meet demand in the most cost-effective manner. You can download the excel file and the problem statement by clicking here. E Question 1 O pts G B D E 19 Decision Variables 20 Opes or Not Opeor Not 21 Plant Warehouse 1 22 Part2 Www2 23 Plast Warehouse 3 24 Plant Warehouse 4 25 Plant Plus 6 27 28 Production and Shipment Amt. Wanthouse Warehouse Warehouse 3 Warmhouse 4 29 Plant 1 30 P2 31 Plant 32 Plant 33 Plus 34 Plant 35 36 Shipment Amout Customer1 Cure Customer 37 Warehouse 1 38 Warehouse 39 Warehouse 3 40 Warehouse 41 Customers 43 LIS RAS Effective Upper Bound Plant Plant 2 45 Pla 46 47 48 49 50 51 52 53 54 55 56 57 58 En Plant Plant Plast 6 Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 Warehouse Balance Constraints Warehouse 1 Warehouse 2 Warehouse Warehouse 4 Consider The CoolAire Company problem and the screenshot above. What type of decision variables are in range F21:F24? O Integer Continuous Random Binary Question 2 O pts G Customer A B D E F 19 Decision Variables 20 Opes or Not Opeor Not 21 Plant Warehouse 1 22 Plan 2 Warmhouse 2 23 Plant Warehouse 3 24 Plan 4 Whouse 4 25 Plants 26 Plast 27 28 Production and Shipment Amt. Warehouse Who? Warehouse Warehouse 4 29 Plant 30 Plast 32 Plant 4 33 Plants 34 Plant 35 36 Shipment Ameat Customer1 Customer Cu 4 37 Warehouse 1 38 Warehouse 2 39 Warehouse 3 40 Warehouse 41 42 Subject to 43 Effective Upper Bel LES RAS 44 Pa 45 Plast 2 46 47 Planet 48 Plants 49 Plant 6 50 Warehouse 1 51 Warehouse 2 Warehouse 3 53 Warehouse 4 54 Warehouse Balance Constraints 55 Warehouse 1 56 Warehouse 2 57 Warehouse 3 58 Warehouse 4 Consider The CoolAire Company problem and the screenshot above. To model linkage between opening Plant 3 and shipment from Plant 3 to warehouses (Row 46,) select correct LHS, RHS, and the relation between them using the drop-down boxes. LHS Relation RHS Select] [Select) (Select) Question 3 O pts E F G Op or Not Warehouse 1 Warehouse 2 Warehouse 3 Www Plast 6 Warmhouse 4 Plet Customer Custom 4 Customers B D 19 Decision Variables 20 Opea or Not 21 Plut! 22 Plant 2 23 Plast 24 Plan 25 Plot 5 26 27 28 Production and Shipment Amt. Wasthouse 29 Plast 30 31 32 Plast 4 33 Plants 34 Plan 6 33 36 Shipment Amout Customer1 Con 2 37 Warehouse 38 Warehouse 39 Warehouse 3 40 Warehomet 41 42 Subject to Effective Upper Bound LES Plant 45 Plant 2 46 Plant 47 Plant 4 48 49 Plant 6 50 Warehouse 1 51 Warehouse 2 52 Warehouse 3 53 Warehouse 4 54 Warehouse Balance Constraints 55 Warehouse 1 56 Warehouse 57 Warehouse 3 58 Warehouse 4 RIS Planes en Consider The CoolAire Company problem and the screenshot above. To model linkage between opening Warehouse 4 and shipment from Warehouse 4 to customers (Row 53.) select correct LHS, RHS, and the relation between them using the drop-down boxes. LHS Relation RHS Select) (Select) [Select] Question 4 O pts G Plast Customers B D E 19 Decision Variables 20 Opeor Not Op or Not 21 Planet Warehouse 1 22 Plant 2 Warmhouse 2 23 Warehouse 3 24 Plan Whouse 4 25 Plus 26 Plast 6 27 28 Production and Shipment Amt. Warehouse 1 Warehouse 2 Warehouse Ww howed 29 Plast 30 Plant 2 Plant 32 Plast 4 33 Plant 34 Plan 6 35 36 Shipment Amout Customer1 Custom 2 Customer 4 37 Warehouse 1 38 Warehouse 39 Warehouse 40 Warehouse 41 42 Subject to 43 Effective Upper Bound LES RIS Plant 45 Plant 2 46 Plant Plast 48 Plants 49 Plant 6 50 Warehouse 51 Warehouse 2 52 Warehouse 53 Warehouse 4 54 Warehouse Balance Constraints 55 Warehouse 1 56 Warehouse 2 57 Warehouse 58 Warehouse en Consider The CoolAire Company problem and the screenshot above. To make sure that Warehouse 2 cannot ship out more airconditioner than it receives (Row 56,) select correct LHS, RHS, and the relation between them using the drop-down boxes. LHS Relation RHS Select) [Select) [Select] 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 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 Warehouse 1 Warehouse 2 Warehouse 3 Warehouse + Fixed Cost Capacity Plant 1 $700 $1,000 $900 $1,200 $55,000 300 Plant 2 $800 $500 $600 $700 $40,000 200 Plant 3 $850 $600 $700 $500 $45,000 Plant 4 $600 $800 $500 $600 $50,000 250 Plant 5 $500 $600 $450 $700 $42.000 Plant 6 $700 $600 $750 $500 $40,000 400 300 350 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. Customer 1 Customer 2 Customer 3 Customer 4 Customer 5 Fixed Cost Warehouse 1 $40 $80 $60 $90 $50 $40,000 Warehouse 2 $60 $50 $75 $40 $35 $50,000 Warehouse 3 $55 $40 $65 $60 $80 $35,000 Warehouse 4 $80 $30 $80 $50 $60 $60,000 The monthly demand from each customer is summarized next: Customer 1 Customer 2 Customer 3 Customer 4 Customer 5 Demand 200 200 150 250 300 CoolAire would like to determine which plants and warehouses it should operate to meet demand in the most cost-effective manner. You can download the excel file and the problem statement by clicking here. E Question 1 O pts G B D E 19 Decision Variables 20 Opes or Not Opeor Not 21 Plant Warehouse 1 22 Part2 Www2 23 Plast Warehouse 3 24 Plant Warehouse 4 25 Plant Plus 6 27 28 Production and Shipment Amt. Wanthouse Warehouse Warehouse 3 Warmhouse 4 29 Plant 1 30 P2 31 Plant 32 Plant 33 Plus 34 Plant 35 36 Shipment Amout Customer1 Cure Customer 37 Warehouse 1 38 Warehouse 39 Warehouse 3 40 Warehouse 41 Customers 43 LIS RAS Effective Upper Bound Plant Plant 2 45 Pla 46 47 48 49 50 51 52 53 54 55 56 57 58 En Plant Plant Plast 6 Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 Warehouse Balance Constraints Warehouse 1 Warehouse 2 Warehouse Warehouse 4 Consider The CoolAire Company problem and the screenshot above. What type of decision variables are in range F21:F24? O Integer Continuous Random Binary Question 2 O pts G Customer A B D E F 19 Decision Variables 20 Opes or Not Opeor Not 21 Plant Warehouse 1 22 Plan 2 Warmhouse 2 23 Plant Warehouse 3 24 Plan 4 Whouse 4 25 Plants 26 Plast 27 28 Production and Shipment Amt. Warehouse Who? Warehouse Warehouse 4 29 Plant 30 Plast 32 Plant 4 33 Plants 34 Plant 35 36 Shipment Ameat Customer1 Customer Cu 4 37 Warehouse 1 38 Warehouse 2 39 Warehouse 3 40 Warehouse 41 42 Subject to 43 Effective Upper Bel LES RAS 44 Pa 45 Plast 2 46 47 Planet 48 Plants 49 Plant 6 50 Warehouse 1 51 Warehouse 2 Warehouse 3 53 Warehouse 4 54 Warehouse Balance Constraints 55 Warehouse 1 56 Warehouse 2 57 Warehouse 3 58 Warehouse 4 Consider The CoolAire Company problem and the screenshot above. To model linkage between opening Plant 3 and shipment from Plant 3 to warehouses (Row 46,) select correct LHS, RHS, and the relation between them using the drop-down boxes. LHS Relation RHS Select] [Select) (Select) Question 3 O pts E F G Op or Not Warehouse 1 Warehouse 2 Warehouse 3 Www Plast 6 Warmhouse 4 Plet Customer Custom 4 Customers B D 19 Decision Variables 20 Opea or Not 21 Plut! 22 Plant 2 23 Plast 24 Plan 25 Plot 5 26 27 28 Production and Shipment Amt. Wasthouse 29 Plast 30 31 32 Plast 4 33 Plants 34 Plan 6 33 36 Shipment Amout Customer1 Con 2 37 Warehouse 38 Warehouse 39 Warehouse 3 40 Warehomet 41 42 Subject to Effective Upper Bound LES Plant 45 Plant 2 46 Plant 47 Plant 4 48 49 Plant 6 50 Warehouse 1 51 Warehouse 2 52 Warehouse 3 53 Warehouse 4 54 Warehouse Balance Constraints 55 Warehouse 1 56 Warehouse 57 Warehouse 3 58 Warehouse 4 RIS Planes en Consider The CoolAire Company problem and the screenshot above. To model linkage between opening Warehouse 4 and shipment from Warehouse 4 to customers (Row 53.) select correct LHS, RHS, and the relation between them using the drop-down boxes. LHS Relation RHS Select) (Select) [Select] Question 4 O pts G Plast Customers B D E 19 Decision Variables 20 Opeor Not Op or Not 21 Planet Warehouse 1 22 Plant 2 Warmhouse 2 23 Warehouse 3 24 Plan Whouse 4 25 Plus 26 Plast 6 27 28 Production and Shipment Amt. Warehouse 1 Warehouse 2 Warehouse Ww howed 29 Plast 30 Plant 2 Plant 32 Plast 4 33 Plant 34 Plan 6 35 36 Shipment Amout Customer1 Custom 2 Customer 4 37 Warehouse 1 38 Warehouse 39 Warehouse 40 Warehouse 41 42 Subject to 43 Effective Upper Bound LES RIS Plant 45 Plant 2 46 Plant Plast 48 Plants 49 Plant 6 50 Warehouse 51 Warehouse 2 52 Warehouse 53 Warehouse 4 54 Warehouse Balance Constraints 55 Warehouse 1 56 Warehouse 2 57 Warehouse 58 Warehouse en Consider The CoolAire Company problem and the screenshot above. To make sure that Warehouse 2 cannot ship out more airconditioner than it receives (Row 56,) select correct LHS, RHS, and the relation between them using the drop-down boxes. LHS Relation RHS Select) [Select) [Select]