General Fund KPI's - April 2024 Final

AID 1653234 · View on Simbli

Agenda Item

i. Acceptance of the April 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 April 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 4/30/2024 (Per 10 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.333               91.5%
                 Benchmark         $1.338               92.1%
                                                                        3
                 Difference         -$5M                 -.6%
                                                         FY2024
                                                    DCSD General Fund
                                             YTD REVENUE Budget vs Collections

           1,000
Millions




                   $920.39

            900         $880.15



            800



            700
                                                                                                                                                      Revenue Sources
                                                                                                                                              Local    $880.2M     66.0%
            600
                                                                 $524.47
                                                                                                                             REVENUE BUDGET
            500
                                                                      $428.03
                                                                                                                             YTD ACTUALS
                                                                                                                             Series8
                                                                                                                                              State    $428.0M     32.1%
            400
                                                                                                                                              Other     $22.5M     1.9%
            300



            200



            100

                                        $9.00 $18.79                                         $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: $905,266,226 97.08%
                                            (STATE) Budgeted: $524,472,714 Actual: $428,029,516 81.61%
                                           TOTAL Budgeted: $1,456,941,502 Actual: $1,333,295,741 91.51%
                                                                                                                                                                    4
                                                                       5
Microsoft Power BI




                        Amount Spent   Percentage of Budget (no encumbrances)
           Actual            $1,108                    75.2%
           Benchmark         $1,140                    77.2%
                                                                                5
           Difference        -$32.3                     -2%
                                                                FY2024
                                                      DeKalb County School District
                                                     YTD Expense Actuals by Function


                                                                                                   INSTRUCTION, 682,164,422 , 61.5%


                 TRANSFERS & OTHER           DEBT SERVICE, 0 , 0.0%
              OUTLAYS, 1,500,000 , 0.1%
OTHER SUPPORT SERVICES,
    1,122,881 , 0.1%
ENTERPRISE OPERATIONS,
                                                                                                                                             Significant Functions
    519,970 , 0.0%
                                                                                                                                      Instruction      $682.2M       61.5%
   SCHOOL NUTRITION
 PROGRAM, 4,799 , 0.0%
                                                                                                                                      M&O              $126.2M       11.4%
                                                                                                                                      School            $67.4M       6.1%
SUPPORT SERVICES ‐ CENTRAL,
    26,649,588 , 2.4%

STUDENT TRANSPORTATION
                                                                                                                  PUPIL SERVICES,
                                                                                                                 64,135,393 , 5.8%
                                                                                                                                      Administration
SERVICE, 57,770,463 , 5.2%


         MAINTENANCE AND OPERATION,                                                                         IMPROVEMENT OF
             126,199,872 , 11.4%                                                                        INSTRUCTIONAL SERVICES,
                                                                                                            13,386,327 , 1.2%
                   SUPPORT SERVICES ‐                                                             INSTRUCTIONAL STAFF
               BUSINESS, 13,344,811 , 1.2%                                                       TRAINING, 54,638 , 0.0%
                                                                                                         EDUCATIONAL MEDIA
                                SCHOOL ADMINISTRATION,                                                SERVICES, 11,652,894 , 1.1%
                                   67,380,790 , 6.1%
                                                                                                       GENERAL ADMINISTRATION,
                                                               GENERAL OPERATIONS YTD EXPENSES            42,546,909 , 3.8%
                                                                        $1,108,433,757
                                                                                                                                                               6
                                                                          3
Microsoft Power BI – General Fund FB




                        Unassigned FB   Designated FB   Total FB   Total $
         FY24 Actual        23.7%           15%         38.7%      $592.7
         FY23 Actual        21.9%           15%         36.9%
                                                                             7
         Difference          1.8%           0.0%         1.8%