Prepare a forecast for the next year by quarter by product family. Quarter lQuarter Quarter Quarter Year 1 2 3 4 5000 5209 5400 5600 575:] ssoo srsz seso soon 02 lCustomer Service is very important to Chez Ronald. As part of that service they want to be sure that when a customer orders a food I-cit it is delivered within 24 hours. 0? '15 of the time. The following are the sales results to the forecast by month for last year. [11 marl-cs) Perlo - Actua january 2000 1150 February 2000 March 1150 April 2000 2000 May 2000 2350 932 . mac- August 1020 2m 1500 2mm 2450 2mm 2mm a) What is HAD based on the forecasted and actual sales given? bi What is the standard deviation (50} based on those same numbers? cl What is the tracking signal per month? d} The Company uses a trigger of +3'- 3 to decide whether the forecast should be adjusted. For which periods should the forecast be adjusted? Do you have any othe r observations ? e] Reviewing the actual versus forecast for the last year. do you agree with the proposed forecasting technique? Give your recommendations to improve forecast accuracy. I am loolcing for a qualitative recommendation: it does not need to be supported by a revised quantitative forecast. fl Is the error random or bias? 1;} For Chez Ronald to maintain its' customer service goal above. how much safety stock should they maintain