Monthly Budget Monitoring and Expenditures Report Analysis Jan 2023
"Analyzing cash and investments, expenditures, and fund balances for January 2023, this report provides insights into the financial performance of the educational institution, aiding in strategic decision-making. Explore the detailed comparison of funds and changes over time to gain a comprehensive understanding of the financial landscape."
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 JANUARY 2023 Presented to the Board of Education March 8, 2023
Comparison of Cash and Investments Report January 31, 2022 and January 31, 2023 Cash and Investments 1/31/22 $32,659,833 Cash and Investments 1/31/23 $34,994,529 Cash and Investments Change $2,334,696 General Fund Community Services Fund 142,421 1,268,539 1,126,118 Food Service Fund 1,037,614 168,468 (869,146) Student/School Activity Fund 1,221,081 1,350,506 129,425 TOTAL $35,060,949 $37,782,042 $2,721,093 2 2023 Monthly Budget Monitoring Report March 8, 2023
Report of Monthly Expenditures for January 2023 General Fund $21,639,271 Community Services Fund 248,534 Food Service Fund 432,088 Student/School Activity Fund 36,169 TOTAL $22,356,062 3 2023 Monthly Budget Monitoring Report March 8, 2023
Comparison of Summary of All Funds Report YTD January 31, 2022 and January 31, 2023 Prior Income Statement Comparison Year-to-Date 2021-2022 Year-to-Date 2022-2023 Percent Changes Revenue General Fund $146,640,907 2,081,339 3,127,662 299,949 $152,149,857 $156,754,963 2,431,145 1,389,746 451,041 $161,026,895 $10,114,056 349,806 (1,737,916) 151,092 $8,877,038 6.9% 16.8% (55.6)% 50.4% 5.8% Community Services Fund Food Service Fund Student/School Activity Fund TOTAL Expenditures General Fund $141,082,942 2,263,564 2,542,707 310,226 $146,199,439 $143,665,157 2,520,879 2,858,277 334,245 $149,378,558 $2,582,215 257,315 315,570 24,019 $3,179,119 1.8% 11.4% 12.4% 7.7% 2.2% Community Services Fund Food Service Fund Student/School Activity Fund TOTAL 4 2023 Monthly Budget Monitoring Report March 8, 2023
Comparison of Summary of All Funds Report YTD January 31, 2022 and January 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 $5,557,965 (182,225) 584,955 (10,277) $5,950,418 $13,089,806 (89,734) (1,468,531) 116,796 $11,648,337 (135.5)% 50.8% (351.1)% (1236.5)% 95.8% $7,531,841 92,491 (2,053,486) 127,073 $5,697,919 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 $27,784,457 740,436 639,174 1,209,941 $30,374,008 $32,772,288 773,147 (875,964) 1,350,251 $34,019,722 $4,987,831 32,711 (1,515,138) 140,310 $3,645,714 18.0% 4.4% (237.0)% 11.6% 12.0% TOTAL 2023 Monthly Budget Monitoring Report March 8, 2023 5
Summary of All Funds Reports Revenues and Expenditures for Month Ending January 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 $44,674,111 135,738 335,152 33,602 $45,178,603 $156,754,963 2,431,145 1,389,746 451,041 $161,026,895 $121,970,187 1,412,725 3,390,617 164,484 $126,938,013 56.2% 63.2% 29.1% 73.3% 55.9% 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 $21,639,271 248,534 432,088 36,169 $22,356,062 $143,665,157 2,520,879 2,858,277 334,245 $149,378,558 $138,753,752 1,322,991 1,922,086 281,280 $142,280,109 50.9% 65.6% 59.8% 54.3% 51.2% Community Services Fund Food Service Fund Student/School Activity Fund TOTAL 6 2023 Monthly Budget Monitoring Report March 8, 2023
Summary of All Funds Reports Revenues and Expenditures for Month Ending January 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) $23,034,840 (112,796) (96,936) (2,567) $22,822,541 $13,089,806 (89,734) (1,468,531) 116,796 $11,648,337 Community Services Fund Food Service Fund Student/School Activity Fund 0 0 0 $(3,693,759) 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 $32,772,288 773,147 (875,964) 1,350,251 $34,019,722 TOTAL 7 2023 Monthly Budget Monitoring Report March 8, 2023
