Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The spreadsheet Question3-Forecasting.xlsx has data for the past 30 weeks of sales for product X. Based on the data, do the following questions. [If

image text in transcribed image text in transcribed

The spreadsheet "Question3-Forecasting.xlsx" has data for the past 30 weeks of sales for product X. Based on the data, do the following questions. [If you use Excel to solve this question, submit the excel file along with your solutions to the assignment. Note that you need to explain your answers to the following questions in detail, and just submitting the calculations done by excel is not enough.] (a) Plot the data. Just by looking at the plot, do you think a 3-week simple moving average would be a better forecast, or a 6-week simple moving average? Just by looking at the plot, do you think an exponential smoothing with value of a = 0.2 would be better forecast or would a = 0.6 be better? Explain your reasoning. (b) Which one of the four possible forecasts mentioned in part (a) (3-week and 6-week simple moving average and exponential smoothing with value of a = 0.2 and a = 0.6) is the best forecast? Justify your answer by calculating MAD. (Different people could reach different conclusions, but you need to give good reasons for your conclusions.) Question 3 of Assignment 3 Week t 1 23456 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Sales 574 1,004 717 1,076 1,076 932 1,291 1,219 932 1,219 1,219 1,076 1,650 1,650 1,434 1,219 1,291 1,578 1,793 1,721 1,578 1,865 1,434 1,793 1,865 1,506 1,650 1,506 1,721 1,506

Step by Step Solution

3.55 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

a The data is plotted below By looking at the plot it seems that the 6 month moving average will give a better forecast b The forecast using 3 week 6 week moving average alpha 02 and 06 are shown belo... 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

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, Srikant M. Datar, George Foster

12th edition

131495380, 978-0131495388

More Books

Students also viewed these Accounting questions