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