please provide formulas for the excel problems.

Can you please do a, c, d, e

5.10. David, LaDeana, and Lydia are the sole partners and workers in a company that produces fine clocks. David and LaDeana are each available to work a maximum of 40 hours per week at the company, while Lydia is available to work a maxi- mum of 20 hours per week. The company makes two different types of clocks: a grandfa- ther clock and a wall clock. To make a clock, David (a mechani- cal engineer) assembles the inside mechanical parts of the clock while LaDeana (a woodworker) produces the hand-carved wood casings. Lydia is responsible for taking orders and shipping the clocks. The amount of time required for each of these tasks is shown next. Time Required Grandfather Wall Clock Clock Task 6 hours 4 hours Assemble clock mechanism Carve wood casing Shipping 8 hours 4 hours 3 hours 3 hours Each grandfather clock built and shipped yields a profit of $300, while cach wall clock yields a profit of $200. The three partners now want to determine how many clocks of each type should be produced per week to maximize the total profit. a. Formulate a linear programming model in algebraic form for this problem. b. Use the Graphical Linear Programming and Sensi- tivity Analysis module in your Interactive Manage ment Science Modules to solve the model. Then use this module to check if the optimal solution would change if the unit profit for grandfather clocks were changed from $300 to $375 (with no other changes in the model). Then check if the optimal solution would change if, in addition to this change in the unit profit for grandfather clocks, the estimated unit profit for wall clocks also changed from $200 to $175 E c. Formulate and solve the original version of this model on a spreadsheet Use Solver to check the effect of the changes speci- fied in part b. e. Use a parameter analysis report to systematically generate the optimal solution and total profit as the unit profit for grandfather clocks is increased in $20 increments from $150 to $450 (with no change in the unit profit for wall clocks). Then do the same as the unit profit for wall clocks is increased in 520 increments from $50 to $350 (with no change in the unit profit for grandfather clocks). Use this infor mation to estimate the allowable ringe for the unit profit of each type of clock. Use a two-way parameter analysis report to sys- tematically generate the optimal total profit as the unit profits for the two types of clocks are changed simultaneously as specified in parte except use $50 increments instead of $20 increments & For each of the three partners in turn, use Solver to determine the effect on the optimal solution and the total profit if that partner alone were to increase his or her maximum number of work hours available per week by 5 hours Use parameter analysis report to systemati. cally generate the optimal solution and the total profit when the only change is that David's maxi mum number of hours available to work per week changes to each of the following values: 35, 37, 39, 41, 43, 45. Then do the same when the only change is that Labeana's maximum number of hours avail able to work per week changes in the same way. Then do the same when the only change is that Lydia's maximum number of hours available to work per week changes to each of the following values: 15, 17, 19,21,23,25 1 Generate a sensitivity report and use it to determine the allowable range for the unit profit for each type of clock and the allowable range for the maximum number of hours each partner is available to work per week To increase the total profit, the three partners have agreed that one of them will slightly increase the maximum number of hours available to work per week. The choice of which one will be based on which one would increase the total profit the most Use the sensitivity report to make this choice (Assume no change in the original estimates of the unit profits) * Explain why one of the shadow prices is equal to yero Can the shadow prices in the sensitivity report be validly used to determine the effectif Lydia were to change her maximum number of hours available to work per week from 20 to 257 If so, what would be the increase in the total profit? m. Repeat parti, in addition to the change for Lydia David also were to change his maximum number of hours available to work per week from 40 to 35