Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer the questions, thank you Sensifivity II. A fumiture manufacturer produces four products (Desks, Tables, Chairs, and Bookshelves). The following table shows the amouat

please answer the questions, thank you
image text in transcribed
image text in transcribed
Sensifivity II. A fumiture manufacturer produces four products (Desks, Tables, Chairs, and Bookshelves). The following table shows the amouat of time needed in each department to produce the fumiture, the available time, and the profit per unit. Note the unitr of the required times are in minutes and available time in hours! Vrite the linear prognamming model for this problem and use Excel to solve it. Save the sensitivity analysis and answer the following questions. MAXIMIZE PROFIT 61x1+95x2+60x3+80x4 39. C. Suppose the profit per unit for tables is incrrased by 51 , for chain is decreased by $2, and forbookahelver is iacreased by 53. Would the optimum solution change? What will be the new value of the objective function? (Range of Optimality and the 100% Rule) f. Identify the mange of feasibility for the right-hand-side values and fully explain their meanings. 5. Fully interpret the meaning of the Shadow Prices (Dual Prices). h. A painter has offered his services for painting on this project at a price below the minimum wage. Should we obtain the houn? Why or why not? Fully explain. i. If you could get additional time in all three departments, which department should get priority and why? j. Twenty hous of fininhing time can be purchased at 25 cests per mirt ite above the current. 47 cost. Should we obtain the additional houn? If yes, what will be our total profit after paying for the time used. k. Refer to part "a" of this problem. One of the company's best clients has requested 10 chain. If the company decides to produce the requested units of chain, what woald be the new total 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

Operations Management Processes and Supply Chains

Authors: Lee J. Krajewski, Manoj K. Malhotra, Larry P. Ritzman

12th edition

134741064, 9780273766834, 027376683X, 9780273766940, 273766945, 9780273766841, 273766848, 978-0134741062

More Books

Students also viewed these General Management questions