Concept explainers
Videos
Compute the errors of bias and absolute deviation for the forecasts in problem 6 which of the
To compute: The errors of bias and absolute deviation and explain which forecast is the best.
Introduction:
Exponential smoothing:
In exponential smoothing forecast method, older data are given lesser importance, and newer data are given more importance. It is efficient in making short-term forecasts.
Explanation of Solution
Given information:
Forecast for period 1 (F1) = 90
Smoothing constant (α) = 0.1
| Period | Dt |
| 1 | 92 |
| 2 | 127 |
| 3 | 106 |
| 4 | 165 |
| 5 | 125 |
| 6 | 111 |
| 7 | 178 |
| 8 | 97 |
Formula for exponential smoothing:
Calculation of forecast:
The forecast for period 1 is 90.
Period 2:
The forecast for period 2 is 90.2.
Period 3:
The forecast for period 3 is 93.9.
Period 4:
The forecast for period 4 is 95.1.
Period 5:
The forecast for period 5 is 102.1.
Period 6:
The forecast for period 6 is 104.4.
Period 7:
The forecast for period 7 is 105.
Period 8:
The forecast for period 8 is 112.3.
Given information:
Forecast for period 1 (F1) = 90
Smoothing constant (α) = 0.3
| Period | Dt |
| 1 | 92 |
| 2 | 127 |
| 3 | 106 |
| 4 | 165 |
| 5 | 125 |
| 6 | 111 |
| 7 | 178 |
| 8 | 97 |
Calculation of forecast:
The forecast for period 1 is 90.
Period 2:
The forecast for period 2 is 90.6.
Period 3:
The forecast for period 3 is 101.5.
Period 4:
The forecast for period 4 is 102.9.
Period 5:
The forecast for period 5 is 121.5.
Period 6:
The forecast for period 6 is 122.6.
Period 7:
The forecast for period 7 is 119.1.
Period 8:
The forecast for period 8 is 136.8.
Calculation of error and absolute deviation:
For α = 0.1
Excel work:
Excel formula:
For α = 0.3
Excel work:
Excel formula:
For α = 0.1
Sum of error = 208
Sum of absolute deviation = 238.6
For α = 0.3
Sum of error = 116
Sum of absolute deviation = 218.8
The sum of error and absolute deviation is lower for α = 0.3 when compared with values of α = 0.1 (116 < 208) and (218.8 < 238.6). Hence, the forecasting method with α = 0.3 will be the best method.
The forecasting method with α = 0.3 is the best method.
Want to see more full solutions like this?
Chapter 10 Solutions
OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
- assess how Human Capital Management Strategy is aimed at building an effective integrated performance management system: Discuss how human capital management strategy relates to performance management.arrow_forwardCASE STUDY 9-1 Was Robert Eaton a Good Performance Management Leader? R obert Eaton was CEO and chairman of Chrys- ler from 1993 to 1998, replacing Lee Iacocca, who retired after serving in this capacity since 1978. Eaton then served as cochairman of the newly merged DaimlerChrysler organization from 1998 to 2000. In fact, Eaton was responsible for the sale of Chrysler Corporation to Daimler-Benz, thereby creating DaimlerChrysler. With 362,100 employees, DaimlerChrysler had achieved revenues of €136.4 billion in 2003. DaimlerChrysler's passenger car brands included Maybach, Mercedes-Benz, Chrysler, Jeep, Dodge, and Smart. Commercial vehicle brands included Mercedes-Benz, Freightliner, Sterling, Western Star, and Setra. From the beginning of his tenure as CEO, Eaton communicated with the people under him. He immediately shared his plans for the future with his top four executives, and upon the advice of his colleague, Bob Lutz, decided to look around the company before making any hasty…arrow_forwardCritically assess Martin’s coaching style.arrow_forward
- Compare Robert Eaton’s performance management leadership presented in the case against the performance management leadership principles, functions, and behaviors. What recommendations can be made about what he might do more effectively? Explain and defend your answer.arrow_forwardIn the context of the material in Chapter 9, provide a critical analysis of the decisions that Henry has made in assigning Martin to this role.arrow_forwardpanies (pp. 80-118). New York, NY: Times Books, specifically Chap. 4, "Robert Eaton and Robert Lutz; The Copilots." CASE STUDY 9-2 Performance Management Leadership at Henry's Commercial Sales and Leasing H enry is the owner of a small real estate agency that handles the sale and leasing of commercial property. He has two real estate agents working in the office, along with himself. He also has two customer service representatives (CSRs), each of whom has a real estate license, and one receptionist who has worked for the company for about three months. Henry has recently decided that he needs another customer service representative. He hasarrow_forward
- Discuss possible solutions to help Tara become an effective CSR. What should martin be doing to help her?arrow_forwardWhat are the ethical challenges regarding employees (i.e., diversity, discrimination, sexual harassment, privacy, employee theft, bad leadership, etc.) that Apple Inc. has faced over the past five to ten years and that they should prepare to face in the next five to ten years. Once a developed list of challenges is created, consider how having faced those challenges will impact and be impacted by the social cause you've selected. Propose the findings on the ethical challenges faced by Apple Inc. in recent history and the near future. Analyze ways in which each challenge was (and/or could be) appropriately handled and areas for improvement. Evaluate the ethical/moral aspects of Apple Inc. that protected it from ethical challenges in the past and could protect it in the future. Assess how ethical challenges and handling of ethical challenges could positively or negatively impact the charitable cause are selected and how the selection of your social cause could positively or negatively…arrow_forwardBy selecting Cigna Accredo pharmacy that i identify in my resand compare the current feedback system against the “Characteristics of a Good Multiple Source Feedback Systems” described in section 8-3-3. What can be improved? As a consultant, what recommendations would you make?arrow_forward
- Scenario You have been given a task to create a demand forecast for the second year of sales of a premium outdoor grill. Accurate forecasts are important for many reasons, including for the company to ensure they have the materials they need to create the products required in a certain period of time. Your objective is to minimize the forecast error, which will be measured using the Mean Absolute Percentage Error (MAPE) with a goal of being below 25%. You have historical monthly sales data for the past year and access to software that provides forecasts based on five different forecasting techniques (Naïve, 3-Month Moving Average, Exponential Smoothing for .2, Exponential Smooth for .5, and Seasonal) to help determine the best forecast for that particular month. Based on the given data, you will identify trends and patterns to create a more accurate forecast. Approach Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next…arrow_forwardApproach Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next month. Remember to select the forecasting technique that produces the forecast error nearest to zero. For example: a. Naïve Forecast is 230 and the Forecast Error is -15. b. 3-Month Moving Forecast is 290 and the Forecast Error is -75. c. Exponential Smoothing Forecast for .2 is 308 and the Forecast Error is -93. d. Exponential Smoothing Forecast for .5 is 279 and the Forecast Error is -64. e. Seasonal Forecast is 297 and the Forecast Error is -82. The forecast for the next month would be 230 as the Naïve Forecast had the Forecast Error closest to zero with a -15. This forecasting technique was the best performing technique for that month. You do not need to do any external analysis-the forecast error for each strategy is already calculated for you in the tables below. Naïve Month Period Actual Demand Naïve Forecast Error 3- Month Moving Forecast 3- Month Moving…arrow_forwardScenario You have been given a task to create a demand forecast for the second year of sales of a premium outdoor grill. Accurate forecasts are important for many reasons, including for the company to ensure they have the materials they need to create the products required in a certain period of time. Your objective is to minimize the forecast error, which will be measured using the Mean Absolute Percentage Error (MAPE) with a goal of being below 25%. You have historical monthly sales data for the past year and access to software that provides forecasts based on five different forecasting techniques (Naïve, 3-Month Moving Average, Exponential Smoothing for .2, Exponential Smooth for .5, and Seasonal) to help determine the best forecast for that particular month. Based on the given data, you will identify trends and patterns to create a more accurate forecast. Approach Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next…arrow_forward
Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning