Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Management and Competitive Advantage Concepts and Cases

Authors: Jay B. Barney, William Hesterly

5th edition

133129306, 0133127400, 9780133129304, 978-0133127409

More Books

Students also viewed these General Management questions