PLEASE SHOW IN EXCEL SOLVER
A sudden increase in the demand for smoke detectors has left 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 summarized below. Monthly Hours Hours/Unit Hours/Unit Department Available (Electronic) (Battery) Fabrication 2000 0.15 0.10 Assembly 4200 0.20 0.20 Shipping 2500 0.10 0.15 Variable cost/unit $18.80 $16.60 Retail price $29.50 $28.00 The company also has the option to obtain additional units from a subcontractor, 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. What are the optimal profit and corresponding make/buy levels? (Fractional quantity decisions are acceptable because this is a planning model.) [20 points] b. Suppose Acme is able to increase its fabrication capacity by 10%. How will the optimal profit and corresponding make/buy mix change? [10 points]
PLEASE SHOW IN EXCEL SOLVER A sudden increase in the demand for smoke detectors has left...
Also please solve by either using excel or R LP solvers
The Magnetron Company manufactures and markets microwave ovens. Currently, the company produces two models: full-size and compact. Production is limited by the amount of labor available in the general assembly and electronic assembly departments, as well as by the demand for each model. Each full-size oven requires 2 hours of general assembly and 2 hours of electronic assembly, whereas each compact oven requires 1 hour of general assembly and...
a. Formulate the corresponding integer programming problem
b. Find an optimal solution using Excel Solver
Cyberdata, a PC manufacturer, currently has two production facilities. The first one is located in Alpha City and has a capacity of 200,000 units a year and an annual fixed cost of 20 million. The second plant is located in Beta City and has a capacity of 60,000 units a year and annual fixed cost of 9 million. The two plants serve the entire country...
please show how to do in excel solver Problem: Coneheads supplies its ice cream parlors with three flavors of ice cream: chocolate, vanilla, and banana. Due to extremely hot weather and a high demand for its products, the company has run short of its supply of ingredients: milk, sugar, and cream. Hence, they will not be able to fill all of the orders received from their retail outlets, the ice cream parlors. Due to these circumstances, the company has decided...
Solve the following LP problems using the Solver in MS Excel. Q1. A candy manufacturer has 130 pounds of chocolate-covered cherries and 170 pounds of chocolate-covered mints in stock. He decides to sell them in the form of two different mixtures. One mixture will contain half cherries and half mints by weight and will sell for $2.00 per pound. The other mixture will contain one-third cherries and two-thirds mints by weight and will sell for $1.25 per pound. How many...