Loading...
HomeMy WebLinkAbout2024 RFP Housing & Homelessness v.2.2023 Affordable Housing 148 & Homeless Housing 149 January - June 13, 2023 BEGINNING FUND BALANCE REVENUES County Sales Tax (1406) - Support Housing-Sales Use Tax City Sales Tax (1406) - City Contribution Sales Use Tax Sales Tax (1590) Investment Interest Shelter Program Grant Recording Fees Misc Revenue TOTAL REVENUES EXPENSES Community Build - Caswell Brown Dove House Dove House - Emergency Shelter Dove House - Housing Support Habitat for Humanity Habitat for Humanity - Landes Family Homes Fairgrounds Housing Bayside PTAC Heaters Bayside Shelter Grant Bayside Housing - Tiny OlyCAP 7th Haven Project OlyCAP Caswell Brown OlyCap Adult Shelter OlyCap Haines Street Cottages Pfeiffer House/Owl 360 Treasurer Financial Service Fees RFP Budget - 1590 TOTAL EXPENSES Change in Fund Balance Unused Shelter Grant Budget ENDING FUND BALANCE Estimated 2024 Revenues Total Available Possible RFP Amount 2023 Budget 148 223017 62000 585000 350 40000 0 687350 20000 50000 12000 60000 100000 55000 30000 25000 335000 687000 350 56631 279998 762000 1041998 965798 149 276832 1500 10000 234000 0 245500 85000 45000 10000 144500 45000 180000 10000 9000 528500 -283000 9959 3791 241000 244791 220691 TOTAL 499849 62000 0 585000 1850 10000 274000 0 932850 20000 135000 12000 45000 60000 0 0 0 110000 144500 0 100000 180000 40000 34000 0 335000 1195500 -262650 237199 2023 Actual 148 223017 11885 14695 317918 6664 14850 0 366012 20000 22599 43369 6061 9926 101955 264057 487074 149 276832 5480 34609 92645 11.95 132745.95 34632 8306 41 33954 66028 25518 168479 -35733.05 241098.95 6/13/2023 TOTAL 499849 11885 14695 317918 12144 34609 107495 11.95 498757.95 20000 34632 0 8306 22599 0 0 0 43410 33954 0 6061 66028 25518 9926 0 0 250434 248323.95 748172.95 Available Amount 50115 -14695 267082 -10294 -24609 166505 -11.95 434092.05 0 100368 12000 36694 37401 0 0 0 66590 110546 0 93939 113972 14482 24074 0 335000 945066 Budget % 0.191693548387097 Over 0.543449572649573 Over Over 0.392317518248175 Over 1 0.256533333333333 0 0.184577777777778 0.37665 0.394636363636364 0.234975778546713 0.06061 0.366822222222222 0.63795 0.291941176470588 0 0 0.209480552070263 2022 Affordable Housing 148 & Homeless Housing 149 January - July 2022 (Updated 8-17-2022) BEGINNING FUND BALANCE REVENUES County Sales Tax (1406) - Support Housing-Sales Use Tax City Sales Tax (1406) - City Contribution Sales Use Tax Sales Tax (1590) - Orig Budget $600,000 Investment Interest Shelter Program Grant Recording Fees TOTAL REVENUES EXPENSES Dove House Habitat for Humanity Habitat for Humanity - Landes Family Homes Fairgrounds Housing Bayside PTAC Heaters Bayside Shelter Grant Bayside Housing - Tiny OlyCAP 7th Haven Project OlyCap Adult Shelter OlyCap Haines Street Cottages Pfeiffer House/Owl 360 Treasurer Financial Service Fees TOTAL EXPENSES Change in Fund Balance ENDING FUND BALANCE Current Year Model BEGINNING FUND BALANCE Budgeted Revenues Budgeted Expenditures Projected Ending Fund Balance Projected Current Year Model and Recommendation 2022 Beginning Fund Balance Projected Revenues Projected Expenditures 2022 Projected Ending Fund Balance Recommended Reserve (approx 25%) 2022 Fund Balance for RFP 1590 Revenue Other Affordable Housing Revenue Ending Homelessness 2023 Projected Revenues for RFP 2023 Recommended RFP SHB 1590 Revenue and Expenditure Budget 2021 2022 through 12/31/2022 2023 Anticipated Total 2022 Budget 148 521071.85 62000 600000 350 42753 705103 50000 27000 6000 35000 600000 90000 70500 878500 -173397 347674.85 148 521071.85 705103 878500 347674.85 148 521071.85 900000 1318500 102571.85 102575 0 940000 102000 1042000 1042000 Revenue 438556 720000 720000 1878556 149 301674.33 250 45000 500000 545250 87588 45000 28000 128100 40000 133505 462193 83057 384731.33 149 301674.33 545250 462193 384731.33 149 301674.33 545250 462193 384731.33 100000 284500 234000 234000 518500 Expense 0 600000 940000 1540000 TOTAL 822746.18 62000 600 45000 542753 1250353 87588 50000 27000 6000 35000 45000 28000 600000 218100 40000 204005 1340693 -90340 732406.18 Total 822746.18 1250353 1340693 732406.18 Total 822746.18 1445250 1340693 927303.18 202575 284500 940000 102000 234000 1276000 1560500 BALANCE 438556 558556 338556 2022 Actual 148 521071.85 25352 13705 426881 1006 29114 496058 6582 27000 6000 21400 600000 23710 50 684742 -188684 332387.85 Total $620,500 Other Housing Revenue 149 301676 1102 35076 184196 220374 37113 43395 16780 68465 32994 13296 55 1 220373 522049 8/18/2022 TOTAL 822747.85 25352 13705 426881 2108 35076 213310 716432 37113 6582 27000 6000 21400 43395 16780 600000 68465 32994 37006 105 896840 -180408 642339.85 FUND 148 & FUND 149 - 2021 Updated 1-27-2022 BEGINNING FUND BALANCE REVENUES County Sales Tax (1406) City Sales Tax (1406) Sales Tax (1590) Investment Interest Shelter Program Grant Recording Fees TOTAL REVENUES EXPENSES Bayside - rental subsidies Bayside - tiny homes Dove House Habitat for Humanity 2020** Habitat for Humanity 20 homes Jefferson Interfaith Action Coalition 2020 Bayside (Shelter grant) OlyCap - Fairgrounds OlyCAP Adult Shelter 2020 OlyCAP Housing Assistance OlyCAP Haines Street Cottages OlyCAP/Parcher Pfeiffer House renovation OlyCAP/Parcher Pfeiffer House repairs OlyCAP SHB 1590 (7th and Hendricks project) Affordable Housing SHB 2060 (7th and Hendricks project) Transfer to Construction and Renovation Fund Treasurer Fees Facilitator Contract Administrative Costs TOTAL EXPENSES Change in Fund Balance ENDING FUND BALANCE 148 226277 120048 400000 2830 42752 565630 75000 27000 40000 27000 6000 20000 400000 75000 27500 2137.6 699637.6 -134007.6 92269.4 2021 Budget 149 377426.87 1400 145000 270239 416639 16000 73691 145000 200000 20000 182660 15000 16214.34 668565.34 -251926.34 125500.53 TOTAL 603703.87 0 120048 4230 145000 312991 982269 91000 73691 40000 0 145000 200000 0 40000 182660 15000 0 18351.94 805702.94 176566.06 780269.93 148 226277 67703 13705 438556 240.85 65290 585494.85 0.0351 75000 27000 44533 0 20000 21660 75000 27500 7 0 290700 -0.5845 294794.85 521071.85 2021 Actual 149 377427 319 93940 414422 508681 14719 73691 80611 200000 20000 169355 15000 7.67 11050 0 584433.67 -75752.67 301674.33 TOTAL 603704 67703 559.85 93940 479712 1094175.85 89719 27000 73691 44533 0 0 80611 0 200000 0 40000 169355 15000 75000 11050 0 825959 268216.85 871920.85 FUND 148 & FUND 149 - 2020 Updated 1-25-2021 BEGINNING FUND BALANCE REVENUES Sales Tax (1406) Investment Interest Transfer 148-149 Shelter Program Grant Recording Fees TOTAL REVENUES EXPENSES Interim Homeless Shelter Services Jan 1- April 30 2020 Bayside 2020 Dove House 2020 Habitat for Humanity 2020 Jefferson Interfaith Action Coalition 2020 Bayside (Shelter grant) OlyCAP Adult Shelter 2020 OlyCAP Housing Assistance OlyCAP Haines Street Cottages 2020 1st Task Force Facilitator Contract Olycap housing support request Transfer 148-149 Est'd Administrative Costs & New Facilitation Contract as of 2020 TOTAL EXPENSES Change in Fund Balance ENDING FUND BALANCE 2020 RFP ALLOCATIONS Actual Expenditures Difference - RFP Allocation Unspent 148 410852 3080 47283 50363 1900 272281 0 274181 -223818 2019 FINAL 149 0 5702 272281 299044 577027 251843 21013 272856 304171 TOTAL 410852 346327 627390 251843 22913 0 547037 80353 148 187034 52155 1402 59754 113311 13770 60298 0 0 0 0 0 74068 39243 226277 108780 74068 34712 2020 Actual 149 304171 0 2320 0 379365 381685 118682 18210 20397 94555.58 15000 31666.55 9918 16284.95 308429.13 73255.87 377426.87 159477 159432.13 44.87 TOTAL 491205 52155 3722 0 439119 494996 118682 31980 60298 0 0 20397 94555.58 15000 31666.55 9918 0 16284.95 398782.08 96213.92 603703.87 268257 233500.13 34756.87 148 1% increase 60351.54 60351.54 12621.002 12621.002 2021 Est'd 149 1% increase 383158.65 383158.65 0 19617.998 19617.998 TOTAL 443510.19 443510.19 0 0 32239 32239