Solve d) and e). I have provided answer for c)too required in e)
Winkler Furniture manufactures two different types of chinacabinets: a French provincial model and a Danish Modern model. Eachcabinet produced must go through three departments: carpentry,painting, and finishing. The table below contains all relevantinformation concerning production times per cabinet produced andproduction capacities for each operation per day, along with netrevenue per unit produced. The firm has a contract with an Indianadistributor to produce a minimum of 300 of each cabinet per week(or 60 cabinets per day). Owner Bob Winkler would like to determinea product mix to maximize his daily revenue.
Formulate as an LP problem and obtain the revenue
| Cabinet Style | Carpentry (hours/cabinet) | Painting (hours/cabinet) | Finishing (hours/cabinet) | Net revenue/cabinet ($) |
| French Provincial | 3 | 1.5 | 0.75 | 28 |
| Danish Modern | 2 | 1 | 0.75 | 25 |
| Department Capacity (hours) | 360 | 200 | 125 |
c. What is the total Revenue at the optimal solution?
d. Bob Winkler wants to add this requirement to his productionpolicy: To produce at least as many French Provencial cabinets asDanish Modern. How many French Provencial and Danish ModernCabinets should Bob produce?
e. What is the impact on revenue of the solution in part dcompared to the result in part c?
Solution for c)
Optimal Solution:
X1 = 60 X2 = 90
Revenue
Revenue =28*60+25*90= $3,930
