June 2023 PY to CY Comparison Report

AID 1543399 · View on Simbli

Agenda Item

i. Acceptance of the (Tentative) June 2023 Monthly Financial Reports

Summary: Presented by: Mr. Byron Schueneman, Chief Financial Officer, Division of Finance
Request: It is requested that the Board of Education accept the June 2023 Monthly Financial Report.
Contact: Mr. Byron Schueneman, Chief Financial Officer, Division of Finance, Division of Finance, 678.676.0278
Status: General Counsel approval not required.
                                                                     DEKALB COUNTY BOARD OF EDUCATION
                                                                 GENERAL FUND - PRIOR YEAR COMPARISON CHARTS
                                                                                June - 06/30/2023



                                                                          Revenues Comparison


                        70,000,000

                        60,000,000

                        50,000,000

                        40,000,000

                        30,000,000

                        20,000,000

                        10,000,000

                                   0
                                            Local Revenue                  State Revenue                        Other Revenue                    Total Revenue
           FY22 - Prior Fiscal Year           8,421,309                      53,241,681                            125,079                        61,788,070
           FY23 - Current Fiscal Year         7,680,171                       56,366,942                           1,528,754                      65,575,867

                                                                  FY22 - Prior Fiscal Year   FY23 - Current Fiscal Year

June revenue was largely comparable to the previous reporting period. Modest and expected increases continue to be experienced in State Revenue attributable to additional
QBE, Quality Basic Education, revenue received to fund the employer portion of administratively mandated health insurance rate increases. Other Revenue, which consists mainly
of interest earnings, continues to outpace prior year levels due to increased yields on the District's reserves held in the Local Government Investment Pool and other cash
accounts.




                                                                       Expenditures Comparison


                        140,000,000

                        120,000,000

                        100,000,000

                         80,000,000

                         60,000,000

                         40,000,000

                         20,000,000

                                       0
                                           Instruction           Pupil Services              Maintenance and                   Other Functions     Total Expenditures
                                                                                                Operation
            FY22 - Prior Fiscal Year       68,227,141             6,324,494                    10,103,784                        19,837,470           104,492,888
            FY23 - Current Fiscal Year     75,965,540             6,717,005                    19,722,640                        24,254,524           126,659,709

                                                                  FY22 - Prior Fiscal Year   FY23 - Current Fiscal Year


June expenditures were higher than average, and represented a 21.2 percent increase as compared to the previous fiscal year. This increase is identifiable to
notable district safety enhancements in Maintenance and Operations, as well as increases in Instruction, Student Transportation, and General Administration
functions.

Within Maintenance and Operations, safety enhancements led the increase with purchases for EVOLV Security Solutions and Centegix's Safety Alert System, as
well as increased costs experienced for maintenance and supplies. Within the Instruction function, increases were attributable from one-time purchases of student
chromebooks, rising employee benefit costs, and increased expenditures for substitutes. Additionally, various smaller but broad increases were noted across Other
Functions, including increased expenses for student transportation, maintenance personnel, energy costs, and one-time legal fees.
                             DEKALB COUNTY BOARD OF EDUCATION
                            GENERAL FUND - PRIOR YEAR COMPARISON
                                      June - 06/30/2023

                                             Revenues:


           Description        FY22 - Prior Fiscal Year     FY23 - Current Fiscal Year    Difference


Local Revenue                                  8,421,309                     7,680,171        (741,139)
State Revenue                                 53,241,681                    56,366,942       3,125,261
Other Revenue                                    125,079                     1,528,754       1,403,675
Total Revenue                                61,788,070                    65,575,867        3,787,798




                                           Expenditures:


           Description        FY22 - Prior Fiscal Year     FY23 - Current Fiscal Year    Difference


Instruction                                   68,227,141                   75,965,540        7,738,399
Pupil Services                                 6,324,494                    6,717,005          392,511
Maintenance and Operation                     10,103,784                   19,722,640        9,618,856
Other Functions                               19,837,470                   24,254,524        4,417,055
Total Expenditures                          104,492,888                   126,659,709       22,166,821