OBM (Obsolete Business Machines) Inc. wants to forecast 2017’s demand for manual typewriters based on the following historical data:
YEAR | DEMAND (x1000) |
2013 | 100 |
2014 | 80 |
2015 | 55 |
2016 | 40 |
What is OBM’s forecast for 2017 using a linear trend equation?
Expert Answer
Answer
1)
Linear trend y = a+bx
a = intercept
b = slope
x = time period
y = forecast for demand for period x
n = no of peiods
= the mean of the x values
= the mean of the y values
Slope b
Slope b = -20.5
Intercept a
a = 120
Y = 120 -20.5x
2017 forecast(x=5) = 120-(20.5*5) = 17.5(thousands)
2017 forecast = 17,500