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

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 $22

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!