Please provide a clear step-by-step solution.

Question VI (20 minutes): 11. Kevin builds two kinds of birdhouses, one for wrens and a second for bluebirds. Each wren birdhouse takes 4 hours of labor and 2 units of lumber. Each bluebird house requires 4 hours of labor and 12 units of lumber. The craftsman has available 60 hours of labor and 120 units of lumber. Wren houses yield a profit of $6 each and bluebird houses yield a profit of $15 each. The linear programming formulation is: LetxW=numberofbirdhousesforwrens,andxB=numberofbirdhousesforbluebirds.Maximize6xW+15xBSubjectto:4xW+4xB602xW+12xB120xW,xB0 The following report is the sensitivity report: Microsoft Excel 10.0 Sensitivity Report Worksheet: [birdhousea.xIs]Solution Report Created: 5/25/2004 1:13:54 PM Adiustable Cells Constraints a) Which variables are basic variables? Which variables are non-basic variables? b) Which constraints are binding? Which constraints are non-binding? c) If Kevin has 100 more labor hours, what is the new optimal value of the objective function? d) If the profit per Blue birdhouse increased by another 25 units, would the optimal solution change? How do you calculate the new value of the objective function (profit)