March 2023 PY to CY Comparison Report (1)

AID 1509456 · View on Simbli

Agenda Item

i. Acceptance of the March 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 March 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
                                                                       March - 03/31/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,689,312                   48,204,906                           32,565                    56,926,783
          FY23 - Current Fiscal Year        13,849,975                   49,519,467                         1,896,425                  65,265,867

                                                            FY22 - Prior Fiscal Year   FY23 - Current Fiscal Year


Monthly revenue was in line with expectations and comparable to the previous reporting period. Other Revenue is once again far exceeding prior year levels
due to rising interest earnings on the District's reserves held in the Local Government Investment Pool and other cash accounts.




                                                                 Expenditures Comparison


                       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      70,515,345          6,237,199                    7,309,665                     17,566,893         101,629,102
           FY23 - Current Fiscal Year    70,216,909          6,473,181                   12,768,307                     21,433,969         110,892,367

                                                            FY22 - Prior Fiscal Year   FY23 - Current Fiscal Year


Overall expenditures increased 9.11 percent as compared to the previous reporting period, primarily driven by increases experienced in the Maintenance and
Operation of Plant functional expense category. Expenditure increases within the function were experienced across several categories, including rising energy
and utility costs, supplies, repairs and maintenance, and the purchase of multiple maintenance vehicles from Ford Automotive. In addition, expenditures
associated with Student Transportation Service increased due to rising energy costs and the purchase of GPS software from Education Logistics, Inc.
                             DEKALB COUNTY BOARD OF EDUCATION
                            GENERAL FUND - PRIOR YEAR COMPARISON
                                      March - 03/31/2023

                                             Revenues:


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


Local Revenue                                  8,689,312                    13,849,975       5,160,663
State Revenue                                 48,204,906                    49,519,467       1,314,561
Other Revenue                                     32,565                     1,896,425       1,863,860
Total Revenue                                56,926,783                    65,265,867        8,339,084




                                           Expenditures:


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


Instruction                                   70,515,345                   70,216,909         (298,436)
Pupil Services                                 6,237,199                    6,473,181          235,982
Maintenance and Operation                      7,309,665                   12,768,307        5,458,642
Other Functions                               17,566,893                   21,433,969        3,867,076
Total Expenditures                          101,629,102                   110,892,367        9,263,265