Answered step by step
Verified Expert Solution
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
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
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