Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Inv# 160 - SHAWN MITCHELL - 09/23/2022 (2)
Shawn Mitchell 2299 Rose Walk Drive Alpharetta, GA 30005 (470) 235-9079 cell September 23, 2022 shawn.fms@gmail.com K. Michael Chen, Executive Director Dania Beach Community Redevelopment Agency 100 W. Dania Beach Boulevard Dania Beach, FL 33004 Dear Mr. Chen: Please find attached hereto my invoice for services rendered pursuant to the review, analysis, and updating of CRA financial matters for the Dania Beach Community Redevelopment Agency. This represents all work done through September 30, 2022. I have included the following documentation: • Invoice • Deliverable Thank you for allowing me the opportunity to work with your organization and please let me know if any additional information is needed. Sincerely, Shawn Mitchell Page 1 of 19 09/23/2022 Final Final Final Final Final Final Final Final Final FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 ORIGINAL BOUNDARIES City of Dania Beach Actual/Forecasted Growth #REF!-8.8%-12.7%-0.4%2.8%9.0%4.0%6.2%26.0% Existing Value:276,714,880$ 252,370,700$ 220,323,790$ 219,469,440$ 225,663,520$ 245,913,760$ 255,671,150$ 271,631,690$ 342,126,380$ New Construction:incl. above incl. above incl. above incl. above incl. above incl. above incl. above incl. above incl. above Taxable Value 276,714,880$ 252,370,700$ 220,323,790$ 219,469,440$ 225,663,520$ 245,913,760$ 255,671,150$ 271,631,690$ 342,126,380$ Base Year Value 172,715,440 172,715,440 172,715,440 172,715,440 172,715,440 172,715,440 172,715,440 172,715,440 172,715,440 Tax Increment 103,999,440$ 79,655,260$ 47,608,350$ 46,754,000$ 52,948,080$ 73,198,320$ 82,955,710$ 98,916,250$ 169,410,940$ Millage Rate 5.8579 5.9998 5.9998 5.9998 5.9998 5.9998 5.9998 5.9998 5.9998 Gross Incremental Revenue 609,218$ 477,916$ 285,641$ 280,515$ 317,678$ 439,175$ 497,718$ 593,478$ 1,016,432$ Statutory Reduction 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 578,757$ 454,020$ 271,359$ 266,489$ 301,794$ 417,217$ 472,832$ 563,804$ 965,610$ Taxable Values and TIF Generation Scenarios Incremental Revenue Page 2 of 19 09/23/2022 Final Final Final Final Final Final Final Final Final FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Taxable Values and TIF Generation Scenarios EXPANDED BOUNDARIES City of Dania Beach Actual/Forecasted Growth -19.4%-2.2%-5.1%2.8%7.3%10.9%10.1%8.3% Existing Value:383,273,470$ 308,808,290$ 302,087,340$ 286,578,780$ 294,529,160$ 316,080,540$ 350,496,240$ 386,044,250$ 418,193,930$ New Construction:incl. above incl. above incl. above incl. above incl. above incl. above incl. above incl. above incl. above Taxable Value 383,273,470$ 308,808,290$ 302,087,340$ 286,578,780$ 294,529,160$ 316,080,540$ 350,496,240$ 386,044,250$ 418,193,930$ Base Year Value 383,273,470 383,273,470 383,273,470 383,273,470 383,273,470 383,273,470 383,273,470 383,273,470 383,273,470 Tax Increment -$ (74,465,180)$ (81,186,130)$ (96,694,690)$ (88,744,310)$ (67,192,930)$ (32,777,230)$ 2,770,780$ 34,920,460$ Millage Rate 5.8579 5.9998 5.9998 5.9998 5.9998 5.9998 5.9998 5.9998 5.9998 Gross Incremental Revenue -$ (446,776)$ (487,101)$ (580,149)$ (532,448)$ (403,144)$ (196,657)$ 16,624$ 209,516$ Statutory Reduction 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 -$ -$ -$ -$ -$ -$ -$ 15,793$ 199,040$ Total Incremental Revenue (Combined)578,757$ 454,020$ 271,359$ 266,489$ 301,794$ 417,217$ 472,832$ 579,597$ 1,164,650$ Notes: Incremental Revenue (1) The calculations above present each Boundary seperately. That said, in the early years (2010-2016), the tax increment within the Expanded Boundar b d i t d t th Page 3 of 19 09/23/2022 ORIGINAL BOUNDARIES City of Dania Beach Actual/Forecasted Growth Existing Value: New Construction: Taxable Value Base Year Value Tax Increment Millage Rate Gross Incremental Revenue Statutory Reduction Incremental Revenue Final Final Final Final Certified FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 13.4%18.0%2.5%5.6%8.3% 388,054,400$ 457,822,300$ 469,241,270$ 495,743,860$ 536,902,010$ incl. above incl. above incl. above incl. above incl. above 388,054,400$ 457,822,300$ 469,241,270$ 495,743,860$ 536,902,010$ 172,715,440 172,715,440 172,715,440 172,715,440 172,715,440 215,338,960$ 285,106,860$ 296,525,830$ 323,028,420$ 364,186,570$ 5.9998 5.9998 5.9998 5.9998 5.9998 1,291,991$ 1,710,584$ 1,779,096$ 1,938,106$ 2,185,047$ 0.95 0.95 0.95 0.95 0.95 1,227,391$ 1,625,055$ 1,690,141$ 1,841,201$ 2,075,794$ Page 4 of 19 09/23/2022 EXPANDED BOUNDARIES City of Dania Beach Actual/Forecasted Growth Existing Value: New Construction: Taxable Value Base Year Value Tax Increment Millage Rate Gross Incremental Revenue Statutory Reduction Total Incremental Revenue (Combined) Incremental Revenue Final Final Final Final Certified FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 8.1%23.8%9.7%20.6%16.6% 452,211,440$ 559,719,900$ 613,905,770$ 740,271,600$ 863,169,860$ incl. above incl. above incl. above incl. above incl. above 452,211,440$ 559,719,900$ 613,905,770$ 740,271,600$ 863,169,860$ 383,273,470 383,273,470 383,273,470 383,273,470 383,273,470 68,937,970$ 176,446,430$ 230,632,300$ 356,998,130$ 479,896,390$ 5.9998 5.9998 5.9998 5.9998 5.9998 413,614$ 1,058,643$ 1,383,748$ 2,141,917$ 2,879,282$ 0.95 0.95 0.95 0.95 0.95 392,933$ 1,005,711$ 1,314,560$ 2,034,822$ 2,735,318$ 1,620,324$ 2,630,766$ 3,004,701$ 3,876,023$ 4,811,112$ ries was negative which would have decreased the overal contribution if the Page 5 of 19 09/23/2022 Dania Beach Community Redevelopment Agency Fund 106: Community Redevelopment Agency A B C D=C-A Fund Balance (beginning of year) 14,663 2,351,170 2,332,919 2,197,279 1,757,582 1,111,176 1,815,273 1,676,205 524,298 446,078 832,509 699,307 745,427 1,563,362 -$ -$ -$ -$ -$ -$ -$ 50,620.00$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - 30,000.00 - - - - - - - - - - - - - - - - - - - - - 100,000.00 - 20,000.00 20,000.00 1,655.00 - 2,592.23 6,857.45 4,760.51 1,914.59 4,377.00 9,285.02 19,031.88 10,771.00 16,409.36 7,272.73 1,250.40 5,000.00 1,300.59 (3,699.41) - - - - 36,139.00 54,277.88 77,563.47 82,554.54 58,903.66 62,295.31 94,473.83 4,000.00 - 150,000.00 45,241.08 (104,758.92) - - - - - 8,127.44 40,560.54 260.00 100.00 1,188.50 85,089.17 64,894.23 333,333.00 666,667.00 12,365.80 (654,301.20) - - - - - - - - - 32,000.00 - - - - - - - - - - - - - - - - 700.00 31.00 - 8,000.00 - (8,000.00) 662,602.00 693,283.00 822,150.00 768,971.00 822,150.00 822,150.00 880,000.00 880,000.00 880,000.00 1,130,000.00 1,137,927.00 1,444,548.00 1,383,926.00 1,383,926.00 1,037,944.50 (345,981.50) - - - 261,867.00 - 279,170.00 279,170.00 279,170.00 279,170.00 224,331.00 233,080.00 - - - - - - - - 1,104,790.00 8,079.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 500,000.00 - - - 2,334,200.00 2,730,909.00 - - - - - - - - - - - - - - - - - - - 1,128,143.00 - - - - - - - - - - - - - - - - - - - - - - - 1,041,301.00 - - - - - - - - - - - - - - - - - - 2,998,457.00$ 3,424,192.00$ 824,742.23$ 2,142,485.45$ 871,128.51$ 2,303,782.91$ 1,321,671.01$ 1,311,889.56$ 1,247,205.54$ 1,470,585.81$ 1,577,679.36$ 1,520,745.96$ 2,318,509.40$ 3,254,894.00$ 1,116,851.97$ (1,096,741.03)$ A B C D=A-(B+C) 94,108.00$ 136,193.00$ 177,967.72$ 217,971.92$ 219,503.38$ 241,047.56$ 237,457.12$ 176,960.33$ 184,119.34$ 262,754.18$ 311,362.42$ 316,829.65$ 299,383.11$ 400,140.00$ -$ 269,123.70$ 131,016.30$ 369-90-08 Miscellaneous Revenues Miscellaneous Dania after Dark FY 2017 Actual FY 2017 Actual 369-90-06 Miscellaneous Revenues Miscellaneous Community Foundation Grant FY 2009 Actual FY 2009 Actual Account Description EXPENSE FY 2019 Actual FY 2015 Actual FY 2021 Actual Division 01 - Admin Activity 552 - Industry Development 12-10 Salaries and Wages Full-Time FY 2013 Actual FY 2014 Actual Other Sources: Non-Operating Transfer from General Fund (Contribution towards Arts & Seafood Festival) Department 52 - CRA Account 337-50-02 Grant Proceeds (Broward County; Health Foundation of South FL) Other Sources: Non-Operating Transfer from General Fund (Cost Allocation Plan) Other Sources: Non-Operating Transfer from General Fund (County Loan Repayment) 369-90-01 Miscellaneous Revenues (All) 384-01-01 Debt Proceeds Loan from General Fund REVENUE TOTALS 389-90-01 Other Sources: Non-Operating Re-Appropriations Appropriated Fund Balance 389-90-14 Other Sources: Non-Operating Re-Appropriations Appropriated Fund Balance - Impact Fees (Transportation Commercial) FY 2022 (as of 7-7-2022) FY 2020 Actual FY 2020 Actual 384-00-00 Debt Proceeds 369-90-00 Miscellaneous Revenues: Seafood Festival FY 2022 (as of 7-7-2022) Account Description Fund 106 - Community Redevelopment Agency REVENUE Department 00 - Revenues Division 00 - Non-Dep. 361-10-01 Interest and Other Earnings Interest Operating Interest 381-00-01 Other Sources: Non-Operating Transfer from General Fund (operations) 337-50-01 Grant Proceeds (Broward County; Columbus Project) Account FY 2012 Actual Amended Budget FY 2015 Actual YTD Transactions Preliminary Funds Available Year-to-Date Encumbrances Year-to-Date Transactions Preliminary Funds Available Amended Budget FY 2018 Actual FY 2021 Actual FY 2019 Actual FY 2018 Actual Historical Activity Historical Activity 337-50-03 Grant Proceeds (Affordable Housing Foundation) 381-03-01 Other Sources: Non-Operating Transfer from Capital Projects Fund 324-32-01 Impact Fees (Transportation Commercial) FY 2016 Actual FY 2016 Actual FY 2010 Actual FY 2011 Actual FY 2012 Actual FY 2013 Actual FY 2014 Actual FY 2010 Actual FY 2011 Actual Page 6 of 19 09/23/2022 A B C D=A-(B+C) FY 2017 Actual FY 2009 Actual Account Description EXPENSE FY 2019 Actual FY 2015 Actual FY 2021 Actual Account FY 2022 (as of 7-7-2022) FY 2020 Actual Amended Budget Year-to-Date Encumbrances Year-to-Date Transactions Preliminary Funds Available FY 2018 Actual Historical Activity FY 2016 Actual FY 2010 Actual FY 2011 Actual FY 2012 Actual FY 2013 Actual FY 2014 Actual - - - - - - - 836.49 614.59 11,542.00 16,472.87 35,185.73 53,005.21 27,614.00 - 23,037.95 4,576.05 - - - - - 6,065.95 3,626.39 - - 5,225.30 6,016.50 6,032.97 5,291.24 6,001.00 - 4,170.34 1,830.66 - - - - - - 154.27 482.60 481.28 899.27 962.55 965.19 1,189.35 1,440.00 - 333.60 1,106.40 - 746.00 - 126.82 1,942.72 6,439.97 2,379.19 9,463.63 4,920.64 547.93 2,965.81 1,629.24 149.28 - - 2,170.25 (2,170.25) - - 154.00 - 5,222.37 375.75 30,670.93 297.85 354.20 17,928.56 172.54 20,067.85 27,453.28 6,943.00 - 5,003.08 1,939.92 6,361.00 8,831.00 11,195.00 13,892.93 13,605.17 15,414.48 16,256.45 10,959.04 11,011.32 17,168.97 19,566.89 22,558.14 23,275.39 26,269.00 - 16,651.22 9,617.78 1,488.00 2,116.00 2,717.11 3,268.53 3,278.88 3,629.43 3,835.30 2,562.99 2,575.25 4,015.32 4,576.08 5,275.70 5,443.47 6,473.00 - 4,346.82 2,126.18 13,867.00 20,002.00 19,888.51 - - - - - - - - - - - - - - - - 932.72 12,269.26 15,057.41 25,955.61 25,151.96 10,788.30 12,522.29 37,494.21 45,939.17 54,722.71 61,061.75 75,184.00 - 51,829.69 23,354.31 - - 239.54 3,554.73 6,069.79 9,568.82 9,778.00 8,781.32 7,755.39 4,537.95 5,777.76 6,009.51 5,641.52 5,731.00 - 3,872.95 1,858.05 18,058.00 51,381.00 66,831.72 59,281.90 58,303.20 52,180.04 57,960.31 50,386.07 47,352.05 54,622.08 62,003.90 80,913.32 46,673.79 85,139.00 - 38,587.05 46,551.95 296.00 1,008.00 930.44 732.64 672.29 702.93 - 1,286.39 1,434.93 582.68 503.43 503.88 373.52 471.00 37.83 353.47 79.70 400,975.00 372,804.00 281,660.69 189,128.43 126,814.37 233,008.57 262,486.69 331,666.92 302,501.27 137,001.18 79,867.77 50,586.96 40,809.50 216,100.00 97,679.00 118,147.90 273.10 101,858.00 68,167.00 72,322.17 67,666.57 47,278.20 59,501.69 31,884.39 3,558.62 12,793.02 3,784.00 34,904.90 20,224.17 5,080.00 10,000.00 6,550.00 3,450.00 - - 1,758.00 53,563.76 78,704.33 84,973.78 32,169.70 14,718.73 7,000.00 10,358.00 21,945.65 - - - 4,000.00 - 1,495.00 2,505.00 2,741.00 3,393.00 6,529.89 4,178.40 8,048.23 6,995.11 5,738.61 10,518.12 8,681.89 28,002.79 21,619.03 8,675.20 3,571.00 10,000.00 - 4,104.59 5,895.41 6,016.00 5,830.00 6,770.74 6,032.33 6,226.17 (48.46) 395.00 536.81 - 14,903.57 - - - - - - - 739.00 1,438.00 1,868.07 2,121.44 1,825.02 1,957.28 2,180.08 2,026.14 1,514.55 853.85 673.35 642.32 751.09 800.00 - 17.12 782.88 1,200.00 - 54.75 999.83 882.91 1,332.91 3,803.87 793.41 753.72 195.87 1,656.90 254.45 215.19 2,000.00 - 409.36 1,590.64 - - - - - - - - - - - - 131.14 2,000.00 - - 2,000.00 5,027.00 2,946.00 2,145.32 1,523.63 1,799.08 3,483.16 1,974.21 1,225.75 547.95 16.98 2,157.13 1,954.97 128.50 2,000.00 59.76 975.24 965.00 - - - - - - 179,254.32 188,414.60 179,201.91 125,378.90 166,288.92 50,250.84 - 204,000.00 22,410.75 178,679.26 2,909.99 - - - - - - - - - - - - - - - - - - - - - - - - - - 5,000.00 15,000.00 10,000.00 22,000.00 - - - - 3,799.00 5,289.00 638.99 6,035.00 1,089.60 3,885.82 1,395.81 1,111.00 348.50 348.50 1,230.84 395.75 233.00 2,860.00 - - 2,860.00 1,509.00 10,611.00 7,040.81 5,224.54 4,351.65 6,238.58 5,965.53 1,733.32 2,360.41 6,751.00 5,689.97 1,670.25 7,185.14 5,000.00 - 1,617.91 3,382.09 - - - - - - - - - - - 39.98 141.16 750.00 - 369.90 380.10 1,009.00 330.00 1,057.46 858.67 291.30 872.42 1,185.82 1,086.89 1,181.35 951.13 6,318.56 430.38 187.35 1,600.00 - 1,494.91 105.09 497.00 1,740.00 599.00 949.14 1,328.85 901.74 1,059.96 1,500.00 - - - - - - - - - 193.00 20.00 537.00 980.89 445.95 325.00 - - - 500.00 5,112.04 4,891.89 6,596.39 12,000.00 1,280.00 9,627.94 1,092.06 2,209.00 1,782.00 2,212.75 4,704.45 6,154.14 4,787.48 4,129.98 3,963.00 5,294.53 5,000.00 4,633.00 4,645.00 3,485.39 6,000.00 - 3,472.01 2,527.99 - - - - - - - - - - - - - 500,000.00 - - 500,000.00 - - - - - - - - - - - - 333,333.00 666,667.00 - - 666,667.00 - - - - - - - - - - 31,561.00 - - - - - - - 4,577.00 - - - - - - - - - - - - - - - - - - - - - - - - - 41,458.40 41,458.40 - - - - - - - - - - - - - - - 84,852.22 19,537.50 - - - - - - 2,730,909.00 - 512,075.00 261,867.00 279,170.00 279,170.00 279,170.00 279,170.00 224,331.00 233,080.00 247,098.00 233,789.00 251,888.00 - 188,916.75 62,971.25 - - - - - - - - - - - - - - - - - - - - - - 154,713.00 181,000.00 150,000.00 120,000.00 55,000.00 154,318.00 102,336.00 138,498.00 150,000.00 - 112,500.00 37,500.00 - - - 42,100.00 8,060.00 - - - - - - - - - - - - - - - - - - - - - - - - - 19,024.00 - 14,268.00 4,756.00 - - - - - - - - - - - - - 2,974.00 - 2,230.50 743.50 - - - - - - - - - - - - - 79,951.00 - 59,963.25 19,987.75 64-20 Machinery and Equipment (Vehicle) 48-16 Promotional Activities (Community Foundation Grant) 41-10 Communications Services Telephone 42-10 Freight & Postage Services Freight & Postage FICA Taxes 31-10 Prof. Services General Prof. Services Legal 34-10 61-10 Land 63-45 Operating Supplies Miscellaneous 52-30 Operating Supplies Software 54-10 Retirement Contributions FRS Pension 22-30 Retirement Contributions Deferred Comp. Match 23-10 24-10 Workers' Compensation Premium FICA Medicare 22-20 Life and Health Insurance 31-20 Printing and Binding General 40-10 12-11 Salaries and Wages Part Time (FRS Eligible) 48-14 Promotional Activities (Seafood Festival) 91-11 Intragovernmental Transfers Out CRA Patch Fund 91-51 Intragovernmental Transfers Out Facilities Fund 91-52 Intragovernmental Transfers Out Fleet Mgmt Fund 91-53 Intragovernmental Transfers Out IT Systems Fund 64-30 Machinery and Equipment Other Current Charges/Obligations Legal & Display Advertising 51-10 Office Supplies General 52-20 Retirement Contributions City Pension Travel and Per Diem Training and Per Diem 40-20 Travel and Per Diem Expense Allowance Books/Publications, Memberships, Subscriptions Books & Subscriptions 54-20 Books/Publications, Memberships, Subscriptions Memberships 91-35 Intragovernmental Transfers Out Capital Projects Fund 71-10 Principal (Loan Repayments) 72-10 Interest (Loan Repayments) 91-00 Intragovernmental Transfers Out General Fund (Columbus Project; Broward County Grant Reimbursement) 91-00 Intragovernmental Transfers Out General Fund 12-13 Salaries and Wages Expense Allowance 21-20 22-10 12-14 Cell Phone Stipend Special Pay (Accrued Leave) 14-10 Overtime Regular 15-15 21-10 49-20 Contractual Services General 47-10 NEW Promotional Activities (Community Events) Infrastructure (Trion Public Improvements) 52-10 Operating Supplies Gasoline 46-30 Repair & Maint. Services (Vehicles) Page 7 of 19 09/23/2022 A B C D=A-(B+C) FY 2017 Actual FY 2009 Actual Account Description EXPENSE FY 2019 Actual FY 2015 Actual FY 2021 Actual Account FY 2022 (as of 7-7-2022) FY 2020 Actual Amended Budget Year-to-Date Encumbrances Year-to-Date Transactions Preliminary Funds Available FY 2018 Actual Historical Activity FY 2016 Actual FY 2010 Actual FY 2011 Actual FY 2012 Actual FY 2013 Actual FY 2014 Actual - - - - - - - - - - - 5,703.09 - 9,280.00 - - 9,280.00 661,950.00$ 3,431,871.00$ 717,858.16$ 1,234,381.38$ 885,091.46$ 1,150,674.54$ 1,363,612.92$ 1,257,109.59$ 1,197,848.38$ 1,047,282.87$ 1,366,741.95$ 1,121,489.04$ 1,325,075.76$ 2,800,299.00$ 128,017.34$ 1,121,219.76$ 1,551,061.90$ -$ 10,569.00$ 38,973.50$ -$ -$ -$ -$ -$ 20,250.00$ -$ 200.00$ -$ -$ -$ -$ -$ -$ - - 74,924.42 17,400.81 33,582.84 12,254.88 13,553.81 10,480.25 14,202.36 - 45,634.48 25,985.75 11,713.82 51,220.00 17,120.00 12,802.74 21,297.26 - - 24,253.35 - 33,620.05 28,511.65 10,375.00 5,085.00 2,970.00 - 70,727.52 77,397.00 836.76 79,337.00 - 800.00 78,537.00 - - - - - 709.26 - - - - - - - - - - - - - - 6,067.15 110,943.99 127,405.50 5,618.68 14,766.18 8,471.82 36,872.76 18,266.01 12,118.94 5,652.62 15,000.00 - 11,589.49 3,410.51 - 3.00 - - - - - - - - - - - - - - - - - - - - - - - - - 38,747.00 1,500.00 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -$ 10,572.00$ 138,151.27$ 23,467.96$ 178,146.88$ 168,881.29$ 29,547.49$ 30,331.43$ 45,894.18$ 36,872.76$ 173,575.01$ 117,001.69$ 18,203.20$ 145,557.00$ 17,120.00$ 25,192.23$ 103,244.77$ -$ -$ 57.93$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 43,250.00 - - - - - 6,620.70 - - - - - - - - - - 8,500.00 - - - - - - - - - - - - - - - - - - - - - - 1,364.36 - - - - - - - - -$ -$ 51,807.93$ -$ -$ -$ -$ -$ 7,985.06$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 29,420.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 24,722.80 681,370.36 140,695.87 - - - - - - - - - - - - - - 24,722.80 681,370.36 170,115.87 - - - - - - - - - - - - -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Division 06 - Marine Division 03 - College Gardens Activity 552 - Industry Development 31-10 Prof. Services General 31-42 Prof. Services CRA - Redevelopment Initiatives Division 03 - College Gardens Totals 63-10 Infrastructure Improvements other than Bldgs. Division 05 - East Federal Highway Activity 552 - Industry Development 63-42 Infrastructure CRA Landscaping Enhancements Division 04 - Dania Beach Heights Activity 552 - Industry Development 62-10 Infrastructure CRA Buildings Infrastructure CRA Parks Improvements 63-41 Infrastructure CRA Streetscape Enhancements 99-80 Other Uses Reserve for CRA 63-42 Infrastructure CRA Landscaping Enhancements 63-41 Infrastructure CRA Streetscape Enhancements 63-10 63-44 63-43 Infrastructure Improvements other than Bldgs. Division 05 - East Federal Highway Totals Infrastructure CRA Landscaping Enhancements 63-43 Infrastructure CRA Parks Improvements 48-10 Promotional Activities General 63-41 Infrastructure CRA Streetscape Enhancements 63-42 31-41 Prof. Services CRA - Marketing/PR 31-42 Prof. Services CRA - Redevelopment Initiatives 63-42 Infrastructure CRA Landscaping Enhancements Division 02 - City Center Totals 31-10 Prof. Services General Division 04 - Dania Beach Heights Totals Infrastructure CRA Neighborhood Beautification Division 02 - City Center Activity 552 - Industry Development 31-10 Prof. Services CRA - General Division 01 - Admin Totals 40-10 Travel and Per Diem Training and Per Diem Page 8 of 19 09/23/2022 A B C D=A-(B+C) FY 2017 Actual FY 2009 Actual Account Description EXPENSE FY 2019 Actual FY 2015 Actual FY 2021 Actual Account FY 2022 (as of 7-7-2022) FY 2020 Actual Amended Budget Year-to-Date Encumbrances Year-to-Date Transactions Preliminary Funds Available FY 2018 Actual Historical Activity FY 2016 Actual FY 2010 Actual FY 2011 Actual FY 2012 Actual FY 2013 Actual FY 2014 Actual -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 5,179.75$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - 1,500.00 209,087.55 22,932.30 - - - - - - - - - - - - - 38,135.74 80,328.81 6,756.32 - - - - - - - - - - - - - 15,342.50 401,148.28 30,976.93 - 9,341.94 - - - - - - - - - - -$ -$ 15,342.50$ 439,284.02$ 117,985.49$ 215,843.87$ 32,274.24$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 12,500.00$ 45,953.38$ -$ -$ 7,000.00$ 16,300.00$ 2,234.13$ -$ 78,551.92$ 113,336.00$ 79,294.72$ 128,000.00$ 48,682.00$ 66,823.00$ 12,495.00$ - - - 157,725.23 137,893.19 64,286.78 1,204.00 31,912.55 71,463.53 - 92,011.67 122,799.92 78,000.00 181,038.00 6,037.58 - 175,000.42 - - - - - - - - - - - - - - - - - - - - - 28,301.00 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -$ -$ 12,500.00$ 203,678.61$ 166,194.19$ 64,286.78$ 8,204.00$ 48,212.55$ 73,697.66$ -$ 170,563.59$ 236,135.92$ 157,294.72$ 309,038.00$ 54,719.58$ 66,823.00$ 187,495.42$ -$ -$ -$ -$ -$ -$ 27,100.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 27,100.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 661,950.00$ 3,442,443.00$ 960,382.66$ 2,582,182.33$ 1,517,533.89$ 1,599,686.48$ 1,460,738.65$ 1,335,653.57$ 1,325,425.28$ 1,084,155.63$ 1,710,880.55$ 1,474,626.65$ 1,500,573.68$ 3,254,894.00$ 199,856.92$ 1,213,234.99$ 1,841,802.09$ 2,998,457.00$ 3,424,192.00$ 824,742.23$ 2,142,485.45$ 871,128.51$ 2,303,782.91$ 1,321,671.01$ 1,311,889.56$ 1,247,205.54$ 1,470,585.81$ 1,577,679.36$ 1,520,745.96$ 2,318,509.40$ 3,254,894.00$ -$ 1,116,851.97$ (1,096,741.03)$ 661,950.00$ 3,442,443.00$ 960,382.66$ 2,582,182.33$ 1,517,533.89$ 1,599,686.48$ 1,460,738.65$ 1,335,653.57$ 1,325,425.28$ 1,084,155.63$ 1,710,880.55$ 1,474,626.65$ 1,500,573.68$ 3,254,894.00$ 199,856.92$ 1,213,234.99$ 1,841,802.09$ 2,336,507.00$ (18,251.00)$ (135,640.43)$ (439,696.88)$ (646,405.38)$ 704,096.43$ (139,067.64)$ (23,764.01)$ (78,219.74)$ 386,430.18$ (133,201.19)$ 46,119.31$ 817,935.72$ -$ (199,856.92)$ (96,383.02)$ (2,938,543.12)$ Fund Balance (end of year)2,351,170.00 2,332,919.00 2,197,278.57 1,757,581.69 1,111,176.31 1,815,272.74 1,676,205.10 1,652,441.09 446,078.35 832,508.53 699,307.34 745,426.65 1,563,362.37 1,466,979.35 Prior-Period Adjustment (Columbus Project)- - - - - - (1,128,143.00) - - - - - Fund Balance (end of year)2,332,919 2,197,279 1,757,582 1,111,176 1,815,273 1,676,205 524,298 446,078 832,509 699,307 745,427 1,563,362 Beginning Fund Balance (as of 9/30/2021)1,525,662 Reflects Proposed Budget Amendment FY 2022 Revenues to-date 1,116,852 Reflects Proposed Journal Entry FY 2022 Forecasted Revenues 345,982 FY 2022 Encumbrances to-date (199,857) FY 2022 Expenditures to-date (1,213,235) FY 2022 Forecasted Expenses/Encumbrances (665,855) Preliminary Available CF 909,549 FY 2023 Carryforward (900,000) Excess Fund Balance 9,549 62-10 Buildings EXPENSE TOTALS Prof. Services General Division 10 - Columbus Project Totals Machinery and Equipment 63-43 Infrastructure CRA Parks Improvements 64-30 99-80 Division 08 - City-Wide Activity 552 - Industry Development 31-10 63-44 Prof. Services General Division 06 - Marine Totals Division 10 - Columbus Project (Mile Marker 55) Activity 552 - Industry Development Infrastructure CRA Streetscape Enhancements63-41 Fund 106 - Community Redevelopment Agency Totals REVENUE TOTALS EXPENSE TOTALS Infrastructure CRA Neighborhood Beautification Division 07 - Sunny Garden Isles Totals Division 07 - Sun Garden Isles Activity 552 - Industry Development 31-10 Prof. Services General 31-42 Prof. Services CRA - Redevelopment Initiatives 99-80 Other Uses Reserve for CRA Division 08 - City-Wide Totals Fund 106 - Community Redevelopment Agency Totals Activity 552 - Industry Development 31-10 Prof. Services General Division 09 - PATCH Bus Plan Totals Division 09 - Phase I PATCH Bus Plan 31-10 Activity 552 - Industry Development Reserve (pending Reallocation/Repayment) 61-10 Land Page 9 of 19 09/23/2022 Dania Beach Community Redev Fund 106: Community Redevelopme Fund Balance (beginning of year) 369-90-08 Miscellaneous Revenues Miscellaneous Dania after Dark 369-90-06 Miscellaneous Revenues Miscellaneous Community Foundation Grant Account Description EXPENSE Division 01 - Admin Activity 552 - Industry Development 12-10 Salaries and Wages Full-Time Other Sources: Non-Operating Transfer from General Fund (Contribution towards Arts & Seafood Festival) Department 52 - CRA Account 337-50-02 Grant Proceeds (Broward County; Health Foundation of South FL) Other Sources: Non-Operating Transfer from General Fund (Cost Allocation Plan) Other Sources: Non-Operating Transfer from General Fund (County Loan Repayment) 369-90-01 Miscellaneous Revenues (All) 384-01-01 Debt Proceeds Loan from General Fund REVENUE TOTALS 389-90-01 Other Sources: Non-Operating Re-Appropriations Appropriated Fund Balance 389-90-14 Other Sources: Non-Operating Re-Appropriations Appropriated Fund Balance - Impact Fees (Transportation Commercial) 384-00-00 Debt Proceeds 369-90-00 Miscellaneous Revenues: Seafood Festival Account Description Fund 106 - Community Redevelopment Agency REVENUE Department 00 - Revenues Division 00 - Non-Dep. 361-10-01 Interest and Other Earnings Interest Operating Interest 381-00-01 Other Sources: Non-Operating Transfer from General Fund (operations) 337-50-01 Grant Proceeds (Broward County; Columbus Project) Account 337-50-03 Grant Proceeds (Affordable Housing Foundation) 381-03-01 Other Sources: Non-Operating Transfer from Capital Projects Fund 324-32-01 Impact Fees (Transportation Commercial) E F=C+E G=A-F H I J=H+I -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - 20,000.00 20,000.00 - - - - 1,300.59 (3,699.41) - 5,000.00 5,000.00 - 45,241.08 (104,758.92) - 50,000.00 50,000.00 - 12,365.80 (654,301.20) 666,667.00 - 666,667.00 - - - - - - - - (8,000.00) - 8,000.00 8,000.00 345,981.50 1,383,926.00 - - 1,114,481.00 1,114,481.00 - - - - 259,445.00 259,445.00 - - - - 10,000.00 10,000.00 - - - - - - - - - - - - - - - - - - - - - - - - - - - 500,000.00 400,000.00 900,000.00 - - - - - - 345,981.50$ 1,462,833.47$ (750,759.53)$ 1,166,667.00$ 1,846,926.00$ 3,013,593.00$ E F=B+C+E G=A-F H I J=H+I 131,016.30$ 400,140.00$ -$ -$ 424,148.00$ 424,148.00$ Capital Est. Carryforward from FY 2022 2023 Budget Appropriation Transfers & Amendments ) FY 2023 ) FY 2022 FY 2023 Budget Final Estimated Funds Available Total Encumbrances and Expenses Forecasted Expenditures Forecasted Revenue Collections Final Estimated Funds Available FY 2023 Budget Capital Est. Carryforward from FY 2022 2023 Budget Appropriation Transfers & Amendments Total Revenues Page 10 of 19 09/23/2022 Account Description EXPENSE Account 64-20 Machinery and Equipment (Vehicle) 48-16 Promotional Activities (Community Foundation Grant) 41-10 Communications Services Telephone 42-10 Freight & Postage Services Freight & Postage FICA Taxes 31-10 Prof. Services General Prof. Services Legal 34-10 61-10 Land 63-45 Operating Supplies Miscellaneous 52-30 Operating Supplies Software 54-10 Retirement Contributions FRS Pension 22-30 Retirement Contributions Deferred Comp. Match 23-10 24-10 Workers' Compensation Premium FICA Medicare 22-20 Life and Health Insurance 31-20 Printing and Binding General 40-10 12-11 Salaries and Wages Part Time (FRS Eligible) 48-14 Promotional Activities (Seafood Festival) 91-11 Intragovernmental Transfers Out CRA Patch Fund 91-51 Intragovernmental Transfers Out Facilities Fund 91-52 Intragovernmental Transfers Out Fleet Mgmt Fund 91-53 Intragovernmental Transfers Out IT Systems Fund 64-30 Machinery and Equipment Other Current Charges/Obligations Legal & Display Advertising 51-10 Office Supplies General 52-20 Retirement Contributions City Pension Travel and Per Diem Training and Per Diem 40-20 Travel and Per Diem Expense Allowance Books/Publications, Memberships, Subscriptions Books & Subscriptions 54-20 Books/Publications, Memberships, Subscriptions Memberships 91-35 Intragovernmental Transfers Out Capital Projects Fund 71-10 Principal (Loan Repayments) 72-10 Interest (Loan Repayments) 91-00 Intragovernmental Transfers Out General Fund (Columbus Project; Broward County Grant Reimbursement) 91-00 Intragovernmental Transfers Out General Fund 12-13 Salaries and Wages Expense Allowance 21-20 22-10 12-14 Cell Phone Stipend Special Pay (Accrued Leave) 14-10 Overtime Regular 15-15 21-10 49-20 Contractual Services General 47-10 NEW Promotional Activities (Community Events) Infrastructure (Trion Public Improvements) 52-10 Operating Supplies Gasoline 46-30 Repair & Maint. Services (Vehicles) E F=B+C+E G=A-F H I J=H+I Capital Est. Carryforward from FY 2022 2023 Budget Appropriation Transfers & Amendments )FY 2022 Final Estimated Funds Available Total Encumbrances and Expenses Forecasted Expenditures FY 2023 Budget 4,576.05 27,614.00 - - 29,271.00 29,271.00 1,830.66 6,001.00 - - 6,361.00 6,361.00 1,106.40 1,440.00 - - 1,526.00 1,526.00 (2,170.25) - - - - - 1,939.92 6,943.00 - - 7,360.00 7,360.00 9,617.78 26,269.00 - - 27,845.00 27,845.00 2,126.18 6,473.00 - - 6,861.00 6,861.00 - - - - - - 23,354.31 75,184.00 - - 79,695.00 79,695.00 1,858.05 5,731.00 - - 6,075.00 6,075.00 46,551.95 85,139.00 - - 90,247.00 90,247.00 79.70 471.00 - - 499.00 499.00 273.10 216,100.00 - - 60,500.00 60,500.00 - 10,000.00 - - 10,000.00 10,000.00 2,505.00 4,000.00 - - 15,855.00 15,855.00 5,895.41 10,000.00 - - 22,800.00 22,800.00 - - - - - - 782.88 800.00 - - 2,500.00 2,500.00 1,590.64 2,000.00 - - 3,000.00 3,000.00 2,000.00 2,000.00 - - 2,000.00 2,000.00 965.00 2,000.00 - - 2,500.00 2,500.00 2,909.99 204,000.00 - - 195,000.00 195,000.00 - - - - 134,350.00 134,350.00 - - - - - - 2,860.00 2,860.00 - - 2,860.00 2,860.00 3,382.09 5,000.00 - - 6,000.00 6,000.00 380.10 750.00 - - 750.00 750.00 105.09 1,600.00 - - 8,440.00 8,440.00 - - - - - - 1,092.06 12,000.00 - - 6,045.00 6,045.00 2,527.99 6,000.00 - - 475.00 475.00 - - 500,000.00 500,000.00 - 500,000.00 - - 666,667.00 666,667.00 - 666,667.00 - - - - - - - - - - - - - - - - - - - - - - - - 62,971.25 251,888.00 - - 259,445.00 259,445.00 - - - - - - 37,500.00 150,000.00 - - 150,000.00 150,000.00 - - - - - - 4,756.00 19,024.00 - - 19,595.00 19,595.00 743.50 2,974.00 - - 3,063.00 3,063.00 19,987.75 79,951.00 - - 82,350.00 82,350.00 Page 11 of 19 09/23/2022 Account Description EXPENSE Account Division 06 - Marine Division 03 - College Gardens Activity 552 - Industry Development 31-10 Prof. Services General 31-42 Prof. Services CRA - Redevelopment Initiatives Division 03 - College Gardens Totals 63-10 Infrastructure Improvements other than Bldgs. Division 05 - East Federal Highway Activity 552 - Industry Development 63-42 Infrastructure CRA Landscaping Enhancements Division 04 - Dania Beach Heights Activity 552 - Industry Development 62-10 Infrastructure CRA Buildings Infrastructure CRA Parks Improvements 63-41 Infrastructure CRA Streetscape Enhancements 99-80 Other Uses Reserve for CRA 63-42 Infrastructure CRA Landscaping Enhancements 63-41 Infrastructure CRA Streetscape Enhancements 63-10 63-44 63-43 Infrastructure Improvements other than Bldgs. Division 05 - East Federal Highway Totals Infrastructure CRA Landscaping Enhancements 63-43 Infrastructure CRA Parks Improvements 48-10 Promotional Activities General 63-41 Infrastructure CRA Streetscape Enhancements 63-42 31-41 Prof. Services CRA - Marketing/PR 31-42 Prof. Services CRA - Redevelopment Initiatives 63-42 Infrastructure CRA Landscaping Enhancements Division 02 - City Center Totals 31-10 Prof. Services General Division 04 - Dania Beach Heights Totals Infrastructure CRA Neighborhood Beautification Division 02 - City Center Activity 552 - Industry Development 31-10 Prof. Services CRA - General Division 01 - Admin Totals 40-10 Travel and Per Diem Training and Per Diem E F=B+C+E G=A-F H I J=H+I Capital Est. Carryforward from FY 2022 2023 Budget Appropriation Transfers & Amendments )FY 2022 Final Estimated Funds Available Total Encumbrances and Expenses Forecasted Expenditures FY 2023 Budget - - 9,280.00 - - - 375,114.90$ 1,624,352.00$ 1,175,947.00$ 1,166,667.00$ 1,667,416.00$ 2,834,083.00$ -$ -$ -$ -$ -$ -$ 21,297.26 51,220.00 - - 165,350.00 165,350.00 78,537.00 79,337.00 - - 300,500.00 300,500.00 - - - - - - 3,410.51 15,000.00 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 103,244.77$ 145,557.00$ -$ -$ 465,850.00$ 465,850.00$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - -$ -$ -$ -$ -$ -$ - - - - - - -$ -$ -$ -$ -$ -$ Page 12 of 19 09/23/2022 Account Description EXPENSE Account Fund Balance (end of year) Prior-Period Adjustment (Columbus Project) Fund Balance (end of year) Reflects Proposed Budget Amendment Reflects Proposed Journal Entry 62-10 Buildings EXPENSE TOTALS Prof. Services General Division 10 - Columbus Project Totals Machinery and Equipment 63-43 Infrastructure CRA Parks Improvements 64-30 99-80 Division 08 - City-Wide Activity 552 - Industry Development 31-10 63-44 Prof. Services General Division 06 - Marine Totals Division 10 - Columbus Project (Mile Marker 55) Activity 552 - Industry Development Infrastructure CRA Streetscape Enhancements63-41 Fund 106 - Community Redevelopment Agency Totals REVENUE TOTALS EXPENSE TOTALS Infrastructure CRA Neighborhood Beautification Division 07 - Sunny Garden Isles Totals Division 07 - Sun Garden Isles Activity 552 - Industry Development 31-10 Prof. Services General 31-42 Prof. Services CRA - Redevelopment Initiatives 99-80 Other Uses Reserve for CRA Division 08 - City-Wide Totals Fund 106 - Community Redevelopment Agency Totals Activity 552 - Industry Development 31-10 Prof. Services General Division 09 - PATCH Bus Plan Totals Division 09 - Phase I PATCH Bus Plan 31-10 Activity 552 - Industry Development Reserve (pending Reallocation/Repayment) 61-10 Land E F=B+C+E G=A-F H I J=H+I Capital Est. Carryforward from FY 2022 2023 Budget Appropriation Transfers & Amendments )FY 2022 Final Estimated Funds Available Total Encumbrances and Expenses Forecasted Expenditures FY 2023 Budget -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - -$ -$ -$ -$ -$ -$ 12,495.00$ 128,000.00$ -$ -$ -$ -$ 175,000.42 181,038.00 - - 100,000.00 100,000.00 - - - - - - - - - - - - - - - - - - 187,495.42$ 309,038.00$ -$ -$ 100,000.00$ 100,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - -$ -$ -$ -$ -$ -$ 665,855.09$ 2,078,947.00$ 1,175,947.00$ 1,166,667.00$ 2,233,266.00$ 3,399,933.00$ 345,981.50$ 1,462,833.47$ (750,759.53)$ 1,166,667.00$ 1,846,926.00$ 3,013,593.00$ 665,855.09$ 2,078,947.00$ 1,175,947.00$ 1,166,667.00$ 2,233,266.00$ 3,399,933.00$ (319,873.59)$ (616,113.53)$ (1,926,706.53)$ -$ (386,340.00)$ (386,340.00)$ CAFR rolls Funds together (allocable = $1,525,662… $38K is restricted - foreclosed properties) cushion to cover FY 2023 Forecast Variances Page 13 of 19 09/23/2022 Dania Beach Community Redevelopment Agency Fund 112: CRA Patch A B C D=C-A Fund Balance (beginning of year) - - - - - 15,625.36 20,975.61 55,745.81 71,541.49 (25,379.37) 75,209.53 45,624.51 51,317.53 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - 22,432.69 25,046.77 21,379.35 14,600.00 28,111.04 80,186.39 74,517.77 54,325.56 40,600.00 52,764.92 12,164.92 - - - - - - 13,045.50 3,653.45 - 78.72 1,129.46 811.61 - 597.45 597.45 - - - - - - - 17,858.06 19,672.17 20,153.97 15,208.10 5,845.97 20,000.00 6,255.93 (13,744.07) - - - - - - - - - 59,500.00 - - - - - - - - - - 1,806.00 - - - - - - - - - - - - - 154,713.00 181,000.00 150,000.00 120,000.00 55,000.00 154,318.00 102,336.00 138,498.00 150,000.00 112,500.00 (37,500.00) - - - - - - - - - - - - 40,415.00 - - - - - - - - - - - - - - - - - -$ -$ -$ -$ 177,145.69$ 207,852.77$ 184,424.85$ 156,111.51$ 102,783.21$ 314,237.08$ 193,191.33$ 199,481.14$ 251,015.00$ 172,118.30$ (38,481.70)$ A B C D=A-(B+C) -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - 11,857.50 48,356.75 50,710.23 57,013.48 62,538.92 62,519.70 71,539.00 - 53,396.82 18,142.18 - - - - - - - 2,357.64 398.97 1,159.33 358.75 392.07 - - 100.89 (100.89) - - - - - - - - - 934.45 - - 734.00 - 738.75 (4.75) - - - - - - 735.16 3,053.73 3,073.71 3,555.37 3,889.18 3,900.53 4,481.00 - 750.76 3,730.24 - - - - - - 171.94 714.16 718.87 831.49 909.56 912.24 1,048.00 - 786.41 261.59 - - - - - - - 3,715.57 4,096.76 4,882.06 5,530.83 6,222.71 7,820.00 - 5,868.41 1,951.59 - - - - - - - - - - - - - - - - - - - - - - - 228.32 1,107.08 1,342.54 1,343.76 1,770.96 1,896.00 152.48 1,426.22 317.30 - - - - 370.00 - 62,391.35 8,652.13 72,795.46 5,375.00 5,919.70 4,650.25 25,000.00 - 21.45 24,978.55 - - - - - - - - - 3,793.79 - - - - - - - - - - 103,950.00 99,334.00 - - - - - - - - - - 31-42 Prof. Services Redevelopment Initiatives 34-10 Contractual Services General 31-10 Prof. Services General 22-20 Retirement Contributions FRS Pension 22-30 Retirement Contributions Deferred Comp. Match 24-10 21-10 Salaries and Wages Full-Time 15-15 Special Pay 14-10 Overtime Regular Account Account Description EXPENSE Department 52 - CRA FY 2010 Actual FY 2011 Actual FY 2012 Actual FY 2013 Actual FY 2014 Actual FY 2015 Actual Amended Budget Year-to-Date Encumbrances Year-to-Date Transactions Preliminary Funds Available Miscellaneous Revenues (Patch Sales) FY 2020 Actual 369-90-07 Miscellaneous Revenues (DeLuca Grant) FY 2021 Actual FY 2017 Actual FY 2016 Actual FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2022 (as of 7-7-2022) 369-91-01 Insurance Reimbursements FY 2021 Actual 389-90-17 Other Sources: Non-Operating Re-Appropriations DeLuca Grant 369-90-01 369-90-03 Miscellaneous Revenues (FL Organic Growers) Amended Budget YTD Transactions Preliminary Funds Available FY 2016 Actual FY 2017 Actual FY 2018 Actual FY 2019 Actual FY 2012 Actual FY 2013 Actual FY 2014 Actual FY 2015 Actual FY 2022 (as of 7-7-2022) Fund 112 - CRA Community Gardens (PATCH) Workers' Compensation Premium Account Account Description REVENUE Department 00 - Revenues Division 00 - Non-Dep. 361-10-01 Interest and Other Earnings Interest Operating Interest new account Rentals and Leasing Division 09 - Community Gardens (PATCH) Activity 552 - Industry Development FY 2010 Actual FY 2011 Actual Historical Activity Historical Activity Miscellaneous Revenues (All) 381-01-06 Other Sources: Non-Operating Transfer from CRA 389-90-01 Other Sources: Non-Operating Re-Appropriations Appropriated Fund Balance REVENUE TOTALS 12-11 Salaries and Wages Part Time (FRS Eligible) 21-20 FICA Medicare FICA Taxes 12-10 369-90-05 Page 14 of 19 09/23/2022 A B C D=A-(B+C) Account Account Description FY 2010 Actual FY 2011 Actual FY 2012 Actual FY 2013 Actual FY 2014 Actual FY 2015 Actual Amended Budget Year-to-Date Encumbrances Year-to-Date Transactions Preliminary Funds Available FY 2017 Actual FY 2016 Actual FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2022 (as of 7-7-2022) FY 2021 Actual Historical Activity - - - - 65.37 276.48 418.28 738.86 878.61 1,168.04 1,277.30 1,224.06 1,800.00 - 975.06 824.94 - - - - - - - - - 889.61 - - 300.00 - - 300.00 - - - - 678.51 724.02 270.70 36.07 216.42 - - - 100.00 - - 100.00 - - - - 5,163.99 23,360.14 6,199.36 6,642.42 5,965.06 6,667.03 7,413.99 3,793.49 7,600.00 - 1,789.27 5,810.73 - - - - 286.98 132.72 11,521.01 147.58 902.82 1,143.31 1,547.76 2,037.22 1,900.00 - 1,460.86 439.14 - - - - 984.66 5,133.61 4,946.24 4,598.38 4,442.30 4,358.76 4,612.88 3,768.63 5,000.00 - 3,368.52 1,631.48 - - - - - - - - 477.19 578.67 1,008.00 1,091.35 2,000.00 - 1,576.34 423.66 - - - - - - - - - - - - 2,000.00 - 51.23 1,948.77 - - - - - 1,706.04 11,513.14 11,148.36 10,040.32 9,347.28 9,347.25 9,347.25 9,348.00 2,670.89 6,466.76 210.35 - - - - - - - 3,400.00 1,800.00 - - - - - - - - - - - - - - - 122.00 137.50 491.15 - 1,000.00 - - 1,000.00 - - - - - 276.34 5,187.60 8,791.15 12,000.00 14,764.77 7,570.28 5,515.23 10,500.00 1,100.00 8,548.42 851.58 - - - - - - - 446.00 - 35.00 25.00 35.00 600.00 - - 600.00 - - - - - - - - - 313.91 125.99 350.56 600.00 - 577.81 22.19 - - - - 2,003.26 26,534.40 18,506.52 11,082.82 9,933.86 8,228.83 4,576.03 1,885.80 10,000.00 - 6,860.23 3,139.77 - - - - - - - - - - - - 1,500.00 - 340.10 1,159.90 - - - - 48,017.56 45,024.77 15,935.85 20,147.89 20,024.41 7,589.81 16,787.57 17,595.26 22,500.00 - 16,616.12 5,883.88 - - - - - - - 6,058.00 - - - - - - - - - - - - - - - - - - - - 13,414.00 - 10,060.50 3,353.50 - - - - - - - - - - - - 3,248.00 - 2,436.00 812.00 - - - - - - - - - - - - 1,436.00 - 1,077.00 359.00 - - - - - - - - - - - - 10,000.00 - - 10,000.00 -$ -$ -$ -$ 161,520.33$ 202,502.52$ 149,654.65$ 140,315.83$ 199,704.07$ 134,110.03$ 135,273.90$ 127,012.31$ 217,364.00$ 3,923.37$ 125,293.93$ 88,146.70$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 63,750.96$ 8,000.00$ 52,500.96$ -$ -$ -$ -$ - - - - - - - - - - 46,903.16 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 2,011.29 448.97 7,040.00 - - - - -$ -$ -$ -$ -$ -$ -$ -$ -$ 65,762.25$ 55,352.13$ 59,540.96$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 11,249.97$ 6,250.03$ -$ 5,834.00$ -$ -$ 5,834.00$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 429.72 1,840.00 - 330.00 1,510.00 - - - - - - - - - 105.70 110.68 248.95 3,433.00 - - 3,433.00 - - - - - - - - - 2,420.23 789.61 2,107.18 893.00 - - 893.00 - - - - - - - - - - 25,000.00 4,449.00 1,051.00 - - 1,051.00 -$ -$ -$ -$ -$ -$ -$ -$ -$ 13,775.90$ 32,150.32$ 7,234.85$ 13,051.00$ -$ 330.00$ 12,721.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 20,600.00$ -$ 13,400.00$ 7,200.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 20,600.00$ -$ 13,400.00$ 7,200.00$ 91-51 Intragovernmental Transfers Out Facilities Fund 91-52 Intragovernmental Transfers Out Fleet Mgmt Fund 91-53 Intragovernmental Transfers Out IT Systems Fund 52-10 Operating Supplies Gasoline and Diesel Fuel 62-10 Buildings 34-20 Contractual Services Merchant Card Processing Fees 41-10 Communications Services Telephone Utility Services Water 43-20 Utility Services Electricity 46-10 Printing and Binding General 52-06 40-10 Travel and Per Diem Training and Per Diem 51-10 Office Supplies General Repair & Maintenance (Utilities) 49-30 Permits & Licenses 44-10 Rentals and Leases Equipment 46-50 Repair & Maintenance (Grounds) 48-10 Promotional Activities Repair & Maintenance (Equipment) 47-10 43-10 34-10 Contractual Services General 40-10 Travel and Per Diem 44-20 Rentals and Leases Trailers 52-20 Operating Supplies Miscellaneous Division 10 - Totals Division 11 - DeLuca Grant Activity 552 - Industry Development 31-10 Prof. Services General 34-10 Contractual Services General 40-10 Travel and Per Diem 44-20 Rentals and Leases Trailers Operating Supplies Miscellaneous Other Uses Reserve for CRA Division 09 - Totals 52-20 Division 11 - Totals Division 10 - USDA Grant Activity 552 - Industry Development 31-10 Prof. Services General 52-10 Operating Supplies Gasoline and Diesel Fuel 99-10 Division 12 - UHP Grant Activity 552 - Industry Development 31-10 Prof. Services General Division 12 - Totals 64-20 M&E Vehicle 46-30 Repair & Maintenance (Vehicles) 46-30 Repair & Maintenance (Vehicles) 46-70 52-20 Operating Supplies Miscellaneous Operating Supplies Cost of Goods Sold (PATCH) Page 15 of 19 09/23/2022 A B C D=A-(B+C) Account Account Description FY 2010 Actual FY 2011 Actual FY 2012 Actual FY 2013 Actual FY 2014 Actual FY 2015 Actual Amended Budget Year-to-Date Encumbrances Year-to-Date Transactions Preliminary Funds Available FY 2017 Actual FY 2016 Actual FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2022 (as of 7-7-2022) FY 2021 Actual Historical Activity -$ -$ -$ -$ 161,520.33$ 202,502.52$ 149,654.65$ 140,315.83$ 199,704.07$ 213,648.18$ 222,776.35$ 193,788.12$ 251,015.00$ 3,923.37$ 139,023.93$ 108,067.70$ -$ -$ -$ -$ 177,145.69$ 207,852.77$ 184,424.85$ 156,111.51$ 102,783.21$ 314,237.08$ 193,191.33$ 199,481.14$ 251,015.00$ -$ 172,118.30$ (38,481.70)$ -$ -$ -$ -$ 161,520.33$ 202,502.52$ 149,654.65$ 140,315.83$ 199,704.07$ 213,648.18$ 222,776.35$ 193,788.12$ 251,015.00$ 3,923.37$ 139,023.93$ 108,067.70$ -$ -$ -$ -$ 15,625.36$ 5,350.25$ 34,770.20$ 15,795.68$ (96,920.86)$ 100,588.90$ (29,585.02)$ 5,693.02$ -$ (3,923.37)$ 33,094.37$ (146,549.40)$ Fund Balance (end of year) $ - $ - $ - $ - $ 15,625.36 $ 20,975.61 $ 55,745.81 $ 71,541.49 $ (25,379.37) $ 75,209.53 $ 45,624.51 $ 51,317.53 $ 84,411.90 Beginning Fund Balance (as of 9/30/2021)51,318 Reflects Proposed Budget Amendment FY 2022 Revenues to-date 172,118 Reflects Proposed Journal Entry FY 2022 Forecasted Revenues 37,500 FY 2022 Encumbrances to-date (3,923) FY 2022 Expenditures to-date (139,024) FY 2022 Forecasted Expenses (78,252) Preliminary Available CF 39,737 FY 2023 Carryforward (38,209) Excess Fund Balance 1,528 EXPENSE TOTALS Fund 112 - CRA Community Garden (PATCH) EXPENSE TOTALS Fund 112 - CRA Community Garden (PATCH) REVENUE TOTALS Page 16 of 19 09/23/2022 Dania Beach Community Redev Fund 112: CRA Patch Fund Balance (beginning of year) 31-42 Prof. Services Redevelopment Initiatives 34-10 Contractual Services General 31-10 Prof. Services General 22-20 Retirement Contributions FRS Pension 22-30 Retirement Contributions Deferred Comp. Match 24-10 21-10 Salaries and Wages Full-Time 15-15 Special Pay 14-10 Overtime Regular Account Account Description EXPENSE Department 52 - CRA Miscellaneous Revenues (Patch Sales) 369-90-07 Miscellaneous Revenues (DeLuca Grant) 369-91-01 Insurance Reimbursements 389-90-17 Other Sources: Non-Operating Re-Appropriations DeLuca Grant 369-90-01 369-90-03 Miscellaneous Revenues (FL Organic Growers) Fund 112 - CRA Community Gardens (PATCH) Workers' Compensation Premium Account Account Description REVENUE Department 00 - Revenues Division 00 - Non-Dep. 361-10-01 Interest and Other Earnings Interest Operating Interest new account Rentals and Leasing Division 09 - Community Gardens (PATCH) Activity 552 - Industry Development Miscellaneous Revenues (All) 381-01-06 Other Sources: Non-Operating Transfer from CRA 389-90-01 Other Sources: Non-Operating Re-Appropriations Appropriated Fund Balance REVENUE TOTALS 12-11 Salaries and Wages Part Time (FRS Eligible) 21-20 FICA Medicare FICA Taxes 12-10 369-90-05 E F=C+E G=A-F H I J=H+I -$ -$ -$ -$ -$ -$ - - - - - - - 52,764.92 12,164.92 - 40,600.00 40,600.00 - 597.45 597.45 - - - - 6,255.93 (13,744.07) - 20,000.00 20,000.00 - - - - - - - - - - - - 37,500.00 150,000.00 - - 150,000.00 150,000.00 - - - - - - - - - 13,209.00 25,000.00 38,209.00 37,500.00$ 209,618.30$ (981.70)$ 13,209.00$ 235,600.00$ 248,809.00$ E F=B+C+E G=A-F H I J=H+I -$ -$ -$ -$ -$ -$ 18,142.18 71,539.00 - - 75,831.00 75,831.00 - 100.89 (100.89) - - - - 738.75 (4.75) - 778.00 778.00 3,730.24 4,481.00 - - 4,750.00 4,750.00 261.59 1,048.00 - - 1,111.00 1,111.00 1,951.59 7,820.00 - - 8,289.00 8,289.00 - - - - - - 317.30 1,896.00 - - 2,010.00 2,010.00 24,978.55 25,000.00 - - 26,000.00 26,000.00 - - - - - - - - - - - - 2023 Budget Appropriation Transfers & Amendments Forecasted Expenditures Total Encumbrances and Expenses Final Estimated Funds Available Capital Est. Carryforward from FY 2022 ) Forecasted Revenue Collections Total Revenues )FY 2023 Capital Est. Carryforward from FY 2022 2023 Budget Appropriation Transfers & Amendments Final Estimated Funds Available FY 2023 Budget FY 2023 Budget FY 2023 Page 17 of 19 09/23/2022 Account Account Description 91-51 Intragovernmental Transfers Out Facilities Fund 91-52 Intragovernmental Transfers Out Fleet Mgmt Fund 91-53 Intragovernmental Transfers Out IT Systems Fund 52-10 Operating Supplies Gasoline and Diesel Fuel 62-10 Buildings 34-20 Contractual Services Merchant Card Processing Fees 41-10 Communications Services Telephone Utility Services Water 43-20 Utility Services Electricity 46-10 Printing and Binding General 52-06 40-10 Travel and Per Diem Training and Per Diem 51-10 Office Supplies General Repair & Maintenance (Utilities) 49-30 Permits & Licenses 44-10 Rentals and Leases Equipment 46-50 Repair & Maintenance (Grounds) 48-10 Promotional Activities Repair & Maintenance (Equipment) 47-10 43-10 34-10 Contractual Services General 40-10 Travel and Per Diem 44-20 Rentals and Leases Trailers 52-20 Operating Supplies Miscellaneous Division 10 - Totals Division 11 - DeLuca Grant Activity 552 - Industry Development 31-10 Prof. Services General 34-10 Contractual Services General 40-10 Travel and Per Diem 44-20 Rentals and Leases Trailers Operating Supplies Miscellaneous Other Uses Reserve for CRA Division 09 - Totals 52-20 Division 11 - Totals Division 10 - USDA Grant Activity 552 - Industry Development 31-10 Prof. Services General 52-10 Operating Supplies Gasoline and Diesel Fuel 99-10 Division 12 - UHP Grant Activity 552 - Industry Development 31-10 Prof. Services General Division 12 - Totals 64-20 M&E Vehicle 46-30 Repair & Maintenance (Vehicles) 46-30 Repair & Maintenance (Vehicles) 46-70 52-20 Operating Supplies Miscellaneous Operating Supplies Cost of Goods Sold (PATCH) E F=B+C+E G=A-F H I J=H+I 2023 Budget Appropriation Transfers & Amendments Forecasted Expenditures Total Encumbrances and Expenses Final Estimated Funds Available Capital Est. Carryforward from FY 2022 ) FY 2023 Budget FY 2023 824.94 1,800.00 - - 1,872.00 1,872.00 300.00 300.00 - - 312.00 312.00 100.00 100.00 - - 104.00 104.00 5,810.73 7,600.00 - - 7,904.00 7,904.00 439.14 1,900.00 - - 1,976.00 1,976.00 1,631.48 5,000.00 - - 5,200.00 5,200.00 423.66 2,000.00 - - 2,080.00 2,080.00 1,948.77 2,000.00 - - 2,080.00 2,080.00 210.35 9,348.00 - - 9,722.00 9,722.00 - - - - - - 1,000.00 1,000.00 - - 1,040.00 1,040.00 851.58 10,500.00 - - 10,920.00 10,920.00 600.00 600.00 - - 624.00 624.00 22.19 600.00 - - 624.00 624.00 3,139.77 10,000.00 - - 10,400.00 10,400.00 1,159.90 1,500.00 - - 1,560.00 1,560.00 5,883.88 22,500.00 - - 23,400.00 23,400.00 - - - - - - 3,353.50 13,414.00 - - 13,816.00 13,816.00 812.00 3,248.00 - - 3,345.00 3,345.00 359.00 1,436.00 - - 1,479.00 1,479.00 - - 10,000.00 - 18,373.00 18,373.00 78,252.34$ 207,469.64$ 9,894.36$ -$ 235,600.00$ 235,600.00$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - -$ -$ -$ -$ -$ -$ -$ -$ 5,834.00$ 6,009.00$ -$ 6,009.00$ - - - - - - - - - - - - - - - - - - - 330.00 1,510.00 - - - - - 3,433.00 - - - - - 893.00 - - - - - 1,051.00 - - - -$ 330.00$ 12,721.00$ 6,009.00$ -$ 6,009.00$ -$ 13,400.00$ 7,200.00$ 7,200.00$ -$ 7,200.00$ -$ 13,400.00$ 7,200.00$ 7,200.00$ -$ 7,200.00$ Page 18 of 19 09/23/2022 Account Account Description Fund Balance (end of year) Reflects Proposed Budget Amendment Reflects Proposed Journal Entry EXPENSE TOTALS Fund 112 - CRA Community Garden (PATCH) EXPENSE TOTALS Fund 112 - CRA Community Garden (PATCH) REVENUE TOTALS E F=B+C+E G=A-F H I J=H+I 2023 Budget Appropriation Transfers & Amendments Forecasted Expenditures Total Encumbrances and Expenses Final Estimated Funds Available Capital Est. Carryforward from FY 2022 ) FY 2023 Budget FY 2023 78,252.34$ 221,199.64$ 29,815.36$ 13,209.00$ 235,600.00$ 248,809.00$ 37,500.00$ 209,618.30$ (981.70)$ 13,209.00$ 235,600.00$ 248,809.00$ 78,252.34$ 221,199.64$ 29,815.36$ 13,209.00$ 235,600.00$ 248,809.00$ (40,752.34)$ (11,581.34)$ (30,797.06)$ -$ -$ -$ CAFR rolls Funds together (allocable = $51,318) cushion to cover FY 2023 Forecast Variances Page 19 of 19 09/23/2022