Answers only please

a. Formulate and solve this model on a spreadsheet, and then generate a sensitivity report to fill in the information below. Note: If an allowable increase/decrease is 10,000 or larger, simply enter 10,000 . Round all decimal values to 3 decimal places. b. Determine the total profit. 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 maximum of 20 hours per week. The company makes two different types of clocks: a grandfather clock and a wall clock. To make a clock, David (a mechanical 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. Click here for the Excel Data File Each grandfather clock built and shipped yields a profit of $300, while each 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 and solve this model on a spreadsheet, and then generate a sensitivity report to fill in the information below. Note: If an allowable increase/decrease is 10,000 or larger, simply enter 10,000 . Round all decimal values to 3 decimal places