SHOW STEP BY STEP SPREADSHEET MODEL
A furniture manufacturer produces two types of tables – countryand contemporary – using three types of machines. The time requiredto produce the tables on each machine is given in the followingtable:
Machine | Country | Contemporary | Total Machine Time Available Per Week |
Router | 2.5 | 3.0 | 1,000 |
Sander | 3.5 | 5.5 | 2,000 |
Polisher | 2.0 | 1.0 | 1,500 |
Country tables sell for $395 and contemporary tables sell for$515.  Management has determined that at least 25% ofthe tables made should be country and at least 38% should becontemporary. How many of each type of table should the companymanufacture if it wants to maximize its revenue?
- Formulate an LP model for this problem
- Create the spreadsheet model and use Solver to solve theproblem.
