Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept.  ii. Use that formula to forecast television sales for years 11 and 12.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.6: Moving Averages Models
Problem 20P: The file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year...
icon
Related questions
Question

b. The following table shows the number of televisions sold over the last ten years at a
local electronic store.
YEAR TV SALES
1 150
2 300
3 480
4 600
5 630
6 640
7 700
8 825
9 900
10 980
i. Using trend projection, develop a formula to predict sales for years 11 and 12. You
have to show all working. You will need to develop a table to calculate the slope and
the intercept. 


ii. Use that formula to forecast television sales for years 11 and 12.

 

Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Process strategy
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning