PLEASE ANSWER LETTER C AND D, please explain it I need it for my report but i don’t understand it please help me PLEASE DON’t USE HAND WRITTEN PLEASE thank you Meredith had an excellent management science course as part of her MBA program in college, so she realizes thatbreak-even analysis is needed to help make this decision. With this in mind, she instructs several staff members toinvestigate this prospective product further, including developing estimates of the related costs and revenues as well asforecasting the potential sales.One month later, the preliminary estimates of the relevant financial figures come back. The cost of designing thegrandfather clock and then setting up the production facilities to produce this product would be approximately$250,000. There would be only one production run for this limited-edition grandfather clock. The additional cost foreach clock produced would be roughly $2,000. The marketing department estimates that their price for selling theclocks can be successfully set at about $4,500 apiece, but a firm forecast of how many clocks can be sold at this pricehas not yet been obtained. However, it is believed that the sales likely would reach into three digits.Meredith wants all these numbers pinned down considerably further. However, she feels that some analysis can bedone now to draw preliminary conclusions.a. Assuming that all clocks produced are sold, develop a spreadsheet model for estimating the profit or loss fromproducing any particular number of clocks.b. Use this spreadsheet to find the break-even point by trial and error.c. Develop the corresponding mathematical expression for the estimated profit in terms of the number of clocksproduced.d. Use a graphical procedure to find the break-even point.e. Use the algebraic procedure to find the break-even point.A fairly reliable forecast now has been obtained indicating that the company would be able to sell 300 of the limited-edition grandfather clocks, which appears to be enough to justify introducing this new product. However, Meredith isconcerned that this conclusion might change if more accurate estimates were available for the various costs andiliat if onelvaie dene Case 1-1Keeping TimeFounded nearly 50 years ago by Alfred Lester-Smith, Beautiful Clocks specializes in developing and marketing a diverseline of large ornamental clocks for the finest homes. Tastes have changed over the years, but the company hasprospered by continually updating its product line to satisfy its affluent clientele. The Lester-Smith family continues toown a majority share of the company and the grandchildren of Alfred Lester-Smith now hold several of the topmanagerial positions. One of these grandchildren is Meredith Lester-Smith, the new CEO of the company.Meredith feels a great responsibility to maintain the family heritage with the company. She realizes that the companyneeds to continue to develop and market exciting new products. Since the 5oth anniversary of the founding of thecompany is rapidly approaching, she has decided to select a particularly special new product to launch with greatfanfare on this anniversary. But what should it be? As she ponders this crucial decision, Meredith's thoughts go back tothe magnificent grandfather clock that her grandparents had in their home many years ago. She had admired themajesty of that clock as a child. How about launching a modern version of this clock?This is a difficult decision. Meredith realizes that grandfather clocks now are largely out of style. However, if she is sonostalgic about the memory of the grandfather clock in her grandparents' home, wouldn't there be a considerablenumber of other relatively wealthy couples with similar memories who would welcome the prestige of adding thegrandeur of a beautifully designed limited-edition grandfather clock in their home? Maybe. This also would highlightthe heritage and continuity of the company. It all depends on whether there would be enough sales potential to makethis a profitable product.break-even analysis is needed to help make this decision. With this in mind, she instructs several staff members toludinMeredith had an excellent management science course as part of her MBA program in college, so she realizes that

Question

Accepted Answer

THE ANSWER IS AS BELOW: