September 2022 PY to CY Comparison Report (1)

AID 1443621 · View on Simbli

Agenda Item

i. Acceptance of the September 2022 Monthly Financial Reports

Summary: Presented by: Mrs. Masana Mailliard, Deputy Chief Financial Officer, Division of Finance
Request: It is requested that the Board of Education accept the September 2022 Monthly Financial Report.
Contact: Mrs. Masana Mailliard, Deputy Chief Financial Officer, Division of Finance, 678.676.0446
Status: General Counsel approval not required.
                                                 DEKALB COUNTY BOARD OF EDUCATION
                                             GENERAL FUND - PRIOR YEAR COMPARISON CHARTS
                                                        September - 09/30/2022


                                                               Revenues Comparison


                    300,000,000


                    250,000,000


                    200,000,000


                    150,000,000


                    100,000,000


                     50,000,000


                                   0
                                       Local Revenue                  State Revenue                   Other Revenue                  Total Revenue
        FY22 - Prior Fiscal Year        60,945,747                      47,963,122                        3,812                       108,912,681
        FY23 - Current Fiscal Year      232,065,649                    48,556,637                         278,710                    280,900,996

                                                       FY22 - Prior Fiscal Year       FY23 - Current Fiscal Year


Local revenue recognition attributable to September increased due to earlier receipt of property tax collections than in previous
years. The property tax revenue collection cycle for the District has compressed around ten days. Therefore, whereas the District's
largest single distribution in FY22 was received in October, the largest single distribution for FY23 was recieved toward the end of
September. While this changes the month the revenue is attributable to, it does not substantially change the total annual collection
expected. Property tax receipts received during first quarter operations will be used to cover expenditures for the remainder of the
fiscal year.




                                                            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       71,536,144              6,274,002                 8,211,586                   17,856,989          103,878,721
        FY23 - Current Fiscal Year     70,514,975              6,535,362                 9,749,684                   19,185,524          105,985,545

                                                       FY22 - Prior Fiscal Year       FY23 - Current Fiscal Year


Amounts attributable to the General Fund were largely comparable to the previous reporting period, with a modest and expected
overall increase of two percent. Expenditures attributable to instructional services were down as compared to the previous year,
driven by net decreases in the total cost of teachers and substitutes. While the average cost of single educator has increased,
declines in staffing due to the nation-wide educator shortage offsets individual cost increases.
                             DEKALB COUNTY BOARD OF EDUCATION
                            GENERAL FUND - PRIOR YEAR COMPARISON
                                    September - 09/30/2022

                                             Revenues:


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


Local Revenue                                 60,945,747                   232,065,649     171,119,902
State Revenue                                 47,963,122                    48,556,637         593,515
Other Revenue                                      3,812                       278,710         274,898
Total Revenue                               108,912,681                   280,900,996      171,988,315




                                           Expenditures:


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


Instruction                                   71,536,144                   70,514,975        (1,021,169)
Pupil Services                                 6,274,002                    6,535,362           261,360
Maintenance and Operation                      8,211,586                    9,749,684         1,538,098
Other Functions                               17,856,989                   19,185,524         1,328,535
Total Expenditures                          103,878,721                   105,985,545         2,106,824