Allocate Resources

Ajaniopii
BudgetDocument.xlsx

Budget for This Year

INCOME
Weekly Tuition Number Week Annual
Toddler Program (ages 1–3 years) $180.00 12 $2,160.00 $112,320.00
Preschool Program (ages 3–4 years) $160.00 16 $2,560.00 $133,120.00
Pre–K Program (ages 4–5 years) $150.00 72 $10,800.00 $561,600.00
Total Enrollment 100
Total Tuition Income $807,040.00
Other Income
Initial Enrollment Fee ($150.00) 30 $4,500.00
Grants $5,000.00
Fundraising Activities $4,000.00
Total Other Income $13,500.00
Estimated 1% Vacancy Rate -$8,070.40
TOTAL INCOME $812,469.60
EXPENSES
Salaries
Director $42,000.00
Assistant Director $33,000.00
Administrative Assistant $27,000.00
Lead Caretakers (8 @ $24,000) $192,000.00
Full Time Assistant Caretakers (7 @ $20,000) $140,000.00
Part Time Assistant Caretakers (6 @ $15,000) $90,000.00
Substitutes $8,000.00
Full Time Custodian (@ $10.00/hr.) $20,800.00
Full Food Service Worker (@ $9.00/hr.) $18,720.00
Total Salaries $571,520.00
Benefits (Estimated @30%) $171,456.00
Total Personnel Cost $742,976.00
Other Expenses
Rent and Utilities $24,000.00
Food $20,000.00
Equipment $10,000.00
Curriculum Supplies $8,500.00
Insurance $3,000.00
Total Other Expenses $65,500.00
TOTAL EXPENSES $808,476.00
BALANCE $3,993.60

Budget for Next Year

INCOME
Weekly Tuition Number of Children Enrolled Week Annual
Toddler Program (ages 1–3 years) X 20 ERROR:#VALUE! ERROR:#VALUE!
Preschool Program (ages 3–4 years) Y 25 ERROR:#VALUE! ERROR:#VALUE!
Pre-K Program (ages 4–5 years) Z 80 ERROR:#VALUE! ERROR:#VALUE!
Total Enrollment 125
Total Tuition Income ERROR:#VALUE!
Other Income
Initial Enrollment Fee ($100) 31 $3,125.00
USDA Food Subsidy $12,000.00
Grants $5,000.00
Fundraising Activities $6,000.00
Total Other Income $26,125.00
Estimated 1% Vacancy Rate ERROR:#VALUE!
TOTAL INCOME ERROR:#VALUE!
EXPENSES
Salaries 
Director $45,000.00
Assistant Director $35,000.00
Administrative Assistant $27,000.00
Full Time Lead Caretakers (10 @ $27,000) $270,000.00
Full Time Assistant Caretakers (9 @ $23,000)—Including 2 Floaters $207,000.00
Part Time Assistant Caretakers (6 @ $16,000)—Including 1 floater $96,000.00
Substitutes $9,000.00
Custodial Contractor $12,000.00
Full Time Food Service Worker (@ $9.00/hr.) $18,720.00
Total Salaries $719,720.00
Benefits (Estimated @30%) $215,916.00
Total Personnel Cost $935,636.00
Other Expenses 
Rent and Utilities $42,000.00
Food $35,000.00
Outdoor Play Area $25,000.00
Facility Maintenance and Beautification $16,000.00
Equipment $15,000.00
Supplies $12,000.00
Insurance $5,000.00
Total Other Expenses $150,000.00
TOTAL EXPENSES $1,085,636.00
BALANCE ERROR:#VALUE!

Sheet3