Question details

Hsm220 creating a budget
$ 10.00
Associate Level Material          
Appendix C                  
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. 
Available solutions