Loading...
HomeMy WebLinkAbout1. CURRENT -Fund 131b BHAC2024 Budget - 131 Fund =Projected =Actual Updated:11/12/2024 DESCRIPTION 2024 2024 DEC JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD Projected Total Remaining Bal Budgeted Amend Oper Bud 2023 Actual less actual PROJECTED (Over)/Under REVENUES Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Projected Projected CHEM DEPEND/MENTAL HLTH SERVICE TAX 849,538 849,538 66,828 74,454 59,987 65,806 77,849 70,975 75,418 84,632 90,508 89,251 86,831.00 70,898.00 755,707.52 157,729 913,436.52 (63,899) Budgeted Amend Oper Bud Actual Actual Actual Actual Actual Actual Actual Actual Projected Projected Projected Projected YTD Actual Projected YTD Actual + Proj Year End Projection % Spent Mental Health & Substance Abuse Treatment Jumping Mouse 127,063 127,063 10,589 10,589 10,589 10,589 10,589 10,589 10,589 10,589 10,589 10,589 10,589 10,589 95,297 31,766 127,063 - 75% Jumping Mouse - Brinnon Pilot Project 41,745 41,745 1,298 1,298 2,653 3,346 3,204 3,218 3,391 2,396 1,604 6,446 6,446 6,446 22,406 19,339 41,745 - 54% Jumping Mouse - Chimacum 38,531 38,531 2,947 972 2,119 3,750 3,163 3,141 3,503 3,322 2,347 4,423 4,423 4,423 25,263 13,268 38,531 - Benji Project 24,708 24,708 3,823 3,871 2,801 - - - - 478 7,681 4,412 821 821 23,065 1,643 24,708 - Public Health - Nurse Family Partnership 67,055 67,055 13,037 11,380 8,476 10,057 8,740 2,090 7,840 5,435 - - - - - 67,055 67,055 - 0% Gateway to Freedom BIR - Inmate Services 35,743 35,743 3,726 4,305 4,070 4,061 3,653 3,659 3,180 3,381 3,334 2,373 - - 35,743 - 35,743 (0) Gateway to Freedom BIR - Mobile Unit 43,472 43,472 3,726 5,590 5,590 6,521 6,521 6,521 6,521 2,482 - - - - 43,472 - 43,472 0 100% Gateway to Freedom BIR - FIRE Cares 50,000 50,000 5,808 961 1,025 738 260 87 9,724 9,570 5,457 5,457 5,457 5,457 28,173 21,827 50,000 - Discovery Behavioral Healthcare - Housing 19,400 19,400 1,680 1,575 1,597 1,575 1,575 1,712 1,575 1,575 1,634 1,634 1,634 1,634 12,864 6,536 19,400 - 66% OlyCAP 24,650 24,650 1,983 2,334 1,822 3,996 4,145 1,665 709 1,496 1,428 1,691 1,691 1,691 19,578 5,072 24,650 - 79% Dove House - Recovery Café 93,094 93,094 7,463 8,434 8,112 8,078 7,982 7,740 7,544 8,021 7,993 7,243 7,243 7,243 71,366 21,728 93,094 - 77% PT Police/MH Navigator 67,200 67,200 - - - - - - - - - 22,400 22,400 22,400 - 67,200 67,200 - Olympic Angels-Case Management 15,000 15,000 1,244 1,245 1,244 1,389 1,244 1,223 1,265 1,224 1,224 1,224 1,237 1,237 12,525 2,475 15,000 - OESD - MH Svcs 114,853 50,000 164,853 18,519 14,812 17,332 15,641 19,843 13,701 - - 16,251 16,251 16,251 16,251 99,848 65,005 164,853 - 61% Therapeutic Court & Case Mgmt.- JC Juvenile & Family Court-FFT 10,000 10,000 - - - 240 840 900 540 900 1,440 1,713 1,713 1,713 4,860 5,140 10,000 - 49% JC Juvenile & Family Court-Therpeutic Support 22,248 22,248 638 1,838 1,745 1,865 2,585 2,296 2,701 - 1,920 2,220 2,220 2,220 13,669 8,579 22,248 - 61% Combined Therapeutic Court 200,000 200,000 33,577 11,363 13,414 16,709 12,511 10,005 - - 50,200 17,407 17,407 17,407 147,778 52,222 200,000 - Misc. Expense 300 300 59 49 63 - 76 - 85 - - - - - 333 - 333 (33) 111% Baseline Study, Community Assess. & Eval.26,500 26,500 403 858 - - - - - 425 566 8,083 8,083 8,083 2,251 24,249 26,500 - 8% Admin./Billing 29,317 29,317 2,443 2,443 2,443 2,443 2,443 2,443 2,443 2,443 2,443 2,443 2,443 2,443 24,431 4,886 29,317 - 83% Contracts Management 24,452 24,452 2,038 2,038 2,038 2,038 2,038 2,038 2,038 2,038 2,038 2,038 2,038 2,038 20,377 4,075 24,452 - 83% TOTAL EXPENDITURES 1,012,092 113,239 1,125,331 - 115,000 85,953 87,132 93,035 91,413 73,028 63,646 55,772 118,148 118,046 112,096 112,096 703,298 422,065 1,125,363 (32) 62% =Projected =Actual VARIANCE BETWEEN REVENUE AND EXPENSE Beginning Cash & Investments 625,203 625,203 577,031 565,532 538,387 511,158 497,594 495,542 507,314 536,174 508,534 479,739 454,474 Expense Expenditures (1,125,363) (115,000) (85,953) (87,132) (93,035) (91,413) (73,028) (63,646) (55,772) (118,148) (118,046) (112,096) (112,096) YTD Actuals are Revenues 913,437 66,828 74,454 59,987 65,806 77,849 70,975 75,418 84,632 90,508 89,251 86,831 70,898 62% Ending Cash & Investments 413,276 577,031 565,532 538,387 511,158 497,594 495,542 507,314 536,174 508,534 479,739 454,474 413,276 of Total Budget Reserves (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) Emergency Fund Reserve (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) Cash Available 278,322 442,077 430,578 403,433 376,204 362,640 360,588 372,360 401,220 373,580 344,785 319,520 278,322 131 Fund Expenditures Comparison Chem Depend/Mental Health Svc Tax Month Budget Amend Budget Actual*Variance Month Budget Amend Budget Actual*Variance 68,649.00 January 84,341 89,611 115,000 (30,659) January 68,649 68,649 66,828 1,821 -3% February 84,341 89,611 85,953 (1,612) February 69,083 69,083 74,454 (5,371) 8% March 84,341 89,611 87,132 (2,791) March 42,964 42,964 59,987 (17,023) 40%Revenue April 84,341 89,611 93,035 (8,694) April 60,166 60,166 65,806 (5,640) 9%YTD Actuals are May 84,341 89,611 91,413 (7,072) May 68,334 68,334 77,849 (9,515) 14%11% June 84,341 89,611 73,028 11,313 June 65,266 65,266 70,975 (5,709) 9%Above YTD July 84,341 89,611 63,646 20,695 July 73,949 73,949 75,418 (1,469) 2%Amended Budget August 84,341 89,611 55,772 28,569 August 84,714 87,948 84,632 3,316 0% September 84,341 89,611 - - September 79,012 82,029 90,508 (8,479) 15% October 84,341 89,611 - - October 79,672 82,714 89,251 (6,537) 12% November 84,341 89,611 - - November 86,831 90,146 - - -100% December 84,341 89,611 - - December 70,898 73,605 - - -100% Total 1,012,092 1,075,331 664,978 9,750 Total 849,538 864,853 755,708 (54,606) YTD Total 674,728 268,833 664,978 9,750 YTD Total 691,809 701,102 755,708 (54,606) *Revenue collected is based on sales tax collected 2-3 months prior. Bumps in revenue, every three months reflect the businesses paying sales tax quarterly. Chem Depend/Mental Health Svc Tax Expenditures are input in the month incurred. Prior Year Expenses 131 Fund Revenue Comparison Jan-Dec '24Jan-Dec '24 2025 Budget - 131 Fund =Projected =Actual Updated:11/12/2024 DESCRIPTION 2025 2025 DEC JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD Projected Total Remaining Bal Projection Amend Oper Projection 2024 Actual less actual PROJECTED (Over)/Under REVENUES Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected CHEM DEPEND/MENTAL HLTH SERVICE TAX 850,000 850,000 66,649.00 69,083.00 45,426.00 60,166.00 68,334.00 65,266.00 73,949.00 84,714.00 79,012.00 79,672.00 86,831.00 70,898.00 - 850,000 850,000.00 - Award Amend Oper Bud Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected YTD Actual Projected YTD Actual + Proj Year End Projection % Spent Mental Health & Substance Abuse Treatment OESD - MH Svcs 172,780 172,780 15,938 15,938 15,938 15,938 15,938 15,938 12,858 12,858 12,858 12,858 12,858 12,858 - 172,780 172,780 - 0% Benji Project 23,917 23,917 2,059 2,059 2,059 2,059 2,059 2,059 1,927 1,927 1,927 1,927 1,927 1,927 - 23,917 23,917 - Jumping Mouse - Brinnon Pilot Project 36,220 36,220 3,118 3,118 3,118 3,118 3,118 3,118 2,919 2,919 2,919 2,919 2,919 2,919 - 36,220 36,220 - 0% Jumping Mouse - Chimacum 37,297 37,297 3,211 3,211 3,211 3,211 3,211 3,211 3,005 3,005 3,005 3,005 3,005 3,005 - 37,297 37,297 - Service Period January-December Jumping Mouse - Port Townsend 107,354 107,354 8,946 8,946 8,946 8,946 8,946 8,946 8,946 8,946 8,946 8,946 8,946 8,946 - 107,354 107,354 - 0% OWL360-Therapeutic Support- Indep Living 24,502 24,502 2,042 2,042 2,042 2,042 2,042 2,042 2,042 2,042 2,042 2,042 2,042 2,042 - 24,502 24,502 OWL360 Resource Nav & SUD Peer Ally Outreach 9,463 9,463 789 789 789 789 789 789 789 789 789 789 789 789 - 9,463 9,463 Public Health - Nurse Family Partnership 58,070 58,070 4,839 4,839 4,839 4,839 4,839 4,839 4,839 4,839 4,839 4,839 4,839 4,839 - 58,070 58,070 - 0% Gateway to Freedom BIR - Inmate Services 30,198 30,198 2,517 2,517 2,517 2,517 2,517 2,517 2,517 2,517 2,517 2,517 2,517 2,517 - 30,198 30,198 - Gateway to Freedom BIR - Mobile Unit 36,729 36,729 3,061 3,061 3,061 3,061 3,061 3,061 3,061 3,061 3,061 3,061 3,061 3,061 - 36,729 36,729 - 0% Gateway to Freedom BIR - FIRE Cares 42,244 42,244 3,520 3,520 3,520 3,520 3,520 3,520 3,520 3,520 3,520 3,520 3,520 3,520 - 42,244 42,244 - Dove House - Recovery Café 81,281 81,281 6,773 6,773 6,773 6,773 6,773 6,773 6,773 6,773 6,773 6,773 6,773 6,773 - 81,281 81,281 - 0% Olympic Angels-Case Management 12,673 12,673 1,056 1,056 1,056 1,056 1,056 1,056 1,056 1,056 1,056 1,056 1,056 1,056 - 12,673 12,673 - Therapeutic Court & Case Mgmt. JC Juvenile Court/Referred Becca Petition Project 15,000 15,000 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 - 15,000 15,000 - 0% Combined Therapeutic Court 200,000 200,000 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 16,667 - 200,000 200,000 - Misc. Expense 300 300 25 25 25 25 25 25 25 25 25 25 25 25 - 300 300 - 0% Baseline Study, Community Assess. & Eval.26,500 26,500 2,208 2,208 2,208 2,208 2,208 2,208 2,208 2,208 2,208 2,208 2,208 2,208 - 26,500 26,500 - 0% Admin./Billing 29,317 29,317 2,443 2,443 2,443 2,443 2,443 2,443 2,443 2,443 2,443 2,443 2,443 2,443 - 29,317 29,317 - 0% Contracts Management 24,452 24,452 2,038 2,038 2,038 2,038 2,038 2,038 2,038 2,038 2,038 2,038 2,038 2,038 - 24,452 24,452 - 0% TOTAL EXPENDITURES 968,297 - 968,297 - 82,500 82,500 82,500 82,500 82,500 82,500 78,883 78,883 78,883 78,883 78,883 78,883 - 968,297 968,297 - 0% =Projected =Actual VARIANCE BETWEEN REVENUE AND EXPENSE Beginning Cash & Investments 392,202 625,203 609,352 595,935 558,861 536,527 522,361 505,128 500,194 506,025 506,154 506,943 514,891 Expense Expenditures (968,297) (82,500) (82,500) (82,500) (82,500) (82,500) (82,500) (78,883) (78,883) (78,883) (78,883) (78,883) (78,883) YTD Actuals are Revenues 850,000 66,649 69,083 45,426 60,166 68,334 65,266 73,949 84,714 79,012 79,672 86,831 70,898 0% Ending Cash & Investments 273,905 609,352 595,935 558,861 536,527 522,361 505,128 500,194 506,025 506,154 506,943 514,891 506,906 of Total Budget Reserves (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) (84,954) Emergency Fund Reserve (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) (50,000) Cash Available 138,951 474,398 460,981 423,907 401,573 387,407 370,174 365,240 371,071 371,200 371,989 379,937 371,952 131 Fund Expenditures Comparison Chem Depend/Mental Health Svc Tax Month Budget Amend Budget Actual*Variance Month Budget Amend Budget Actual*Variance 68,649.00 January 84,341 89,611 - - January 68,649 68,649 - - -100% February 84,341 89,611 - - February 69,083 69,083 - - -100% March 84,341 89,611 - - March 42,964 42,964 - - -100%Revenue April 84,341 89,611 - - April 60,166 60,166 - - -100%YTD Actuals are May 84,341 89,611 - - May 68,334 68,334 - - -100%-100% June 84,341 89,611 - - June 65,266 65,266 - - -100%Above YTD July 84,341 89,611 - - July 73,949 73,949 - - -100%Amended Budget August 84,341 89,611 - - August 84,714 - - -100% September 84,341 89,611 - - September 79,012 - - -100% October 84,341 89,611 - - October 79,672 - - -100% November 84,341 89,611 - - November 86,831 - - -100% December 84,341 89,611 - - December 70,898 - - -100% Total 1,012,092 1,075,331 - - Total 849,538 448,411 - - YTD Total - - - - YTD Total - - - - *Revenue collected is based on sales tax collected 2-3 months prior. Bumps in revenue, every three months reflect the businesses paying sales tax quarterly. Service Period July-June - Award amount is half of 2025 + half of 2026* Chem Depend/Mental Health Svc Tax Expenditures are input in the month incurred. Prior Year Expenses 131 Fund Revenue Comparison Jan-Dec '25 Jan-Dec '25