General Fund KPI's - October 2024

AID 1722244 · View on Simbli

Agenda Item

a. Acceptance of the October 2024 Monthly Financial Report

Summary: Presented by: Mr. Byron Schueneman, Chief Financial Officer, Division of Finance
Request: It is requested that the Board of Education accept the October 2024 Monthly Financial Report.
Contact: Mr. Byron Schueneman, Chief Financial Officer, Division of Finance, Division of Finance, 678.676.0270
Status: Attorney approval not required
GF Key Performance Indicators
As of 10/31/2024 (Per 4 of 12)
https://www.dekalbschoolsga.org/data-dashboards/finance/




Last data refresh:
11/27/2023 3:53:36 PM UTC

Downloaded at:
11/28/2023 12:48:16 PM UTC



                                                           1
2
Microsoft Power BI




                              Amount Collected   Percentage of Budget
                 Actual           $658.4M               42.5%
                 Benchmark         $632M                40.7%
                                                                        3
                 Difference        $26.4M                1.8%
                                                              FY2025
                                                         DCSD General Fund
                                                  YTD REVENUE Budget vs Collections

           1,200
Millions




                   $970.27
           1,000




            800
                                                                                                                                                           Revenue Sources
                                                                                                                                                   Local    $529.2M     80.4%
                                                                                                                                  REVENUE BUDGET
            600
                                                                                                                                                   State    $122.5M     18.6%
                                                                   $560.33
                       $529.20                                                                                                    YTD ACTUALS
                                                                                                                                  Series8
                                                                                                                                  Series11         Other     $6.7M      1.0%
            400                                                                                                                   Series12
                                                                                                                                  Series13



            200
                                                                       $122.53


                                          $15.00
                                               $6.55                                          $1.65$0.00             $0.00$0.10
              0

                         LOCAL REVENUES                INTEREST              STATE SOURCES         FEDERAL SOURCES   TRANSFERS AND OTHER LOCAL

                                           (LOCAL & OTHER) Budgeted: $986,923,398 Actual: $535,852,233 54.30%
                                               (STATE) Budgeted: $560,327,715 Actual: $122,527,811 21.87%
                                               TOTAL Budgeted: $1,547,251,113 Actual: $658,380,045 42.55%
                                                                                                                                                                         4
                                                                             5
Microsoft Power BI




                        Amount Spent   Percentage of Budget (no encumbrances)
           Actual            $426.1                    26.5%
           Benchmark         $412.6                    25.7%
                                                                                5
           Difference        $13.5                      .8%
                                                             FY2025
                                                   DeKalb County School District
                                                  YTD Expense Actuals by Function
                 SCHOOL NUTRITION
                 PROGRAM, 0 , 0.0%
                                                TRANSFERS & OTHER
           OTHER SUPPORT SERVICES,           OUTLAYS, 21,000,000 , 4.9%
               598,236 , 0.1%
                                                                                                                       INSTRUCTION, 202,419,776 , 47.5%
            ENTERPRISE OPERATIONS,
                235,028 , 0.1%

                                                                                                                                                                 Significant Functions
           SUPPORT SERVICES ‐ CENTRAL,
               18,047,922 , 4.2%


         STUDENT TRANSPORTATION                                                                                                                           Instruction      $202.4M       47.5%
         SERVICE, 19,790,848 , 4.6%
                                                                                                                                                          M&O               $67.1M       15.8%
        SCHOOL SAFETY AND
     SECURITY, 224,495 , 0.1%
MAINTENANCE AND OPERATION,
                                                                                                                                                          Gen               $30.6M       7.2%
     67,133,453 , 15.8%                                                                                                                                   Administration


                                                                                                                                       PUPIL SERVICES,
   SUPPORT SERVICES ‐                                                                                                                 21,803,272 , 5.1%
BUSINESS, 5,563,823 , 1.3%      SCHOOL ADMINISTRATION,
                                   27,458,211 , 6.4%
                                                                                                                                  IMPROVEMENT OF
                                                                                                                              INSTRUCTIONAL SERVICES,
                                      GENERAL ADMINISTRATION,                                                                      5,670,235 , 1.3%
                                                                        EDUCATIONAL MEDIA         INSTRUCTIONAL STAFF
                                         30,627,622 , 7.2%
                                                                     SERVICES, 5,412,602 , 1.3% TRAINING, 106,021 , 0.0%

                                                            GENERAL OPERATIONS YTD EXPENSES
                                                                      $426,091,546

                                                                            3
                                                                                                                                                                                   6
Microsoft Power BI – General Fund FB




                        Unassigned FB   Designated FB   Total FB   Total $
         FY25 Actual         27%            15%          42%       $678M
         FY24 Actual         26%            15%          41%
                                                                             7
         Difference           1%            0.0%          1%