Daily attendance at a movie theatre for the past six Fridays is given in Table 2. Table 2 Week Attendance 1 1200 2 1350 3 1400 4 1425 5 1475 6 1490 The forecast for week 5 is 1450 and α =0.20 a. Using exponential smoothing, calculate the forecast for week 7. [8 marks]
****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****
Ft+1 = Ft + α(At – Ft)
Where,
Ft+1 is the forecast for period (t+1)
Ft is the forecast for period t
At is the actual for period t
α = 0.2
F5 = 1450
Using F5 and A5, we can calculate F6.
F5 = 1450
A5 = 1475
α = 0.2
Hence,
F6 = F5 + α(A5 – F5) = 1450 + 0.2*(1475-1450) = 1450 + 0.2*(25) = 1450 + 5 = 1455
Similarly, using F6 and A6, we can determine the forecast for week 7.
So,
F7 = F6 + α(A6 – F6)
F6 = 1455
A6 = 1490
α = 0.2
F7 = 1455 + 0.2*(1490-1455) = 1455 + 0.2*(35) = 1455 + 7 = 1462.
****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****
Daily attendance at a movie theatre for the past six Fridays is given in Table 2....
Chapter 4 Forecasting Homework Assignment Daily high temperatures in St. Louis for the last week were as follows: 34, 36, 37, 39, 35, 32, and 36 (yesterday). Forecast the high temperature today, using a 3-day moving average. Forecast the high temperature today, using a 2-day moving average. For questions c-e use all the days where a 3-day forecast value is possible. Calculate the mean absolute deviation based on a 3-day moving average. Compute the mean squared error for the 3-day...
QUESTION 5 A carnival runs for 10 days a year. Attendance for each day in each of the past three years has been captured and is provided in the table below. sing the multiplicative seasonal method, determine the average seasonal index for Day 2. Year 1 Year 2 Year 3 Dayl 13,578 14,471 15,421 Day2 21,659 21,630 21,124 Day3 20,051 20,558 20,367 Day4 12,035 12,820 13,315 Day5 12,264 12,924 12,077 Day6 13,139 13,875 13,818 Day7 18,754 18,801 19,491 Day8 21,670...
A) A firm has a daily demand of 450 units. The lead time of receiving supplies is 3 days. If demand has a standard deviation of 100 units per day, what should be their safety stock? The firm plans for a 95% service level. What should be their reorder point? Note: ?0.95 = 1.64. A) This firm decides to increase their service level to 98%. What should be their safety stock? What should be their reorder point? Note: ?0.98 =...
Masters Level work....all work must be shown. FORECASTING
Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...