(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

(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

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

Justify the trade-off between responsiveness and consistency in a time-series forecasting system.
To have a stable forecasting tool when using the simple moving average method, what value of N (the number of periods) should a firm choose among the following choices? a. 3b. 2c. 8d. 6
Sales of tablet computers at Ted Glickman's electronicsstore in Washington, D.C., over the past 10 weeks are shownin the ta ble below: a) Forecast demand for each week, including week 10, usingexponential smoothing with a = .5 (in itial forecast = 20).b) Compute the MAD.c) Compute the tracking signal.
Using naïve method to make a forecast involving data with trend, the forecasted sales volume for week 4 must be ________ units if the actual sales are 500, 510, and 508 in weeks 1, 2, & 3, respectively: * o 506 o 508 o 510 o 500
Given the table below, complete the missing cell values applying the Exponential Smoothing method of forecasting and Mean Absolute Deviation. Answer also the other 2 related questions below the table. Numbers with decimal should take 2 decimal places. Actual Quarter Tonnage Unloaded 1 2 3 4 5 6 7 8 175 160 170 160 160 170 180 200 Forecast for a=3 175 175.0 170.5 167.2 165.1 166.6 170.6 Sum of absolute deviation = Absolute Deviation for a = .3 Other questions: (1) What is the MAD for a = .3? (2) Which smoothing constant would you prefer? 0.00 15.00 0.50 10.35 4.93 13.45 29.41 80.89 Forecast for a = .6 175 166.0 168.4 163.4 161.3 166.5 174.6 Absolute Deviation for a = .6 0.00 15.00 4.00 8.40 3.36 8.66 13.46 25.38
14 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 With an alpha value of 0.31 and a starting forecast in day 3 equal to the 21 , what is the exponentially smoothed forecast for day 4? (Round to two decimal places) 15 What is the exponentially smoothed forecast for day 5? (Round to two decimal places)
What effect does the number of cycles in a moving average have on the forecast's responsiveness?
(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
Use simple exponential smoothing with a=0.6 to forecast chargers sales for February through May. Assume that the forecast for January was 24 chargers. *** Month January Charger Sales 42 February 33 March 28 April 59 May ? a) What will be the forecast for May? b) Calculate the MSE.
Give typed explanation Part 2: Using exponential smoothing, the forecasted demand for period 5 using the smoothing constant determined in image= ?
Compute the forecast sale using α = 0.20 and α = 0.35 respectively. (Note: express all answers using 4 decimal places)