Operations Management CH 3 QUESTION 22 Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $0.5 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR QUANTITY (UNITS) QUARTER THIS YEAR QUANTITY (UNITS) I 12 I 16 II 18 II 24 III 26 III 28 IV 16 IV 18 a) Find a line using regression in Excel. Note: Round your answers to 3 decimal places. y = ________ + ________ t b)Find the trend and seasonal indexes. Note: Round your answers to 3 decimal places. Period Trend Forecast Seasonal Factors Last Year I Last Year II Last Year III Last Year IV This Year I This Year II This Year III This Year IV This is left blank This is left blank This is left blank c) Forecast sales for next year. Note: Round your answers to 2 decimal places. Period Forecast (Units) Next Year I Next Year II Next Year III Next Year IV Exhibit 3.10. (Yellow Graph)
Operations Management CH 3 QUESTION 22 Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $0.5 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR QUANTITY (UNITS) QUARTER THIS YEAR QUANTITY (UNITS) I 12 I 16 II 18 II 24 III 26 III 28 IV 16 IV 18 a) Find a line using regression in Excel. Note: Round your answers to 3 decimal places. y = ________ + ________ t b)Find the trend and seasonal indexes. Note: Round your answers to 3 decimal places. Period Trend Forecast Seasonal Factors Last Year I Last Year II Last Year III Last Year IV This Year I This Year II This Year III This Year IV This is left blank This is left blank This is left blank c) Forecast sales for next year. Note: Round your answers to 2 decimal places. Period Forecast (Units) Next Year I Next Year II Next Year III Next Year IV Exhibit 3.10. (Yellow Graph)
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 28P: The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present...
Related questions
Question
Operations Management CH 3
QUESTION 22
Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $0.5 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10.
QUARTER LAST YEAR | QUANTITY (UNITS) | QUARTER THIS YEAR | QUANTITY (UNITS) |
---|---|---|---|
I | 12 | I | 16 |
II | 18 | II | 24 |
III | 26 | III | 28 |
IV | 16 | IV | 18 |
a) Find a line using regression in Excel. Note: Round your answers to 3 decimal places.
y = | ________ | + | ________ | t |
b)Find the trend and seasonal indexes. Note: Round your answers to 3 decimal places.
Period | Trend |
Seasonal Factors | |
Last Year | I | ||
Last Year | II | ||
Last Year | III | ||
Last Year | IV | ||
This Year | I | ||
This Year | II | ||
This Year | III | ||
This Year | IV | ||
This | is | left | blank |
This | is | left | blank |
This | is | left | blank |
c) Forecast sales for next year. Note: Round your answers to 2 decimal places.
Period | Forecast (Units) | |
Next Year | I | |
Next Year | II | |
Next Year | III | |
Next Year | IV |
Exhibit 3.10. (Yellow Graph)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,