General Fund KPI's - July 2024

AID 1665984 · View on Simbli

Agenda Item

i. Acceptance of the May 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 May 2024 Monthly Financial Report.
Contact: Mr. Byron Schueneman, Chief Financial Officer, Division of Finance, 678.676.0270
Status: General Counsel approval not required
GF Key Performance Indicators
As of 5/31/2024 (Per 11 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.39               95.5%
                 Benchmark          $1.41               97.3%
                                                                        3
                 Difference        -$14M                -1.8%
                                                         FY2024
                                                    DCSD General Fund
                                             YTD REVENUE Budget vs Collections

           1,000
Millions




                   $920.39

                        $888.65
            900


            800




                                                                                                                                                      Revenue Sources
            700



            600
                                                                                                                                              Local    $888.6M     63.7%
                                                                 $528.35

                                                                                                                                              State    $478.6M     34.3%
                                                                                                                             REVENUE BUDGET
            500                                                       $478.58
                                                                                                                             YTD ACTUALS
                                                                                                                             Series8

            400                                                                                                                               Other     $26.8M     1.9%
            300



            200


            100

                                        $9.00 $21.35                                         $1.65 $6.15           $1.43 $0.18
              0

                       LOCAL REVENUES           INTEREST              STATE SOURCES             FEDERAL SOURCES   TRANSFERS AND OTHER LOCAL

                                        (LOCAL & OTHER) Budgeted: $932,468,788 Actual: $916,328,238 98.27%
                                            (STATE) Budgeted: $528,349,554 Actual: $478,577,397 90.58%
                                           TOTAL Budgeted: $1,460,818,342 Actual: $1,394,905,636 95.49%                                                             4
                                                                       5
Microsoft Power BI




                        Amount Spent   Percentage of Budget (no encumbrances)
           Actual            $1,232                    83.6%
           Benchmark         $1,270                    86.0%
                                                                                5
           Difference        -$38M                     -2.4%
                                                               FY2024
                                                     DeKalb County School District
                                                    YTD Expense Actuals by Function


                                                                                                   INSTRUCTION, 763,389,383 , 61.9%


                TRANSFERS & OTHER           DEBT SERVICE, 0 , 0.0%
            OUTLAYS, 1,530,000 , 0.1%
OTHER SUPPORT SERVICES,
   1,265,037 , 0.1%
ENTERPRISE OPERATIONS,
                                                                                                                                             Significant Functions
    545,511 , 0.0%
                                                                                                                                      Instruction      $764.4M       61.9%
   SCHOOL NUTRITION
 PROGRAM, 4,799 , 0.0%
                                                                                                                                      M&O              $137.7M       11.2%
                                                                                                                                      School            $74.4M       6.0%
SUPPORT SERVICES ‐ CENTRAL,
    29,748,541 , 2.4%

STUDENT TRANSPORTATION                                                                                           PUPIL SERVICES,      Administration
SERVICE, 64,259,922 , 5.2%                                                                                      72,222,141 , 5.9%


        MAINTENANCE AND OPERATION,                                                                         IMPROVEMENT OF
            137,719,606 , 11.2%                                                                        INSTRUCTIONAL SERVICES,
                                                                                                           14,891,318 , 1.2%
                  SUPPORT SERVICES ‐                                                             INSTRUCTIONAL STAFF
              BUSINESS, 14,840,137 , 1.2%                                                       TRAINING, 54,888 , 0.0%
                                                                                                       EDUCATIONAL MEDIA
                              SCHOOL ADMINISTRATION,                                                SERVICES, 12,984,897 , 1.1%
                                 74,433,964 , 6.0%
                                                                                                    GENERAL ADMINISTRATION,
                                                              GENERAL OPERATIONS YTD EXPENSES          44,505,279 , 3.6%
                                                                       $1,232,395,423

                                                                         3
                                                                                                                                                               6
Microsoft Power BI – General Fund FB




                        Unassigned FB   Designated FB   Total FB   Total $
         FY24 Actual        19.4%           15%         34.4%      $530.3
         FY23 Actual        17.6%           15%         32.6%
                                                                             7
         Difference          1.8%           0.0%         1.8%