Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Tucson Machinery, Inc., 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 18.10. LAST YEAR QUANTITY (UNITS) THIS YEAR QUANTITY (UNITS) QUARTER QUARTER I 11 I 16 II 17 II 23 III 25 III 27 IV 15 IV 18 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) Y = t b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Period Trend Forecast Seasonal Factors Last Year III IV This Year II IV

Tucson Machinery, Inc., 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 18.10. LAST YEAR QUANTITY (UNITS) THIS YEAR QUANTITY (UNITS) QUARTER QUARTER I 11 I 16 II 17 II 23 III 25 III 27 IV 15 IV 18 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) Y = t b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Period Trend Forecast Seasonal Factors Last Year III IV This Year II IV

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.3: Simple Regression Models
Problem 9P
See similar textbooks
icon
Related questions
Question
c. Forecast sales for next year using the above seasonal factors. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Period Forecast (Units) Next Year II iv
Transcribed Image Text:c. Forecast sales for next year using the above seasonal factors. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Period Forecast (Units) Next Year II iv
Tucson Machinery, Inc., 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 18.10. LAST YEAR THIS YEAR QUANTITY (UNITS) QUANTITY QUARTER (UNITS) QUARTER I 11 I 16 II 17 II 23 III 25 III 27 IV 15 IV 18 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) Y = b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Period Trend Forecast Seasonal Factors Last Year II IV This Year II III IV
Transcribed Image Text:Tucson Machinery, Inc., 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 18.10. LAST YEAR THIS YEAR QUANTITY (UNITS) QUANTITY QUARTER (UNITS) QUARTER I 11 I 16 II 17 II 23 III 25 III 27 IV 15 IV 18 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) Y = b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Period Trend Forecast Seasonal Factors Last Year II IV This Year II III IV
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer