Reference no: EM132127541

David, Diana and Lydia are the sole partners and workers in a company that produces fine clocks. David and Diana 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 Diana (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 below. Task Time required Grandfather clock: Assemble clock mechanism 6 hours, carve wood casing 8 hours, shipping 3 hours. Wall clock: assemble clock mechanism 4 hours, carve wood casing 4 hours, shipping 3 hours. 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 using linear programming. They have asked for your help. generate the excel 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.