hsm220

posted by .

I am having the worst time with this. Even after reading the material several times I a very lost. Any help would be great.
The Department of Education has awarded your agency with grant funding of $1.6 million to provide training programs to high school dropouts. The funded programs are a basic work skills training program and a vocational program. You are preparing a budget matrix to present to the awarding agency. The matrix budget consists of line-item, functional, and program budgets.

Operating Expenses: Per Year
Rent
$125,000

Utilities
$100,000

Office supplies
$25,000

Equipment/lease
$50,000

Transportation and travel
$100,000

Outside consultants
$100,000

Overhead costs
$100,000


Personnel expenses: Annual Salary Number of FTEs
Executive director
$100,000
1
Training supervisor
$80,000
1
Trainers
$50,000 10
Administrative coordinator
$45,000 1
Administrative staff
$25,000 3
Employee-related benefit expenses @ 25%
$200,000

All costs excluding the salary of the executive director and training supervisor will be allocated according to this formula:

60% to basic skills program
40% to vocational program

Number of eligible students: 1,000

Use the information above to create each of the following:

1. A line-item budget table showing all associated costs implementing the training programs.
2. A combined functional and program budget to calculate all costs per enrolled student.

  • hsm220 -

    IT seems to me to be straightforward. What is your question about it? Frankly, I would use a spreadsheet, is is so much easier with built in formulas.

  • hsm220 -

    No one here seems to be able to help with the question about this assignment LOL I have read several responses and the answers are either evasive or outright telling people we won't do your assignment...I am not looking for anyone to do my assignment but to help with understanding how to do it...if you are unable to help because you don't understand the material yourself then just don't respond...why make someone who is already struggling feel ignorant...which by the way all of us are ignorant about somethings!

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. HSM 220 Creating a Budget

    Need help with how to start this assignment, as I am not sure how to begin making my budgets (ex: line-item, functional and program budgets). Any assistance would be most appreciated. This is due Oct 12th. Creating a Budget Various …
  2. Creating a Budget -HSM 220

    Need help to complete assgnmnt for HSM 220 due Sunday 10/12 - will attach the Appendix C upon request, not enough room to post on site. Various budget approaches play an important role in resource allocation in human service org. The …
  3. Human Resourses

    The department of education has awarded an agency a grant for 1.6 million to provide training,programming for school drop outs. Prepare a budget matrix to help award the agency. The matrix budget consists of line-item and functional …
  4. Budget Matrix

    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 …
  5. ENGLISH

    You'll be alert, engrosed in the (14)material.And concentrated 100 percent. a) no change b) material, and c) material; and d) material and After reading it over and over, I think b) a comma after material would be the correct answer. …
  6. Accoubting

    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 …
  7. History

    Would this be considered a shortcoming for Rosa Parks?
  8. 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 …
  9. Human Resources

    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 …
  10. english

    I am trying to figure out details as to when groom service (short story) has taken place any help with examples would be great or even a lead?

More Similar Questions