Monthly Budget Reports and Fund Analysis in May 2023
Explore detailed reports on cash and investments, monthly expenditures, revenue and expenses for May 2023, comparing year-to-date figures. Gain insights into the financial performance and fund balances for various funds, aiding decision-making and planning.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
AAPS MONTHLY BUDGET MONITORING REPORT MAY 2023 Presented to the Board of Education June 14, 2023
Comparison of Cash and Investments Report May 31, 2022 and May 31, 2023 Cash and Investments 5/31/22 $24,917,404 Cash and Investments 5/31/23 $19,808,072 Cash and Investments Change $(5,109,332) General Fund Community Services Fund 1,041,819 1,640,497 598,678 Food Service Fund 2,138,988 593,205 (1,545,783) Student/School Activity Fund 1,168,985 1,298,289 129,304 TOTAL $29,267,196 $23,340,063 $(5,927,133) 2 2023 Monthly Budget Monitoring Report June 14, 2023
Report of Monthly Expenditures for May 2023 General Fund $23,672,701 Community Services Fund 315,830 Food Service Fund 1,109,631 Student/School Activity Fund 151,468 TOTAL $25,249,630 3 2023 Monthly Budget Monitoring Report June 14, 2023
Comparison of Summary of All Funds Report YTD May 31, 2022 and May 31, 2023 Prior Income Statement Comparison Year-to-Date 2021-2022 Year-to-Date 2022-2023 Percent Changes Revenue General Fund $238,835,706 3,779,800 6,009,532 596,793 $249,221,831 $253,892,926 4,254,259 5,702,887 959,581 $264,809,653 $15,057,220 474,459 (306,645) 362,788 $15,587,822 6.3% 12.6% (5.1)% 60.8% 6.3% Community Services Fund Food Service Fund Student/School Activity Fund TOTAL Expenditures General Fund $237,127,740 3,494,545 4,072,682 673,065 $245,368,032 $249,669,923 3,928,915 5,058,245 857,994 259,515,077 $12,542,183 434,370 985,563 184,929 $14,147,045 5.3% 12.4% 24.2% 27.5% 5.8% Community Services Fund Food Service Fund Student/School Activity Fund TOTAL 4 2023 Monthly Budget Monitoring Report June 14, 2023
Comparison of Summary of All Funds Report YTD May 31, 2022 and May 31, 2023 (cont d) Income Statement Comparison Prior Year-to-Date 2022-2023 Percent Changes Year-to-Date 2021-2022 Addition (Reduction) to Fund Balance General Fund $1,707,966 285,255 1,936,850 (76,272) $3,853,799 $4,223,003 325,344 644,642 101,587 $5,294,576 147.3% 14.1% (66.7)% 33.2% 33.4% $2,515,037 40,089 (1,292,208) 25,315 $1,288,233 Community Services Fund Food Service Fund Student/School Activity Fund TOTAL Beginning Fund Balance General Fund Community Services Fund Food Service Fund Student/School Activity Fund $22,226,492 922,661 54,219 1,220,218 $24,423,590 $19,682,482 862,881 592,567 1,233,455 $22,371,385 $(2,544,010) (59,780) 538,348 13,237 $(2,052,205) (11.4)% (6.5)% 992.9% 1.1% (8.4)% TOTAL Ending Fund Balance General Fund Community Services Fund Food Service Fund Student/School Activity Fund $23,934,458 1,207,916 1,991,069 1,143,946 $28,277,389 $23,905,485 1,188,225 1,237,209 1,335,042 $27,665,961 $(28,973) (19,691) (753,860) 191,096 $(611,428) (0.1)% (1.6)% (37.9)% 16.7% -2.2% TOTAL 2023 Monthly Budget Monitoring Report June 14, 2023 5
Summary of All Funds Reports Revenues and Expenditures for Month Ending May 2023 Month- to-Date 2022-2023 Year- to-Date 2022-2023 Budget 2022-2023 Balance 2022-2023 YTD Percent Revenue General Fund $278,725,150 3,843,870 4,780,363 615,525 $287,964,908 $16,335,837 13,328 1,113,077 190,253 $17,652,495 $253,892,926 4,254,259 5,702,887 959,581 $264,809,653 $24,832,224 (410,389) (922,524) (344,056) $23,155,255 91.1% 110.7% 119.3% 155.9% 92.0% Community Services Fund Food Service Fund Student/School Activity Fund TOTAL Expenditures General Fund $282,418,909 3,843,870 4,780,363 615,525 $291,658,667 $23,672,701 315,830 1,109,631 151,468 $25,249,630 $249,669,923 3,928,915 5,058,245 857,994 $259,515,077 $32,748,986 (85,045) (277,882) (242,469) $32,143,590 88.4% 102.2% 105.8% 139.4% 89.0% Community Services Fund Food Service Fund Student/School Activity Fund TOTAL 6 2023 Monthly Budget Monitoring Report June 14, 2023
Summary of All Funds Reports Revenues and Expenditures for Month Ending May 2023 (cont d) Month- to-Date 2022-2023 Year- to-Date 2022-2023 Budget 2022-2023 Addition (Reduction) to Fund Balance General Fund $(3,693,759) $(7,336,864) (302,502) $4,223,003 325,344 644,642 101,587 $5,294,576 Community Services Fund Food Service Fund Student/School Activity Fund 0 0 0 3,446 (38,785) $(3,693,759) $(7,597,135) TOTAL Beginning Fund Balance General Fund Community Services Fund Food Service Fund Student/School Activity Fund $19,682,482 862,881 592,567 1,233,455 $22,371,385 $19,682,482 862,881 592,567 1,233,455 $22,371,385 TOTAL Ending Fund Balance General Fund Community Services Fund Food Service Fund Student/School Activity Fund $15,988,723 862,881 592,567 1,233,455 $18,677,626 $23,905,485 1,188,225 1,237,209 1,335,042 $27,665,961 TOTAL 7 2023 Monthly Budget Monitoring Report June 14, 2023
