{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This 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:
Image of page 1

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

View Full Document Right Arrow Icon
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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern