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 SUR 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.
See the other post.
Use an Excel worksheet to figure all these -- or whatever spreadsheet program you have been instructed to use.
To create a line-item budget table showing all associated costs implementing the training programs, we need to calculate the costs for each item and allocate them based on the given formula.
1. Line-Item Budget Table:
Category | Cost | Allocation | Basic Skills Program | Vocational Program
-------------------------|------------------|------------------|---------------------------|---------------------
Operating Expenses:
Rent | $125,000 | N/A | $75,000 | $50,000
Utilities | $100,000 | N/A | $60,000 | $40,000
Office Supplies | $25,000 | N/A | $15,000 | $10,000
Equipment/Lease | $50,000 | N/A | $30,000 | $20,000
Transportation/Travel | $100,000 | N/A | $60,000 | $40,000
Outside Consultants | $100,000 | N/A | $60,000 | $40,000
Overhead Costs | $100,000 | N/A | $60,000 | $40,000
Total Operating Expenses | $600,000 | N/A | $360,000 | $240,000
Personal Expenses:
Executive Director | $100,000 | N/A | $0 | $0
Training Supervisor | $80,000 | N/A | $0 | $0
Trainers | $50,000 | 60% | $30,000 | $20,000
Admin Coordinator | $45,000 | 60% | $27,000 | $18,000
Admin Staff | $25,000 | 60% | $15,000 | $10,000
Employee Benefits | $200,000 | 60% | $120,000 | $80,000
Total Personal Expenses | $500,000 | N/A | $192,000 | $128,000
Total Costs (Programs + Personal Expenses):
Basic Skills Program | $552,000
Vocational Program | $368,000
2. Combined Functional and Program Budget:
To calculate all costs per enrolled student, we need to divide the total costs by the number of eligible students (1,000).
Cost per Enrolled Student:
Basic Skills Program | $552,000 / 1,000 = $552
Vocational Program | $368,000 / 1,000 = $368
Therefore, the cost per enrolled student for the Basic Skills Program is $552, and for the Vocational Program is $368.