HSM 220 Creating a Budget

posted by .

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 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 work-related skills. 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.

  • HSM 220 Creating a Budget -

    I NEED HELP

  • HSM 220 Creating a Budget -

    I had problems too, but somehow figured it out. Take the first amount, such as the rent at $125,000. Multiply 60% times the 125,000 for the basic skills and multiply 40% times the 125,000 for the vocational. Therefore 75,000 for basic, and 50,000 for vocational. Do this for all the totals and write up on an excell spreadsheet and you'll be good to go. Good luck!!!

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. HHS-human service administrator

    This is my assignment for my HHS class. I have already completed an assignment and some reading regarding budgets, but I'm not quite grasping the idea of everything. I'd like any advice or information you could give me to better understand …
  2. budgets

    What is the difference between line-item, functional and program budgets?
  3. budject matrix

    you are the medical clinic administrator for three physicians group clinic and you are preparing a budget matrix to be presented to the physicians. The matrix budget consists of line-item, functional, and program budgets pls explain?
  4. 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 …
  5. Hospital Administration

    How to Prepare Budget Matrix that consists of line-item, functional, and program budgets
  6. Accounting

    I am attempting to complete a budget matrix. Is a consultant listed as a functional budget item or a line-item budget?
  7. HSM 220 Week 6 Budget Matrix

    I am having some help with this assignment. I have filled it in with what I think is correct but am not positive with my answers. Can someone please help me?
  8. Hsm/220

    You are the executive director of a local government workforce agency that focuses on developing training skills for high school dropouts. Determine which of the budget items listed would be necessary in order to calculate a functional, …
  9. HSM 220

    I need help understanding the categorization of line-item budgets, program budgets, and functional budgets matrix for an organization?
  10. HSM 220 Budget Matrix

    I am so confused on this assignment in HSM/220(Budget Matrix-Appendix B) and wondering if I am even close to being correct on showing where to place the X's for a Functional Budget,Line-item Budget & Total Program Budget) before I …

More Similar Questions