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 yourwork on excel Question 1 Product Forecasting Information Throx uses two mainforecasting methods based on annual data to predict orders for the following

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

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!