Question: I need help with this question #2 can you show your work on excel Question 1 Product Forecasting Information Throx uses two main forecasting methods



I need help with this question #2 can you show your work on excel
Question 1 Product Forecasting Information 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. Weighted Moving Average uses Wt=0.6,Wt1=0.2,Wt2=0.2 Exponential Smoothing uses =0.9 and 1=0.1 2) Develop forecasts for FY2021 using the two forecasting methods currently employed by Throx. a) What are the forecast values that you calculated for each? Please be sure to show work. b) Based on your assessments of forecast accuracy from Q1, which of the forecasts would be more appropriate to support decisions you may need to make? c) Are there other considerations that you would recommend to Throx
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
