Question

Operating Expenses
RENT Per Year $125,000
UTILITIES Per Year $100,000
OFFICE SUPPLIES Per Year $25,000
EQUIP/LEASE $50,000
TRANSPTN/TRAVEL $100,000
OUTSIDE CONSULTANTS $100,000
OVERHEAD COSTS $100,000

Peronal Expenses
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
Employee-benefit
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.

Answer 1

See the other post.

Use an Excel worksheet to figure all these -- or whatever spreadsheet program you have been instructed to use.