Question: This is a first half question. A student is asked to predict sales in May using a weighted moving average of n-3 and weights of

This is a first half question. A student is asked

This is a first half question. A student is asked to predict sales in May using a weighted moving average of n-3 and weights of 0.2, 0.3, and 0.5 from oldest to most recent. Past sales data is: Jan 200 Feb 186 Mar 204 April 196 The student produces the following forecast: Sales(May) = [0.2(204) + 0.3(186) +0.5(200)/3 = 68 Identify and explain the student's error(s)

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) Predict demand for June using Weighted Moving Average (n=3) with w 3=0.7 for May, w2 =0.2 for April, and w 1=0.1 for March. b) What is the forecast for March using exponential smoothing with alpha...

ASSIGNMENT 1 (Demand forecasting on Excel) Question 1 A high-tech company wants to forecast the demand for their Kindle e-readers (in 000), based on the data below. (2 marks) Month 1 2 3 4 5 6 7...

Question 2 Use the data provided in Question 1, the Analyst would like to establish a Linear regression model for the demand, Using Excel, please run linear regression on this data (1 mark) 2.1 2.2...

Question 1 A high-tech company wants to forecast the demand for their Kindle e-readers (in 000), based on the data below. (2 marks) Month 1 2 3 4 5 6 7 8 9 10 11 12 13 Demand (000s) 3600 3400 3450...

Question 1 A high-tech company wants to forecast the demand for their Kindle e-readers (in 000), based on the data below. (2 marks) Month Demand (000s) 1 1250 1450 2 3 4 1175 1375 1075 5 6 1475 7...

QUESTION 22 The Video Sales Inc. wants to forecast sales for DVD movies based on the historical data in the table below. What is the MAD menawalute deviation of the exponential smoothing forecasts...

Question 1 A high-tech company wants to forecast the demand for their Kindle e-readers (in 000), based on the data below. (2 marks) Month Demand (000s) 1 1144 2 1182 3 1235 4 1184 5 1223 6 1218 7...

1. To establish a driver education school, organizers must decide how many cars, instructors, and students to have. Costs are estimated as follows. Annual fixed costs to operate the school are...

A high-tech company wants to forecast the demand for their Kindle e-readers (in 000), based on the data below. (2 marks) Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Demand (000s) 3600 3400 3400 3350...

The following is the recent historical sales of Sony HDTV at a local BestBuy store. Month Jan Feb Mar April May Actual HDTV sales 60 65 70 50 62 Solution inputs are numbers only, no symbols or...

In a Harvard Business Review article titled Why Incentive Plans Cannot Work, (Volume 71, Issue 5) author Alfie Kohn wrote: Research suggests that, by and large, rewards succeed at securing one thing...

A steel piston ring has a mean diameter of 70 mm, a radial height h = 4.5 mm, and a thickness b = 3 mm. The ring is assembled using an expansion tool that separates the split ends a distance...

2 0 2 5 Rita is a self - employed taxpayer who turns 3 9 years old at the end of the year. In the current year, her net Schedule C income was $ 3 0 6 , 0 0 0 . This was her only source of income....

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...