OPERATIONS AND SUPPLY CHAIN MANAGEMENT
9th Edition
ISBN: 9781119448037
Author: Russell
Publisher: WILEY
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 12, Problem 17P
Townside Food Vending operates vending machines in office buildings, the airport, bus stations, colleges, and other businesses and agencies around town and operates vending trucks for building and construction sites. The company believes its sandwich sales follow a seasonal pattern. It has accumulated the following data for sandwich sales per season during the past four years.
Develop a seasonally adjusted
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Boi’s Car Rentals has been doing great business since acquiring a major North American car rental label. In preparation for the World Peace Summit slated for next month, they need to project their demand for May. The business’ historic data is listed below:
Months
Nov.
Dec.
Jan.
Feb.
Mar.
April
Quantity
37
36
40
42
47
43
Based on the above data calculate the demand for May using a five-month moving average
Calculate the forecast for May based on a THREE month weighted moving average applied to the following past demand data and using the weights: 4, 3, 2 (largest weight is for most recent data)?
Using the exponential forecasting technique with a smoothing constant value of 0.2 and an initial value of 40, forecast the number of cars that will be demanded for May.
The manager of a fabric company needs to accurately forecast the demand for fabric. If the customers do not order enough fabric (in 10,000 yards), they will buy their fabric from one of the company’s major competitors. The company has collected the following demand data for the past 10 months. Compute a weighted three-month moving average forecast using weights of (a) 10%, 30%, 60%, and (b) 25% 30% 45% for the most distant data, next recent, and the most recent respectively.
Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Demand
37
45
47
50
52
54
58
60
63
65
Forecast Table:
Month
Actual
WMA (10%, 30%, 60%)
WMA (25%, 30%, 45%)
January
February
March
April
May
June
July
August
September
October
a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error.
b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error.
c. Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?
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
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)
8. What three methods are used to determine the accuracy of any given forecasting method? How would you determi...
Operations Management: Sustainability and Supply Chain Management (12th Edition)
Define the terms total quality management, just-in-time, and reengineering. What do these terms have in common?
Operations Management, Binder Ready Version: An Integrated Approach
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)
Create an Excel spreadsheet on your own that can make combination forecasts for Problem 18. Create a combinatio...
Operations Management: Processes and Supply Chains (12th Edition) (What's New in Operations Management)
What is precedent, and how does it affect common law?
Business in Action (8th 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_forwardThe 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_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_forward
- Scenario 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_forwardPlease see attached image for chart to answer questions. Prepare a graph that shows the four-year demand history for the bow rake. Discuss any apparent trend and seasonal patterns. Which forecasting method might be best for bow rakes for each month of Year 5? Why? Use the forecasting method you recommended in part c to forecast demand for each month of Year 5. OM Explorer is highly recommended to develop your forecasts.arrow_forwardMark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 TV Appearances 3 4 8 6 7 7 Demand for Guitars 4 6 7 5 10 6 This exercise contains only parts b, c, and d. Part 2 b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): Y = enter your response here + enter your response herexarrow_forward
- Explain the difference between qualitative and quantitative approaches to forecasting. Describe three (3) qualitative methods used in forecasting. Given the following data of demand for shopping carts at a leading supermarket. Prepare a forecast for period 6 using each of the following approaches: Period 1 2 3 4 5 Demand 60 65 55 58 64 A three-period moving average. A weighted average using weights of .50 (most recent), .20 and .30. Exponential smoothing with a smoothing constant of .40. The manager of a large cement production factory in Road Town, Tortola has to choose between two alternative forecasting techniques. His production staff used both techniques in order to prepare forecasts for a six-month period (See table below). Using MAD as a criterion, which technique has the better performance record? FORECAST MONTH DEMAND TECHNIQUE 1 TECHNIQUE 2 1 492 488 495 2 470 484 482 3 485…arrow_forwardSuppose that the Perpetual Help College of Rizal had the following record of its growth of enrollment from 2011 -2020. Year Enrolment Year Enrolment 2011 5,200 2016 7,000 2012 5,500 2017 8,800 2013 6,000 2018 9,400 2014 6,500 2019 9,600 2015 6,800 2020 10,500 a) Develop a forecast of enrolment beginning 2014 to 2021 using 3-years moving average forecast model. b) Using weights of .50 for the most recent data, .30 to the second recent data, and .20 to the 3 months old data, develop a forecast beginning 2014 to 2021 using 3 years weighted moving average forecast…arrow_forwardWeekly income for Quiet Mental Breakdown, an online psychology firm, is provided below. Determine, on the basis of minimizing the mean square error, whether a three-period or four-period simple moving average gives a better forecast. Week Income 1 980 2 1040 3 1120 4 1050 5 960 6 990 7 1030 8 1260 9 1240 10 1100 Group of answer choices Both the four-period & three-period simple moving averages have the same forecast accuracy in terms of their MSE There is not enough information to determine the answer The four-period simple moving averages gives a better forecast because it has the smallest MSE The three-period simple moving average gives a better forecast because it has the smallest MSEarrow_forward
- Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 Tv Appearances 3 4 7 6 8 5 Demand for Guitars 3 6 7 5 10 7 b) Using the least-squares regression method, the equation for forecasting is (round your response to four decimal places): Y= _____+_____X C) The estimate for guitar sales if Maroon 5 performed on Tv 9 times =___ (round your response to 2 decimal placesarrow_forwardThe Hartley-Davis motorcycle dealer in the Minneapolis– St. Paul area wants to be able to forecast accurately the de-mand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated thedata in the following table for the past year. a. Compute a three-month moving average forecast ofdemand for April through January (of the next year).b. Compute a five-month moving average forecast forJune through January.c. Compare the two forecasts computed in parts (a) and(b) using MAD. Which one should the dealer use forJanuary of the next year? Month Motorcycle SalesJanuary 9February 7March 10April 8May 7June 12July 10August 11September 12October 10November 14December 16arrow_forwardThe following monthly sales of chocolate boxes (in thousands of AUS dollars) have been recorded for January, February, March, and April, respectively: 9.5, 8, 9, 9. Examining the forecasting accuracy for the month of April only: Explain which of the following forecasting method would you recommend: (i) the Naïve method, (ii) the Average method, or (iii) the Simple exponential smoothing method (assuming alpha= 0.8 and initial state (in December) of 8.5)?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
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,
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
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
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