Question: Question 3 30 pts Q3) Uncle Ulysses operates a small business: he produces three types of houses to sell to people wanting to get back

Question 3 30 pts Q3) Uncle Ulysses operates aQuestion 3 30 pts Q3) Uncle Ulysses operates a

Question 3 30 pts Q3) Uncle Ulysses operates a small business: he produces three types of houses to sell to people wanting to get back to nature. Based on your discussion with your uncle you construct the following table based on your understanding of his weekly availability of labor. Item Profit/Unit Fabrication Assembly Painting Crating Birdhouse $15 1 2.5 1 0.25 Doghouse $35 1.25 1.5 0.5 0.5 Outhouse $58 1.75 4 2 0.75 Capacity 30 hours 50 hours 20 hours 20 hours Based on the information in the table, he formulated the problem as the following linear programming model: Max Z = 15x1 + 35x2 + 583 subject to: 1X1 + 1.25x2 + 1.75x3 = 30 2.5X1 + 1.5x2 + 4x3 = 50 1x1 + 0.5x2 + 2x3 = 20 0.25X1 +0.5x2 +0.75x3 = 20 X1, X2, X320 Given the linear programming model: a) Transform the model into standard form. b) Solve the model by using Excel. c) Based on Excel sensitivity report: c1) Which additional resources would you recommend that Uncle Ulysses try to obtain? Please justify your answer. c2) Uncle Ulysses feels that his prices are too low, particularly for his birdhouses. How much would he have to charge for his birdhouses before it is profitable for him to make and sell them? Please justify your answer. c3) What would be the effect on the optimal solution if Uncle Ulysses could obtain 2 more hours of crating? Please justify your answer. c4) If Uncle Ulysses could get 2 hours more of fabrication, 9 hours more of assembly, or 9 hours more of painting, which should he choose? Please justify your answer. In your report, please: . Write the standard form clearly and completely. Report the optimal values of decision variables and objective function value. Answer to part c questions and mark each question clearly. Excel file: Use excel solver for finding the optimal solution. Rename your excel file as question3_lastName_firstName.xlsx. Submit your excel file

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!