OPERATIONS AND SUPPLY CHAIN MANAGEMENT
9th Edition
ISBN: 9781119448037
Author: Russell
Publisher: WILEY
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 12, Problem 23P
Temco Industries has developed a
Measure the accuracy of the forecast using MAD, MAPD, and cumulative error. Does the forecast method appear to be accurate?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Weekly sales of copy paper at Cubicle Suppliers are in the table below. Compute a three-
period moving average and a four-period moving average for weeks 5, 6, and 7. Compute
each forecast. Which model is more accurate? Forecast week 8 with the more accurate method
Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows:
PREDICTED DEMAND
Period
Demand
F1
F2
1
68
61
60
2
75
67
66
3
70
75
70
4
74
69
67
5
69
74
72
6
72
67
78
7
80
74
78
8
78
76
80
Click here for the Excel Data File
a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.)
The forecasts generated by two forecasting methods and actual sales have been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop forecast accuracy and answer the following question.
Forecast Accuracy Measures
Forecast 1
Period
Sales
Forecast
Error
Absolute Error
Error^2
Abs. % Error
1
271
276
2
285
263
3
290
286
4
276
288
5
266
269
6
268
267
7
265
261
8
270
268
Total
Average
RSFE
MAD
MSE
MAPE
Tracking Signal
1. What is the MAD, the MSE, the MAPE, the RSFE, and the tracking signal for each forecasting method? Do not round intermediate calculations. Round your answers to two decimal places. Use the minus sign to enter negative values, if any.
2. What can be concluded about the quality of the forecasts 1? Assume that the control limit for the tracking signal…
Chapter 12 Solutions
OPERATIONS AND SUPPLY CHAIN MANAGEMENT
Ch. 12 - List some of the operations and functions in a...Ch. 12 - What is the difference between quantitative...Ch. 12 - Describe the difference between short- and...Ch. 12 - Prob. 4QCh. 12 - Why is accurate forecasting so important to...Ch. 12 - Discuss the relationship between forecasting and...Ch. 12 - Prob. 7QCh. 12 - Describe the Delphi method for forecasting.Ch. 12 - What is the difference between a trend and a cycle...Ch. 12 - How is the moving average method similar to...
Ch. 12 - In the chapter examples for time series methods,...Ch. 12 - What effect on the exponential smoothing model...Ch. 12 - How does adjusted exponential smoothing differ...Ch. 12 - What determines the choice of the smoothing...Ch. 12 - How does the linear trend line forecasting model...Ch. 12 - Of the time series models presented in this...Ch. 12 - What advantages does adjusted exponential...Ch. 12 - Describe how a forecast is monitored to detect...Ch. 12 - Explain the relationship between the use of a...Ch. 12 - Selecting from MAD, MAPD, MSE, E, and E, which...Ch. 12 - What is the difference between linear and multiple...Ch. 12 - Define the different components (y, x, a, and b)...Ch. 12 - A company that produces video equipment, including...Ch. 12 - The Hartley-Davis motorcycle dealer in the...Ch. 12 - The manager of the I-85 Carpet Outlet needs to be...Ch. 12 - The LawnPlus Fertilizer Company distributes...Ch. 12 - Graph the demand data in Problem 12.3. Can you...Ch. 12 - The chairperson of the department of management at...Ch. 12 - The manager of the Excom Service Station wants to...Ch. 12 - The Intrepid mutual fund of growth stocks has had...Ch. 12 - The Oceanside Hotel is adjacent to City Coliseum,...Ch. 12 - Mary Hernandez has invested in a stock mutual fund...Ch. 12 - Globetron manufactures components for use in small...Ch. 12 - The Bee Line Caf is well known for its popular...Ch. 12 - For the demand data in Problem 12.11, develop a...Ch. 12 - Develop a seasonally adjusted forecast for the...Ch. 12 - Backstreets Pizza delivery service has randomly...Ch. 12 - The Willow River Mining Company mines and ships...Ch. 12 - The Great Northwest Outdoor Company is a catalog...Ch. 12 - Townside Food Vending operates vending machines in...Ch. 12 - The town aquatic center has an indoor pool that...Ch. 12 - Develop an adjusted exponential smoothing forecast...Ch. 12 - During the past five months the emergency room at...Ch. 12 - At its craft store and through its website, the...Ch. 12 - A group of business students at Tech organized a...Ch. 12 - Temco Industries has developed a forecasting model...Ch. 12 - Monitor the forecast in Problem 12.23 for bias...Ch. 12 - Develop a statistical control chart for the...Ch. 12 - Monitor the adjusted exponential smoothing...Ch. 12 - Develop an exponential smoothing forecast with =...
Additional Business Textbook Solutions
Find more solutions based on key concepts
5. Answer Question 4 for some other organization, perhaps an organization where you have worked.
Operations Management
The best fits using exponential smoothing, trend analysis, and linear regression for the given data. Introducti...
Principles of Operations Management: Sustainability and Supply Chain Management (10th Edition)
What is precedent, and how does it affect common law?
Business in Action (8th Edition)
• 4.3 Refer to Problem 4.2. Develop a forecast for years 2 through 12 using exponential smoothing with ? =.4 an...
Operations Management: Sustainability and Supply Chain Management (12th Edition)
What is precedent, and how does it affect common law?
Business in Action
Consider the sales data for Computer Success given in Problem 7. Use a 3-month weighted moving average to forec...
Operations Management: Processes and Supply Chains (11th Edition)
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_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?arrow_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forward
- 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?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_forwardThe file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?arrow_forward
arrow_back_ios
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 LearningMarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
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
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;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