(11- Jane and John's l[Goodie Baskets had been using an averaging forecasting model. They thought they should try something different for next year's forecast. The! recognized that sales were increasing and they feft they oould apply a trend analysis for the yearly forecast and then applying a seasonal index by semester. The following chart represents the demand history over the last 3 years {The last semester is the sales forecast as the sales gures are not in yet} Calculate the next year's forecast using trend analysis trend line y= 52001 +56.?00 [See if you can get that trend line on excelbonus of 2 marks]. Using the yearly forecast calculate the forecast by semester using seasonal index technique. {5 marks] _- -m Isl _:v.-sil m (12- Customer Service is very important to Jane and John's Goodie Baskets. '0 fact, the target for customer servioe level is 99%. The following are the sales results to the forecast by month for last year. {11 madrs} a] What is MAD? b} What is standard deviation? cl What is the tracking signal per month? d} The company uses a trigger of +! 4, which periodlIs] should the forecast be looked at? e} Reviewing the actual versus forecast for last year, do you agree with la no and John's Goodie Baskets' forecasting technique? Give your recommendations to improve the forecast accuracy. {I am looking for a qualitative recommendation; it does not need to be supported by a revised quantitative forecast.) f] Is the error random or bias? g} For Jane and John's Goodie Baskets to maintain their customer service goal above, how much safety stock should they maintain? What are the iss uee with carrying this level of safety stock given the product they are building