#### Details of this Paper

##### The Electrocomp Corporation manufactures two electrical products

**Description**

solution

**Question**

Question;1.The;Electrocomp Corporation manufactures two electrical products: air;conditioners and large fans. The assembly process for each is similar in;that both require a certain amount of wiring and drilling. Each air;conditioner takes 3 hours of wiring and 2 hours of drilling. Each fan;must go through 2 hours of wiring and 1 hour of drilling. During the;next production period, 240 hours of wiring time are available and up to;140 hours of drilling time may be used. Each air conditioner sold;yields a profit of $25. Each fan assembled may be sold for a $15 profit.;Use SOLVER to find the number of air conditioners and fans to produce;in order to maximize profit.2.MSA;Computer Corporation manufactures two models of minicomputers, the;Alpha 4 and the Beta 5. Management has allocated 800 hours of labor for;production. It requires 20 labor hours to assemble each Alpha 4 computer;and 25 labor hours to assemble each Beta 5 model. MSA wants to see at;least 10 Alpha 4s and at least 15 Beta 5s produced during the production;period. Alpha 4s generate $1,200 profit per unit, and Beta 5s yield;$1,800 each. Use SOLVER to determine the most profitable number of each;model of minicomputer to produce during the coming month.3.;The Weinberger Electronics Corporation manufactures four highly;technical products that it supplies to aerospace firms that hold NASA;contracts. Each of the products must pass through the following;departments before they are shipped: wiring, drilling, assembly, and;inspection.Table;A shows each product, its profit per unit, and the amount of time it;must spend in each department. Table B shows the total production time;available in each department for the month. Table C shows the minimum;monthly production requirements to fulfill the firm's contracts.First;use SOLVER to determine the profit-maximizing level of production for;each product. Use the template in columns I:N so that your answers will;end up in the green boxes.Second;suppose that the production manager is unsure of the accuracy of the $9;unit profit figure for XJ201. Use a sensitivity analysis to determine;the range of values that XJ201 unit profit can take without changing the;results of your analysis. Write that answer here

Paper#53657 | Written in 18-Jul-2015

Price :*$19*