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.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER