Answer:
1st quarter := 2488.23
2nd quarter = 1646.50
3rd quarter = 1893.98
4th quarter = 1152.93
Step-by-step explanation:
Forecast demand in the next four quarters
intercept ( a ) = 3116.67 - (- 168.25 * 6.5 ) = 4210.29
Slope ( b ) = ( 219041.15 ) - ( 12 * 6.5 * 3,116.67 ) / 650 - ( 12 * ( 6.5)^2 )
= -24059.11 / 143 = -168.25
Forecast demand = a + bt = 4210.29 + 168.25t
1st quarter := 2488.23
2nd quarter = 1646.50
3rd quarter = 1893.98
4th quarter = 1152.93
Values calculated using data from table attached below ( table 2 )
