Allocate Resources

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

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!