Daily demand for newspapers for the last 10 days has been as follows: 12, 13, 16, 15, 12, 18, 14, 12, 12, 15 (listed from oldest to most recent). Forecast sales for the next day using a three-day weighted moving average where the weights are 3,2 and 1 (from most recent to oldest one) Show your calculation
Last 10 days demand: 12,13,16,15,12,18,14,12,12,15
The most recent 3 being:
15 x weight = 15 x 3= 45
12 x weight = 12 x 2= 24
12 x weight = 12 x 1 = 12
The 3 day moving average = (45 + 24 + 12)/3 = 27
Answer: 27
Daily demand for newspapers for the last 10 days has been as follows: 12, 13, 16,...
)Enrollment in a particular class for the last four semesters has been 120, 126, 110, and 130 semester moving average was used to forecast enrollment (this is sometimes refered to as a naive Thus, the forecast for the second semester it would be 110. What would the MSE be for this situation? reg 2) Enrollment in a particular class for the last four semesters has been 122.128, 100, and 153 listed from oldest to most recent). The best forecast of...
The historical demand for a product is as follows: Month Demand January 12 February 11 March 15 April 12 May 16 June 15 Stating any assumptions that you make answer the following questions. (i) Using a weighted moving average with weights of 0.60 for June; 0.30 for May and 0.10 for April, find the July forecast. (4 marks) (ii) Using a simple three-month moving average, find the July forecast. (4 marks) (iii) Using simple exponential smoothing with α=0,2 and a...
Enrollment in a particular class for the last four semesters has been 122, 128, 101, and 155 (listed from oldest to most recent). The best forecast of enrollment next semester, based on a three-semester moving average, would be
Develop a two-period weighted moving average forecast for periods 12 through 15. Use weights of 0.9 and 0.1, with the most recent observation weighted higher Demand 229 389 461 330 406 Period 10 12 13 Calculate the forecasts for periods 12-15 by using a two-period weighted moving average model (enter your responses rounded to the nearest whole number) Demand 229 389 461 330 Forecast Period 10 12 13 14 406
HYV Score: 60%, 18 of 30 pt 44 of 22 (17 complete)> Score: 0 of 2 pts Show Work Question Help Problem 2 Develop a two-period weighted moving average forecast for periods 12 through 15. Use weights of 0.9 and 0.1, with the most recent observation weighted higher. Demand 210 347 458 241 403 Period 10 12 13 14 Calculate the forecasts for periods 12-15 by using a two-period weighted moving average model (enter your responses rounded to the nearest...
A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were Day: 1 2 3 4 5 6 7 8 9 Number sold: 33 35 40 42 42 42 43 48 49 Day: 10 11 12 13 14 15 Number sold: 46 52 46 48 57 50 a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 48 for Day 8, an...
Week Of Pints Used September 14 410 September 28 October 5 371 378 The forecasted demand for the week of October 12 using a 3-week movingrage 377.33 pints (round your response to two b)Using a 3-week weighted moving average. with weights of 0.10,025, and 065,using 0 65 for the most c) it the forecasted demand for the week of August 31 is 345 and 025 exponential to two decimal places). recent week, the forecasted demand for the week of October...
22. Corporate has provided the following weights for the demand data below: most recent data .55, next most recent = .20, third most recent = .15, and forth most recent - .10. Use the data below to calculate the forecast for 2017 using a four year weighted moving average: SALES WEIGHT YEAR 3000 2012 2013 2500 6000 2014 4000 2015 7500 2016 2017
Dave Green, an analyst at Hyvee, shared his forecasts of the daily Tide sales for days 1 to 15 with you as given in the table below (actual sales for days 1 to 15 is already given to you in question 4 above). Using Dave’s forecasts given below answer the following questions: Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Dave's Forecast 20 27 14 14 8 11 18 15 8 24...
The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar 16 Apr May 15 13 Jun 18 Jul 15 Aug Sept Oct Nov Dec 18 19 22 202 This exercise contains only parts de b) The forecast for the next month (Jan) using the naive method = 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach = 22 sales (round your...