8 9 Part 2: Industrial Designs has used a linear programming model to assign each of its three designers, Lisa, Sarah and David, hours for the LVW label design project. The model is used to minimize the total cost for the designers' time so that the contract bid will be competitive. The two tables from the sensitivity analysis are shown below. o varduleLe 7 Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 Lisa hrs 48 0 30 1E+30 5 10 $8$4 Sarah hrs 30 0 18 12 1E+30 1 $e$5 David hrs 72 0 25 5 1E+30 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $B$10 David Max hrs 72 -5 72 48 2 17 $B$11 Sarah min hrs 30 0 30 0 1E430 18 $B$12 Sarah max hrs 30 -12 30 48 0 19 $B$13 Lisa max hrs 48 0 50 1E+30 2 20 $B$9 Total hrs hrs 150 30 150 2 48 Question 2: How many hours should Lisa be assigned for the project to minimize the costs and meet all the constraints? Question 3: If the maximum number of hours that David can work on the project is increased to 76 hours what will be the change in the total design cost of the project? Question 4: The shadow price for Lisa's maximum number of hours is zero because The maximum number of hours David can be assigned is greater than the maximum number of hours that Lisa can be assigned, The optimal solution assigns Lisa less hours than the constraint on her maximum number of hours allows, or Sarah must work exactly 30 hours on the project? (Choose one of the options). Question 5: The objective function is the total cost of the three designers' time. The billing rate ($/hr.) of the Senior Designer is higher than the billing rate of either of the other designers. Who is the Senior Designer