Table Rock Tables, manufactures two popular tables, a country style table and a contemporary style table. The manufacturing process for both tables requires the use of three types of machines. The time to produce the tables on each machine given in the following table: Machine Country Table Contemporary Table Total Time Available Router 1.5 2.0 1,000 Sander 3.0 4.5 2,000 Polisher 2.5 1.5 1,500 The earns a profit of $350 on the Country table, and $450 on the Contemporary table. The marketing department requires that the company make exactly twice as many Country tables as Contemporary tables. Table Rock City Tables want to determine the product mix to maximize profit.
Please use Excel in answering the question.
Solution
The steps in solver are
Solution is
c | 380 | |
m | 190 | |
Z | 218500 | |
950 | <= | 1000 |
1995 | <= | 2000 |
1235 | <= | 1500 |
380 | = | 380 |
Formula are
Get Answers For Free
Most questions answered within 1 hours.