The following are sales revenues for a large utility company for years 1 through 11. Forecast revenue for years 12 through 15. B
ecause
we are forecasting four years into the future, you will need to use linear regression as your forecasting method. (Enter your answers in
millions.)
YEAR
01 OUA
REVENUE (MILLIONS)
$4,869.
5,069.9
5,522.7
5,734.3
5,503.6
5.195.1
$5, 101.3
5,107.0
5. 552.3
5,744.8
5,863.0
Forecast
Period
12
13
15
we are forecasting four years into the future, you will need to use linear regression as your forecasting method. (Enter your answers in
millions.)
YEAR
01 OUA
REVENUE (MILLIONS)
$4,869.
5,069.9
5,522.7
5,734.3
5,503.6
5.195.1
$5, 101.3
5,107.0
5. 552.3
5,744.8
5,863.0
Forecast
Period
12
13
15
1 answer:
You might be interested in
Answer:
Job 301 $ 11,000
Job 302 $ 16,500
Job 303 $ 22,000
Explanation:
To calculate the overhead rate <u>we divide the estimated overhead cost by the estimated cost driver:</u>
0.55 overhead rate
Job 301 $20,000 labor cost x 0.55 overhead rate
11,000
Job 302 $30,000 labor cost x 0.55 overhead rate
16,500
Job 303 $40,000 labor cost x 0.55 overhead rate
22,000