**Question 12**A company has experienced the following quarterly sales for the past eight quarters.| Quarter (Year 1) | Demand ||------------------|--------|| 1 | 10 || 2 | 22 || 3 | 26 || 4 | 19 || Quarter (Year 2) | Demand ||------------------|--------|| 1 | 5 || 2 | 7 || 3 | 8 || 4 | 4 |Forecasting demand for the next four periods requires using a given set of statistical coefficients:- Intercept (c): 52.38- Seasonal factors: S1 = 2.39, S2 = 3.05, S3 = 0.24, S4 = 1.25- Smoothing constants: - α = 0.2 - β = 0.3 - γ = 0.2- Lag factors: d = 12- Additional constants: - c1 = 20.14 - c2 = 30.00 - c3 = 2.00Forecast the four-period ahead demand at time t=0, where t-0 is the present (period 8).

Answered: Image /qna-images/answer/0c43953c-b17c-4c2b-ae84-413730a777c1.jpg

Answered: QUESTION 12 A company has experienced…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Please do not give solution in image format thanku
DETERMINE I) the adjusted seasonal indexes ofautumn: II) the de-seasonalised of period 1: III) the de-seasonalised of period 16:
The owner of Leisure Boutique in a local mall is reviewing their forecasting model for errors. Month Actual Forecasted March 64 63 April 66 67 May 70 71 June 78 75 July 80 79 August 84 83 September 92 87 October 94 91 What is the cumulative forecast error? Group of answer choices a) -16 b) 16 c) 12 d) -12
A marketing analyst wants to examine the relationship between sales (in $1,000s) and advertising (in $100s) for firms in the food and beverage Industry and collects monthly data for 25 firms. He estimates the model Sales-o Advertising. The following ANOVA table shows a portion of the regression results. Regression Residual df 1 23 55 78.53 504.02 MS 78.53 21.91 T 3.58
4) A small manufacturing firm has recorded a time series of the cost per unit for the firm's leading product over the past eight years. Year Cost/Unit($) 1 2 3 4 5 6 7 8 20 24.5 28.2 27.5 26.6 30 31 36 a) If you are not given a base value or trend, what would be the forecast for the year 10 made at the end of year 8 (a=0.2, ß=0.4). b) Forecast for the year 9 using 1) 5-month weighted average using 0.1,0.1,0.1,0.2,0.3, with the heaviest weight applied to the recent month 2) Exponential smoothing using a =0.2 and forecast of 21 for year 5 3) If a value was not provided in the question above, what value of a would you choose?
Font Paragraph Styles Question 3 Consider the following from an estate agent's business nationally: Month Houses Sold Jan Feb Mar 380 360 390 Apr May June July Aug Sep Oct 400 390 380 394 454 460 460 Nov Dec 430 370 a) Calculate the three point moving averages (quarters) and seasonal variation for the above data b) Define moving averages and how they're useful in forecasting (use Harvard referencing) c) At races, your horse, White Rum, has a probability of 1/20 of coming 1st, 1/10 of coming 2nd and a probability of 4 in coming 3rd. First place pays $5,000 to the winner, second place $4,000 and third place $1,350. Hence, is it worth entering the race if it costs $1050?
Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $14.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR I II III IV QUANTITY (UNITS) Y = 14 20 28 18 QUARTER THIS YEAR I II III IV QUANTITY (UNITS) 20 26 30 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) > Answer is complete but not entirely correct. 18.535 X + 0.630 t
A firm finds that it sold 150 units in January, 160 in February, and 170 in March. What is the forecast of April in case the firm uses 3-month moving average? a. 150 b. 155 c. 160 d. 170
Quarter 1 2 31 11 14 172 20 23 263 29 32 354 38 41 44Compute seasonal relatives for this quarterly data.a. Use the SA method.
Use the following data to determine the tracking signal for period 4. Actual Forecast 10 16 23 16 50 49 63 59 108 106 122 118 a. 1.333 b. 1.108 c. 0.742 d. 0.429
QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 72.4 Q2 85.3 Q3 109.6 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,506 Time 71.3 If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)
Given the following historical data, what is the simple three-period moving average forecast for period 6? Period 1 2 3 4 5 67.67 68.2 67.3 68.4 Value 73 66 64 73 66

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS