Financial Update of Fredericksburg City Public Schools

Fredericksburg City Public Schools Monthly Financial Update August 5, 2024 Jennifer R. Brody, Chief Financial Officer

Executive Summary Operating Fund at June 30, 2024 Operating Fund Revenues Local Revenue State Revenue General Fund Transfers Use of Fund Balance Total Operating Fund Revenues FY24 Budget 406,075.00 $ 24,537,325.00 30,750,000.00 4,250,000.00 59,943,400.00 $ FY24 Actual 387,299.17 $ 22,244,804.68 30,750,000.00 53,382,103.85 $ FY24 % YTD FY23 % YTD 95.4% 90.7% 100.0% 0.0% 89.1% - - - - - 93.0% Operating Fund Expenditures Human Capital Professional Services Maintenance and Repairs Supplies Capital Assets Transfers and Reserves Total Operating Fund Expenditures FY24 Budget 49,245,670.00 $ 2,067,443.00 1,864,203.00 1,879,755.00 990,100.00 3,896,229.00 59,943,400.00 $ FY24 Actual 42,620,564.29 $ 2,429,144.40 2,150,719.27 1,936,281.72 837,362.84 3,250,000.00 53,224,072.52 $ FY24 % YTD FY23 % YTD 86.5% 117.5% 115.4% 103.0% 84.6% 83.4% 88.8% - - - - - 96.0%

Executive Summary Special Revenue Fund at June 30, 2024 Special Revenue Fund Revenues FY24 Budget 2,104,661.00 $ 2,027,110.00 4,537,526.00 3,125,298.00 11,794,595.00 $ FY24 Actual 1,342,683.15 $ 1,544,647.09 2,709,849.58 3,542,113.98 9,139,293.80 $ FY24 % YTD FY23 % YTD Title I Head Start School Nutrition Program Other Grant Revenue Total Special Revenue Fund Revenues 63.8% 76.2% 59.7% 113.3% 77.5% - - - - 54.0% Special Revenue Fund Expenditures Human Capital Professional Services Maintenance and Repairs Supplies Capital Assets Total Special Revenue Fund Expenditures FY24 Budget 5,293,303.00 $ 153,984.00 281,205.00 3,808,956.00 2,257,147.00 11,794,595.00 $ FY24 Actual 5,109,219.01 $ 893,220.95 96,971.72 2,580,980.31 2,612,776.64 11,293,168.63 $ FY24 % YTD FY23 % YTD 96.5% 580.1% 34.5% 67.8% 115.8% 95.7% - - - - - 86.0%

Detailed Operating Fund Revenues at June 30, 2024 Operating Fund Revenues Facilities Rental Cafeteria Revenues Tuition Rebates & Refunds Gifts/Donations Sale of Equipment Insurance Adjustments Miscellaneous Revenue Dept Recovered Cost King George Head Start Basic Aid GED Funding/ISAEP Remedial Summer School Foster Children Gifted Education - SOQ Prevention Intervention & Remediation Compensation Supplement Special Education - SOQ FY24 Revised Budget $ 9,145,331.00 1,553,291.00 FY24 Actual 46,121.07 $ 25,008.96 51,500.60 37,046.97 16,342.00 65,829.97 35,147.25 1,302.35 109,000.00 8,555,334.00 16,345.70 111,635.00 80,267.00 422,456.00 1,252,318.00 546,376.00 FY24 % YTD 26,150.00 9,125.00 90,000.00 20,000.00 1,200.00 600.00 24,000.00 101,000.00 25,000.00 109,000.00 176% 274% 57% 185% 0% 2724% 274% 35% - 5% 100% 94% 100% 73% 668% 92% 92% 81% 92% 16,405.00 153,498.00 92.00 87,215.00 459,024.00 615.00 593,671.00

Detailed Operating Fund Revenues at June 30, 2024 (Cont.) Operating Fund Revenues (Cont.) Textbooks Vocational Education - SOQ Social Security Retirement Early Intervention Group Life Insurance Sped - Homebound Regional Special Education Regional Vocational Equipment Vocational Career Occ Tech Special Education Foster Care At Risk Primary Class Size (K-3) Vocational Ed Prep Regional Supp Lottery Per Pupil Mentor Teacher State Sales Tax ESL Payment State Sales Tax 1/8 Cent FY24 Revised Budget 1,115,428.00 1,293,346.00 4,544,955.00 FY24 Actual 186,416.00 99,981.00 439,354.00 1,023,751.00 107,532.00 30,980.00 3,916.13 269,118.82 5,440.61 1,150,103.18 443,050.00 10,742.00 570,202.00 6,335.00 3,994,393.82 480,820.00 497,683.62 FY24 % YTD 202,552.00 108,636.00 478,915.00 92% 92% 92% 92% 65% 92% 74% 167% 0% 0% 0% 89% 75% 0% 93% 4% 88% 111% 90% 165,310.00 33,662.00 5,276.00 160,856.00 - 15,987.00 - - 299.33 587,935.00 - 612,510.00 142,224.00 433,633.00 553,000.00

Detailed Operating Fund Revenues at June 30, 2024 (Cont.) Operating Fund Revenues (Cont.) CTE Equipment High Demand CTE STEM Industry Certification Workplace Readiness Skills National Board Certification SOL Algebra Readiness Project Graduation Career Switcher Mentor Vision Screening Grant Albuterol Grant Hold Harmless Rebenchmarking Supp Grocery Tax Medicaid Return of Cost Transfer from General Fund Encumbrance Fund Balance Rev Total Operating Fund Revenues FY24 Revised Budget 1,098,415.00 30,750,000.00 4,250,000.00 59,943,400.00 $ FY24 Actual 4,196.54 1,160.80 3,091.12 2,500.00 42,232.00 6,555.00 3,900.00 7,553.00 1,098,415.00 721,944.00 47,075.44 30,750,000.00 53,382,103.85 $ FY24 % YTD - - - - 100% 0% 100% 100% 100% 104% 100% 0% 104% 0% 100% 96% 28% 100% 0% 89% 716.57 2,500.00 40,748.00 6,555.00 - 7,294.00 310.00 - 752,751.00 166,000.00 -

Detailed Operating Fund Expenditures at June 30, 2024 Operating Fund Expenditures Administration School Board Members Superintendant Instructional Data Coaches Teacher Librarian/Media Guidance Counselor Principal Assistant Principal Other Salaried Services Nurse Psychologist Administrative Assistant Social Worker Transportation Supervisor Other Professional Clerical Paraprofessional FY24 Revised Budget 2,245,579.00 $ 18,378,798.00 2,510,973.00 2,594,779.00 FY24 Actual 2,324,020.60 $ 33,000.48 244,904.16 1,035,171.18 14,295,476.13 288,432.24 858,969.26 514,577.76 949,577.91 366,318.73 221,375.90 281,317.84 23,340.05 (10,029.08) 80,405.11 41,460.82 2,411,959.23 2,113,370.75 FY24 % YTD 105% 100% 111% 107% 78% 97% 96% 99% 107% 83% 79% 94% 67% -5% 104% 100% 96% 81% 33,000.00 219,904.00 969,424.00 298,315.00 894,450.00 520,587.00 891,100.00 439,850.00 278,697.00 298,810.00 34,789.00 208,022.00 77,568.00 41,577.00

Detailed Operating Fund Expenditures at June 30, 2024 (Cont.) Operating Fund Expenditures Trade/Mechanic School Bus Driver Other Tech/Bus Assistant Other Tech/Car Assistant Custodial School Maintenance SNP Staff Bonus Salaries & Wages Sub Teachers Regular Supplemental Pay ERIP Supplemental Pay Athletics Supplemental Pay Activities ISAEP/GED OT Regular Salaries & Wages FICA Benefits VRS Retirement Hybrid VRS FY24 Revised Budget 1,423,000.00 1,090,919.00 2,693,649.00 3,081,456.00 2,019,115.00 FY24 Actual 116,336.62 1,282,542.90 87,534.51 116,329.06 1,050,791.71 752,471.60 63,797.92 59,641.28 18,665.81 477,020.85 173,868.17 144,128.00 2,225,989.42 2,771,606.19 2,110,030.77 FY24 % YTD 110,158.00 106% 90% 127% 116% 96% 96% 128% 100% 11% 5% 227% 150% 352% 0% 0% 83% 90% 105% 68,676.00 100,016.00 780,412.00 50,000.00 - - 550,000.00 364,813.00 210,000.00 115,650.00 41,000.00 16,465.00 10,000.00 - -

