Question: a (Submit your work in Excel and use the solver to solve.)

The Apex Television Company has to decide on the number of 27" and 20" sets to be produced at one of its factories. Market research indicates that at most 40 of the 27" sets and 10 of the 20" sets can be sold per month. The maximum number of work-hours available is 500 per month. A 27" set requires 20 work-hours and a 20" set requires 10 work-hours. Each 27" set produces a profit of $80. A wholesaler has agreed to purchase all the television sets produced if the numbers do not exceed the maxima indicated by the market research.

1. Formulate and solve the revised linear programming model for this problem on a spreadsheet.
2. Formulate this same model algebraically.
3. Solve this model by using the Graphical Linear Programming and Sensitivity Analysis.

Price: $2.99

Solution: The downloadable solution consists of 1 pages
Deliverable: Word Document