please solve using excel Solver Sensitivity

please solve using excel solver

4.4 Make or Buy: A sudden increase in the demand for smoke detectors has leht Acme Alarms with insufficient capacity to meet demand. The company has seen monthly demand for its electronic and battery-operated detectors rise to 20,000 and 10,000, respectively, and Acme wishes to continue meeting demand. Acme's production process involves three departments: fabrication, assembly, and shipping. The relevant quantitative data on production and prices are sum- the corresponding make/buy levels? (This is a planning model; fractional (b) Investigate the solution for Shipping capacities between 1200 and 2400 hours. Draw a graph showing how the optimal quantities change over marized below. Department Fabrication Assembly Shipping Variable cost/unit Retail price Monthly Hours Hours/Unit Hours/Unit Available (Electronic) (Battery) 2000 0.15 0.10 4200 0.20 0.20 2500 0.100.15 hosto in $18.80 $16.00 $29.50 $28.00 The company also has the option of obtaining additional units from a subcon- tractor, who has offered to supply up to 20,000 units per month in any combination of electronic and battery-operated models, at a charge of $21.50 per unit. For this price, the subcontractor will test and ship its models directly to the retailers without using Acme's production process. (a) Determine how the manufacturer should allocate its in-house capacity and how it should utilize the subcontractor. What are the maximum profit and decisions are acceptable.) this range. 4.4 Make or Buy: A sudden increase in the demand for smoke detectors has leh Acme Alarms with insufficient capacity to meet demand. The company has seen monthly demand for its electronic and battery-operated detectors rise to 20,000 and 10,000, respectively, and Acme wishes to continue meeting demand. Acme's production process involves three departments: fabrication, assembly, and shipping. The relevant quantitative data on production and prices are sum- (b) Investigate the solution for Shipping capacities between 1200 and 2400 hours. Draw a graph showing how the optimal quantities change over the corresponding make/buy levels? (This is a planning model; fractional marized below. Hours/Unit (Battery) 0.10 Department Fabrication Assembly Shipping Variable cost/unit Retail price Monthly Hours Hours/Unit Available (Electronic) 2000 0.15 4200 0.20 0.20 2500M 0.100.15 to $18.80 $16.00 $29.50 $28.00 The company also has the option of obtaining additional units from a subcon- tractor, who has offered to supply up to 20,000 units per month in any combination of electronic and battery-operated models, at a charge of $21.50 per unit. For this price, the subcontractor will test and ship its models directly to the retailers without using Acme's production process. (a) Determine how the manufacturer should allocate its in-house capacity and how it should utilize the subcontractor. What are the maximum profit and decisions are acceptable.) this range. 4.4 Make or Buy: A sudden increase in the demand for smoke detectors has leht Acme Alarms with insufficient capacity to meet demand. The company has seen monthly demand for its electronic and battery-operated detectors rise to 20,000 and 10,000, respectively, and Acme wishes to continue meeting demand. Acme's production process involves three departments: fabrication, assembly, and shipping. The relevant quantitative data on production and prices are sum- the corresponding make/buy levels? (This is a planning model; fractional (b) Investigate the solution for Shipping capacities between 1200 and 2400 hours. Draw a graph showing how the optimal quantities change over marized below. Department Fabrication Assembly Shipping Variable cost/unit Retail price Monthly Hours Hours/Unit Hours/Unit Available (Electronic) (Battery) 2000 0.15 0.10 4200 0.20 0.20 2500 0.100.15 hosto in $18.80 $16.00 $29.50 $28.00 The company also has the option of obtaining additional units from a subcon- tractor, who has offered to supply up to 20,000 units per month in any combination of electronic and battery-operated models, at a charge of $21.50 per unit. For this price, the subcontractor will test and ship its models directly to the retailers without using Acme's production process. (a) Determine how the manufacturer should allocate its in-house capacity and how it should utilize the subcontractor. What are the maximum profit and decisions are acceptable.) this range. 4.4 Make or Buy: A sudden increase in the demand for smoke detectors has leh Acme Alarms with insufficient capacity to meet demand. The company has seen monthly demand for its electronic and battery-operated detectors rise to 20,000 and 10,000, respectively, and Acme wishes to continue meeting demand. Acme's production process involves three departments: fabrication, assembly, and shipping. The relevant quantitative data on production and prices are sum- (b) Investigate the solution for Shipping capacities between 1200 and 2400 hours. Draw a graph showing how the optimal quantities change over the corresponding make/buy levels? (This is a planning model; fractional marized below. Hours/Unit (Battery) 0.10 Department Fabrication Assembly Shipping Variable cost/unit Retail price Monthly Hours Hours/Unit Available (Electronic) 2000 0.15 4200 0.20 0.20 2500M 0.100.15 to $18.80 $16.00 $29.50 $28.00 The company also has the option of obtaining additional units from a subcon- tractor, who has offered to supply up to 20,000 units per month in any combination of electronic and battery-operated models, at a charge of $21.50 per unit. For this price, the subcontractor will test and ship its models directly to the retailers without using Acme's production process. (a) Determine how the manufacturer should allocate its in-house capacity and how it should utilize the subcontractor. What are the maximum profit and decisions are acceptable.) this range