Detailed Operating Fund Expenditures at June 30, 2024 (Cont.) Operating Fund Expenditures VRS COV 457 Cash Match Medical Insurance Group Life Insurance Disabilty Hybrid Plan Unemployment Workers Compensation Tuition Assistance Retiree Leave Payout Health Services Legal Services Other Professional Services Contractual Services Repairs & Maintenance Repairs & Maintenance - Computers Printing & Binding Advertising Electrical Service Heating Service FY24 Revised Budget 4,987,136.00 1,204,819.00 FY24 Actual 8,586.34 4,516,270.06 372,215.94 29,322.96 142,322.61 27,442.50 69,684.51 63,299.90 139,676.76 1,367,365.29 487,471.35 249,765.16 35,986.80 13,491.18 2,403.45 894,939.29 152,220.67 FY24 % YTD 5,000.00 172% 91% 99% 104% 0% 98% 137% 100% 154% 243% 113% 88% 157% 144% 55% 472% 138% 152% 376,813.00 28,259.00 46,305.00 145,606.00 20,000.00 - - 41,000.00 57,500.00 555,000.00 159,100.00 25,000.00 24,515.00 509.00 650,000.00 100,000.00

Detailed Operating Fund Expenditures at June 30, 2024 (Cont.) Operating Fund Expenditures Water & Sewer Service Postal Service Telecommunication VOIP/Data/Internet Cell/Wireless Motor Vehicle Insurance General Liability Equipment Lease/Rental Copier Lease Buildings Lease/Rental Mileage Convention & Education Dues & Association Memberships Office Supplies Food Supplies Medical & Laboratory Supplies Janitorial Supplies Repair & Maintenance Supplies Motor Fuels Vehicle & Power Equip Supplies FY24 Revised Budget FY24 Actual 96,460.10 16,194.91 29,855.70 89,600.79 45,155.53 37,905.00 133,690.00 76,191.67 320,679.56 65,414.31 17,078.17 139,247.62 36,085.95 99,154.54 32,539.82 9,675.78 177,842.28 228,881.82 229,739.72 59,363.10 FY24 % YTD 91,000.00 21,500.00 35,000.00 142,000.00 58,000.00 38,219.00 127,854.00 59,074.00 271,000.00 65,000.00 18,200.00 129,850.00 57,506.00 76,541.00 50,000.00 5,000.00 95,000.00 400,000.00 160,000.00 37,000.00 106% 75% 85% 63% 78% 99% 105% 129% 118% 101% 94% 107% 63% 130% 65% 194% 187% 57% 144% 160%

Detailed Operating Fund Expenditures at June 30, 2024 (Cont.) Operating Fund Expenditures Education & Rec Supplies Other Operating Supplies School Books & Subscriptions Algebra Intervention Supplies Classroom Instr Materials Tuition to Other Localities Equipment Replacement Machinery & Equipment Replacement Furniture & Fixture Replacement Motor Vehicle & Equip Replacement EDP Equipment Replacement Equipment Addition Furniture & Fixture Addition EDP Equipment Addition Contingency Reserve Transfer to Debt Service Transfer to School Capital Reserve for City Funding & Savings Misc Recovered Costs Total Operating Fund Expenditures FY24 Revised Budget 3,250,000.00 (621,506.00) 59,968,400.00 $ FY24 Actual 163,348.06 548,603.08 277,794.16 106,049.36 3,290.00 251,266.77 448,830.38 137,240.70 3,250,000.00 53,224,072.52 $ FY24 % YTD 106,160.00 459,334.00 262,485.00 38,231.00 170,004.00 20,000.00 36,000.00 154% 119% 106% 0% 62% 16% 698% 0% 0% 0% 0% 86% 0% 0% 0% 0% 100% 0% 0% 89% - - - - - - - 720,000.00 159,100.00 - - 75,000.00 942,735.00 300,000.00 24.99 - - - - 25,000.00

