Question: Sam's Apple Farm is looking for forecasting help in trying to calculate the harvest. Here are the numbers from the last 6 harvests: (Year 1

Sam's Apple Farm is looking for forecasting help

Sam's Apple Farm is looking for forecasting help in trying to calculate the harvest. Here are the numbers from the last 6 harvests: (Year 1 is 2014, Year 2 is 2015...Year 6 is 2019). (Bushels are scaled from their true values to make calculation easier). Simple AE Yr Bushels Adjuste AE 2MA AE 2MA ES (SES) SES Trend d ES AES 1 48 2 56 2 3 50 52 -2 4 58 53 5 5 55 54 1 6 65 56.5 8.5 AE = 3.1 a) Fill in the table above for Years 1-6. Use alpha = 2 for Simple Exponential Smoothing, alpha = 2 and beta = 4 for Adjusted Exponential Smoothing. Make sure to use my method (not the book's adjustment) to calculate Adjusted ES. Also calculate Average Errors (AE) for both Simple and Adjusted Exponential Smoothing. Are the AE for either type of Exponential Smoothing lower than the AE of 3.1 for 2MA? b) Suppose I told you that I wanted to use Linear Trend to forecast 2021 data. My formula is Bushels = 48 +2.5* Year. What would the value be for 2021

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!