Question
Posted by:
ameliorator
ameliorator
Rating (114): A
Questions Asked: 38
Tutorials Posted: 713, earned $3,798.44
 

$15.00 HSM 220 Appendix C...Guaranteed Solution...Scored Full Points

Found in General-Questions: General-Academic-Questions
Chapter 11, # 11
Q:

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.

 


   
   
   
   
 
Tutorial
 

$15.00 HSM 220 Appendix C...Guaranteed Solution...Scored Full Points

  • This tutorial hasn't been purchased yet.
  • Posted on Nov 02, 2009 at 7:20:56PM
A:
Preview: ... ed Solution. ...

The full tutorial is about 7 words long plus attachments.

Attachments:
budget.xlsx (11K)
   
Join Now or Log In
Get Tutoring
Get Paid
Academic Honesty