college

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?

  1. 👍 0
  2. 👎 0
  3. 👁 95
  1. What is your college subject?

    How would you like us to help you with this assignment?

  2. what is an exponent

    1. 👍 0
    2. 👎 0
    posted by tanya
  3. 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?

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. Human Resources

    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

    asked by Jessie on December 1, 2012
  2. hsm260

    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

    asked by hopeless student on October 13, 2009
  3. college

    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

    asked by Shereka Sanders on August 20, 2010
  4. hhs 265 math accounting

    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

    asked by kristina on June 8, 2009
  5. Accounting

    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

    asked by Confused on May 21, 2009
  6. accounting

    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 Forecast total revenues for

    asked by Anonymous on April 25, 2010
  7. adult education

    you are a CEO at a human service Agency, who just took over another small human service agency. Now convince the board of directors why you need a new mission statement

    asked by importance of writing a new mission statement after taking over a small human service agency on March 20, 2010
  8. human services

    2. CheckPoint: Researching Human Service Agencies One of the best ways to learn about how various human service organizations meet human needs is to research and study agencies within your city or state. Resources: Appendixes B,

    asked by shardae on April 23, 2009
  9. Accounting

    Write a 200- to 300-word response to the following: Why are cost per output and cost per outcome calculations valuable to a human service agency? This is what I have so far can someone help me meet the maximum word

    asked by Jess on January 4, 2008
  10. Human Services

    Creating a Budget Various budget approaches play an important role in resource allocation in human service organizations. You are the executive director for a local government workforce agency that focuses on providing career- and

    asked by Angel on February 1, 2012

More Similar Questions