Concept explainers
a
Interpretation:Current values of mean and the MAD of monthly demand is to be determined.
Concept Introduction:
Exponential smoothing is used to recursively update the estimates of the mean and standard deviation of demand. The standard deviation is estimated using the mean absolute deviation (MAD).
b
Interpretation:Current values of mean and standard deviation of lead time demand are to be determined.
Concept Introduction:
Exponential smoothing is used to recursively update the estimates of the mean and standard deviation of demand. The standard deviation is estimated using the mean absolute deviation (MAD).
c
Interpretation:Current values of mean and standard deviation of lead time demand when ordered from Japan are to be determined.
Concept Introduction:
Exponential smoothing is used to recursively update the estimates of the mean and standard deviation of demand. The standard deviation is estimated using the mean absolute deviation (MAD).
d
Interpretation:Value of reorder is to be determined.
Concept Introduction:
Exponential smoothing is used to recursively update the estimates of the mean and standard deviation of demand. The standard deviation is estimated using the mean absolute deviation (MAD).
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
Production and Operations Analysis, Seventh Edition
- 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_forwardUse @RISK to analyze the sweatshirt situation in Problem 14 of the previous section. Do this for the discrete distributions given in the problem. Then do it for normal distributions. For the normal case, assume that the regular demand is normally distributed with mean 9800 and standard deviation 1300 and that the demand at the reduced price is normally distributed with mean 3800 and standard deviation 1400.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_forward
- 9. Mancini's Pizzeria sells four types of pizza crust. Last week, the owner tracked the number sold of each type, and this is what she found. Type of Crust Number Sold Thin crust 344 Thick crust 240 Stuffed crust 175 Pan style 316 Based on this information, of the next 5000 pizzas she sells, how many should she expect to be thin crust? Round your answer to the nearest whole number. Do not round any intermediate calculations.arrow_forwardIn year 2010, a saop manufacturer forecasts that demand of 2011 will be 200 lakhs of units of saop. Whereas the actual demand was 210 lakhs of saops , now using the smoothing constant choosen by the management of alpha is 0.30 , the manufacturer wants to forecast the 2012 demand using the exponential smoothing model , calculate the same .arrow_forwardFavors Distribution Company purchases small imported trinkets in bulk, packages them, and sells them to retail stores. They are conducting an inventory control study of all their items. The following data for the year 2006 are for one such item, which is not seasonal. Month Jan Feb Mar Apr May Jun Jul Aug Sales 15 18 14 12 19 10 11 15 Use trend projection to estimate the relationship between time and sales (state the trend line equation in this problem). Show the calculations of the intercept and the slope. Interpret the meaning of the intercept and the slope in this problem. Calculate forecasts for March 2007, May 2007, and June 2008arrow_forward
- 1. Favors Distribution Company purchases small imported trinkets in bulk, packages them, and sells them to retail stores. They are conducting an inventory control study of all their items. The following data for the year 2006 are for one such item, which is not seasonal. [10 Points] Month Sales Jan Feb 18 19 Mar Apr May Jun 17 21 20 19 Jul 20 Aug 23 a. Use trend projection to estimate the relationship between time and sales (state the trend line equation in this problem). b. Calculate forecasts for February 2007, April 2007, and February 2008arrow_forwardThe controller for McGarvey Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Month January February March May July August September October November December Purchasing Cost Intercept X variable 1 X variable 2 Required: $19,250 18,050 18,200 18,050 19,345 19,500 19,670 20,940 19,430 20,020 18,800 19,340 Number of Purchase Orders 370 330 320 410 400 450 460 560 440 600 470 480 Number of Nonstandard Orders 61 40 35 73 55 30 80 51 75 12 27 Multiple regression was run on the above data; the coefficients shown by the regression program are: 14,530 (rounded to the nearest dollar) 6.30 (rounded to the nearest cent) 16.8 (rounded to the nearest cent) 1.…arrow_forwardWhat advantages does adjusted exponential smoothing have over a linear trend line for forecasted demand that exhibits a trend?arrow_forward
- Year Sales 1) 123 2)118 3) 109 4) 112 5) 100 6) 110 7) 124 8)Determine the demand in Year 8 using a 3-month moving average using the sales table. Use weights of 0.40, 0.30 and 0.30arrow_forwardA cosmetics manufacturer's marketing department has developed a linear trend equation that can be used to predict annual sales of Its popular Hand & Foot Cream. Ft = 100,000 - 16.000t Where F₁ = Annual sales t is in years (Enter all answers as whole numbers.) a. Are annual sales increasing or decreasing? By how much? Annual sales are b. Predict annual sales for year 8 using the equation. Annual sales for year 8 bottles bottles per year.arrow_forwardD. Given the following data on the number of CitChat brand prepaid card (in units) that has been sold in the first eight months in a telecommunication shop in Jitra, Kedah: Bulan/Month Iualan/sales 785 2 600 3 578 4 590 5 770 6 805 7 710 8 900 Compute a 3-months moving average for the period from month 5 until 8 (of the next year).arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,