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 drilli

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:

ATTACHMENT PREVIEW

Download attachment

Variables

Air Cond.

Fans

Units to Produce

40

60

Objective Function

25

15

1900 << Maximize Profit
LHS
RHS
Constraints
3
2
240 <
240
2
1
140 <
240
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.
Unlock Solution Unlocking...
Variables
Alpha4
Beta5
Units to Produce
Objective Function
Constraints
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.
Show entire document