ANC is a small artesean wood shop

FIND A SOLUTION AT Academic Writers Bay

ANC is a small artesean wood shop that turns out four different items: bookcases, desks, chairs, and bedframes.• A bookcase requires three hours of work, one unit of metal, and four units of wood, and it brings in a net profit of $19.• A desk requires two hours of work, one unit of metal, and three units of wood and it brings in a net profit of $13.• A chair requires one hour of work, one unit of metal, and three units of wood, and it brings in a profit of $12.• A bedframe requires two hours of work, one unit of metal, and four units of wood, and it brings in a net profit of $17.• Only 225 hours of labor, 117 units of metal, and 420 units of wood are available per day.2.1 Problem Determine the production quantities that maximize (daily) net profit. Also display in the listing file the values (levels) of the optimal solution values (variables and objective function).2.2 Problem The optimal solution calls for 39 bookcases, 48 chairs, and 30 bedframes to be produced every day. (You should verify that your model produces this solution before continuing). You have been brought in to do some “what-if” analysis on their operations. Solve the following variations:
The net profit brought in by each desk increases from $13 to $15.
The availability of metal increases from 117 to 125 units per day.
The company may also produce coffee tables, each of which requires three hours of work, one unit of metal, two units of wood, and brings in a net profit of $14.(You should assume that the changes are cumulative. Thus, for example, the net profit for desks is $15 in the second and third questions). For each of the three instances you solve, be sure to extract and place the relevant lines of the solution report. Also, you should be able to solve this problem with one model, and capture all the instances with solves of that model with adjusted data. Full credit will only be given if your solution has a single model.

Order from Academic Writers Bay
Best Custom Essay Writing Services

QUALITY: 100% ORIGINAL PAPERNO PLAGIARISM – CUSTOM PAPER