Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
The following data are the last three years of quarterly sales ($ thousands) for AmeriWeld. They are looking to
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps with 2 images
Knowledge Booster
Similar questions
- Getting mixed up with the correct formulas. TextBook shows different than on cheggarrow_forwardTwo independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:arrow_forwardGiven the following data of actual sales and forecast for the five months: Month 1, Month 2, Month 3, Month 4, Month 5, and Month 6: Month 1 2 3 4 5 6 Actual Sales 50 40 45 55 65 50 Forecast 55 50 (b) Calculate the Mean Square Error (MSE). (a) Calculate the Mean Absolute Percent Error (MAPE). 40 50° 65 40 (c) Calculate the Mean Absolute Deviation (MAD).arrow_forward
- It wouldnt let me take a screenshot of the table so I had to copy and paste it in here. My question is: How do you Calculate a moving average forecast using the last 2 and 4 dates of stay. What is the prediction for 7/1/2021 for each technique? Discussion Question 1 - 200 room hotel Forecasts MA 2 Errors MA 4 Errors ES (0.8) Errors ES (0.5) Errors Date Day of Week Rooms Sold MA 2 MA 4 ES (0.8) ES (0.5) AE APE AE APE AE APE AE APE 6/1/2021 Tuesday 123 6/2/2021 Wednesday 109 6/3/2021 Thursday 140 6/4/2021 Friday 199 6/5/2021 Saturday 179 6/6/2021 Sunday 140 6/7/2021 Monday 117 6/8/2021 Tuesday 132 6/9/2021 Wednesday 108 6/10/2021 Thursday 151…arrow_forwardwhat is the stregth of analyst forecast information for business decision making?arrow_forwardSuppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Sales (1,000s of gallons) Week 1 17 2 21 3 19 23 5 18 6 16 7 21 8 19 9 23 10 21 11 16 12 23 (a) Using a weight of - for the most recent observation, for the second most recent observation, and - for third most recent observation, compute a three-week weighted moving average for the time series. (Round your answers to two decimal places.) Time Series Value Weighted Moving Average Forecast Week 1. 17 2 21 19 4 23 5 18 6 16 7 21arrow_forward
- Effective capacity is: Multiple Choice a. also called theoretical capacity. b. base capacity plus time for maintenance, breaks, and absenteeism. c. the amount of capacity that can be used in planning for actual output. d. All of these choices are correct.arrow_forwardPlease answer this simple questionarrow_forwardThe current values of sales of a product in a company are as follows: November - 22, December - 35, January - 28, February - 20, March - 33, April - 20. What is the forecast for May using a mean mobile three months? Select one: a. twenty b. 25.25 c. 24.33 d. 26.33arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
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
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.