Question
A furniture manufacturer produces four products (Desks, Tables, Chairs, and Bookshelves). The production process consists of Assembly, Painting, Finishing, and Packaging. LP problem has been
A furniture manufacturer produces four products (Desks, Tables, Chairs, and Bookshelves). The production process consists of Assembly, Painting, Finishing, and Packaging. LP problem has been solved and resulted in an optimum profit of $36,080 and the following sensitivity Analysis. All times are in Hours. Questions are independent of each other. (5 points per part) Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$17 Units Produced Desk 40 0 270 4.15 2 $C$17 Units Produced Table 40 0 230 68 4.5 $D$17 Units Produced Chair 60 0 268 2 8.91 $E$17 Units Produced Bookshelf 0 -19.6 290 19.6 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$22 Assembly Amount Used (LHS) 2200 0.5 2200 240 160 $B$23 Painting Amount Used (LHS) 1600 20.4 1600 133.33 200 $B$24 Finishing Amount Used (LHS) 2600 0.9 2600 184.62 200 $B$25 Amount Used (LHS) 2080 0 3000 1E+30 920 Please answer the following questions based on the sensitivity analysis. (5 points each) a. One of the companys best clients has requested 15 bookslelves. If the company decides to produce the requested units of bookshelves, what would be the new total profit? Show your computations and fully explain how you arrived at your answer.Write your answerbelow. New profit = b. If the objective function coefficient of desks (profit per unit) is increased by $1.50 per unit, what would be the production of Desks, Tables, Chairs and bookshelves and the new total profit. Write their new values below. Desks = Tables= Chairs= Bookshelves= New Profit =
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started