Concept explainers
At you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years:
The director of medical services predicted 6 years ago that demand in year 1 would be 41 surgeries.
a) Use exponential smoothing, first with a smoothing constant of .6 and then with one of .9, to develop forecasts for years 2 through 6.
b) Use a 3-year moving average to forecast demand in years 4, 5, and 6.
c) Use the trend-projection method to forecast demand in years 1 through 6.
d) With MAD as the criterion, which of the four
a)
To determine: Findthe forecast for years 2 through 6, using exponential smoothing.
Introduction: A sequence of data pointing in successive order is known as time series. Time series forecasting is the prediction based on past events which are at a uniform time interval. Moving average method and trend projections are one of the time series methods which use weights to prioritize past data.
Answer to Problem 13P
The forecast for years 2 through 6 using exponential smoothing with smoothing constant 0.6 is 56.263 and smoothing constant 0.9 is 57.757.
Explanation of Solution
Forecast for years 1 through 6 using exponential smoothing with smoothing constant 0.6:
Given information:
Year | 1 | 2 | 3 | 4 | 5 | 6 |
Heart Transplants | 45 | 50 | 52 | 56 | 58 |
Formula to calculate the forecasted demand:
Where,
Smoothing constant=0.6 | |||
Year | Heart Transplants | Forecast | Absolute error |
1 | 45 | 41 | 4.000 |
2 | 50 | 43.400 | 6.600 |
3 | 52 | 47.360 | 4.640 |
4 | 56 | 50.144 | 5.856 |
5 | 58 | 53.658 | 4.342 |
6 | 56.263 | ||
Total | 25.438 | ||
MAD | 5.08768 |
Excel worksheet:
Calculation of the forecast for year 2:
To calculate forecast for year 2, substitute the value of forecast of year 1, smoothing constant and difference of actual and forecasted demand in the above formula. The result of the forecast for year 2 is 43.40.
Calculation of the forecast for year 3:
To calculate forecast for year 3, substitute the value of forecast of year 2, smoothing constant and difference of actual and forecasted demand in the above formula. The result of the forecast for year 3 is 47.360.
Calculation of the forecast for year 4:
To calculate forecast for year 4, substitute the value of forecast of year 3, smoothing constant and difference of actual and forecasted demand in the above formula. The result of the forecast for year 4 is 50.144.
Calculation of the forecast for year 5:
To calculate forecast for year 5, substitute the value of forecast of year 4, smoothing constant and difference of actual and forecasted demand in the above formula. The result of the forecast for year 5 is 53.658.
Calculation of the forecast for year 6:
To calculate forecast for year 6, substitute the value of forecast of year 5, smoothing constant and difference of actual and forecasted demand in the above formula. The result of the forecast for year 6 is 56.263.
Calculation of MAD using exponential smoothing with smoothing constant α=0.6:
Formula to calculate the Mean Absolute Deviation:
Calculation of the absolute error for year 1:
The absolute error for year 1 is the modulus of the difference between 45 and 41, which corresponds to 4. Therefore, the absolute error for year 1 is 4.
Calculation of the absolute error for year 2:
The absolute error for year 2 is the modulus of the difference between 50 and 43.4, which corresponds to 6.6. Therefore, the absolute error for year 2 is 6.6.
Calculation of the absolute error for year 3:
The absolute error for year 3 is the modulus of the difference between 52 and 47.360, which corresponds to 4.640. Therefore, the absolute error for year 3 is4.640.
Calculation of the absolute error for year 4:
The absolute error for year 4 is the modulus of the difference between 56 and 50.144, which corresponds to 5.856. Therefore, the absolute error for year 4 is5.856.
Calculation of the absolute error for year 5:
The absolute error for year 5 is the modulus of the difference between 58 and 53.658, which corresponds to 4.342. Therefore, the absolute error for year 5 is 4.342.
Calculation of the Mean Absolute Deviation using exponential smoothing:
Upon the substitution of summation value of absolute error for 5 years, that is, 25.438 are divided by number of years. That is, 5 yields MAD of 5.08768.
The forecast for years 2 through 6 using exponential smoothing with 0.6 as smoothing constant is 56.263.
The forecast for years 1 through 6 using exponential smoothing with smoothing constant 0.9:
Given information:
Year | 1 | 2 | 3 | 4 | 5 | 6 |
Heart Transplants | 45 | 50 | 52 | 56 | 58 |
Formula to calculate the forecasted demand:
Where
Smoothing constant=0.9 | |||
Year | Heart Transplants | Forecast | Absolute Error |
1 | 45 | 41 | 4 |
2 | 50 | 44.600 | 5.400 |
3 | 52 | 49.460 | 2.540 |
4 | 56 | 51.746 | 4.254 |
5 | 58 | 55.575 | 2.425 |
6 | 57.757 | 57.757 | |
Total | 18.6194 | ||
MAD | 3.72388 |
Excel worksheet:
Calculation of the forecast for year 2:
To calculate the forecast for year 2, substitute the value of forecast of year 1, smoothing constant and difference of actual and forecasted demand in the above formula. The result of the forecast for year 2 is 44.60.
Calculation of the forecast for year 3:
To calculate forecast for year 3, substitute the value of forecast of year 2, smoothing constant and difference of actual and forecasted demand in the above formula. The result of the forecast for year 3 is 49.460.
Calculation of the forecast for year 4:
To calculate forecast for year 4, substitute the value of forecast of year 3, smoothing constant and difference of actual and forecasted demand in the above formula. The result of the forecast for year 4 is 50.144.
Calculation of the forecast for year 5:
To calculate forecast for year 5, substitute the value of forecast of year 4, smoothing constant and difference of actual and forecasted demand in the above formula. The result of the forecast for year 5 is55.575.
Calculation of the forecast for year 6:
To calculate forecast for year 6, substitute the value of forecast of year 5, smoothing constant and difference of actual and forecasted demand in the above formula. The result of the forecast for year 6 is57.757.
Calculation of MAD using exponential smoothing with smoothing constant α=0.9:
Formula to calculate the Mean Absolute Deviation:
Calculation of the absolute error for year 1:
The absolute error for year 1 is the modulus of the difference between 45 and 41, which corresponds to 4. Therefore, the absolute error for year 1 is 4.
Calculation of the absolute error for year 2:
The absolute error for year 2 is the modulus of the difference between 50 and 44.6, which corresponds to 5.4. Therefore, the absolute error for year 2 is 5.4.
Calculation of the absolute error for year 3:
The absolute error for year 3 is the modulus of the difference between 52 and49.460, which corresponds to 2.540. Therefore, the absolute error for year 3 is2.540.
Calculation of the absolute error for year 4:
The absolute error for year 4 is the modulus of the difference between 56 and51.746, which corresponds to 4.254. Therefore, the absolute error for year 4 is4.254.
Calculation of the absolute error for year 5:
The absolute error for year 5 is the modulus of the difference between 58 and55.575, which corresponds to 2.425. Therefore, the absolute error for year 5 is 2.425.
Calculation of the Mean Absolute Deviation using exponential smoothing:
Upon the substitution of summation value of absolute error for 5 years, that is,18.6194are divided by the number of years. That is, 5 yields MAD of 3.72388.
The forecast for years 2 through 6 using exponential smoothing with 0.9 as smoothing constant is 57.757.
Hence, the forecast for years 2 through 6 using exponential smoothing with smoothing constant 0.6 is 56.263 and smoothing constant 0.9 is 57.757.
b)
To determine: Using 3-year moving average, forecast the demand for years 4, 5 and 6.
Answer to Problem 13P
The demand forecast for years 4, 5 and 6 is 49, 52.67 and 55.33.
Explanation of Solution
Given information:
Year | 1 | 2 | 3 | 4 | 5 | 6 |
Heart Transplants | 45 | 50 | 52 | 56 | 58 |
Formula to calculate the forecasted demand:
Year | Heart Transplants | Forecast | Absolute Error |
1 | 45 | ||
2 | 50 | ||
3 | 52 | ||
4 | 56 | 49 | 7 |
5 | 58 | 52.67 | 5.333 |
6 | 55.33 | ||
Total | 12.333 | ||
MAD | 6.1667 |
Excel worksheet:
Calculation of the forecast for year 4:
To calculate the forecast for year 4, divide the summation of the values from years 1, 2 and 3 and divide by 3. The corresponding value 49 is the forecast for year 4. The 3-year moving average for year 4 is 49.
Calculation of the forecast for year 5:
To calculate the forecast for year 5, divide the summation of the values from years 2, 3 and 4 and divide by 3. The corresponding value 52.67 is the forecast for year 5. The 3-year moving average for year 5 is 52.67.
Calculation of the forecast for year 6:
To calculate the forecast for year 6, divide the summation of the values from years 3, 4, 5 and divide by 3. The corresponding value 55.33 is the forecast for year 5. The 3-year moving average for year 5 is 55.33.
Calculation of MAD using 3-year moving average:
Formula to calculate the Mean Absolute Deviation:
Calculation of the absolute error for year 4:
The absolute error for year 4 is the modulus of the difference between 56 and 49, which corresponds to 7. Therefore, the absolute error for year 4 is 7.
Calculation of the absolute error for year 5:
The absolute error for year 4 is the modulus of the difference between 58 and 52.67, which corresponds to 5.33. Therefore, the absolute error for year 4 is 5.33.
Calculation of the Mean Absolute Deviation using 3-year moving average:
Upon the substitution of the summation value of the absolute error for 2 years, that is,12.333is divided by number of years. That is, 2 yields MAD of 6.1666.
Hence, the demand forecast for years 4, 5 and 6 is 49, 52.67 and 55.33.
c)
To determine: Find the demand forecast in year 1 through 6using trend projection.
Answer to Problem 13P
The forecast in year 1 through 6using trend projection is62.1.
Explanation of Solution
Given information:
Year | 1 | 2 | 3 | 4 | 5 | 6 |
Heart Transplants | 45 | 50 | 52 | 56 | 58 |
Formula to calculate the demand forecast
Where,
Where,
Year (x) | Heart Transplants (y) | xy | x^2 |
1 | 45 | 45 | 1 |
2 | 50 | 100 | 4 |
3 | 52 | 156 | 9 |
4 | 56 | 224 | 16 |
5 | 58 | 290 | 25 |
∑=15 | ∑=261 | ∑=815 | ∑=55 |
Excel worksheet
Substituting the values in the above formula
Calculation of average of x values
The average of x values is obtained by dividing the summation of x values, that is, (1+2+…+5) with the number of period n. That is, 5. The value of
Calculation of average of y values
The average of y values is obtained by dividing the summation of sales with the number of period n. That is, 5. The value of
Calculation of slope of regression line‘b’:
The summation of product of sales (y) with x values is ∑xy = 815, the product of number of years (n), the average of x values and the average of y values is obtained. That is,
The summation of square of x values, that is, 55 is subtracted from the product of the number of years. That is,5 with average of x values;3. The resultant value is 10. The slope of regression line is obtained by dividing 32 with 10. The value of ‘b’ is 3.2.
Calculation of y-axis intercept ‘a’:
The y-axis intercept is obtained by the difference between average of y values and values obtained by the product of slope of regression line with average of x values. The resultant value of ‘a’ is 42.9.
Calculation of the forecast for years 1 through 6:
a= | 42.9 | b= | 3.2 | |
Year (x) | Heart Transplants (y) | xy | x^2 | Forecast |
1 | 45 | 45 | 1 | 46.1 |
2 | 50 | 100 | 4 | 49.3 |
3 | 52 | 156 | 9 | 52.5 |
4 | 56 | 224 | 16 | 55.7 |
5 | 58 | 290 | 25 | 58.9 |
6 | 62.1 |
Excel worksheet:
Calculation of forecast of year 1:
The forecast for year 1 is obtained by the summation of the product of slope of regression line and forecasted year, with the y-axis intercept. The forecasted value obtained is 46.1.
Calculation of forecast of year 2:
The forecast for year 2 is obtained by the summation of the product of slope of regression line and forecasted year, with the y-axis intercept. The forecasted value obtained is 49.3.
Calculation of forecast of year 3:
The forecast for year 3 is obtained by the summation of the product of slope of regression line and forecasted year, with the y-axis intercept. The forecasted value obtained is 52.5.
Calculation of forecast of year 4:
The forecast for year 4 is obtained by the summation of the product of slope of regression line and forecasted year, with the y-axis intercept. The forecasted value obtained is 55.7.
Calculation of forecast of year 5:
The forecast for year 5 is obtained by the summation of the product of slope of regression line and forecasted year, with the y-axis intercept. The forecasted value obtained is 58.9.
Calculation of forecast of year 6:
The forecast for year 6 is obtained by the summation of the product of slope of regression line and forecasted year, with the y-axis intercept. The forecasted value obtained is 62.1.
Formula to calculate the Mean Absolute Deviation:
Calculation of MAD using trend projection:
a= | 42.9 | b= | 3.2 | ||
Year (x) | Heart Transplants (y) | xy | x^2 | Forecast | Absolute error |
1 | 45 | 45 | 1 | 46.1 | 1.1 |
2 | 50 | 100 | 4 | 49.3 | 0.7 |
3 | 52 | 156 | 9 | 52.5 | 0.5 |
4 | 56 | 224 | 16 | 55.7 | 0.3 |
5 | 58 | 290 | 25 | 58.9 | 0.9 |
6 | 62.1 | ||||
Total | 3.5 | ||||
MAD | 0.7 |
Excel worksheet:
Calculation of the absolute error for year 1:
The absolute error for year 1 is the modulus of the difference between 45 and 46.1, which corresponds to 1.1. Therefore, the absolute error for year 1 is 1.1.
Calculation of the absolute error for year 2:
The absolute error for year 2 is the modulus of the difference between 50 and 49.3, which corresponds to 0.7. Therefore, the absolute error for year 2 is 0.7.
Calculation of the absolute error for year 3:
The absolute error for year 3 is the modulus of the difference between 52 and 52.5, which corresponds to 0.5. Therefore, the absolute error for year 3 is 0.5.
Calculation of the absolute error for year 4:
The absolute error for year 4 is the modulus of the difference between 56 and 55.7, which corresponds to 0.3. Therefore, the absolute error for year 4 is 0.3.
Calculation of the absolute error for year 5:
The absolute error for year 5 is the modulus of the difference between 58 and 58.9, which corresponds to 0.9. Therefore, the absolute error for year 5 is 0.9.
Calculation of the Mean Absolute Deviation using trend projection:
Upon the substitution of summation value of absolute error for 5 years, that is,3.5is divided by the number of years. That is,5 yields MAD of 0.7.
Thus, the forecast in year 1 through 6 using trend projection is 62.1.
d)
To determine: Compare the MAD of exponential smoothing, 3-year moving average and trend projection and infer the best method.
Explanation of Solution
On Comparing MAD from the four methods, (refer to equations (1), (2), (3) and (4)) it can be inferred that trend projection is the best methods since it has the least MAD.
Want to see more full solutions like this?
Chapter 4 Solutions
EBK PRINCIPLES OF OPERATIONS MANAGEMENT
- In 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_forwardDiscuss possible solutions to help Tara become an effective CSR. What should martin be doing to help her?arrow_forward
- What 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_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
- Approach 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_forwardUse the internet to obtain crash safety ratings for passenger vehicles. Then, answer thesequestions:a. Which vehicles received the highest ratings? The lowest ratings?b. How important are crash-safety ratings to new car buyers? Does the degree of importancedepend on the circumstances of the buyer?c. Which types of buyers would you expect to be the most concerned with crash-safety ratings?d. Are there other features of a new car that might sway a buyer from focusing solely on crashsafety? If so, what might they be?arrow_forward
- “Implementing a Performance Management Communication Plan at Accounting, Inc.” Evaluate Accounting Inc.’s communication plan. Specifically, does it answer all of the questions that a good communication plan should answer? Which questions are left unanswered? How would you provide answers to the unanswered questions? “Implementing an Appeals Process at Accounting, Inc.” If you were to design an appeals process to handle these complaints well, what would be the appeal process? Describe the recommended process and why.arrow_forwardThe annual demand for water bottles at Mega Stores is 500 units, with an ordering cost of Rs. 200 per order. If the annual inventory holding cost is estimated to be 20%. of unit cost, how frequently should he replenish his stocks? Further, suppose the supplier offers him a discount on bulk ordering as given below. Can the manager reduce his costs by taking advantage of either of these discounts? Recommend the best ordering policy for the store. Order size Unit cost (Rs.) 1 – 49 pcs. 20.00 50 – 149 pcs. 19.50 150 – 299 pcs. 19.00 300 pcs. or more 18.00arrow_forwardHelp answer showing level work and formulasarrow_forward
- Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage LearningMarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational PublishingPractical 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