In: Statistics and Probability
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 | 1000 | |
Sander | 3.0 | 4.5 | 2000 | |
Polisher | 2.5 | 1.5 | 1500 |
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
ANSWER:
The linear programming problem is
The steps in solver are
Solution is
c | 380 | |
m | 190 | |
Z | 218500 | |
950 | <= | 1000 |
1995 | <= | 2000 |
1235 | <= | 1500 |
380 | = | 380 |
Formula are
NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE SUPPORT ME WITH YOUR RATING...
***PLEASE GIVE ME "LIKE"...ITS VERY IMPORTANT FOR ME NOW....PLEASE SUPPORT ME ....THANK YOU