Purchase Solution

Forecasting for Palmdale Human Service Agency

Not what you're looking for?

Ask Custom Question

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

Forecast personnel expenses for fiscal year 20X5 using moving averages, weighted moving averages, exponential smoothing, and time series regression. For moving averages and weighted moving averages, use only the data for the past three fiscal years. For weighted moving averages, assign a value of 1 to the data for 20X2, a value of 2 to the data for 20X3, and a value of 3 to the data for 20X4. For exponential
smoothing, assume that the last forecast for fiscal year 20X4 was $6,300,000. You decide on the alpha to be used for exponential smoothing. For time series regression, use the data for all four fiscal years. Which forecast will you use? Why?

I have completed the simple moving average, weighted moving average, exponential smoothing. I need help with is Time Series Regression.
Which forecast will you use and why. I attatched the reading material just in case I also attached the work I have completed so far.

Attachments
Purchase this Solution
Solution Summary

This posting provides forecast of personal expenses for Palmdale Human Service Agency using moving averages, weighted moving averages, exponential smoothing and time series regression.

Purchase this Solution
Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

View More Free Quizzes
Related BrainMass Solutions

  • Forecast personnel expenses for year 20X5

    Forecast personnel expenses for year 20X5 for Palmdale Human Service Agency. The solution is calculated in an Excel file.

  • Issues for a Human Service Agency

    162452 Issues for a Human Service Agency The most important issues for a human service agency to address are direct and indirect costs, depreciation and use allowance, unallowable costs, profit margins, fixed and variable costs, break-even points, market

  • Fund-raising

    With the help of this method, individuals can express their gratitude towards a human service agency for the services received by them and their dear ones (Martin, 2001).

  • Agency: Cultural Competence

    Via cultural competence, Human Services as a social agency can reduce disparity in terms and can yield payoffs via quality of service improvement.

  • Hypothesis Test on Correlation and Regression Analysis

    115306 Hypothesis Test on Correlation and Regression Analysis Palmdale Permits Population 2003 946 127,585 2004 1366 131,295 2005 1536 134,570 2006 1190 141,012 Total Permits: 5,038 Ho: p=0

  • Benifits of Human resource planning software

    This would also help the organization in advanced analysis and forecasting ?

  • matching demand with capacity and capability

    encouraged. 2) Compare and contrast the differences in forecasting demand for a product versus a service.

  • Evaluating Family-Oriented Service for Alcoholics

    292329 Evaluating Family-Oriented Service for Alcoholics You are a staff member of a human service agency serving alcoholics. Previously, each alcoholic client was seen on an individual basis.

  • Need help with writing a good paper

    Another area to think about would be risk management practices within a human service agency. One practice within a human service agency risk management process that needs to be addressed is disaster planning.

View More Related Solutions