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