Please solve part B in excel. thanks!

astigned to the pmyect, a is the number of hour Devid in atcignes to the preject, and 5 is the number of heurs sarelh is asugned to the grsgect. Mituithint lisa Miniment sinasin Maxmert Lia Mavimian 5srah fisil finte 1,0,5+0 (b) How many hours should be assigned to each grophic designer? (c) Suppose uss could the assigned more than 50 hours, What effect would this have on the optimal solution? Explain. The shadow price foe this constraint is X isince the constraint is . Therefore, additional hours for tise change the solution. (d) If Sarab ware not required to work a minimum number of hours cn this project, would the optimal solution change? Explain. The shodaw price far thit constraint is x is since the constraint is X. Therefore, assigning fewer hours to sarah astigned to the pmyect, a is the number of hour Devid in atcignes to the preject, and 5 is the number of heurs sarelh is asugned to the grsgect. Mituithint lisa Miniment sinasin Maxmert Lia Mavimian 5srah fisil finte 1,0,5+0 (b) How many hours should be assigned to each grophic designer? (c) Suppose uss could the assigned more than 50 hours, What effect would this have on the optimal solution? Explain. The shadow price foe this constraint is X isince the constraint is . Therefore, additional hours for tise change the solution. (d) If Sarab ware not required to work a minimum number of hours cn this project, would the optimal solution change? Explain. The shodaw price far thit constraint is x is since the constraint is X. Therefore, assigning fewer hours to sarah