EBK PRODUCTION AND OPERATIONS ANALYSIS
7th Edition
ISBN: 8220102480681
Author: Olsen
Publisher: WAVELAND
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 46AP
Summary Introduction
Interpretation:
Concept Introduction:All planning/
Size of the bucket depends on and affects many parameters.
MRP’s in many manufacturing companies are seen to have a time bucket of a week but it is not the rule.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
a. What is your forecast for December of Year 4, making period 1 as the starting period for the regression?
b. The actual demand for period 48 was just learned to be 5,100. Add this demand to the Inputs file and change the starting period for the regression to period 2 so that the number of periods in the regression remains unchanged. How much or little does the forecast for period 49 change from the one for period 48? The error measures? Are you surprised?c. Now change the time when the regression starts to period 25 and repeat the process. What differences do you note now? What forecast will you make for period 49?
The observed demand from the four quarters of Year 1 can also be used to developinitial deseasonalized forecast estimates that are required to start making forecasts withthe exponential smoothing models. The first real forecast will be for Q1 of Year 2, andthe use of simple exponential smoothing requires an estimated deseasonalized forecastfrom Q4 of Year 1 to use as a starting point. The estimated deseasonalized “forecast” forQ4 of Year 1 should be obtained as the average deseasonalized quarterly demand fromYear 1. The estimate can also be used as the starting base forecast component for Q4 ofYear 1 for trend-adjusted exponential smoothing. The initial deseasonalized trendcomponent estimate for Q4 of Year 1 should be assumed to be zero.
What should be our forecast accuracy target if there is a high degree of volatility in customer orders and long lead times?
We have a new chief sales officer who is proposing that we should forecast in dollars, not in units/cases. I have never heard of anyone forecasting in dollars. It is true that dollarized forecasts can help Sales in knowing precisely what sales target they should be hitting. But, is it the best practice?
Chapter 8 Solutions
EBK PRODUCTION AND OPERATIONS ANALYSIS
Ch. 8.1 - Prob. 1PCh. 8.1 - Prob. 2PCh. 8.1 - Prob. 3PCh. 8.1 - Prob. 4PCh. 8.1 - Prob. 5PCh. 8.1 - Prob. 6PCh. 8.1 - Prob. 7PCh. 8.1 - Prob. 8PCh. 8.1 - Prob. 9PCh. 8.2 - Prob. 10P
Ch. 8.2 - Prob. 11PCh. 8.2 - Prob. 12PCh. 8.2 - Prob. 13PCh. 8.2 - Prob. 14PCh. 8.2 - Prob. 15PCh. 8.2 - Prob. 16PCh. 8.2 - Prob. 17PCh. 8.2 - Prob. 18PCh. 8.2 - Prob. 19PCh. 8.2 - Prob. 20PCh. 8.2 - Prob. 21PCh. 8.2 - Prob. 22PCh. 8.3 - Prob. 23PCh. 8.3 - Prob. 24PCh. 8.3 - Prob. 25PCh. 8.4 - Prob. 26PCh. 8.4 - Prob. 27PCh. 8.4 - Prob. 28PCh. 8.4 - Prob. 29PCh. 8.5 - Prob. 30PCh. 8.5 - Prob. 31PCh. 8.5 - Prob. 32PCh. 8.5 - Prob. 33PCh. 8.5 - Prob. 34PCh. 8.6 - Prob. 35PCh. 8.6 - Prob. 36PCh. 8.6 - Prob. 37PCh. 8.6 - Prob. 38PCh. 8.6 - Prob. 39PCh. 8.6 - Prob. 40PCh. 8 - Prob. 41APCh. 8 - Prob. 42APCh. 8 - Prob. 43APCh. 8 - Prob. 44APCh. 8 - Prob. 45APCh. 8 - Prob. 46APCh. 8 - Prob. 48APCh. 8 - Prob. 49APCh. 8 - Prob. 50APCh. 8 - Prob. 51AP
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
- The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?arrow_forwardSangster Manufacturing makes a line of wheelbarrows consisting of three models: 4 cubic feet, 3 cubic feet, and 2 cubic feet. While the demand for each model varies, the same work centers are used in making each model. As well, some of the parts are common. For planning purposes Sangster uses a four-week period. This provides for 13 periods of four weeks for the year. Based on past demand they have developed the following forecast for the next year: Period Demand Forecast Period Demand Forecast 500 8 1500 600 1000 3. 900 10 800 4. 1200 11 700 1400 12 600 1600 13 400 1800 The cost of carrying inventory is calculated at $2 per unit per period. Because wheelbarrows are a common item and there is a lot of competition, the company feels that a stockout will result in lost sales. They estimate that the cost of a lost sale is approximately $20 a wheelbarrow. Consequently, it is company policy to cany aarrow_forwardWhitebridge Hardware Store Whitebridge Hardware Store has a monthly demand for lawn fertilizer listed below. The gardening season starts in early spring when people want to fertilize their lawns. Period Demand Jan 59 Feb 68 March 91 April 145 May 182 June 212 July 193 Aug 174 Sept 144 Oct 89 Nov 74 Dec 55 Answer Questions 1 – 5 below. [Be sure to watch the video on how to complete your forecasting problem, in the content module.] Everything must be typed including the graph. You need to complete this assignment in Excel. For the narrative answers, you can include them in Excel in one or more of the empty cells. If you know how to add an extra worksheet, you can add your answers on a new worksheet. Or you can type them in a Word document Please include your name somewhere. In the Assignments area, a…arrow_forward
- K The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week 1 2 3 4 5 6 OA. The value of the forecast will remain the same. B. The value of the forecast will increase. OC. The value of the forecast will decrease. Actual No. of Patients 27 29 36 20 24 35 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.250 one period ago, 0.250 two periods ago, and 0.167 three periods ago. a) What is the value of your forecast? The value of the forecast is 28.67 patients (round your response to two decimal places). b) If instead the weights were 20, 15, 15, and 10, respectively, how would the forecast change?arrow_forwardYou have been tasked with the development of an aggregate plan for the year ended 31 December 2022. Accordingly, you have developed monthly forecasts for a range of motorcycles as presented in Table 5.1, below. Table 5.1: The demand forecast developed for the year ended 31 December 2022. MONTH Jan-2022 Feb-2022 Mar-2022 Apr-2022 May-2022 Jun-2022 Jul-2022 Aug-2022 Sep-2022 Oct-2022 Nov-2022 Dec-2022 PRODUCTION DAYS DEMAND FORECAST 16 16 23 21 22 22 21 20 20 20 16 16 150 150 250 250 400 500 600 750 450 250 150 150 Compute and tabulate the daily demand for each month in the table below (round off to the nearest whole number).arrow_forwardThe options Outlook has for handling the seasonality of magazine are adding workers during the peak season, subcontracting out some of the work, building up inventory during the slow months, or building up a backlog of orders that will be delivered late to customers. To determine how to best use these options through an aggregate plan, Outlook`s vice president of Marketing starts with the first task-building a demand forecast. Although Outlook could attempt to forecast this demand itself, a much more accurate forecast comes from a collaborative process used by both Outlook and its retailers to produce the forecast shown in Table (a). Outlook sells each book through retailers for Rs.40. The company has a starting inventory in January of 1000 books. At the beginning of January the company has a workforce of 80 employees. The company has a total of 20 working days in each month, and each employee earns Rs 4 per hour regular time. Each employee works eight hours per day on straight time…arrow_forward
- The Saki motorcycle dealer in the Minneapolis–St. Paul area wants to make an accurate forecast of demand for the Saki Super TXII motorcycle during the next month. Because the manufacturer is in Japan, it is difficult to send motorcycles back or reorder if the proper number is not ordered a month ahead. From sales records, the dealer has accumulated the following data for the past year: Month Motorcycle Sales January 9 February 7 March 10 April 8 May 7 June 12 July 10 August 11 September 12 October 10 November 14 December 16 a. Compute a 3-month moving average forecast of demand for April through January (of the next year). b. Compute a 5-month moving average forecast for June through January. c. Compare the two forecasts computed in (a) and (b), using MAD. Which one should the dealer use for January of the next year?arrow_forwardThe options Outlook has for handling the seasonality of magazine are adding workers during the peak season, subcontracting out some of the work, building up inventory during the slow months, or building up a backlog of orders that will be delivered late to customers. To determine how to best use these options through an aggregate plan, Outlook`s vice president of Marketing starts with the first task-building a demand forecast. Although Outlook could attempt to forecast this demand itself, a much more accurate forecast comes from a collaborative process used by both Outlook and its retailers to produce the forecast shown in Table (a). Outlook sells each book through retailers for Rs.40. The company has a starting inventory in January of 1000 books. At the beginning of January the company has a workforce of 80 employees. The company has a total of 20 working days in each month, and each employee earns Rs 4 per hour regular time. Each employee works eight hours per day on straight time…arrow_forward For Disney World, there are six main parks. A forecast of daily attendance at each is the main number thatdetermines labour, maintenance, and scheduling. Disney develops daily, weekly, monthly, annual, and 5-year forecasts. At Disney, forecasts are reviewed daily at the highest levels to make sure that the model, assumptions, anddata are valid. Disney uses a variety of statistical models including moving averages, econometrics, and regression analysis.It also employs judgmental, or nonquantitative models. Disney uses park attendance forecasts to drive decisions about staffing, opening times, ride availability, andfood supplies. Disney’s forecasting team employs 35 analysts and 70 field personnel to survey 1 million people/businessevery year. Disney uses a firm called Global Insights for travel industry forecasts and gathers data on exchange rates,arrivals into the U.S., airline specials, Wall Street trends, and school vacation schedules. At Disney, Error measures are applied;…arrow_forward
- 2. Fastway is a parcel delivery company based in Pretoria. It measures demand on a weekly basis in terms of the number of parcels which it is given to deliver (irrespective of the size of each parcel). The forecast for week 20 is 63. The table below shows actual demands for Fastway. Week Actual demand 20 63 21 62 22 67 23 66 24 67 25 69 26 65 27 71 28 68 29 68 30 70 31 72 32 66 33 68 34 67 Predict the forecast for week 35 using an exponential smoothing with a smoothing constant of 0.20.arrow_forwardTime-series analysis is based on the assumption that: a. there are dependable correlations between the variable to be forecast and other independent variables. b. random error terms are normally distributed. c. the data do not exhibit a trend. d. past patterns in the variable to be forecast will continue unchanged into the future.arrow_forwardMarcic Textile Inc. manufactures customized cloth and textile from generic parts. Formed and operated by part-time students Marc and Eric, the company has had steady growth since it started. The company manufactures cloth mostly at night, using part-time students. The company purchases generic threads and fabric in volume at a discount from a variety of sources whenever they see a good deal. Thus, they need a good forecast so that they will know how many fabrics to purchase and stock. For the past 10 months, there had been unstable sales of cloth. During the first month of operations, sales were 890 yards, and there had been a steady growth of 5% per month for the next 3 months. However, after that, sales went down by 10% and continued the declining trend for the next 2 months. On the 7th month, sales were stabilized at 955 yards until the 10thmonth of operations. For every yard of cloth manufactured it needs 2 fiber A, 3 fiber B and 7 fiber C. Forecast for fiber A is based directly on…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,
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