MARICOPA 10-5-2023 ATTACHMENT 1C 16-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
$110,459
$89,037
$89,708
$112,973
$91,049
$91,719
$115,487
$93,060
$93,731
$117,163
$93,731
$93,731
$1,191,846
$1,468,115
$1,729,006
$1,893,528
Fees
$234
$189
$190
$240
$193
$194
$245
$197
$199
$248
$199
$747
$3,075
$3,023
$3,455
$3,676
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
$234
$189
$190
$240
$193
$194
$245
$197
$199
$248
$199
$747
$3,075
$3,023
$3,455
$3,676
• Additional Learning Adventures program revenue (STEAM) classes
Discounts
($2,666)
($2,215)
($2,232)
($2,726)
($2,265)
($2,282)
($2,787)
($2,315)
($2,332)
($2,828)
($2,332)
($2,332)
($29,312)
($35,956)
($42,174)
($46,009)
Staff Discount
($2,127)
($1,714)
($1,727)
($2,175)
($1,753)
($1,766)
($2,224)
($1,792)
($1,805)
($2,256)
($1,805)
($1,805)
($22,947)
($28,265)
($33,285)
($36,451)
• KCE Teachers receive discounted tuition for their children
Family Discount
($210)
($169)
($170)
($214)
($173)
($174)
($219)
($177)
($178)
($222)
($178)
($178)
($2,261)
($2,785)
($3,280)
($3,592)
• 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
($330)
($332)
($335)
($337)
($340)
($342)
($345)
($347)
($350)
($350)
($350)
($350)
($4,104)
($4,907)
($5,609)
($5,967)
• 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
$108,027
$87,011
$87,666
$110,486
$88,977
$89,632
$112,945
$90,942
$91,597
$114,584
$91,597
$92,145
$1,165,609
$1,435,181
$1,690,287
$1,851,194
SALARIES & BENEFITS
Direct Salaries, net of PTO
$162,604
$131,595
$131,878
$165,201
$132,444
$133,365
$167,060
$133,931
$134,215
$167,768
$134,215
$134,486
$1,728,761
$1,889,482
$2,064,235
$2,182,176
Management & Admin Salaries
$12,896
$9,917
$10,351
$12,896
$10,317
$10,351
$12,896
$10,317
$10,351
$12,396
$10,317
$10,611
$133,616
$137,356
$141,478
$145,722
• Center Director Salary, Net PTO
Childcare Salaries
$139,172
$107,290
$112,266
$140,216
$112,452
$113,105
$141,261
$113,287
$113,943
$136,455
$113,566
$113,954
$1,456,966
$1,588,934
$1,735,721
$1,839,984
• Lead and Assistant Teacher Wages, Net PTO
Operating Salaries
$7,844
$7,194
$7,530
$9,380
$7,504
$8,168
$10,177
$8,141
$8,168
$9,790
$8,141
$8,168
$100,205
$122,094
$142,484
$149,410
• Assistant Director, Program Specialist and Cook Wages, Net PTO
Training Salaries
$2,692
$7,194
$1,730
$2,709
$2,172
$1,741
$2,727
$2,186
$1,752
$9,127
$2,191
$1,752
$37,974
$41,097
$44,553
$47,060
• All Staff Training Hour Wages
Benefits
$47,155
$36,805
$37,167
$45,912
$37,035
$37,570
$46,416
$37,438
$37,800
$46,608
$37,515
$37,800
$485,223
$527,351
$575,168
$607,603
Paid Time Off
$16,198
$11,755
$11,780
$14,757
$11,831
$11,913
$14,923
$11,963
$11,989
$14,986
$11,989
$11,989
$156,070
$168,777
$184,387
$194,922
• PTO for All Staff
Payroll Taxes
$17,664
$14,162
$14,193
$17,779
$14,254
$14,353
$17,979
$14,414
$14,444
$18,055
$14,444
$14,444
$186,183
$203,344
$222,151
$234,843
• Payroll Taxes for All Staff
Health Insurance
$11,622
$9,318
$9,338
$11,697
$9,378
$9,443
$11,829
$9,483
$9,503
$11,879
$9,503
$9,503
$122,496
$133,787
$146,160
$154,511
• Health Benefit Allocation for Center Staff
Management Bonus
$1,143
$1,143
$1,428
$1,143
$1,143
$1,428
$1,143
$1,143
$1,428
$1,143
$1,143
$1,428
$14,853
$15,298
$15,757
$16,230
• Center Director Bonus Budgeted at 10%
Other Fringes
$529
$428
$429
$537
$431
$434
$543
$436
$436
$546
$436
$436
$5,621
$6,145
$6,713
$7,097
• 401K Allocation for Center Staff Benefits
Total Salaries & Benefits
$209,759
$168,400
$169,045
$211,114
$169,480
$170,935
$213,476
$171,369
$172,015
$214,376
$171,729
$172,286
$2,213,985
$2,416,833
$2,639,404
$2,789,780
OPERATING EXPENSES
Direct Operating Expenses
$14,123
$11,369
$11,439
$14,387
$11,581
$11,663
$14,667
$11,804
$11,875
$14,843
$11,875
$11,875
$151,501
$181,329
$208,508
$224,625
Bad Debt
$510
$411
$414
$521
$420
$423
$533
$429
$432
$540
$432
$432
$5,498
$6,772
$7,976
$8,735
Food Costs
$4,081
$3,289
$3,314
$4,174
$3,364
$3,388
$4,267
$3,438
$3,463
$4,328
$3,463
$3,463
$44,031
$54,246
$63,867
$69,985
• KCE's standard in-house economical food program
Educational Supplies
$822
$663
$668
$841
$678
$683
$860
$693
$698
$872
$698
$698
$8,871
$10,611
$12,129
$12,904
Equipment Replacement
$1,848
$1,489
$1,501
$1,890
$1,523
$1,534
$1,932
$1,557
$1,568
$1,960
$1,568
$1,568
$19,937
$23,847
$27,258
$28,999
Office Supplies
$893
$720
$725
$913
$736
$742
$934
$752
$758
$947
$758
$758
$9,637
$11,527
$13,176
$14,018
Enrichment Expense/Ancillary
$434
$348
$349
$437
$350
$351
$439
$352
$353
$441
$353
$353
$4,558
$4,825
$5,076
$5,235
Janitorial Supplies
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Insurance Exp-Workers' Comp
$3,021
$2,422
$2,427
$3,040
$2,438
$2,455
$3,075
$2,465
$2,470
$3,088
$2,470
$2,470
$31,840
$35,818
$40,305
$43,886
Local Marketing & Promotional Exp
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$1,049
$1,199
$1,275
Employment Costs
$181
$146
$147
$185
$149
$150
$189
$152
$153
$192
$153
$153
$1,949
$2,332
$2,665
$2,835
• Ongoing recruiting costs
Meetings
$92
$74
$75
$94
$76
$76
$96
$77
$78
$97
$78
$78
$990
$1,220
$1,436
$1,479
•
Travel Expense
$140
$113
$114
$144
$116
$117
$147
$118
$119
$149
$119
$119
$1,515
$1,866
$2,197
$2,263
Training Expense
$111
$89
$90
$113
$91
$92
$116
$93
$94
$117
$94
$94
$1,193
$1,470
$1,730
$1,782
•
Gifts & Awards
$178
$143
$145
$182
$147
$148
$186
$150
$151
$189
$151
$151
$1,920
$2,296
$2,625
$2,718
•
Diapers and Wipes
$1,673
$1,348
$1,359
$1,711
$1,379
$1,389
$1,749
$1,409
$1,420
$1,774
$1,420
$1,420
$18,050
$21,590
$24,679
$26,255
•
Professional Fees
$3
$3
$3
$3
$3
$3
$3
$3
$3
$3
$3
$3
$34
$40
$46
$48
•
Accreditation Exp-Primary
$137
$110
$111
$140
$113
$114
$143
$115
$116
$145
$116
$116
$1,478
$1,820
$2,143
$2,208
•
Indirect Operating Expenses
$15,866
$12,720
$12,747
$15,968
$12,801
$12,829
$16,070
$12,883
$12,910
$16,138
$12,910
$12,984
$166,826
$181,540
$195,784
$204,887
Program Materials
$538
$431
$431
$538
$431
$431
$538
$431
$431
$538
$431
$431
$5,600
$5,768
$5,941
$6,119
•
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
$810
$653
$658
$829
$668
$673
$847
$683
$688
$860
$688
$688
$8,744
$10,772
$12,683
$13,063
Computer Costs
$536
$432
$435
$548
$442
$445
$561
$452
$455
$569
$455
$455
$5,785
$7,127
$8,391
$8,643
•
Cellular Phones
$106
$85
$85
$106
$85
$85
$106
$85
$85
$106
$85
$85
$1,104
$1,137
$1,171
$1,206
•
Insurance Expense
$2,551
$2,056
$2,072
$2,609
$2,103
$2,118
$2,667
$2,149
$2,165
$2,706
$2,165
$2,165
$27,524
$33,910
$39,924
$43,748
•
Taxes & Licenses
($542)
($434)
($434)
($542)
($434)
($434)
($542)
($434)
($434)
($542)
($434)
($360)
($5,564)
($5,806)
($5,981)
($6,160)
•
Bank Service Charges
$593
$478
$481
$606
$488
$492
$619
$499
$503
$628
$503
$503
$6,393
$7,875
$9,273
$10,155
•
Total Operating Expenses
$29,988
$24,088
$24,186
$30,355
$24,382
$24,492
$30,737
$24,687
$24,785
$30,981
$24,785
$24,859
$318,327
$362,869
$404,291
$429,512
Management Fee
$41,667
$41,667
$41,667
$41,667
$41,667
$41,667
$41,667
$41,667
$41,667
$41,667
$41,667
$41,667
$500,000
$515,000
$530,450
$546,364
Operating P&L Projections
Attachment 1C 16-7 Operating Budget

Net Operating Surplus / (Deficit)
($173,387)
($147,144)
($147,232)
($172,650)
($146,552)
($147,462)
($172,935)
($146,781)
($146,870)
($172,440)
($146,584)
($146,667)
($1,866,703)
($1,859,521)
($1,883,858)
($1,914,461)
• 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