Question: a) What is the 3-week moving average forecast for this data? Assume you only have 3 weeks and 5 weeks of actual demand data for

a) What is the 3-week moving average forecast for

a) What is the 3-week moving average forecast for this data? Assume you only have 3 weeks and 5 weeks of actual demand data for the respective forecasts. (5) Week Demand 1 820 2 775 3 680 4 655 5 620 6 600 7 575 b) The weekly demand data is shown in figure below. Find out the exponential smoothing forecasts for periods 2-10 using a=0.10 and a=0.60? Assume Fl=D1. (7) a. Also provide the exponential smoothing plots. b. Calculate the MSE and MAD for both the alphas and conclude which one is better. Week Demand 820 775 1 2 3 680 4 5 6 655 750 802 798 689 775 7 8 9 10

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!

a) What is the 3-week moving average forecast for this data? Assume you only have 3 weeks and 5 weeks of actual demand data for the respective forecasts. (5) Week 1 2 3 Demand 820 775 680 655 620 600...

Mikaela sells homemade pies to many local cafes in Wollongong. She keeps a record of the sales of homemade pies to help her with demand forecasting. The price of a single pie is $4.80. Mikaela has...

Namata Appliances sells refrigerators. The model seen in the data file is relatively inexpensive. Weekly demand for this model is relatively stable though there is enough variation to challenge...

Excel Problem (to be used with the data in the Excel file): Namata Appliances sells refrigerators. The model seen in the data file is relatively inexpensive. Weekly demand for this model is...

The following applies to questions 1 -8. Weekly sales of ballpeen hammers at a home improvement store have been 14,9,30,22, 34, 12, 19,23 over the past 8 weeks. The following table shows the...

1 Problem 1 The number of weekly service jobs a plumbing company has are performed for the last 10 weeks are as follows: Week Number of jobs 1234567891029383228333127372933 a. Using a 3-week moving...

Suppose that five normal populations have common variance 2 = 100 and means 1 = 175, 2 = 190, 3 = 160, 4 =200, and 5 = 215. How many observations per population must be taken so that the probability...

Using the Convention on the Elimination of Discrimination against Women and its Optional Protocols and other relevant sources and cases, write a legal opinion for WJC. In your legal opinion, among...

One ancillary service that surplus lines intermediaries perform during the policy period is to Select one: A . Verity what reinsurance arrangements exist for the surplus lines insurer. B . Ensure...

What is an example of constructive feedback? provide reference