OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
7th Edition
ISBN: 9780077835439
Author: Roger G Schroeder, M. Johnny Rungtusanatham, Susan Meyer Goldstein
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 10, Problem 1P
Daily demand for marigold flowers at a large garden store is shown below. Compute:
- a. A three-period moving average for each period.
- b. A five-period moving average for each period.
| Period | Demand |
| 1 | 85 |
| 2 | 92 |
| 3 | 71 |
| 4 | 97 |
| 5 | 93 |
| 6 | 82 |
| 7 | 89 |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
12.2. The manager of the I-85 Carpet Outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlet’s many competitors. The manager has collected the following demand data for the past eight months:
Month Demand for Soft Shag Carpet (1000 yd)1 52 103 64 85 146 107 98 12
a. Compute a three-month moving average forecast for months 4 through 9.
b. Compute a weighted three-month moving average forecast for months 4 through 9. Assign weights of .55, .33, and .12 to the months in sequence, starting with…
Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows: Compute seasonal indices using all of the data .
A newly operated company producing household items would want to forecast its sales volume for the next month. It has been in operation for ten (10) months now. For the past ten (10) months, forecast and sales data for its top selling Item A are as follow:
Time Period
Forecasted Value
Actual Sales (Quantity)
10th month
405
345
9th month
400
380
8th month
410
400
7th month
370
375
6th month
330
360
5th month
320
325
4th month
320
315
3rd month
305
300
2nd month
290
295
1st month
300
280
The operations manager observes the fluctuations on the sales quantity over the 10-month period that the company is in operation. To forecast for the 11th month, the team decided to evaluate options on what forecasting method to use. Their options are:
To use the Moving Average Method using the sales data for the past 10 months,
To use the Exponential Smoothing Average assigning a smoothing constant of .6 and
To use the Trend-adjusted Exponential Smoothing assigning smoothing constants α =…
Chapter 10 Solutions
OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
Ch. 10.S - Ace Hardware sells spare parts for lawn mowers....Ch. 10.S - eXcel The daily demand for chocolate donuts from...Ch. 10.S - The SureGrip Tire Company produces tires of...Ch. 10.S - eXcelManagement believes there is a seasonal...Ch. 10.S - Management of the ABC Floral Shop believes that...Ch. 10 - Prob. 1DQCh. 10 - What is the distinction between forecasting and...Ch. 10 - Qualitative forecasting methods should be used...Ch. 10 - Describe the uses of qualitative, time-series, and...Ch. 10 - Qualitative forecasts and causal forecasts are not...
Ch. 10 - Prob. 6DQCh. 10 - What are the advantages of exponential smoothing...Ch. 10 - How should the choice of be made for exponential...Ch. 10 - Prob. 9DQCh. 10 - Prob. 10DQCh. 10 - Explain how CPFR can be used to reduce forecasting...Ch. 10 - Under what circumstances might CPFR be useful, and...Ch. 10 - Daily demand for marigold flowers at a large...Ch. 10 - The number of daily calls for the repair of Speedy...Ch. 10 - 3-The ABC Floral Shop sold the following number of...Ch. 10 - The Handy Dandy Department Store had forecast...Ch. 10 - 5-The Yummy Ice Cream Company uses the exponential...Ch. 10 - Using the data in problem 2, prepare exponentially...Ch. 10 - Compute the errors of bias and absolute deviation...Ch. 10 - eXcel At the ABC Floral Shop, an argument...Ch. 10 - Only a portion of the following table for...Ch. 10 - A candy store has sold the following number of...Ch. 10 - eXcel A grocery store sells the following number...Ch. 10 - Prob. 12PCh. 10 - The Easyfit tire store had demand for tires shown...Ch. 10 - Prob. 14P
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
- At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.arrow_forwardRespond to each of the items using the following time series data. Period Demand 144 2 172 3 157 4 160 144 181 7 160 8 176 9. 149 10 183 11 182 12 149 13 153 14 164 15 153 16 104 Click here for the Excel Data File b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal place.) Absolute Period Demand 5-period SMA Errors 1 144 172 3 157 4. 160 5 144 181 7 160 8 176 9 149 10 183 11 182 12 149 13 153 14 164 LOarrow_forwardThe following table shows the three-period moving average and five-period moving average for monthly sales of Budget Furniture's during 2019. Moving averages of Budget Furniture's Time period Months Sales Three-period moving average (rounded off to Five-period moving average four decimals) R'millions 1 Jan 7 5.0000 6.2 February 5.6667 6.6 March 5 7.0000 B 4 April 8.3333 8.2 May 7 9.3333 8.4 June 8.3333 9.6 7 July 12 8.6667 9.6 August 4 A 9.2 September 10 10.6667 10 October 13 10.6667 11 November 9 12 December 10 The seasonal index for the month of February in 2019 is: LOarrow_forward
- Following data on the demand for sewing machines manufactured by Taylor and Son Co. have been compiled for the past 10 years. Year 1971 1972 1973 1974 1975 78 1976 1977 1978 1979 99 1980 106 Demand 58 65 73 76 87 88 93 in (1000 units) Please estimate the value of demand for next 3 years using trend analysis.arrow_forwardForecast error is calculated as: Actual - Forecast O Forecast - Actual (Forecast - Actual) ^ 2 Absolute (Actual - Forecast) (Actual - Forecast) ^ 2arrow_forwardThe manager of Carpet City outlet needs to make an accurate forecast of demand for Soft Shag Carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City’s many competitors. The manager has collected the following demand data for the past 8 months: Month Demand for Soft Shag Carpet (1000 yd) 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 Required showing all workings: Compute a 3-month moving average forecast for months 4 through 9. Compute a weighted 3-month moving average forecast for months 4 through 9. Assign weights of 0.55, 0.33 and 0.12 to the months in sequence, starting with the most recent month.arrow_forward
- 12.2 The manager of the I-85 Carpet outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlets many competitors. The manager has collected the following demand data for the past 8 months. Month 1 2 3 4 5 6 7 8 Demand for Soft Shag Carpet (1000 yd) 5 10 6 8 14 10 9 12 a. Compute a three-month moving average forecast for months 4 through 9.arrow_forwardPlease do not give solution in image format thanku The following time series shows the number of units of a particular product sold over the past six months. Compute the MSE for the 4-month moving average. Month Units Sold 1 8 2 3 3 4 4 5 5 12 6 10 7arrow_forward1. The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Part 2 Week Of Pints Used August 31 350 September 7 372 September 14 412 September 21 381 September 28 366 October 5 378 Part 3 a) The forecasted demand for the week of October 12 using a 3-week moving average LOADING... = _____________pints (round your response to two decimal places).arrow_forward
- Given the demand data, answer the following questions below. Year Sales 1 - 123 2 - 118 3 - 109 4 - 112 5 -100 6 -110 7 -124 8 - ? What will be the forecast demand in Year 8 using Naïve method?a.) 120b.) 110c.) 115d.) 124arrow_forward3. Attendance at Los Angeles' newest Disney like attraction, Vacation World has been as follows: Quarter Guests Quarter Guests (in Thousands) (in Thousands) 2017 Q1 73 Q3 124 Q2 104 Q4 52 Q3 168 2019 Q1 89 Q4 74 Q2 146 2018 Q1 65 Q3 205 Q2 82 Q4 98 a. Graph the data. (Use Excel) b. Compute seasonal indices using all the data. (Solve manually)arrow_forwardIn the Atlanta area, the number of daily calls for the repair of Speedy copy machines has been recorded as follows: October Calls 1 92 2 127 3 106 4 165 5 125 6 111 7 178 8 97 Prepare a three-period moving-average forecast for periods 4-8. What is the error on each day? Prepare a three-period weighted moving average forecast for periods 4-8 using weights of w1=.5, w2=.3, w3=.2 Which of the two forecasts is better? (Use CFE to calculate the better method)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,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
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