Use Excel to solve the linear programming problem.
Use Excel to solve the linear programming problem.
At one of its factories, a manufacturer of televisions makes one or more of four models of HD units (without cases): a 20-in. LCD, a 42-in. LCD, a 42-in. plasma, and a 50-in. plasma. The assembly and testing time requirements for each model are shown in the table, together with the maximum amounts of time available per week for assembly and testing. In addition to these constraints, the supplier of cases indicated that it would supply no more than 290 cases per week and that of these, no more than 40 could be for the 20-in. LCD model.
Use the profit for each television shown in the table to find the number of completed models of each type that should be produced to obtain the maximum profit for the week. Find the maximum profit.
| 20-in. LCD | sets | |
| 42-in. LCD | sets | |
| 42-in. plasma | sets | |
| 50-in. plasma | sets | |
| profit | $ |
| 20-in. LCD |
42-in. LCD |
42-in. Plasma |
50-in. Plasma |
Total Available |
|
|---|---|---|---|---|---|
| Assembly time (hours) |
7 | 10 | 12 | 15 | 2000 |
| Test time (hours) |
2 | 2 | 4 | 5 | 500 |
| Profit (dollars) |
48 | 60 | 73 | 100 |
The complete solutions are given below
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
