Hello! please help me by completing this witj excel solver. thank you!
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. 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.) c. Who should increase their hours? A1 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline 8 & A & B & c & D & E & F & G & H & 1 & J \\ \hline 11 & & TGrandfather & Wall & & & & & & & \\ \hline 2 & & Clock & Clock & & & & & & & \\ \hline 3 & Unit Profit & $300 & $200 & & & & & & & \\ \hline 4 & & & & & & Hours & & & & \\ \hline 5 & & Time Requir & & & & Avallable & & & & \\ \hline 6 & Assembly (David) & 6 & 4 & & & 40 & & & & \\ \hline 7 & Carving (LaDeana) & 8 & 4 & & & 40 & & & & \\ \hline 8 & Shipping (Lydia) & 3 & 3 & & & 20 & & & & \\ \hline 9 & & & & & & & & & & \\ \hline 10 & & & & & & & & & & \\ \hline 11 & & & & & & & & & & \\ \hline 12 & & & & & & & & & & \\ \hline \end{tabular} 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 Lydla is avallable 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
