Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 ThroxStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started