(cont'd) Creating a Budget - HSM 220
posted by Lucille .
RENT Per Year $125,000
UTILITIES Per Year $100,000
OFFICE SUPPLIES Per Year $25,000
OUTSIDE CONSULTANTS $100,000
OVERHEAD COSTS $100,000
EXEC DIRECTOR Annl Sal $100,000 1-FTEs
TRAINING SUPERVSR Sal $80,000 1-FTEs
TRAINERS Annl Sal $50,000 10-FTEs
ADMIN COORD Annl Sal $45,000 1-FTEs
ADMIN STAFF Annl Sal $25,000 3-FTEs
expenses @ 25% Sal $200,000 0-FTEs
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.
See the other post.
Use an Excel worksheet to figure all these -- or whatever spreadsheet program you have been instructed to use.