Daily high temperatures in St. Louis for the last week were as follows: 93, 94, 93, 95, 96, 88, 90 (yesterday). a) Forecast the high temperature today, using a 3-day moving average. b) Forecast the high temperature today, using a 2-day moving average. c) Calculate the mean absolute deviation based on a 2-day mov- ing average. d) Compute the mean squared error for the 2-day moving average. e) Calculate the mean absolute percent error for the 2-day moving average

Daily high temperatures in St. Louis for the last week were as follows: 93, 94, 93, 95, 96, 88, 90 (yesterday). a) Forecast the high temperature today, using a 3-day moving average. b) Forecast the high temperature today, using a 2-day moving average. c) Calculate the mean absolute deviation based on a 2-day mov- ing average. d) Compute the mean squared error for the 2-day moving average. e) Calculate the mean absolute percent error for the 2-day moving average

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 40P: The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels....

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
a. What is the mean square error for time periods 2 through 4 using the average forecasting method? b. What is the mean absolute error for time periods 2 through 4 using the average forecasting method? c. What is the mean absolute percentage error for time period 2 through 4 using the average forecasting method? Round all answers to two decimal places. Time Period 1 2 3 4 Mean absolute error (MAE) Mean squared error (MSE) Mean absolute percentage error (MAPE) Electric Bill 510 315 420 480 Average Forecast Forecast Error
10 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 What is the forecast for day 4 using a 3-period moving average model? (1 mark) (Round to two decimal places). 11 What is the forecast for day 5 using a 3-period moving average model? (Round to two decimal places). 12 What is the forecast for day 6 using a 3-period moving average model? (1 mark) (Round to two decimal places). 13
Daily high temperatures in St. Louis for the lastweek were as follows: 93, 94, 93, 95, 96, 88, 90 (yesterday).a) Forecast the high temperature today, using a 3-day movingaverage.b) Forecast the high temperature today, using a 2-day movingaverage.c) Calculate the mean absolute deviation based on a 2-daymoving average.d) Compute the mean squared error for the 2-day movingaverage.e) Calculate the mean absolute percent error for the 2-daymoving average.
Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks: 모 Week 1 2 3 4 5 6 7 8 10 11 12 Actual Passenger Miles (in thousands) 17 21 19 23 18 16 20 18 22 20 15 22 a) Assuming an initial forecast for week 1 of 17,000 miles, use exponential smoothing to compute miles for weeks 2 through 12. Use a = 0.2 (round your responses to two decimal places). Week 1 2 3 4. 6 7 8 9 10 11 12 Forecasted Passenger Miles (in thousands) 17.00 17.00 17.80 18.04 19.03 18.83 18.26 18.61 18.49 19.19 b) The MAD for this model = (round your response to two decimal places). c) Compute the cumulative forecast errors, cumulative MAD, and tracking signals (round your responses to two decimal places). Cumulative Cumulative Forecast Forecast Errors Tracking Signal Tracking Signal Week MAD Week Errors MAD 1 0.00 0.00 7 8.04 2.25 3.57 2 4.00 2.00 2.00 8 7.43 2.05 3.63 3 5.20 1.73 3.00 9 10.94 2.21 4.96 4 10.16 2.54 4.00 10 11.75 2.07 5.68 9.13 2.24 4.08 11 6…
:40:26 A police station had to deploy a police officer for an emergency multiple times in the last four evenings. The table below shows the number of emergencies each evening. (Round your answers to 3 decimal places.) Weekday ploy police Monday Tuesday Wednesday Thursday Number of calls each day 6 2 11 12 Forecast for tomorrow (calls) Complete the "Forecast for tomorrow" column in the table above. Use an exponential smoothing a. forecasting approach, with a=0.1 and a forecast for Monday of 9. (Round your answer to 3 decimal places.) b. What would be their forecast for Friday using the same exponential smoothing forecasting approach? 9
The number of disk drives (in millions) made at a plant in Taiwan during the past 5 years follows: a) Forecast the number of disk drives to be made next year, using linear regression.b) Compute the mean squared error (MSE) when using linear regression.c) Compute the mean absolute percent error {MAPE).
4.29 The number of disk drives (in millions) made at a plant in Taiwan during the past 5 years follows: YEAR DISK DRIVES 1 140 160 3 190 4 200 5 210 a) Forecast the number of disk drives to be made next year, using linear regression. b) Compute the mean squared error (MSE) when using linear regression. c) Compute the mean absolute percent error (MAPE). PX
The moving average forecasting method is typically bestfor products:a) Functional b) Innovativec) Mature d) New
Forecasting is critical in modern times. Business organizations manifested more concern with anticipating the future, and as a consequence, a number of highly successful consulting firms emerged to provide forecasting help for governments and businesses. You are required: iii. Identify the different levels that forecasting of business trends takes place. iv. Give 3 examples where long-range forecasting can be used v. Do you think forecasting is always correct and accurate? Discuss this assertion in detail
The monthly sales for Yazici Batteries, Inc., wereas follows: a) Plot the monthly sales data.b) Forecast January sales using each of the following:i) Naive method.ii) A 3-month moving average.iii) A 6-month weighted average using .1, .1, .1, .2, .2, and.3, with the heaviest weights applied to the most recentmonths.iv) Exponential smoothing using an a = .3 and aSeptember forecast of 18.v) A trend projection.c) With the data given, which method would allow you toforecast next March’s sales?