Question

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.

Answer 1

Solution

The steps in solver are

Solution is

c	380
m	190
Z	218500
950	<=	1000
1995	<=	2000
1235	<=	1500
380	=	380

Formula are