Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Ethics of Management

Authors: La Rue Hosmer

7th edition

73530543, 73530549, 77470206, 978-0073530543

More Books

Students also viewed these General Management questions