General Fund KPI's - May 2024

AID 1637667 · View on Simbli

Agenda Item

i. Acceptance of the March 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 March 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 3/31/2024 (Per 9 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
Microsoft Power BI




                              Amount Collected   Percentage of Budget
                 Actual            $1.265               86.8%
                 Benchmark         $1.253               86.2%
                 Difference         $12M                 .6%
                                                         FY2024
                                                    DCSD General Fund
                                             YTD REVENUE Budget vs Collections

           1,000
Millions




                   $920.39

            900         $865.04


            800



            700
                                                                                                                                                      Revenue Sources
            600
                                                                 $524.47
                                                                                                                                              Local    $865.0M     68.4%
                                                                                                                             REVENUE BUDGET
            500                                                                                                              YTD ACTUALS
                                                                                                                             Series8
                                                                                                                                              State    $377.7M     29.9%
            400                                                       $377.71
                                                                                                                                              Other     $22.5M     1.8%
            300



            200


            100

                                        $9.00 $16.22                                         $1.65 $6.15           $1.43 $0.15
              0

                       LOCAL REVENUES           INTEREST              STATE SOURCES             FEDERAL SOURCES   TRANSFERS AND OTHER LOCAL

                                        (LOCAL & OTHER) Budgeted: $932,468,788 Actual: $887,559,626 95.18%
                                            (STATE) Budgeted: $524,472,714 Actual: $377,707,869 72.02%
                                           TOTAL Budgeted: $1,456,941,502 Actual: $1,265,267,495 86.84%
Microsoft Power BI




                        Amount Spent   Percentage of Budget (no encumbrances)
           Actual            $994.2                    67.2%
           Benchmark         $998.0                    67.6%
           Difference         -$3.8                     -.4%
                                                             FY2024
                                                   DeKalb County School District
                                                  YTD Expense Actuals by Function


                                                                                              INSTRUCTION, 602,526,905 , 60.6%


                 TRANSFERS & OTHER        DEBT SERVICE, 0 , 0.0%
              OUTLAYS, 1,500,000 , 0.2%
OTHER SUPPORT SERVICES,
    1,026,717 , 0.1%
ENTERPRISE OPERATIONS,
                                                                                                                                           Significant Functions
                                                                                                                                    Instruction      $602.5M       60.6%
    529,615 , 0.1%

   SCHOOL NUTRITION
 PROGRAM, 4,799 , 0.0%
                                                                                                                                    M&O              $116.8M       11.8%
SUPPORT SERVICES ‐ CENTRAL,
    25,175,912 , 2.5%
                                                                                                                                    School            $61.5M       6.2%
STUDENT TRANSPORTATION
                                                                                                                 PUPIL SERVICES,
                                                                                                                57,166,458 , 5.7%
                                                                                                                                    Administration
SERVICE, 52,381,333 , 5.3%


         MAINTENANCE AND OPERATION,                                                                        IMPROVEMENT OF
             116,843,054 , 11.8%                                                                       INSTRUCTIONAL SERVICES,
                                                                                                           12,315,080 , 1.2%

                     SUPPORT SERVICES ‐                                                          INSTRUCTIONAL STAFF
                 BUSINESS, 12,254,690 , 1.2%                                                    TRAINING, 47,770 , 0.0%
                                                                                                        EDUCATIONAL MEDIA
                                                                                                     SERVICES, 10,322,101 , 1.0%
                                  SCHOOL ADMINISTRATION,
                                     61,532,619 , 6.2%
                                                                                                          GENERAL ADMINISTRATION,
                                                            GENERAL OPERATIONS YTD EXPENSES                  40,584,852 , 4.1%
                                                                      $994,211,906
Microsoft Power BI – General Fund FB




                        Unassigned FB   Designated FB   Total FB   Total $
         FY24 Actual        26.8%           15%         41.8%      $638.9
         FY23 Actual        25.3%           15%         40.3%
         Difference          1.5%           0.0%         1.5%