Question: PLEASE PROVIDE LP MODEL IN EXCEL ( SET UP IN EXCEL ) AND PLEASE PROVIDE EACH FORMULA AND STEP BY STEP INSTRUCTIONS. THANK YOU. A
A furniture manufacturer produces two types of tables - country and contemporary - using three types of machines. The time required to produce the tables on each machine is given in the following table: Machine Country Router Sander Polisher 3.5 4.5 Contemporary Total Machine Time Available Per Week 4.0 1,000 6.5 2,000 2.0 1,500 3.0 1 Country tables sell for $395 and contemporary tables sell for $515. Management has determined that at least 25% of the tables made should be country and at least 38% should be contemporary. How many of each type of table should the company manufacture if it wants to maximize its revenue
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
