Suppose a four period weighted average is being used to forecast demand. Weights for the periods are: Wt-4 = 0.1 Wt-3 = 0.2 Wt-2 = 0.35 Wt-1 = 0.35 Demand observed in the previous four periods was: At-4 = 15,781 At-3 = 14,539 At-2 = 14,503 At-1 = 14,579 What will be the demand forecast for period t? (Keep one decimal place in your answer).

Suppose a four period weighted average is being used to forecast demand. Weights for the periods are: Wt-4 = 0.1 Wt-3 = 0.2 Wt-2 = 0.35 Wt-1 = 0.35 Demand observed in the previous four periods was: At-4 = 15,781 At-3 = 14,539 At-2 = 14,503 At-1 = 14,579 What will be the demand forecast for period t? (Keep one decimal place in your answer).

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 11P: For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12...

See similar textbooks

Similar questions

Assume an initial starting Ft of 300 units, a trend (Tt ) of eight units, an alpha of 0.30, and a delta of 0.40. If actual demand turned out to be 288, calculate the forecast for the next period.
Consider the following five monthly returns: 0.04 −0.03 0.03 0.07 −0.02 a. Calculate the arithmetic average monthly return over this period. b. Calculate the geometric average monthly return over this period. c. Calculate the monthly variance over this period. d. Calculate the monthly standard deviation over this period.
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. Construct a time series plot. What type of pattern exists in the data? Compare a three-month moving average forecast with an exponential smoothing forecast for α = 0.2. Which provides the better forecasts using MSE as the measure of model accuracy? What is the forecast for next month?
Consider the following time series data: Construct a time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 8. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 8. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2.
Consider the following time series: a. Construct a time series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? b. Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year.
Refer to the gasoline sales time series data in Table 8.1. Compute four-week and five-week moving averages for the time series. Compute the MSE for the four-week and five-week moving average forecasts. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that the MSE for the three-week moving average is 10.22.
Suppose a company finds that shipping cost is 3,560 each month plus 6.70 per package shipped. What is the cost formula for monthly shipping cost? Identify the independent variable, the dependent variable, the fixed cost per month, and the variable rate.
Consider the following time series data: Construct a time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Explain. Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2.
Consider the following time series data: Construct a time series plot. What type of pattern exists in the data? Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2. 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Compute the quarterly forecasts for next year based on the model you developed in part (b). Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = 1 for quarter 1 in year 1, t = 2 for quarter 2 in year 1, … t = 12 for quarter 4 in year 3. Compute the quarterly forecasts for next year based on the model you developed in part (d). Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.
The returns of Omantel for the last four years are Year 1=21, Year 2=10, Year 3=5, Year 4=(-2). The variance of Omantel is Select one: a. 70.25 b. 62.15 c. 72.50 d. 65.35 e. None of the options
Expected Return, Variance, Std. Deviation and Cofficient of Variation:Magee Inc.'s manager believes that economic conditions during the next year will be strong, normal, or weak, and she thinks that the firm's returns will have the probability distribution shown below. What's the standard deviation of the estimated returns?Round your answer to two decimal places. For example, if your answer is $345.6671 round as 345.67 and if your answer is .05718 or 5.7182% round as 5.72. State of the Economy Probability of State Occurring Stock's Expected Return Boom 20% 24.15% Normal 50% 13.50% Recession 30% –13.30% Group of answer choices 15.68% 16.39% 14.26% 13.54% 10.69%
Expected Return, Variance, Std. Deviation and Cofficient of Variation:Magee Inc.'s manager believes that economic conditions during the next year will be strong, normal, or weak, and she thinks that the firm's returns will have the probability distribution shown below. What's the standard deviation of the estimated returns?Round your answer to two decimal places. For example, if your answer is $345.6671 round as 345.67 and if your answer is .05718 or 5.7182% round as 5.72. State of the Economy Probability of State Occurring Stock's Expected Return Boom 20% 22.20% Normal 50% 12.90% Recession 30% –11.40%