General Fund KPI

AID 1621786 · View on Simbli

Agenda Item

i. Acceptance of the January 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 January 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 1/31/2024 (Per 7 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.132               77.8%
                 Benchmark         $1.105               76.0%
                 Difference         $27M                 1.8%
                                                                                    74.9%
                                                                                                  24.4%
                                                                                                            .7%
                                                                  Revenue Sources
                                                                                    $847.6M
                                                                                                  $276.7M
                                                                                                            $7.7M
                                                                                                            Other
                                                                                                  State
                                                                                    Local




                                                                    FY2024
                                                               DCSD General Fund
                                                        YTD REVENUE Budget vs Collections
                1,000
                        $920.39
M i ll io n s




                 900
                                  $847.61
                 800
                 700
                 600
                                                                                                            $531.45
                                                                                                                                                    REVENUE BUDGET
                 500                                                                                                                                YTD ACTUALS
                                                                                                                                                    Series8
                 400
                 300                                                                                                  $276.72
                 200
                 100
                                                           $9.00 $7.54                                                                $1.43 $0.14
                   0
                                  LOCAL REVENUES                     INTEREST                                         STATE SOURCES   TRANSFERS AND OTHER LOCAL
                                                   (LOCAL & OTHER) Budgeted: $930,818,788 Actual: $855,300,813 91.89%
                                                       (STATE) Budgeted: $531,448,593 Actual: $276,721,732 52.07%
                                                      TOTAL Budgeted: $1,462,267,381 Actual: $1,132,022,545 77.42%
                                                                                              5
Microsoft Power BI




                        Amount Spent   Percentage of Budget (no encumbrances)
           Actual            $743.7                    50.3%
           Benchmark         $735.9                    49.8%
           Difference         -$7.8                    -.5%
                                                                                59.0%
                                                                                              12.3%
                                                                                                      6.4%
                                                        Significant Functions



                                                                                                      $47.5M
                                                                                $439M
                                                                                              $91.7

                                                                                                      Administration
                                                                                Instruction


                                                                                                      School
                                                                                              M&O




                                                             FY2024
                                                   DeKalb County School District
                                                  YTD Expense Actuals by Function
                                                                                                                       INSTRUCTION, 439,019,965 , 59.0%
                    TRANSFERS & OTHER        DEBT SERVICE, 0 , 0.0%
                 OUTLAYS, 1,000,000 , 0.1%
OTHER SUPPORT SERVICES,
     731,631 , 0.1%
ENTERPRISE OPERATIONS,
    375,198 , 0.1%
   SCHOOL NUTRITION
 PROGRAM, 4,799 , 0.0%
SUPPORT SERVICES - CENTRAL,
    19,814,116 , 2.7%
 STUDENT TRANSPORTATION
 SERVICE, 38,093,641 , 5.1%                                                                                                                PUPIL SERVICES,
                                                                                                                                          42,583,862 , 5.7%
      MAINTENANCE AND OPERATION,
           91,733,480 , 12.3%
                                                                                                                                     IMPROVEMENT OF
                                                                                                                                 INSTRUCTIONAL SERVICES,
                                                                                                                                      9,651,148 , 1.3%
              SUPPORT SERVICES -
           BUSINESS, 9,370,970 , 1.3%                                                                                      INSTRUCTIONAL STAFF
                                                                                                                          TRAINING, 17,366 , 0.0%
                                                                                                                                  EDUCATIONAL MEDIA
                           SCHOOL ADMINISTRATION,                                                                              SERVICES, 7,464,825 , 1.0%
                              47,475,481 , 6.4%
                                                                                                                           GENERAL ADMINISTRATION,
                                                                 GENERAL OPERATIONS YTD EXPENSES                              36,325,195 , 4.9%
                                                                           $743,661,679
                                                                                               3
Microsoft Power BI – General Fund FB




                        Unassigned FB   Designated FB   Total FB   Total $
         FY24 Actual         36%            15%          51%       $756.0
         FY23 Actual         35%            15%          50%
         Difference          0.0%           0.0%         0.0%