A furniture company produces 5 different products (A, B, C, D, and E). Each product requires certain
Question:
A furniture company produces 5 different products (A, B, C, D, and E). Each product requires certain amount of linear wood, glue, stain, and production hours (exact amount required can be found in columns 2 - 6). The detailed requirement can be found in the table below. In addition, top management believes in diversification and requires you to produce at least one of each product. However, company has limited resources available on weekly basis, and it cannot procure any additional resources. Company limits can be found in the last column of the table.
A | B | C | D | E | Resource availability (per week) | |
Wood (linear m.) | 11 | 17 | 5 | 12 | 21 | 200 |
Glue (liters) | 2 | 3 | 1 | 4 | 6 | 60 |
Staining (liters) | 3 | 1 | 1 | 6 | 8 | 50 |
Working hours | 3 | 4 | 2 | 5 | 6 | 80 |
Profit ($) | 40 | 70 | 30 | 80 | 100 |
Using and attach MS EXCEL file where you run solver
- What is the optimal manufacturing strategy?
- What is the total profit of you proposed strategy?
Consider a possibility to obtain a decimal solution since production can start this week and end during the next one.