Document type | other |
---|---|
Date | 2024-01-31 |
Source URL | https://go.boarddocs.com/wv/rand/Board.nsf/files/D28MHM5AB9DE/$file/Monthly%20Financial%20Report%20January%202024.pdf |
Entity | randolph_county_schools (Randolph Co., WV) |
Entity URL | https://boe.rand.k12.wv.us/ |
Raw filename | Monthly%20Financial%20Report%20January%202024.pdf |
Stored filename | 2024-01-31-52e18359875e72d327535771c80c84c7-other.txt |
Parent document: Regular Board Meeting - 5_30 p.m.-02-20-2024.pdf
RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Monthly Financial Report on a Cash Basis for January, 2024 es West Virginia perarrMent oF EDUCATION 2/7/2024 11:16:31 AM - 7108 2/7/2024 11:16:31 AM - 7108 Fund: General Current Expense Fund Debt Service Fund Capital Projects Fund Special Revenue Fund Federal Stimulus and Stabilization Fund Total Revenues Fund: General Current Expense Fund Bond Construction Fund Capital Projects Fund Special Revenue Fund Federal Stimulus and Stabilization Fund Total Expenditures RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Summary Schedule of Revenues and Expenditures on a Cash Basis For the Month Ended January, 2024 MTD Revenues 2,319,893 0 0 249,788 1,454,748 4,024,429 MTD Expenditures 3,088,822 0 146,737 678,929 237,686 4,152,174 YTD Revenues 22,302,545 0 242,563 5,769,558 4,065,915 32,380,581 YTD Expenditures 18,110,003 0 1,408,435 4,291,496 1,784,732 25,594,667 Beginning Fund Balance oO1o oO OG &2 28 Encumbrances 15,995,894 0 916,621 4,776,497 1,431,408 23,120,421 Current Annual Budget 43,337,375 0 2,298,344 15,493,772 7,469,477 68,598,968 Current Annual Budget 43,337,375 0 2,268,203 12,740,385 4,950,120 63,296,082 2/7/2024 11:16:31 AM - 7108 Remaining Balance (21,034,830) 0 (2,055,781) (9,724,214) (3,403,562) (36,218,388) Remaining Balance 9,231,478 0 (56,853) 3,672,391 1,733,980 14,580,995 Percent Revenues Received 51.46% 0.00% 10.55% 37.24% 54.43% 47.20% Percent Budget Obligated 78.70% 0.00% 102.51% 71.18% 64.97% 76.96% Prior Year YTD Change Revenues From Prior Yr. 20,900,864 1,401,681 35,000 (35,000) 0 242,563 4,505,747 1,263,811 4,486,551 (420,636) 29,928,162 2,452,419 Prior Year YTD Change Expenditures From Prior Yr. 16,776,129 0 1,228,954 4,126,573 2,638,378 24,770,034 1,333,874 0 179,481 164,924 (853,647) 824,632 Fund Balance Revenue from Local Sources Property Taxes - All Other Collections Revenue from Local Sources-Public Utilities Tax Loss Restoration Fund Property Taxes - Current Year Revenue from Local Sources-From Other Government Units-Restricted-Refunds of Revenue Revenue from Local Sources-Transportation Fees from Other Sources Investment Earnings Other Local Revenues Revenue from State Sources State Aid to Schools Other State Sources Revenue from Federal Sources Medicaid Other Federal Sources Revenue from Miscellaneous Sources Fund Transfers In Other Miscellaneous Sources Total Revenues RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Revenues on a Cash Basis General Current Expense Fund For the Month Ended January, 2024 Beginning Current MTD YTD Fund Annual Revenues Revenues Balance Budget 0 0 0 4,348,027 32,091 64,707 0 60,000 36 755,621 0 0 140,543 5,386,888 0 8,835,387 9,680 22,594 0 30,000 0 5,946 0 0 0 1,160 0 4,000 6,620 107,934 0 80,000 1,356,398 10,218,988 0 19,918,521 770,756 5,446,722 0 9,360,440 3,769 47,683 0 150,000 0 225,895 0 200,000 0 6,007 0 351,000 0 12,401 0 0 2,319,893 22,302,545 0 43,337,375 2/7/2024 11:16:31 AM - 7108 Remaining Balance (4,348,027) 4,707 755,621 (3,448,499) (7,406) 5,946 (2,840) 27,934 (9,699,533) (3,913,719) (102,317) 25,895 (344,993) 12,401 (21,034,830) Percent Revenues Received 0.00% 107.84% 0.00% 60.97% 75.31% 0.00% 29.00% 134.92% 51.30% 58.19% 31.79% 112.95% 1.71% 0.00% 51.46% Prior Year YTD C hange Revenues From prior Yr. 50,235 0 6,043,501 12,463 2,956 3,851 87,624 9,300,656 5,120,841 28,852 250,041 245 20,900,864 14,472 755,621 (656,613) 10,131 3,391 (2,690) 20,309 918,332 325,880 18,832 (24,146) 5,/62 12,401 1,401,681 RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Expenditures on a Cash Basis General Current Expense Fund For the Month Ended January, 2024 2/7/2024 11:16:31 AM - 7108 Current Percent Prior Year MTD YTD Annual Remaining Budget YTD Change Expenditures Expenditures Encumbrances Budget Balance Obligated § Expenditures From prior Yr. Salaries Professional Personnel 1,265,264 6,687,890 8,327,344 14,802,186 (213,048) 101.44% 6,193,954 493,937 Service Personnel 407,903 2,276,796 2,387,183 4,738,686 74,706 98.42% 1,955,345 321,451 Professional Substitutes 68,972 439,556 0 905,000 465,444 48.57% 425,462 14,094 Service Substitutes 15,265 130,668 0 235,000 104,332 55.60% 99,997 30,671 Temporary Part-Time Professional 0 360 0 0 (360) 0.00% 0 360 Board Members 1,280 9,120 0 30,000 20,880 30.40% 13,280 (4,160) Employee Benefits Group Insurance 259,708 1,277,671 1,786,246 3,282,572 218,656 93.34% 1,011,949 265,721 Social Security 128,188 697,497 774,774 1,444,794 (27,477) 101.90% 639,482 58,015 Retirement 469,502 3,127,244 838,970 5,739,220 1,773,006 69.11% 3,204,528 (77,285) Tuition Reimbursements 35 280 0 0 (280) 0.00% 0 280 Unemployment Compensation 81 3,811 0 10,500 6,689 36.29% 4,987 (1,177) Workers' Compensation 7,113 40,119 40,447 113,846 33,279 70.77% 38,222 1,897 Purchased Professional & Technical Services Professional Educators 0 18,610 30,000 40,000 (8,610) 121.53% 18,903 (292) Employee Training and Development 0 408 2,650 8,500 5,442 35.98% 5,620 (5,212) Other Professional 38,068 208,854 241,068 704,000 254,078 63.91% 253,403 (44,548) Technical 0 8,033 6,968 0 (15,000) 0.00% 0 8,033 Purchased Services - Other (Water/Sewage) Utilities (Water/Sewage) 16,787 94,269 0 162,000 67,731 58.19% 74,241 20,029 Cleaning 8,263 55,700 5,519 72,000 10,780 85.03% 46,810 8,890 Repair & Maintenance 49,724 137,908 44,919 356,000 173,173 51.36% 62,459 75,449 Rentals 3,509 8,643 9,452 8,000 (10,095) 226.18% 5,452 3,191 Construction Services 0 62,725 0 117,724 54,999 53.28% 0 62,725 Purchased Services - Other Student Transportation Services Insurance Communications Advertising Printing/Binding Tuition Travel Interagency Purchased Services Supplies General Energy Books, Periodicals and Software Technology Supplies Vehicle Supplies Control Level Equipment Plant and Equipment Equipment Bus Replacement Other Dues and Fees Debt Related Reserved Miscellaneous Transfers Out Total Expenditures RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Expenditures on a Cash Basis General Current Expense Fund For the Month Ended January, 2024 Current MTD YTD Annual Expenditures Expenditures Encumbrances Budget 0 690 2,250 5,000 5,641 263,353 143,886 491,500 4,612 30,388 151,764 140,200 77 2,957 7,160 4,900 0 13 0 356 3,885 3,885 0 15,000 3,063 22,411 3,777 94,750 6,285 44,512 34,664 192,705 31,158 544,242 123,700 727,555 116,050 579,936 0 1,320,000 7,493 43,436 0 485,167 1,787 137,537 5,912 302,318 61,576 312,763 249,275 600,500 0 0 0 10,000 0 12,908 32,206 20,000 0 0 719,958 683,706 835 86,961 5,377 25,000 0 11,500 20,167 0 0 0 0 4,030,547 0 11,000 258 0 106,699 715,349 0 1,418,145 3,088,822 18,110,003 15,995,894 43,337,375 2/7/2024 11:16:31 AM - 7108 Remaining Balance 2,060 84,261 (41,952) (5,217) 343 11,115 68,562 113,528 59,613 740,064 441,730 158,869 38,461 10,000 (25,114) (36,252) (67,338) (31,667) 4,030,547 (11,258) 702,796 9,231,478 Percent Budget Obligated 58.80% 82.86% 129.92% 206.47% 3.52% 25.90% 27.64% 41.09% 91.81% 43.93% 8.95% 47.45% 93.60% 0.00% 225.57% 105.30% 369.35% 0.00% 0.00% 0.00% 50.44% 78.70% Prior Year YTD Change Expenditures From prior Yr. 1,067 (378) 139,070 124,283 43,827 (13,439) 3,447 (490) 0 13 7,088 (3,202) 5,605 16,806 37,692 6,820 368,347 175,895 549,878 30,058 374,543 (331,106) 51,655 85,882 359,489 (46,725) 0 0 17,698 (4,790) 101,993 (101,993) 5,706 81,255 15,333 (3,833) 0 0 11,000 0 628,598 86,751 16,776,129 1,333,874 Revenue from Local Sources Investment Earnings Revenue from Miscellaneous Sources Fund Transfers In Total Revenues RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Revenues on a Cash Basis Debt Service Fund For the Month Ended January, 2024 Beginning Current MTD YTD Fund Annual Remaining Revenues Revenues Balance Budget Balance 0 0 0 0 0 0 0 0 0 0 0 0 2/7/2024 11:16:31 AM - 7108 Percent Revenues Received 0.00% 0.00% 0.00% Prior Year YTD Revenues 35,000 35,000 Change From prior Yr. (35,000) (35,000) Purchased Services - Other (Water/Sewage) Construction Services Total Expenditures RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Expenditures on a Cash Basis Bond Construction Fund For the Month Ended January, 2024 Current MTD YTD Annual Remaining Expenditures Expenditures Encumbrances Budget Balance 0 0 0 0 0 0 0 0 2/7/2024 11:16:31 AM - 7108 Percent Budget Obligated 0.00% 0.00% Prior Year YTD Change Expenditures From prior Yr. Fund Balance Revenue from Local Sources Other Local Revenues Revenue from Miscellaneous Sources Fund Transfers In Total Revenues RANDOLPH COUNTY SCHOOLS CENTRAL OFC. MTD Revenues Schedule of Revenues on a Cash Basis Capital Projects Fund For the Month Ended January, 2024 Beginning Current YTD Fund Annual Revenues Balance Budget 0 0 0 2,024,203 0 274,141 0 274,141 0 (31,578) 0 0 0 242,563 0 2,298,344 2/7/2024 11:16:31 AM - 7108 Remaining Balance (2,024,203) (31,578) (2,055,781) Percent Revenues Received 0.00% 100.00% 0.00% 10.55% Prior Year YTD Change Revenues From prior Yr. 0 0 0 274,141 (31,578) 242,563 Purchased Professional & Technical Services Other Professional Purchased Services - Other (Water/Sewage) Construction Services Purchased Services - Other Insurance Advertising Plant and Equipment Equipment Other Reserved Total Expenditures RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Expenditures on a Cash Basis Capital Projects Fund For the Month Ended January, 2024 Current MTD YTD Annual Expenditures Expenditures Encumbrances Budget 1,942 18,449 12,926 96,155 144,795 1,389,986 817,272 2,172,048 0 0 0 0 0 0 0 0 0 0 86,423 0 0 0 0 0 146,737 1,408,435 916,621 2,268,203 2/7/2024 11:16:31 AM - 7108 Remaining Balance 64,780 (35,210) (86,423) (56,853) Percent Budget Obligated 32.63% 101.62% 0.00% 0.00% 0.00% 0.00% 102.51% Prior Year YTD Change Expenditures From prior Yr. 5,972 1,222,947 435 1,228,954 12,877 167,040 (435) 179,481 RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Revenues on a Cash Basis Special Revenue Fund For the Month Ended January, 2024 Beginning Current Percent Prior Year MTD YTD Fund Annual Remaining Revenues YTD Change Revenues Revenues Balance Budget Balance Received Revenues From prior Yr. Fund Balance 0 0 0 3,207,286 (3,207,286) 0.00% 0 0 Revenue from Local Sources Property Taxes - All Other Collections (27) (27) 0 0 (27) 0.00% 0 (27) Revenue from Local Sources-From Other 0 3,717 0 0 3,717 0.00% 0 3,717 Government Units-Restricted-Refunds of Revenue Revenue from Local Sources-Food Service 0 7,074 0 23,760 (16,686) 29.77% 5,520 1,554 Non-Reimbursable Progs-Daily Sales—Breakfast & Lunch Prog Revenue from Local Sources-Food Service 0 0 0 3,413 (3,413) 0.00% 0 0 Non-Reimbursable Programs-Daily Sales-A la Carte Other Local Revenues 0 3,750 0 0 3,750 0.00% 4,054 (304) Revenue from State Sources Other State Sources 143,115 1,242,851 0 1,639,611 (396,760) 75.80% 1,259,792 (16,940) 2/7/2024 11:16:31 AM - 7108 RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Revenues on a Cash Basis Special Revenue Fund For the Month Ended January, 2024 Beginning Current Percent Prior Year MTD YTD Fund Annual Remaining Revenues YTD Change Revenues Revenues Balance Budget Balance Received Revenues From prior Yr. Revenue from Federal Sources Federal thru State Restricted 0 2,763,532 0 7,484,435 (4,720,903) 36.92% 1,059,380 1,704,152 Rev from Fed Srcs-Reimbs for Food Serv Progs 0 590,669 0 208,300 382,369 283.57% 610,213 (19,543) (Use Project Code 88)-Lunch Prog Rev from Fed Srcs-Reimbs for Food Serv Progs 0 387,820 0 682,728 (294,908) 56.80% 971,578 (583,759) (Use Project Code 88)-Breakfast Prog Rev from Fed Srcs-Reimbs for Food Serv Progs 0 22,082 0 0 22,082 0.00% 0 22,082 (Use Project Code 88)-Summer Meals Prog (Sect 13) Rev from Fed Srcs-Reimbs for Food Serv Progs 0 1,197 0 3,334 (2,137) 35.90% 1,612 (416) (Use Project Code 88)-After School Hours Snack Prog Rev from Fed Srcs-Reimbs for Food Serv Progs 0 0 0 822,761 (822,761) 0.00% 0 0 (Use Project Code 88) Revenue from Miscellaneous Sources Fund Transfers In 106,699 746,893 0 1,418,145 (671,252) 52.67% 593,598 153,295 Total Revenues 249,788 5,769,558 0 15,493,772 (9,724,214) 37.24% 4,505,747 1,263,811 2/7/2024 11:16:31 AM - 7108 RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Expenditures on a Cash Basis Special Revenue Fund For the Month Ended January, 2024 2/7/2024 11:16:31 AM - 7108 Current Percent Prior Year MTD YTD Annual Remaining Budget YTD Change Expenditures Expenditures Encumbrances Budget Balance Obligated § Expenditures From prior Yr. Salaries Professional Personnel 249,212 1,367,688 1,390,282 2,453,974 (303,995) 112.39% 1,169,140 198,547 Service Personnel 103,504 573,693 721,570 1,306,566 11,303 99.13% 575,844 (2,151) Professional Substitutes 7,351 57,332 150 15,202 (42,279) 378.11% 121,392 (64,060) Service Substitutes 7,633 34,854 0 90,300 55,446 38.60% 35,150 (295) Temporary Part-Time Professional 0 2,160 0 3,382 1,222 63.87% 0 2,160 Employee Benefits Group Insurance 54,450 275,059 386,374 542,149 (119,284) 122.00% 222,826 52,233 Social Security 26,733 148,605 152,399 204,031 (96,974) 147.53% 139,393 9,213 Retirement 26,805 148,482 160,308 213,303 (95,487) 144.77% 125,657 22,825 Tuition Reimbursements 0 1,510 571 31,474 29,393 6.61% 667 843 Unemployment Compensation 0 0 0 1,500 1,500 0.00% 0 0 Workers' Compensation 2,068 11,285 13,644 22,462 (2,467) 110.98% 11,102 183 Purchased Professional & Technical Services Administration 0 0 0 0 0 0.00% 0 0 Professional Educators 0 20,920 8,800 60,318 30,598 49.27% 17,859 3,062 Employee Training and Development 0 18,191 75 85,761 67,495 21.30% 46,090 (27,899) Other Professional 28,890 75,561 44,690 189,482 69,231 63.46% 17,799 57,762 Technical 0 0 0 0 0 0.00% 129,113 (129,113) Purchased Services - Other (Water/Sewage) Repair & Maintenance 436 13,170 33,480 28,036 (18,614) 166.39% 2,226 10,944 Rentals 0 0 560 0 (560) 0.00% 13,625 (13,625) Construction Services 1,200 1,200 8,800 0 (10,000) 0.00% 13,623 (12,423) Purchased Services - Other Student Transportation Services Advertising Printing/Binding Tuition Travel Interagency Purchased Services Supplies General Food Books, Periodicals and Software Technology Supplies Vehicle Supplies Control Level Equipment Plant and Equipment Equipment Other Dues and Fees Reserved Miscellaneous Transfers Out Extraordinary Items Total Expenditures RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Expenditures on a Cash Basis Special Revenue Fund For the Month Ended January, 2024 Current MTD YTD Annual Remaining Expenditures Expenditures Encumbrances Budget Balance 0 0 0 6,000 6,000 0 1,616 0 4,000 2,384 0 10,636 0 17,084 6,448 0 0 0 6,000 6,000 1,163 44,036 709 109,755 65,009 2,741 2,741 9,500 3,000 (9,241) 12,144 211,115 146,096 1,194,541 837,330 110,833 949,013 1,674,151 1,969,705 (653,458) 0 13,704 290 45,501 31,507 0 21,239 0 555,639 534,400 0 84 938 5,000 3,978 13,244 91,040 19,327 91,297 (19,069) 30,522 79,920 2,900 116,628 33,809 0 4,026 884 368,576 363,666 0 110,500 0 2,947,877 2,837,377 0 0 0 27,696 27,696 0 299 0 24,144 23,845 0 1,818 0 0 (1,818) 678,929 4,291,496 4,776,497 12,740,385 3,672,391 2/7/2024 11:16:31 AM - 7108 Percent Budget Obligated 0.00% 40.40% 62.26% 0.00% 40.77% 408.05% 29.90% 133.18% 30.75% 3.82% 20.44% 120.89% 71.01% 1.33% 3.75% 0.00% 1.24% 0.00% 71.18% Prior Year YTD Change Expenditures From prior Yr. 0 715 537 22,690 22,125 1,400 178,521 939,298 23,024 34,859 0 68,909 75,825 5,503 110,300 0 245 1,114 4,126,573 0 901 10,098 (22,690) 21,911 1,341 32,595 9,714 (9,321) (13,620) 84 22,131 4,095 (1,477) 200 0 54 704 164,924 Fund Balance Revenue from Federal Sources Federal thru State Restricted Total Revenues RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Revenues on a Cash Basis Federal Stimulus and Stabilization Fund For the Month Ended January, 2024 Beginning Current Percent MTD YTD Fund Annual Remaining Revenues Revenues Revenues Balance Budget Balance Received 0 0 0 0 0 0.00% 1,454,748 4,065,915 0 7,469,477 (3,403,562) 54.43% 1,454,748 4,065,915 0 7,469,477 (3,403,562) 54.43% 2/7/2024 11:16:31 AM - 7108 Prior Year YTD Revenues 4,486,551 4,486,551 Change From prior Yr. (420,636) (420,636) Salaries Professional Personnel Service Personnel Professional Substitutes Service Substitutes Temporary Part-Time Professional Employee Benefits Group Insurance Social Security Retirement Tuition Reimbursements Workers' Compensation Purchased Professional & Technical Services Professional Educators Employee Training and Development Other Professional Purchased Services - Other (Water/Sewage) Repair & Maintenance Rentals Construction Services RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Expenditures on a Cash Basis Federal Stimulus and Stabilization Fund For the Month Ended January, 2024 Current MTD Expenditures 161,215 0 8,/89 0 0 22,160 12,276 12,154 0 313 3,884 7,481 YTD Expenditures 918,613 31,591 76,416 0 7,560 117,407 75,987 71,079 0 2,208 6,191 68,310 13,827 60,181 250 156,914 Encumbrances 968,994 0 0 0 0 155,109 69,416 72,673 0 1,783 1,000 56,010 17,038 41 2,756 Annual Budget 1,904,422 8,452 0 0 0 316,962 128,335 132,695 0 3,291 4,670 0 99,019 60,223 0 159,671 2/7/2024 11:16:31 AM - 7108 Remaining Balance 16,815 (23,138) (76,416) 0 (7,560) 44,446 (16,668) (11,057) 0 (700) (2,521) (124,320) 68,154 0 (250) 0 Percent Budget Obligated 99.12% 373.76% 0.00% 0.00% 0.00% 85.98% 112.99% 108.33% 0.00% 121.27% 153.98% 0.00% 31.17% 100.00% 0.00% 100.00% Prior Year YTD Change Expenditures From prior Yr. 1,181,149 116,064 31,779 6,299 15,645 146,691 99,232 96,186 200 2,807 1,400 224,649 118,311 0 0 20,674 (262,536) (84,473) 44,637 (6,299) (8,085) (29,284) (23,646) (25,107) (200) (598) 4,791 (156,339) (104,484) 60,181 250 136,241 Purchased Services - Other Student Transportation Services Communications Travel Interagency Purchased Services Supplies General Food Books, Periodicals and Software Technology Supplies Vehicle Supplies Control Level Equipment Plant and Equipment Buildings Equipment Other Miscellaneous Transfers Out Total Expenditures RANDOLPH COUNTY SCHOOLS CENTRAL OFC. Schedule of Expenditures on a Cash Basis Federal Stimulus and Stabilization Fund For the Month Ended January, 2024 Current MTD YTD Annual Expenditures Expenditures Encumbrances Budget 0 0 0 1,000 0 3,825 0 0 0 111 0 0 8,688 64,238 67,950 0 726 67,760 1,478 104,374 0 0 0 0 0 0 0 0 0 3,956 0 451 0 0 0 0 0 9,089 7,437 0 0 4,771 0 0 0 19,132 6,223 1,646,411 407 3,500 7,640 5,708 0 372,504 237,686 1,784,732 1,431,408 4,950,120 2/7/2024 11:16:31 AM - 7108 Remaining Balance 1,000 (3,825) (111) (132,188) 35,137 0 0 (3,105) 0 (16,526) (4,771) 1,621,057 3,/33 366,796 1,733,980 Percent Budget Obligated 0.00% 0.00% 0.00% 0.00% 66.34% 0.00% 0.00% 789.10% 0.00% 0.00% 0.00% 1.54% 51.14% 1.53% 64.97% Prior Year YTD Change Expenditures From prior Yr. 209 49,478 435,446 0 50,358 14,012 0 27,789 2,638,378 3,825 (98) 14,760 (367,686) 0 (50,358) (10,456) 0 (18,700) 4,771 19,132 407 5,708 (853,647)