8 Weekly sales of copy paper at Cubicle Suppliers are provided in the table below. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. Compute the MAD for both forecasting methods. Which model is more accurate? Forecast week 8 with the more accurate method. Week Sales (cases) 1 17 2 21 3 27 4 31 5 19 6 17 7 21

8 Weekly sales of copy paper at Cubicle Suppliers are provided in the table below. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. Compute the MAD for both forecasting methods. Which model is more accurate? Forecast week 8 with the more accurate method. Week Sales (cases) 1 17 2 21 3 27 4 31 5 19 6 17 7 21

Understanding Business

12th Edition

ISBN:9781259929434

Author:William Nickels

Publisher:William Nickels

Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment

Section: Chapter Questions

Problem 1CE

See similar textbooks

Similar questions

Suppose the weekly demand for a call centre is shown in the table below. Apply the moving average and exponential smoothing methods to forecast the demand for Week 17.Assume the following:Simple moving average method: two-week moving averageSingle exponential smoothing method: assume the 1st week forecast is 333 and α=0.65.Include the MSE, MAD and MAPE in your calculations. Based on your results, recommend which method should be used and give reasons to support your recommendation. Week Demand (Number of calls) 1 300 2 360 3 410 4 289 5 279 6 302 7 376 8 329 9 248 10 322 11 503 12 511 13 399 14 402 15 380 16 469
Please solve this
Given is a historical time series for job services demand in the prior 6 months. Month 1 2 3 4 5 6 Demand 799 816 789 814 815 805 The Period 6 forecast by using weighted moving average with weights of 0.05, 0.25, 0.40, and 0.30 = Blank 1 (in 2 decimal places)
A recently introduced product has a positive trend in sales. The product’s sales have increased in each of its first eight weeks on the market. The forecast for week 6 was 1,325 (F6 = 1,325), with A6 = 1,283 and T6 = 42. Using smoothing components α = 0.20 and β = 0.30, develop forecasts for weeks 7 and 8.
pls help ASAP
Given an actual demand this period of 90, a forecast for this period of 58, and an alpha of 0.2, what would the forecast for the next period be using exponential smoothing?
Using exponential smoothing with alpha = .2, and assuming the forecast for period 11 was 80, what would the forecast for period 14 be?
Use exponential smoothing with trend adjustment to forecast deliveries for period 5. Let α = 0.1, β = 0.2, and let the initial trend value be 4 and the initial forecast be 200 (both are given in the table). (a) Complete the table below and to predict the demand for Period 5 (See image). Show the calculations for the demand for Period 2. (b) Based on the actual demands of the first 4 periods forecast the demand for period 5 using the linear regression method. (c) Which method performs better based on the actual demand for period 5? Why do you think so?
Problem 3-22 (Algo) Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts for the period indicated and error calculations. 155, 145, 155, 162, 180, 165, 172, 149, 170, 172 Exponential smoothing. Use Excel Solver to determine the optimum alpha value to minimize MSE and answer: What is the Mean Absolute Percentage Error (MAPE)?
Suppose that the demand in period 1 was 7 units and the demand in period 2 was 9 units. Assume that the forecast for period 1 was for 5 units. If the firm uses exponential smoothing with an alpha value of .20, what should be the forecast for period 3? (Round answers to two decimal places.)
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 65 68 77 59 66 75 23456 2 5 6 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.500 on the present period, 0.250 one period ago, 0.125 two periods ago, and 0.125 three periods ago. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 40, 20, 10, and 10, respectively, how would the forecast change? OA. The value of the forecast will decrease. B. The value of the forecast will remain the same. C. The value of the forecast will increase. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7?…