Question: Please ensure that the model looks good and that solver has all ranges named! Thank you so much for the help! Martinez Furniture Martinez Furniture

Please ensure that the model looks good and that solver has all ranges named!
Thank you so much for the help!
Martinez Furniture Martinez Furniture makes three different models of china cabinets, French Provincial, Danish Modern, and American Contemporary. Martinez has a contract with a distributor to produce a minimum of 40 of each cabinet per day. Each cabinet produced goes through three departments: carpentry, painting, and finishing. The table below contains all relevant information regarding production times per cabinet produced and net revenue per unit produced. The capacity of each department is 600 hours for Carpentry, 300 hours for Painting, and 200 hours for Finishing. Build a model that you can use to experiment with different production plans. The performance measures computed by your model should include total net revenue, and the total hours used in each department. Building upon the model above, an obscure clause in a contract requires that at least 1/3 of total units produced must be French Provincial. Add a constraint to do this. What is the optimal production plan and total net revenue? French Cabinet Style Danish Modern American Contemporary DATA Provincial Carpentry (Hrs/cabinet) 5 3 2 Painting 3 1 2 (Hrs/cabinet) Finishing 1 1 1 (Hrs/cabinet) Net Revenue / Cabinet $28 $25 $22Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
