MARICOPA 10-5-2023 ATTACHMENT 1E 24-7 OPERATING BUDGET.PDF

Attachment B Sections (D.)
Month/Year
3
4
5
6
7
8
9
10
11
12
1
2
FY1
FY2
FY3
FY4
Notes
Enrollment and Capacity
Classrooms
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
Center Capacity
156
156
156
156
156
156
156
156
156
156
156
156
156
156
156
156
Avg. Weekly Student FTEs
85
86
87
88
89
90
91
92
93
93
93
93
90
109
125
133
Occupancy
54.5%
55.1%
55.8%
56.4%
57.1%
57.7%
58.3%
59.0%
59.6%
59.6%
59.6%
59.6%
57.7%
69.8%
79.8%
85.0%
Average Rates
Average Tuition Rate
$168
$168
$168
$168
$168
$168
$168
$168
$168
$168
$168
$168
$168
$173
$178
$178
REVENUE
Total Tuition
$143,144
$115,185
$115,856
$145,658
$117,197
$117,867
$148,172
$119,208
$119,879
$149,848
$119,879
$119,879
$1,531,770
$1,818,179
$2,089,678
$2,264,808
Fees
$303
$244
$246
$309
$248
$250
$314
$253
$254
$318
$254
$803
$3,797
$3,743
$4,176
$4,396
Registration/Enrollment
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
• Annual Registration fees ($150 per student)
LA Program Revenue
$303
$244
$246
$309
$248
$250
$314
$253
$254
$318
$254
$803
$3,797
$3,743
$4,176
$4,396
• Additional Learning Adventures program revenue (STEAM) classes
Discounts
($3,455)
($2,866)
($2,882)
($3,515)
($2,916)
($2,932)
($3,576)
($2,966)
($2,982)
($3,616)
($2,982)
($2,982)
($37,672)
($44,530)
($50,972)
($55,031)
Staff Discount
($2,756)
($2,218)
($2,231)
($2,804)
($2,256)
($2,269)
($2,853)
($2,295)
($2,308)
($2,885)
($2,308)
($2,308)
($29,492)
($35,004)
($40,229)
($43,598)
• KCE Teachers receive discounted tuition for their children
Family Discount
($272)
($219)
($220)
($276)
($222)
($224)
($281)
($226)
($227)
($284)
($227)
($227)
($2,906)
($3,449)
($3,964)
($4,296)
• Families with multiple enrolled children receive a discount on tuition
Management Discretionary Discoun
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
• Center Director and District Leader have the ability to provide discretionary discounts to families
ACH Discounts
($427)
($430)
($432)
($435)
($437)
($440)
($442)
($445)
($447)
($447)
($447)
($447)
($5,274)
($6,077)
($6,779)
($7,137)
• Families paying by credit card get a discount
Subsidy Tuition
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
• The remainder of revenue lost after state subsidy reimbursement + parent co-pay
Net Revenue
$139,992
$112,564
$113,219
$142,451
$114,529
$115,185
$144,910
$116,495
$117,150
$146,550
$117,150
$117,699
$1,497,895
$1,777,392
$2,042,882
$2,214,173
SALARIES & BENEFITS
Direct Salaries, net of PTO
$227,236
$184,397
$184,680
$231,204
$185,246
$186,167
$233,062
$186,733
$187,016
$233,770
$187,016
$187,288
$2,413,814
$2,596,497
$2,792,461
$2,932,248
Management & Admin Salaries
$19,344
$14,875
$15,527
$19,344
$15,475
$15,527
$19,344
$15,475
$15,527
$18,594
$15,475
$15,788
$200,296
$206,036
$212,217
$218,583
• Center Director Salary, Net PTO
Childcare Salaries
$191,693
$147,678
$154,423
$192,737
$154,468
$155,261
$193,782
$155,304
$156,099
$186,940
$155,583
$156,110
$2,000,078
$2,148,340
$2,311,909
$2,433,458
• Lead and Assistant Teacher Wages, Net PTO
Operating Salaries
$12,395
$11,683
$12,288
$15,301
$12,241
$12,926
$16,098
$12,878
$12,926
$15,401
$12,878
$12,926
$159,939
$185,031
$207,309
$216,180
• Assistant Director, Program Specialist and Cook Wages, Net PTO
Training Salaries
$3,804
$10,160
$2,442
$3,822
$3,062
$2,453
$3,839
$3,076
$2,464
$12,835
$3,080
$2,464
$53,502
$57,091
$61,026
$64,027
• All Staff Training Hour Wages
Benefits
$66,978
$51,686
$52,191
$64,370
$51,916
$52,594
$64,874
$52,319
$52,824
$65,066
$52,395
$52,824
$680,036
$726,602
$780,397
$818,989
Paid Time Off
$23,463
$16,471
$16,496
$20,652
$16,547
$16,629
$20,818
$16,680
$16,705
$20,881
$16,705
$16,705
$218,754
$231,931
$249,435
$261,922
• PTO for All Staff
Payroll Taxes
$24,767
$19,845
$19,875
$24,882
$19,936
$20,035
$25,082
$20,096
$20,126
$25,158
$20,126
$20,126
$260,054
$279,432
$300,521
$315,565
• Payroll Taxes for All Staff
Health Insurance
$16,295
$13,056
$13,076
$16,371
$13,117
$13,182
$16,502
$13,222
$13,242
$16,552
$13,242
$13,242
$171,099
$183,848
$197,723
$207,621
• Health Benefit Allocation for Center Staff
Management Bonus
$1,714
$1,714
$2,142
$1,714
$1,714
$2,142
$1,714
$1,714
$2,142
$1,714
$1,714
$2,142
$22,279
$22,947
$23,636
$24,345
• Center Director Bonus Budgeted at 10%
Other Fringes
$739
$600
$601
$752
$602
$605
$758
$607
$608
$760
$608
$608
$7,849
$8,444
$9,082
$9,536
• 401K Allocation for Center Staff Benefits
Total Salaries & Benefits
$294,214
$236,082
$236,870
$295,574
$237,162
$238,760
$297,936
$239,052
$239,840
$298,836
$239,412
$240,112
$3,093,851
$3,323,100
$3,572,858
$3,751,237
OPERATING EXPENSES
Direct Operating Expenses
$18,689
$15,022
$15,093
$18,954
$15,234
$15,316
$19,234
$15,458
$15,528
$19,410
$15,528
$15,581
$199,047
$230,320
$258,807
$276,296
Bad Debt
$660
$531
$534
$672
$541
$544
$684
$550
$553
$691
$553
$606
$7,119
$8,387
$9,640
$10,448
Food Costs
$5,288
$4,255
$4,280
$5,381
$4,330
$4,354
$5,474
$4,404
$4,429
$5,536
$4,429
$4,429
$56,589
$67,181
$77,190
$83,707
• KCE's standard in-house economical food program
Educational Supplies
$1,065
$857
$862
$1,084
$872
$877
$1,103
$887
$892
$1,115
$892
$892
$11,401
$13,141
$14,659
$15,434
Equipment Replacement
$2,394
$1,927
$1,938
$2,437
$1,960
$1,972
$2,479
$1,994
$2,005
$2,507
$2,005
$2,005
$25,623
$29,533
$32,945
$34,685
Office Supplies
$1,157
$931
$937
$1,178
$948
$953
$1,198
$964
$969
$1,212
$969
$969
$12,386
$14,276
$15,925
$16,766
Enrichment Expense/Ancillary
$630
$504
$505
$632
$506
$507
$635
$508
$509
$636
$509
$509
$6,590
$6,867
$7,128
$7,298
Janitorial Supplies
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Insurance Exp-Workers' Comp
$4,236
$3,394
$3,399
$4,255
$3,409
$3,426
$4,289
$3,437
$3,442
$4,302
$3,442
$3,442
$44,474
$49,221
$54,524
$58,971
Local Marketing & Promotional Exp
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$1,299
$1,449
$1,525
Employment Costs
$234
$188
$189
$238
$192
$193
$242
$195
$196
$245
$196
$196
$2,505
$2,888
$3,221
$3,391
• Ongoing recruiting costs
Meetings
$119
$96
$96
$121
$97
$98
$123
$99
$100
$124
$100
$100
$1,272
$1,510
$1,735
$1,788
•
Travel Expense
$182
$146
$147
$185
$149
$150
$188
$152
$152
$190
$152
$152
$1,947
$2,311
$2,656
$2,735
Training Expense
$143
$115
$116
$146
$117
$118
$148
$119
$120
$150
$120
$120
$1,533
$1,820
$2,091
$2,154
•
Gifts & Awards
$231
$186
$187
$235
$189
$190
$239
$192
$193
$241
$193
$193
$2,467
$2,844
$3,173
$3,266
•
Diapers and Wipes
$2,168
$1,744
$1,755
$2,206
$1,775
$1,785
$2,244
$1,805
$1,816
$2,269
$1,816
$1,816
$23,198
$26,738
$29,827
$31,403
•
Professional Fees
$4
$3
$3
$4
$3
$3
$4
$3
$3
$4
$3
$3
$43
$50
$55
$57
•
Accreditation Exp-Primary
$177
$143
$144
$181
$145
$146
$184
$148
$149
$186
$149
$149
$1,899
$2,255
$2,590
$2,668
•
Indirect Operating Expenses
$17,466
$14,000
$14,027
$17,568
$14,082
$14,109
$17,670
$14,163
$14,191
$17,738
$14,191
$14,211
$183,414
$198,679
$213,437
$223,069
Program Materials
$808
$646
$646
$808
$646
$646
$808
$646
$646
$808
$646
$646
$8,400
$8,652
$8,912
$9,179
•
Utilities
$6,630
$5,304
$5,304
$6,630
$5,304
$5,304
$6,630
$5,304
$5,304
$6,630
$5,304
$5,304
$68,952
$71,021
$73,151
$75,346
Maintenance Expense
$4,643
$3,714
$3,714
$4,643
$3,714
$3,714
$4,643
$3,714
$3,714
$4,643
$3,714
$3,714
$48,288
$49,737
$51,229
$52,765
Janitorial Contract Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Telephone/Internet Expense
$1,050
$845
$850
$1,069
$860
$865
$1,087
$875
$879
$1,099
$879
$879
$11,238
$13,341
$15,329
$15,788
Computer Costs
$695
$559
$562
$707
$569
$572
$719
$579
$582
$727
$582
$582
$7,435
$8,827
$10,142
$10,446
•
Cellular Phones
$108
$87
$87
$108
$87
$87
$108
$87
$87
$108
$87
$87
$1,128
$1,162
$1,197
$1,233
•
Insurance Expense
$3,306
$2,660
$2,676
$3,364
$2,707
$2,722
$3,422
$2,753
$2,768
$3,461
$2,768
$2,768
$35,375
$41,996
$48,253
$52,326
•
Taxes & Licenses
($542)
($434)
($434)
($542)
($434)
($434)
($542)
($434)
($434)
($542)
($434)
($414)
($5,618)
($5,807)
($5,982)
($6,161)
•
Bank Service Charges
$768
$618
$621
$781
$629
$632
$795
$639
$643
$804
$643
$643
$8,217
$9,752
$11,208
$12,147
•
Total Operating Expenses
$36,155
$29,022
$29,120
$36,522
$29,315
$29,425
$36,904
$29,621
$29,719
$37,148
$29,719
$29,792
$382,461
$428,999
$472,245
$499,365
Management Fee
$77,083
$77,083
$77,083
$77,083
$77,083
$77,083
$77,083
$77,083
$77,083
$77,083
$77,083
$77,083
$925,000
$952,750
$981,333
$1,010,772
Operating P&L Projections
Attachment 1E 24-7 Operating Budget

Net Operating Surplus / (Deficit)
($267,460)
($229,623)
($229,855)
($266,728)
($229,031)
($230,084)
($267,013)
($229,261)
($229,492)
($266,518)
($229,063)
($229,288)
($2,903,417)
($2,927,457)
($2,983,553)
($3,047,202)
• Any Surplus Is Remitted Back to Maricopa. Any Deficit Is Invoiced & Owed By The Client
Required Net Operating Surplus
Staffing Pattern
Center Director
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Assistant Director
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Program Specialst
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Cook
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Career Educators
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
14
Pathway Educators
2
2
2
2
3
3
3
4
4
5
5
5
6
8
8
8
Breakers
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
Wage Rate
Career Educators
$16.27
$16.27
$16.27
$16.27
$16.27
$16.27
$16.27
$16.27
$16.27
$16.27
$16.27
$16.27
$16.27
$16.76
$17.27
$17.78
Pathway Educators
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$15.17
$15.63
$16.09
Breakers
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$14.73
$15.17
$15.63
$16.09