Calculate the forecast for week 16 using - a 2-period moving avergage- a 3-period moving average 1234567891011121314151617AWeek12345678910111213141516CActual Sales 2-period MA148613451455136812091178158113321245152115441502185617531789B1415.514001411.51288.51193.51379.51456.51288.513831532.5152316791804.51771ErrorD39.5-32-202.5-110.5387.5-47.5-211.5232.5161-30.533374EError²F3-period MA Error134413861366G1560.251024 1428.66667 -60.666667 3680.44444-16641006.25 1389.33333 -180.33333 32520.111112210.2527556150156.25 1251.66667 329.333333 108460.4442256.25 1322.66667 9.33333333 87.111111144732.25 1363.66667 -118.66667 14081.777854056.251634135178HError²11925921930.25 1436.66667 65.3333333 4268.44444110889 1522.33333 333.666667 111333.444547614161-15.5 240.25 1703.66667 85.3333333 7281.77778-1771 3136441 1799.33333 -1799.3333 3237600.441822531684

Forecasting means predicting in advance the future sales.

Answered: Calculate the forecast for week 16…

Business

Operations Management

Calculate the forecast for week 16 using - a 2-period moving avergage - a 3-period moving average

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Please solve this
Given below are the demands of a certain product over the past 10 weeks. Week | 1 2 3 4 | 5 67|89 | 10 Demand 50 64 66 68 67 63 69 67 65 66 (a) Forecast the demand for the 13th week using the following techniques: i. 3- week weighted moving average with weights 0.2, 0.3, and 0.5 ii. Exponential smoothing with a smoothing constant equal to 0.85 ii. Adjusted exponential smoothing with a smoothing constant equal to 0.85 and smoothing constant for trend equal to 0.65 (b) Compute for the accuracy of each model using the mean squared error. Based on the computed MSE, what is the best forecasting technique for this time series?
(4) Exponential smoothing with a smoothing constant equal to 0.15, assuming a March forecast of 15(000). (Round your intermediate forecast values and final answer to 2 decimal places.) Forecast thousands (5) A linear trend equation. (Round your intermediate calculations and final answer to 2 decimal places.) Yt thousands
6. Consider the following data table. (12 Points) a) Forecast demand using exponential smoothing with an apha of 0.25, and an initial forecast of 128.0 for period 1. b) Calculate the MAD and MSE. Period Real demand 130 138 129 140 3 4 5 133
please answer in excel Jean’s Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that she can schedule the personnel. The manager uses α = 0.3 for exponential smoothing, and the forecast for the first week was 24 calls. The manager also uses 3 weekly moving averages technique. a) Using 3 period moving averages, forecast the number of calls for week 7. b) Using exponential smoothing, forecast the number of calls for week 7. c) Compare these two forecasting techniques using Mean Squared Errors (MSE) measure. Which one is better?
Week 1 2 4 Forecast Method 1 0.90 1.05 0.97 1.22 Actual Demand 0.72 1.05 1.00 0.97 Week 1 2 3 4 Forecast Method 2 0.82 1.19 0.90 1.17 Actual Demand 0.72 1.05 1.00 0.97 0 The MAD for Method 1 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 1 = thousand gallons (round your response to three decimal places). The MAD for Method 2 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 2 = thousand gallons (round your response to three decimal places).
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. June July August ACTUAL 144 184 210 a. Using a simple three-month moving average, what is the forecast for September? Note: Round your answer to 2 decimal places. Forecast for September b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Forecast for September
Compile a forecast for sales in Q1, Q2, Q3, and Q4 for 2013.
Time period Actual sales 1 18 2 22 If the forecasting value of period 3 is 19.6 using exponential smoothing, the smoothing constant is what?
The following gives the number of pints of type Bblood used a t Woodlawn Hospital in the past 6 weeks: a) Forecast the dema nd for the week of October 12 using a3-week moving average.b) Use a 3-week weighted moving average, with weights of .I , .3,and .6, using .6 for the most recent week. Forecast demand forthe week of October 12.c) Compute the forecast for the week of October 12using exponentialsmoothing with a forecast for August 31 of 360 and a = .2
Explain and give an example of a weighted average in forecasting
Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks: 2 3 21 19 Week 1 Actual Passenger Miles (in thousands) 17 Week Forecasted Passenger Miles (in thousands) a) Assuming an initial forecast for week 1 of 17,000 miles, use exponential smoothing to compute miles for weeks 2 through 12. Use α = 0.2 (round your responses to two decimal places). 10 11 4 5 6 7 8 9 23 18 16 20 18 22 20 15 2 1 3 4 6 7 17.00 17.00 17.80 18.04 19.03 18.83 18.26 5 8 18.61 9 18.49 19.19 10 12 22 11 12