Hsm/260 Week 5 Checkpoint

Topics: Moving average Pages: 2 (376 words) Published: January 25, 2013
Exercise 9.1

The following data represent total 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

Moving Averages
20X2-X4$18,250,000 / 3 = $6,083,333

Weighted Moving Averages
Fiscal YearExpensesWeightWeighted Score
20X2$5,500,0001$5,500,000
20X3 $6,000,0002$12,000,000
20X4 $6,750,0003$20,250,000
__ ___________
6$37,750,000
20X5$37,750,000 /6 = $6,291,667

Exponential Smoothing
NF = $6,300,000 + 0.95($6,750,000 - $6,300,000)
= $6,300,000 + 0.95(45,000)
= $6,300,000 + (42,750)
= $6,342,750

I would rather use moving averages, weighted moving averages, or exponential smoothing because I can better understand how the formulas and numbers turn out and how you get the answers from them. Even though the Time regression is supposed to be easier you are still putting a lot of faith in a computer. Plus I really had a hard time understanding it.

Exercise 9.3

The following data represent total revenues (from all sources) for the Palmdale Human Service Agency for the past four fiscal years:

20X1 $15,000,000
20X2 $14,250,000
20X3 $14,000,000
20X4 $13,500,000

Moving Averages
20X2-X4$41,750,000 / 3 = $13,916,667

Weighted Moving Averages
Fiscal YearExpensesWeightWeighted Score
20X2 $14,250,0001$14,250,000
20X3 $14,000,0002$28,000,000
20X4 $13,500,0003$40,500,000
__ ___________
6 $82,750,000
20X5 $82,750,000/6 = $13,791,667

Exponential Smoothing
NF = $13,000,000 + 0.95($13,500,000 - $13,000,000)
= $13,000,000 + 0.95(500,000)
= $13,000,000 + (475,000)
= $13,475,000

I would rather use moving averages, weighted moving averages, or exponential smoothing because I can better understand how the formulas and numbers turn out and how you get...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Week 8 HSM 260 Foundation Paper
  • Hsm 260 Week 6 Essay
  • hsm 260 week 8 checkpoint Essay
  • Hsm/260 Week 4 Checkpoint Essay
  • Essay on Hsm 230 Week 5 Checkpoint
  • Week 5 Checkpoint Essay
  • Essay about It/205 Week 5 Checkpoint
  • Essay on Hsm/260 Week 8 Assignment

Become a StudyMode Member

Sign Up - It's Free