In Problems 49-54, use Excel to solve each linear programming problem.
Manufacturing 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 following 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 200 cases per week and that of these, no more than 40 could be for the 20-in. LCD model.
20-in.LCD | 42-in.LCD | 42-in.Plasma | 50-in. Total Plasma Available | ||
Assembly time (hours) | 7 | 10 | 12 | 15 | 2000 |
Test time (hours) | 2 | 2 | 4 | 5 | 500 |
Profit(dollars) | 46 | 60 | 75 | 100 |
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.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Mathematical Applications for the Management, Life, and Social Sciences
Additional Math Textbook Solutions
Probability and Statistics for Engineers and Scientists
Calculus for Business, Economics, Life Sciences, and Social Sciences (14th Edition)
Thinking Mathematically (6th Edition)
Pathways to Math Literacy (Loose Leaf)
The Heart of Mathematics: An Invitation to Effective Thinking