Production and Operations Analysis, Seventh Edition
7th Edition
ISBN: 9781478623069
Author: Steven Nahmias, Tava Lennon Olsen
Publisher: Waveland Press, Inc.
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 5, Problem 38AP
a
Summary Introduction
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
Summary Introduction
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
Summary Introduction
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
Summary Introduction
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).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Tucson Machinery, Inc., manufactures numerically controlled machines (NCM), which sell for an average
price of $12 million each. Sales for these NCMs for the past two years were as follows:
Quantity (units)
Quantity (units)
Quarter
Last year
|||
III
IV
12
18
20
24
Quarter
This year
|
||
|||
IV
20
24
28
32
Find the equation of a simple linear regression line using Excel, in the format of Y=a+bX. Keep two decimals of a and b.
Forecast the first quarter sales for next year. Keep two decimals.
National Scan, Incorporated, sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:
Month
Sales (000) Units
February
13
March
21
April
19
May
23
June
20
July
26
August
25
The naive approach.
=25 Thousand
A five-month moving average.
=22.60 Thousands
A weighted average using 0.60 for August, 0.15 for July, and 0.25 for June.
=23.90 thousands
Exponential smoothing with a smoothing constant equal to 0.15, assuming a March forecast of 16(000). -- round 2 decemial places
need help
A linear trend equation.--round 2 decemial places
need help
Please do not give solution in image format thanku
Chapter 5 Solutions
Production and Operations Analysis, Seventh Edition
Ch. 5.2 - Prob. 1PCh. 5.2 - Prob. 2PCh. 5.2 - Prob. 4PCh. 5.3 - Prob. 7PCh. 5.3 - Prob. 9PCh. 5.3 - Prob. 12PCh. 5.5 - Prob. 16PCh. 5.5 - Prob. 18PCh. 5.6 - Prob. 21PCh. 5.7 - Prob. 24P
Ch. 5.7 - Prob. 25PCh. 5.7 - Prob. 26PCh. 5.7 - Prob. 27PCh. 5 - Prob. 28APCh. 5 - Prob. 31APCh. 5 - Prob. 32APCh. 5 - Prob. 33APCh. 5 - Prob. 37APCh. 5 - Prob. 38APCh. 5 - Prob. 40APCh. 5 - Prob. 41APCh. 5 - Prob. 43APCh. 5 - Prob. 44APCh. 5 - Prob. 45APCh. 5 - Prob. 46APCh. 5 - Prob. 47APCh. 5 - Prob. 48APCh. 5 - Prob. 49APCh. 5 - Prob. 50APCh. 5 - 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_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
- solve for MAD, SSE, MSE, and MSE. (Note: express all answers using 4 decimal places if applicable)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_forward1. 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_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_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_forwardPlease do not give solution in image format thankuarrow_forward
- The 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_forwardThe fo llowing a re monthly actual and forecastdemand levels for May through December for units of a productmanufactured by the D. Bishop Company in Des Moines: What is the value of the tracking signal as of the end of December?arrow_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
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