Q. A furniture manufacturer makes two types of tables (Nation also contemporary) using three types of machines. Time requisite to make tables on each machine is given in subsequent table.
Total Machine Time
Machine Nation Contemporary Available per Week
Router1.5 2.0 1,000
Salsoer3.0 4.5 2,000
Polisher2.5 1.5 1,500
Nation tables sell for $350 also contemporary tables sell for $450. Management has determined which at least 20% of table made should be Nation also at least 30% should be contemporary. Elucidate how many of each table should company make if it wants to maximize its revenue?
Formulate an LP model for this problem
Create a spreadsheet model for this problem using solver. Illustrate what is optimal solution?
Elucidate how will spreadsheet model differ from 25 types of tables also 15 machine processes involved in manufacturing them?