Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Company A wants to test three major forecasting techniques on a historical data that they have in terms of the forecasting accuracy on a certain

image text in transcribed
image text in transcribed
Company A wants to test three major forecasting techniques on a historical data that they have in terms of the forecasting accuracy on a certain product's weekly sales data. They have recorded the sales values in the last 13 weeks and you can see the corresponding value of each week as a time series data in the below table. Please use this historical data to perform the following actions: a) Plot the time series as a scatter plot (4 pts) b) Make forecasts starting from the 9th period for five periods using moving average method (you can choose n=5; that is the number of historical data points you should use in calculation) (4 pts) c) Make forecasts starting from the 9th period for five periods using weighted moving average method (you can use the following weight scheme wt1=0.3,wt2=0.2,wt3=0.2, w1.4=0.15,w1s=0.15)(4pts) d) Make forecasts starting from the 9th period for five periods using exponential smoothing method (you can use smoothing factor as 0.25 ) . (4 pts) e) Calculate the accuracy metrics we covered in class for all the methods you used above. Make a comparison between the techniques. (HINT: The numbers in red italic is used for performance assessment. ( 3 pts) Company A wants to test three major forecasting techniques on a historical data that they have in terms of the forecasting accuracy on a certain product's weekly sales data. They have recorded the sales values in the last 13 weeks and you can see the corresponding value of each week as a time series data in the below table. Please use this historical data to perform the following actions: a) Plot the time series as a scatter plot (4 pts) b) Make forecasts starting from the 9th period for five periods using moving average method (you can choose n=5; that is the number of historical data points you should use in calculation) (4 pts) c) Make forecasts starting from the 9th period for five periods using weighted moving average method (you can use the following weight scheme wt1=0.3,wt2=0.2,wt3=0.2, w1.4=0.15,w1s=0.15)(4pts) d) Make forecasts starting from the 9th period for five periods using exponential smoothing method (you can use smoothing factor as 0.25 ) . (4 pts) e) Calculate the accuracy metrics we covered in class for all the methods you used above. Make a comparison between the techniques. (HINT: The numbers in red italic is used for performance assessment. ( 3 pts)

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

Step: 3

blur-text-image

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

Called To Account Fourteen Financial Frauds That Shaped The American Accounting Profession

Authors: Paul M. Clikeman

1st Edition

0415996988, 978-0415996983

More Books

Students also viewed these Accounting questions