General Fund KPI's -December 2024

AID 1744053 · View on Simbli

Agenda Item

a. Acceptance of the December 2024 Monthly Financial Report ~ Updated 2.3.2025

Summary: Presented by: Mr. Byron Schueneman, Chief Financial Officer, Divison of Finance
Request: It is requested that the Board of Education accept the December 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 12/31/2024 (Per 6 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            $1.12B               72.4%
                 Benchmark         $1.10b               70.8%
                                                                        3
                 Difference         $26M                 1.6%
                                                             FY2025
                                                        DCSD General Fund
                                                 YTD REVENUE Budget vs Collections

           1,200
Millions




                                                                                                                                                             Revenue Sources
                   $970.27
           1,000

                       $882.27
                                                                                                                                                   Source      YTD      Mix        Total
            800
                                                                                                                                                   Local &   $893.6M   79.5%       90%
                                                                                                                                                   Other
                                                                                                                                                   State     $229.8M   20.5%       41%
                                                                                                                                  REVENUE BUDGET
            600                                                    $560.33
                                                                                                                                  YTD ACTUALS


                                                                                                                                                   Total      $1.12B   100%
                                                                                                                                  Series8
                                                                                                                                  Series11
            400                                                                                                                   Series12
                                                                                                                                  Series13

                                                                       $229.83

            200




                                          $15.00
                                              $11.21                                          $7.08$0.00             $0.00$0.11
              0

                         LOCAL REVENUES            INTEREST                  STATE SOURCES         FEDERAL SOURCES   TRANSFERS AND OTHER LOCAL

                                           (LOCAL & OTHER) Budgeted: $992,348,398 Actual: $893,589,112 90.05%
                                               (STATE) Budgeted: $560,327,715 Actual: $229,827,712 41.02%
                                              TOTAL Budgeted: $1,552,676,113 Actual: $1,123,416,824 72.35%
                                                                                                                                                                               4
                                                                             5
Microsoft Power BI




                        Amount Spent   Percentage of Budget (no encumbrances)
           Actual            $722.6                    43.9%
           Benchmark         $724.2                    43.8%
                                                                                5
           Difference         $1.6                      .1%
                                                              FY2025
                                                    DeKalb County School District
                                                   YTD Expense Actuals by Function

                                                                                                                INSTRUCTION, 380,665,393 , 52.7%
   SCHOOL NUTRITION
   PROGRAM, 0 , 0.0%             TRANSFERS & OTHER
                              OUTLAYS, 42,500,000 , 5.9%
OTHER SUPPORT SERVICES,
   1,046,897 , 0.1%
ENTERPRISE OPERATIONS,
    432,429 , 0.1%
                                                                                                                                                                Significant Functions
SUPPORT SERVICES ‐ CENTRAL,                                                                                                                              Instruction      $380.7M       52.7%
    27,913,267 , 3.9%

   STUDENT TRANSPORTATION                                                                                                                                M&O               $92.3M       12.8%
   SERVICE, 31,606,059 , 4.4%

                                                                                                                                                         School Admin      $42.4M       5.9%

  SCHOOL SAFETY AND                                                                                                                   PUPIL SERVICES,
SECURITY, 663,204 , 0.1%                                                                                                             38,892,447 , 5.4%


      MAINTENANCE AND OPERATION,
           92,311,099 , 12.8%                                                                                                    IMPROVEMENT OF
                                                                                                                             INSTRUCTIONAL SERVICES,
                                                                                                                                  8,307,897 , 1.1%
           SUPPORT SERVICES ‐
       BUSINESS, 10,023,098 , 1.4%
                                                           GENERAL ADMINISTRATION,    EDUCATIONAL MEDIA
                                                              36,865,021 , 5.1%                                            INSTRUCTIONAL STAFF
                                                                                   SERVICES, 8,796,417 , 1.2%
                           SCHOOL ADMINISTRATION,                                                                        TRAINING, 126,301 , 0.0%
                              42,446,750 , 5.9%            GENERAL OPERATIONS YTD EXPENSES
                                                                     $722,596,279

                                                                         3                                                                                                        6
Microsoft Power BI – General Fund FB




                        Unassigned FB   Designated FB   Total FB   Total $
         FY25 Actual        36.1%           15%         51.1%      $846.6M
         FY24 Actual         38%            15%          53%
                                                                             7
         Difference          1.9%           0.0%         1.9%
Remaining Funds
               Special Revenue   Debt Service   Capital Projects   School Food
YTD Revenues   $28.3M            $0             $121.1M            $26.5M
YTD Expenses   $140.9M           $0             $105.5M            $26.1M
Fund Balance   -$112.6M          $0             $634.3M            $28.7M




                                                                                 8