The unemployment rates in the United States during a 10- year period are given in the following table. Use exponential smoothing to find the best forecast for next year. Use smoothing constants of 0.2, 0.4, 0.6, and 0.8. Which one had the lowest MAD? Year 1 2 3 4 5 6 7 8 9 10 Unemployment Rate 7.2 7.0 6.2 5.5

The unemployment rates in the United States during a 10- year period are given in the following table. Use exponential smoothing to find the best forecast for next year. Use smoothing constants of 0.2, 0.4, 0.6, and 0.8. Which one had the lowest MAD? Year 1 2 3 4 5 6 7 8 9 10 Unemployment Rate 7.2 7.0 6.2 5.5

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?
You work for BMW as a planner. BMW is expecting to increase its annual sales for BMW- X5 in year 2021 by 10 % compared to year 2020 annual sales. Find the quarterly forecast for year 2021, given the following data : (You need to consider the Quarterly seasonal effect) Quarter Actual Car Sales (2019) Actual Car Sales (2020) Quarter 1 80000 88000 Quarter 2 100000 110000 Quarter 3 120000 132000 Quarter 4 90000 99000
The following table shows a tool and die company's quarterly sales for the current year. What sales would you predict for the first quarter of next year? Quarter relatives are SR= .94, SR,- 97, SR= 97, and SR, 112. For the trend forecast (T), add the difference between quarter 3 and quarter 4's deseasonalized sales data to the deseasonalized quarter 4 sales. (Round your answer to 1 decimal place.) Quarter Sales 84.6 83.0 84.7 108.0
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the 3-period weighted moving average method to forecast the number of sales to expect next month. Use the following weights: 0.4 for the most recent, 0.3 for the 2nd most recent, and 0.3 for the 3rd most recent. Month Demand Forecast 1 308 337 2 388 341.4 3 344 368 4 400 342.8 5 341 378.4
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the 3-period simple moving average method to forecast the number of sales to expect next month. Month Demand Forecast 1 308 341 388 343.3 3 344 364.7 4 400 346.7 341 377.3
We are using Winter’s method and monthly data toforecast the GDP. (All numbers are in billions of dollars.)At the end of January 2005, Lt 600 and Tt 5. We aregiven the following seasonalities: January, 0.80; February,0.85; December, 1.2. During February 2005, the GDP is ata level of 630. At the end of February what is the forecastfor the December 2005 level of the GDP? Use a b g 0.5.
Covid-19 is affecting every sector of society. It is expected that Covied-19 will remain there for some more months. Being in the Core Management of Galaxy Technologies (a software technology park), of almost 60 employees at different levels. you have to plan your Human Resources. What do you see in 6 months or so? And perform the given tasks: Forecast your Human Resource demand in July 2021. (use all the forecasting methods). Compare it with the labor supply and take necessary action. (in case of labor shortage, and in case of labor surplus)
Practice with the following questions to deepen the understanding of different forecasting methods. The solutions are provided after you use the "check" function. Thank you for trying out HSP To get started with HSP read our getting started guide Actual demand for a product for the past three months was: • Three months ago 375 units • Two months ago 325 units • Last month 335 units a. Using a simple three-month moving average, make a forecast for this month. (Round your answer to the nearest whole number.) Forecast for this month units. b. If 300 units were actually demanded this month, what would your forecast be for next month, again using a 3-month moving average? (Round your answer to the nearest whole number.) Forecast for the next month units. c. Uning simple exponential smoothing, what would your forecast be for this month if the exponentially smoothed forecast for three months ago was 425 units and the smoothing constant was 0.20? (Round your answer to the nearest whole…
Imagine you work for a breakfast cereal company that makes prepared products that are served cold. Your company wants to introduce a new hot breakfast cereal that would require some minimal preparation by the consumer. How would you propose forecasting initial demand for this product? Identify one quantitative and one qualitative technique. How do the techniques complement each other?
Sales over the past 10 years are shown below. Using the method of least squares, calculate the values of a and b to complete this regression equation. Year Sales 1 1770 2 1880 3 1070 4 1420 5 1540 6 2000 7 1910 8 1360 9 1400 10 1500 (Indicate a negative answer using a "-" sign. Do not round intermediate calculations and round your final answer to 3 decimal places.) What is your forecast for next year’s sales? (Do not round intermediate calculations and round your final answer to 2 decimal places.)
Although the unpredicted, yet disruptive, impact of the CoViD-19 pandemic is global and has negatively affected all organizations, identify a business organization that you think has been affected the most. In the new normal, which forecasting time horizon (short-range, medium-range, or long-range) would you suggest should be adopted by this organization in forecasting the demand for its main product? Justify your answer. Cite your assumptions. Cite 2 to 3 factors that this business organization should use as a basis for forecasting the demand for its main product. Justify your answer.