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 2.10, Problem 45P
Summary Introduction
To explain: The level of difference that would be required to make the series stationary.
Introduction: A statistical time series is one whose statistical characteristics are constant all the time, such as mean, variance, and autocorrelation. Most techniques of
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Note: Use manual computation not in excel
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:
LO
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.
Chapter 2 Solutions
Production and Operations Analysis, Seventh Edition
Ch. 2.4 - Prob. 1PCh. 2.4 - Prob. 2PCh. 2.4 - Prob. 3PCh. 2.4 - Prob. 4PCh. 2.4 - Prob. 5PCh. 2.4 - Prob. 6PCh. 2.4 - Prob. 7PCh. 2.4 - Prob. 8PCh. 2.4 - Prob. 9PCh. 2.6 - Prob. 10P
Ch. 2.6 - Prob. 11PCh. 2.6 - Prob. 12PCh. 2.6 - Prob. 13PCh. 2.6 - Prob. 14PCh. 2.6 - Prob. 15PCh. 2.7 - Prob. 16PCh. 2.7 - Prob. 17PCh. 2.7 - Prob. 18PCh. 2.7 - Prob. 19PCh. 2.7 - Prob. 20PCh. 2.7 - Prob. 21PCh. 2.7 - Prob. 22PCh. 2.7 - Prob. 23PCh. 2.7 - Prob. 24PCh. 2.7 - Prob. 25PCh. 2.7 - Prob. 26PCh. 2.7 - Prob. 27PCh. 2.8 - Prob. 28PCh. 2.8 - Prob. 29PCh. 2.8 - Prob. 30PCh. 2.8 - Prob. 31PCh. 2.8 - Prob. 32PCh. 2.9 - Prob. 33PCh. 2.9 - Prob. 34PCh. 2.9 - Prob. 35PCh. 2.9 - Prob. 36PCh. 2.9 - Prob. 37PCh. 2.10 - Prob. 38PCh. 2.10 - Prob. 42PCh. 2.10 - Prob. 43PCh. 2.10 - Prob. 44PCh. 2.10 - Prob. 45PCh. 2 - Prob. 47APCh. 2 - Prob. 48APCh. 2 - Prob. 49APCh. 2 - Prob. 50APCh. 2 - Prob. 51APCh. 2 - Prob. 52APCh. 2 - Prob. 53APCh. 2 - Prob. 54APCh. 2 - Prob. 55APCh. 2 - Prob. 56APCh. 2 - Prob. 57APCh. 2 - Prob. 58AP
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_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_forwardWhat advantages does adjusted exponential smoothing have over a linear trend line for forecasted demand that exhibits a trend?arrow_forward
- 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 α =…arrow_forwardPlease do not give solution in image format thankuarrow_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
- The 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_forwardsolve for MAD, SSE, MSE, and MSE. (Note: express all answers using 4 decimal places if applicable)arrow_forwardNeed both b and carrow_forward
- In 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_forwardGiven the following data on the number of pints of ice cream sold at a local ice cream store for a 3 period time fram, please forecast the demand for period 5 using a 3-month moving average. Period 1, 2,3,4 Demand 330,300,285,280arrow_forwardForecast error is calculated as: Actual - Forecast O Forecast - Actual (Forecast - Actual) ^ 2 Absolute (Actual - Forecast) (Actual - Forecast) ^ 2arrow_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