Question: use excel + show work please The Bee Line Caf is well known for its popular homemade ice cream, which it makes in a small

use excel + show work please
The Bee Line Caf is well known for its popular homemade ice cream, which it makes in a small plant in back of the cafe. People drive long distances to buy the ice cream. The two ladies who own the caf want to develop a forecasting model so they can plan their ice cream production operation and determine the number of employees they need to sell ice cream in the caf. They have accumulated the following sales records for their ice cream for the past 12 quarters: Year/Quarter Ice Cream Sales (gal) 350 2017 2 510 3 750 4 420 2018 370 6 480 7 860 8 500 2019 450 10 550 11 820 12 570 Develop a seasonally adjusted forecast for 2020. (Use a linear trendline model to develop a forecast estimate for 2020.) Which forecast model do you perceive to be the most accurate, the adjusted exponential smoothing model or the seasonally adjusted forecast? (Round answers to 2 decimal places, e.g. 52.75.) Seasonally adjusted forecast 2020 Quarter 1 116.38 Quarter 2 153.19 Quarter 3 241.72 Quarter 4 148.21Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
