Question: Can you answer this using math NOT EXCEL. And show full work thank you. Using the Product Forecasting Information that has been provided from FY

Can you answer this using math NOT EXCEL. And show full work thank you. Using the Product Forecasting Information that has been provided from FY2017 through FY2020(four years), calculate the measures of forecast accuracy (MFE, MAD, and MAPE) for the Weighted Moving Average (MA) and the Exponential Smoothing (EXP) approaches to forecasting.
What are the values of MFE, MAD, and MAPE for each of these two approaches to forecasting (MA and EXP)? Which of the approaches is more accurate?
Do these forecasts seem adequate for the purposes of decision making? Why or why not? Throx uses two main forecasting methods based on annual data to predict orders for the following year, a weighted moving average and exponential smoothing. The table below provides forecast calculations for FY2017 through FY2020, along with actual demand experienced in each of those years.
Actual Demand (Three Sock Sets)
FY 201719,025, FY 201822,450, FY 201927,250, FY 202030,025
Weighted Moving Average Forecast(MA)
FY 201718,052, FY 201821,083, FY 201923,006, FY 202025,468
Exponential Forecast (EXP)
FY 201715,000, FY 201818,220, FY 201921,604, FY 202026,121
Weighted Moving Average uses Wt =0.7, Wt-1=0.2, Wt-2=0.1
Exponential Smoothing uses alpha =0.8 and 1 alpha =0.2

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!