Forecasting+ - 20X1 $15,000,000 20X2 $14,250,000 20X3...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Check Point: Forecasting Exercise 9.1 Personnel expenses for the Palmdale Human Service Agency for past four fiscal years: 20x1 $5,250,000 20x2 $5,500,000 20x3 $6,000,000 20x4 $6,750,000 Using moving averages method the forecast for fiscal year 20x5 is as follows: Fiscal Year 20x2 $5,500,000 20x3 $6,000,000 + 20x4 $6,750,000 $18,250,000 $18,250,000 ÷ 3 = $6,083,330 So the personnel expenses forecast for 20x5 is $6,083,330 Using the weighted moving averages the forecast for fiscal year 20x5 is as follows: Fiscal Year Weight 20x2 $5,500,000 1 20x3 $12,000,000 2 + 20x4 $20,250,000 +3 $37,750,000 6 $37,750,000 ÷ 6 = $6,291,670 So the personnel expenses forecast for 20x5 is $6,291,670 Exercise 9.3 Total revenues for the Palmdale Human Service Agency for the past four fiscal years:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 20X1 $15,000,000 20X2 $14,250,000 20X3 $14,000,000 20X4 $13,500,000 Using moving averages method the forecast for fiscal year 20x5 is as follows: Fiscal Year 20x2 $14,250,000 20x3 $14,000,000 + 20x4 $13,500,000 $41,750,000 $41,750,000 3 = $13,916,670 So the total revenue forecast for 20x5 is $13,916,670 Using the weighted moving averages the forecast for fiscal year 20x5 is as follows: Fiscal Year Weight 20x2 $14,250,000 1 20x3 $28,000,000 2 + 20x4 $40,500,000 + 3 $82,750,000 6 $82,750,000 6 = $13,791,670 So the total revenue forecast for 20x5 is $13,791,670...
View Full Document

This note was uploaded on 11/28/2010 for the course A a taught by Professor A during the Spring '09 term at Punjab Engineering College.

Page1 / 2

Forecasting+ - 20X1 $15,000,000 20X2 $14,250,000 20X3...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online