Detailed Special Revenue Fund Revenues at June 30, 2024 Special Revenue Fund Revenues Cafeteria Revenues Gifts/Donations Miscellaneous Revenue Governor's School Head Start eRate Schools Libraries School Food Programs Governors School Regional Special Education Regional Va Preschl Init/At Risk 4 Yrs Jobs for Virginia Graduates School Breakfast Breakfast After the Bell Adv Computer Science Education Virginia Preschool Inititiative VPI Teacher to Student Ratio VPI Flexible Spending All In Sch Security System Equip FY24 Revised Budget $ FY24 Actual 72,608.82 $ 22,029.38 25,894.20 6,000.00 97,893.73 22,680.92 26,897.86 60,000.00 30,982.38 67,109.20 220,820.00 12,774.00 1,141,585.00 76,562.89 FY24 % YTD 125,000.00 10,000.00 58% 220% 100% 300% 0% 70% 50% 103% 0% 0% 100% 103% 0% 100% 127% 147% 0% 100% 100% - 2,000.00 25,000.00 140,000.00 45,000.00 26,061.00 - - - - - 60,000.00 30,000.00 11,495.00 - - 174,444.00 8,685.00 55,005.00 - - -

Detailed Special Revenue Fund Revenues at June 30, 2024 (Cont.) Special Revenue Fund Revenues (Cont.) VPSA Technology Title VI-B Special Education CarlPerkins Grant PreSchool In (SPED) 84.173 School Based Mental Health Grant Title III LEP Title II/NCLB/Teacher Qual Grant Title IV/NCLB ESSA Trnsfr 84.4 Medicaid Return of Cost Healthy Workforce Grant Head Start Title I/Chapter I/Part A FS Cash in Lieu of Comm 10.550 FS Sch Food Prog Breakfast 10.553 FS Sch Food Prog Lunch 10.555 Summer Feeding Program CFDA Total Special Revenue Fund Revenues FY24 Revised Budget 1,509,518.00 2,027,110.00 2,104,661.00 3,447,526.00 11,794,595.00 $ FY24 Actual 397,190.45 212,814.03 708,345.78 186,117.35 10,880.13 28,350.16 114,077.70 1,544,647.09 1,342,683.15 192,891.00 697,444.91 1,819,513.67 9,139,293.80 $ FY24 % YTD 154,000.00 258% 14% 711% 314% 100% 18% 0% 123% 0% 0% 76% 64% 90% 0% 53% 0% 77% 99,621.00 59,362.00 - 153,854.00 263,501.00 92,752.00 80,000.00 500.00 - - - 215,000.00 650,000.00 225,000.00 -

Detailed Special Revenue Fund Expenditures at June 30, 2024 Special Revenue Fund Expenditures Administration Teacher Other Salaried Services Nurse Social Worker Clerical Para SNP Administration SNP Staff 414010 Bonus Salaries & Wages Substitute Teachers Supplemental Pay FICA Benefits VRS Retirement Hybrid VRS Medical Insurance Group Life Insurance Disability Hybrid Plan FY24 Revised Budget $ 2,592,194.00 FY24 Actual 52,381.20 $ 1,771,802.57 104,333.26 37,024.92 79,573.96 143,470.76 515,087.57 114,393.24 711,850.91 45,000.00 2,291.25 157,241.00 258,299.22 306,831.13 181,035.73 574,581.86 54,020.43 5,016.83 FY24 % YTD 48,999.00 107% 68% 82% 0% 0% 65% 147% 107% 118% 100% 9% 100% 73% 95% 100% 108% 707% 100% 127,151.00 - - 221,740.00 350,446.00 107,026.00 605,483.00 - 25,480.00 - 351,810.00 323,256.00 - 532,073.00 7,645.00 -

Detailed Special Revenue Fund Expenditures at June 30, 2024 Special Revenue Fund Expenditures Other Professional Services Contractual Services Repairs & Maintenance Telecommunication Mileage Convention & Education Dues & Association Memberships Office Supplies Food Supplies Medical & Laboratory Supplies Education & Rec Supplies Other Operating Supplies Equipment Replacement Motor Vehicle Replacement Equipment Addition Total Special Revenue Fund Expenditures FY24 Revised Budget 3,266,711.00 1,867,526.00 11,794,595.00 $ FY24 Actual 877,412.82 10,791.30 43,481.50 53,285.22 18,260.01 1,798,768.05 322,218.78 441,733.47 1,064,405.64 1,408,364.00 140,007.00 11,293,168.63 $ FY24 % YTD 152,784.00 574% 100% 3623% - 1,200.00 600.00 12,200.00 266,605.00 1,800.00 2,000.00 - - 0% 0% 20% 11% 913% 55% 0% 106% 190% 522% 100% 75% 96% 205.00 3,000.00 305,110.00 232,135.00 204,000.00 - 185,621.00