Operations Management: Sustainability and Supply Chain Management (12th Edition)
12th Edition
ISBN: 9780134130422
Author: Jay Heizer, Barry Render, Chuck Munson
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 4, Problem 4P
A check-processing center uses exponential smoothing to forecast the number of incoming checks each month. The number of checks received in June was 40 million, while the forecast was 42 million. A smoothing constant of .2 is used.
- a. What is the forecast for July?
- b. If the center received 45 million checks in July, what would be the forecast for August?
- c. Why might this be an inappropriate
forecasting method for this situation?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
i need this to study stop canceling my questions
A check-processing center uses exponential smooth- ing to forecast the number of incoming checks each month. The number of checks received in June was 40 million, while the fore- cast was 42 million. A smoothing constant of .2 is used.
a) What is the forecast for July?b) If the center received 45 million checks in July, what would be
the forecast for August?c) Why might this be an inappropriate forecasting method for the situation
A check-processing center uses exponential smoothing to forecast the number of incoming checks each month. The number of checks received in June was 40 million, while the forecast was 42 million. A smoothing constant of .2 is used. a) What is the forecast for July? b) If the center received 45 million checks in July, what would be the forecast for August? c) Why might this be an inappropriate forecasting method for this situation?
a) Apply moving average and exponential smoothing to generate two forecasts of the closing price for the entire data period. Set appropriate values for the forecast parameters (e.g., k and a).
b) Plot and compare the actual and predicted data values you calculated in part (b). Provide one chart that displays actual, moving average, and exponential smoothing lines. Hint: Calculate MSE, MAD, or MAPE to compare the different forecasts.
Develop your own forecast from scratch. Do NOT use Excel’s Data Analysis or Forecast Sheets.
Chapter 4 Solutions
Operations Management: Sustainability and Supply Chain Management (12th Edition)
Ch. 4 - What is a qualitative foretasting model, and when...Ch. 4 - Identify and briefly describe the two general...Ch. 4 - Identify the three forecasting time horizons....Ch. 4 - Briefly describe the steps that are used to...Ch. 4 - A skeptical manager asks what medium-range...Ch. 4 - Explain why such forecasting devices as moving...Ch. 4 - What is the basic difference between a weighted...Ch. 4 - What three methods are used to determine the...Ch. 4 - Research and briefly describe the Delphi...Ch. 4 - What is the primary difference between a...
Ch. 4 - Define time series.Ch. 4 - What effect does the value of the smoothing...Ch. 4 - Explain the value of seasonal indices in...Ch. 4 - Which forecasting technique can place the most...Ch. 4 - In your own words, explain adaptive forecasting.Ch. 4 - What is the purpose of a tracking signal?Ch. 4 - Explain, in your own words, the meaning of the...Ch. 4 - What is the difference between a dependent and an...Ch. 4 - Give examples of industries that are affected by...Ch. 4 - Give examples of industries in which demand...Ch. 4 - Prob. 21DQCh. 4 - Prob. 22DQCh. 4 - The following gives the number of pints of type B...Ch. 4 - 4.2 a. Plot the above data on a graph. Do you...Ch. 4 - Refer to Problem 4.2. Develop a forecast for years...Ch. 4 - A check-processing center uses exponential...Ch. 4 - The Carbondale Hospital is considering the...Ch. 4 - The monthly sales for Yazici Batteries, Inc., were...Ch. 4 - The actual demand for the patients at Omaha...Ch. 4 - Daily high temperatures in St. Louis for the last...Ch. 4 - Lenovo uses the ZX-81 chip in some of its laptop...Ch. 4 - Data collected on the yearly registrations for a...Ch. 4 - Use exponential smoothing with a smoothing...Ch. 4 - Consider the following actual and forecast demand...Ch. 4 - As you can see in the following table, demand for...Ch. 4 - Following are two weekly forecasts made by two...Ch. 4 - Refer to Solved Problem 4.1 on page 138. a. Use a...Ch. 4 - Solved example 4.1 Sales of Volkswagens popular...Ch. 4 - Refer to Solved Problem 4.1. Using smoothing...Ch. 4 - Consider the following actual (At) and forecast...Ch. 4 - Income at the architectural firm Spraggins and...Ch. 4 - Question 4.20 Resolve Problem 4.19 with =.1 and ...Ch. 4 - Question 4.21 Refer to the trend-adjusted...Ch. 4 - Question 4.22 Refer to Problem 4.21. Complete the...Ch. 4 - Question 4.23 Sales of quilt covers at Bud Baniss...Ch. 4 - Question 4.25 The following gives the number of...Ch. 4 - Prob. 25PCh. 4 - Question 4.27 George Kyparisis owns a company...Ch. 4 - Question 4.28 Attendance at Orlandos newest...Ch. 4 - Question 4.29 North Dakota Electric Company...Ch. 4 - Question 4.33 The number of internal disk drives...Ch. 4 - Dr. Lillian Fok, a New Orleans psychologist,...Ch. 4 - Emergency calls to the 911 system of Durham, North...Ch. 4 - Using the 911 call data in Problem 4.43, forecast...Ch. 4 - Question 4.47 Storrs Cycles has just started...Ch. 4 - Question 4.49 Boulanger Savings and Loan is proud...Ch. 4 - Question 4.24 Mark Gershon, owner of a musical...Ch. 4 - Lori Cook has developed the following forecasting...Ch. 4 - Prob. 45PCh. 4 - Question 4.32 The following data relate the sales...Ch. 4 - Question 4.34 The number of auto accidents in...Ch. 4 - Question 4.35 Rhonda Clark, a Slippery Rock,...Ch. 4 - Accountants at the Tucson firm, Larry Youdelman,...Ch. 4 - Sales of tablet computers at Ted Glickmans...Ch. 4 - Question 4.38 City government has collected the...Ch. 4 - Using the data in Problem 4.39, apply linear...Ch. 4 - Bus and subway ridership for the summer months in...Ch. 4 - Thirteen students entered the business program at...Ch. 4 - Question 4.48 Dave Fletcher, the general manager...Ch. 4 - The following are monthly actual and forecast...Ch. 4 - Prob. 1CSCh. 4 - Prob. 2CSCh. 4 - Prob. 3CSCh. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Under what conditions might a firm use multiple forecasting methods?arrow_forwardThe 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?arrow_forwardThe file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.arrow_forward
- The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?arrow_forwardThe file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?arrow_forwardNote:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forward
- An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is F̟ = 124 + 2.1t, and it was developed using data from periods 1 through 10. Based on data for periods 11 through 20 as shown in the table, which of these two methods has the greater accuracy if MAD and MSE are used? (Round your intermediate calculations and final answers to 2 decimal places.) t Units Sold 11 144 12 146 13 152 14 142 15 152 16 149 17 152 18 154 19 20 157 164 Click here for the Excel Data File MAD (Naive) 5.11 MAD (Linear) 5.49 MSE (Naive) MSE (Linear)arrow_forwardA check processing center uses exponential smoothing to forecast the number of incoming chewcks each moth. the number of checks received in june was 40 million while the forecast was 42 mil. A smoothing constabt of 0,15 is used. a)Using exponential smoothing and given a the forecast for the month of july=41.7 million checks received b) If the check-processing center received 46 million checks in the month of July then using exponential smoothing and given a the forecast for the month of august= [__] million checks recievedarrow_forwardA check-processing center uses exponential smoothing to forecast the number of incoming checks each month. The number of checks received in June was 42 million, while the forecast was 41 million. A smoothing constant of 0.15 is used. a) Using exponential smoothing and given a, the forecast for the month of July = million checks received (round your response to one decimal place). #f the check-processing center received 44 million checks in the month of July, then using exponential smoothing and given a, the forecast for the month of August = c) Exponential smoothing may not be an appropriate method to use for the check-processing center because: OA the cheat-processing center's forecast is very hard to make as its processing requirements should have a very high variability. OB the check-processing center should observe an increasing trend in its processing requirements. OC. the check-processing center should observe seasonality in its processing requirements. OD. the check-processing…arrow_forward
- 1. Figure 8.90 shows summer air visibility measurements for Denver, Colorado. The acceptable visibility standard is 100, with readings above 100 indicating clean air and good visibility, and readings below 100 indicating temperature inversions caused by forest fires, volcanic eruptions, or collisions with comets. Figure 8.9 Summer Air Visibility Measurements Visibility rating 250 225 200 175 150 125 100 75 50- 25 0 Year 2 Year 1 22 25 28 31 3 July 6 9 12 15 18 21 24 27 30 Date Augustarrow_forwarda. 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 Errorarrow_forwardeBook Problem 6-05 Consider the following time series data. 3 16 Week 1 Week 2 Value 18 13 a. Choose the correct time series plot (1) € (!!!) Time Series Value Time Series Value 28642986420 284H2G86420 1 4 11 2 {B} 2 TH 3 Week (t) Week (t) 5 6 € (iv) Time Series Value Time Series Value 28642 NO 28642 NO 1 2 2 4 3₁ Week (t) Week (t) 5 6arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Forecasting 2: Forecasting Types & Qualitative methods; Author: Adapala Academy & IES GS for Exams;https://www.youtube.com/watch?v=npWni9K6Z_g;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License