Forecasting personnel expenses

Assignment Help Business Management
Reference no: EM1376670

The following information represent total personnel costs for Palmdale Human Service Agency for last 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?

 

Reference no: EM1376670

Questions Cloud

Constitutional right to pray in public school : Suppose you have a constitutional right to pray in public school? What constitutional amendments guarantee you those rights and are the basis of recent year United States Supreme Court decision?
Obtain remainder from overtime : Which of subsequent production plans is better: Plan A-chase demand by hiring also firing; or Plan B-make at a constant rate of 1200 also obtain remainder from overtime.
Determine economic run quantity : Firm operates 220 days a year also uses couplings at a steady rate of 50 per day. Couplings can be marked at a rate of 200 per day. Annual storage cost is $2 per coupling; also machine setup cost is $70 per run. Determine economic run quantity.
What is becky''s bad debt deduction for 2012 : the bankruptcy proceedings are closed, and creditors receive 10 percent of the amount due on the debt. What is Becky's bad debt deduction for 2012? For 2013?
Forecasting personnel expenses : The following information represent total personnel costs for Palmdale Human Service Agency for last four fiscal years:
Determine economic run quantity : Coupling can be marked at a rate of 200 per day. Annual storage cost is $2 per coupling also machine cost is $70 per run. Determine economic run quantity.
Find the discounting of note receivable : Find the accrued interest earned and find the discounting of note receivable.
Create the entry to record the year-end adjusting entry : Create the entry to record the year-end adjusting entry for predictable returns and evaluate the amount of the year-end allowance for sales returns after adjusting entry is recorded?
Compute optimal quantity also total annual cost of ordering : Ordering costs are $ 35 also annual carrying costs are 20 percent of purchase price. Compute optimal quantity also total annual cost of ordering also carrying inventory.

Reviews

Write a Review

Business Management Questions & Answers

  Did the wentzes do under the contract

Did the Wentzes do under the contract Did the court find exact performance to be an adequate legal remedy in this case Why did the court waste to help Campbell in enforcing its legal contract

  Assume that the price of asset x at close of trading

Assume that the price of Asset X at close of trading yesterday was $300 and its volatility was estimated as 1.3% per day

  Sustainable business and waste management technologies

What criteria do you think are the most important in this prioritization of preference? Do you think this order of preference is correct and if not what would you change?

  Impact costs of doing business in foreign markets

Show how culture, language, and religion might influence the costs of doing business in a particular country. Support your statement with examples.

  Schematic or flowchart of incorporate teams in daily health

As the project manager, you are tasked with educating the staff and informing the public regarding this new technology. Create a schematic or flowchart to illustrate how to incorporate teams into daily health care communication for the issue descr..

  Client capabilities and commitment

Credibility and influence are vital components for success as a performance consultant as well as successful completion of any consulting project. Use the "Client Capabilities and Commitment" Assessment on p. 97 - 98 in the Field Book.

  Show how can an employee be motivated by quality awareness

How can an employee be motivated by quality awareness and how does the free flow of information impact team effectiveness?

  Earnings based on location and benefits

Determine how helpful this Website might be to employers and the type of data that could be used to increase the fairness of compensation practices.

  Show the challenges of conflict

Show the Challenges of Conflict - What is the most valuable lesson about conflict and why it so important?

  Failed business partnership project

What are the similarities and differences between project and program management? Provide examples.

  Explain linear and non linear trend patterns

Linear increasing trend, nonlinear increasing trend and nonlinear decreasing trend. Which ones are easiest to forecast?

  Who loves pixar as well as dreamworks digital animation

Who loves Classic Disney? Who loves Pixar as well as DreamWorks digital animation? Who loves one type more than another? Why? What stands out about one that the other can't capture? If you favour digital to classic hand drawn (or vice-versa) tell ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd