Question: Can you please answer question E through K? I have done everything else just having trouble intrepreting the questions TWrite the linear prograturning model for

Can you please answer question E through K? I have done everything else just having trouble intrepreting the questions Can you please answer question E through K? I
Can you please answer question E through K? I
Can you please answer question E through K? I
TWrite the linear prograturning model for this problem and use Excel to solve it. Save the sensitivity analysis and answer the following questions. a. What is the optimum solution, and what is the valte of the objective function? 0 Desks, 156 Tables, 0 Clairs, 96 Bookstelfs 18. The value of the objective function is in cell M7 ;22,500 i9 b. Which constraints are binding, and which have excess capacity? 20. Binding: assembly and finishing 2y c. Fxplain the mesuing of all the values under the Redaced Cost colunn. Be very specific. 22. In the reduced cost columu we get 4,0,5,0. Since desk has 4 it meass if produce t desk our objective fiuction will deerease by 4. Thble and Bookshelf are alry 26 e. Suppose the profit per unit for tables iv increased by $1, for chairs is decreased by $2, and for bookshelves is increased by $3. Would the optianm solutiou change? What will be the new value of the objective function? (Range of Optinality and the 100% Rule) f. Identify the range of feasibility for the rigat-liand-side values and fally explain their meanings. \& Fally interpret the meaning of the Shadow Prices (Dual Prices). L. A paister has offered lis vervices for painting on this project at a price below the minimum wage. Should we obtain the hours? Why or why not? Fully explain. i. If you could get additional time in all three departments, which department shonld get priority and why? 1. Twenty hours of finishing time can be purchased at 25 cents per misute above the curren cost. Should we obtain the additional boun? If yes, what will be our total profit after paying for the time lised. k. Refer to gass " n " of this problem. One of the company's best clieats has requested 10 clains. If the company decides to produce the requeted units of ehains, what wonld be the new total 4) profit? Variable Ceils Constaints

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!