Practical Management Science
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
Bartleby Related Questions Icon

Related questions

Question

The following data are the last three years of quarterly sales ($ thousands) for AmeriWeld. They are looking to forecast their sales for the upcoming year, 2021.

Quarter t Sales $ thousands (y)
2018 Q1 1 15
Q2 2 14
Q3 3 13
Q4 4 37
2019 Q1 5 54
Q2 6 34
Q3 7 67
Q4 8 73
2020 Q1 9 77
Q2 10 62
Q3 11 94
Q4 12 101

 

a. Determine the regression equation. (Round to 2 decimal places.)

Regression equation: ŷ = ______  + ______  t

 

b. Determine the specific index for each quarter. (Indexes should be in decimal form (e.g. 1.36 not 136). Rounded to 2 decimal places.)

 

Quarter Quarterly Index
Q1  
Q2  
Q3  
Q4  

 

c. What are the estimated sales (forecast) for the next four quarters?  (Values in $thousands. Round to 2 decimal places.)

 

Quarter Forecasted Sales
2021-1  
2021-2  
2021-3  
2021-3  
 
 
 
 
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Text book image
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Text book image
Business in Action
Operations Management
ISBN:9780135198100
Author:BOVEE
Publisher:PEARSON CO
Text book image
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
Text book image
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.