Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Item F1
f.1 County of Monroe` BOARD OF COUNTY COMMISSIONERS Mayor David Rice, District 4 The Flonda, Keys Mayor Pro Tem Sylvia J. Murphy, District 5 y P_ ,: Danny L. Kolhage, District I George Neugent, District 2 Heather Carruthers, District 3 County Commission Meeting February 21, 2018 Agenda Item Number: F.1 Agenda Item Summary #3931 BULK ITEM: Yes DEPARTMENT: Budget and Finance TIME APPROXIMATE: STAFF CONTACT: Christina Brickell (305) 292 -4466 N/A AGENDA ITEM WORDING: Budget & Finance Report ITEM BACKGROUND: PREVIOUS RELEVANT BOCC ACTION: CONTRACT /AGREEMENT CHANGES: N/A STAFF RECOMMENDATION: DOCUMENTATION: Major Revenues February 2018 Report FINANCIAL IMPACT: Effective Date: Expiration Date: Total Dollar Value of Contract: Total Cost to County: Current Year Portion: Budgeted: Source of Funds: CPI: Indirect Costs: Estimated Ongoing Costs Not Included in above dollar amounts: Revenue Producing: If yes, amount: Packet Pg. 3441 F.1 Grant: County Match: Insurance Required: Additional Details: REVIEWED BY: Kathy Peters Board of County Commissioners Completed Pending 02/07/2018 9:28 AM 02/21/2018 9:00 AM Packet Pg. 3442 F.1.a February 2018 YTD Actual Year -End Fiscal Year Oct -Nov Total Budget 2018 466,553 4,761,157 2017 586,371 4,564,973 4,568,220 $inc /dec (119,818) 192,937 % inc /dec -20.4% 4.2% YTD Actual Year -End Fiscal Year Oct -Dec Total Budget State EstnI 2018 2,102,487 12,127,000 12,106,227 2017 2,367,250 11,379,204 11,783,821 11,783,821 $ inc /dec 1264,762) 343,179 322,406 % inc /dec - 11.2°% 2.9% 2.7% 1 YTD Actual Year -End Fiscal Year Oct -Dec Total Budget State EstnI 2018 109,204 575,000 566,490 2017 119,806 564,819 560,000 573,142 $inc /dec 11 15,000 % inc /dec -8.8% 2.7% -1.2% e 1 e - YTD Actual Year -End Fiscal Year Oct -Dec Total Budget State EstnI 2018 1 . • . e 1,145,013 2017 YTD Actual Year -End 1,123,568 Fiscal Year Oct -Dec Total Budget State EstnI 2018 346,918.29 2,023,000 2,002,490 2017 400,254.34 1,979,973 1,875,000 2,038,774 $inc /dec 15,602 148,000 41,341 % inc /dec - 13.3°% 7.9% -1.8% e 1 e - YTD Actual Year -End Fiscal Year Oct -Dec Total Budget State EstnI 2018 281,335 1,150,000 1,145,013 2017 278,183 1,147,550 1,100,000 1,123,568 $ inc /dec 3,152 50,000 21,445 % inc /dec 1.1% 4.5% 1.9% Page 1 O CL d d V C ca C LL 06 d Cl O m Office of Management and Budge Packet Pg. 3443 YTD Actual Year -End Fiscal Year Oct -Dec Total Budget State EstnI 2018 642,127 2,725,000 2,594,197 2017 626,525 2,594,896 2,480,000 2,552,856 $ inc /dec 15,602 245,000 41,341 % inc /dec 2.5% 9.9% 1.6% Page 1 O CL d d V C ca C LL 06 d Cl O m Office of Management and Budge Packet Pg. 3443 YTD Actual Year -End Fiscal Year Oct -Dec Total Budget State EstnI 2018 3,679,153 21,500,000 23,950,492 2017 4,221,842 21,510,929 21,000,000 21,510,929 $ inc /dec 500,000 2,439,563 % inc /dec -12.9% 2.4% 11.3% *State releases revenue estimates for the County in July for the following fiscal year. Page 1 O CL d d V C ca C LL 06 d Cl O m Office of Management and Budge Packet Pg. 3443 F.1.a February 2018 Last year's collection rate for Monroe County was 96.7 %. We are currently on track for the year. However, Property owners have until April to pay their property taxes for FY 2018. OMB estimates the collection rate for FY 2018 to be near 96 %. 2017 2018 October - January October- January Ad Valorem Collection % Collection % Collection Variance Total Ad Valorem Collection 79.0% One cent tax split is 50% for Monroe County and 50% for Land Authority. Below is the Monroe County portion. 398,052.11 % % YTD +/ % 2016 Change 2017 Change 2018 Prior Year Change October 265,641.40 8.3% 267,788.28 0.8% 213,972.89 (53,815.39) -20.1% November 319,216.01 19.1% 318,582.67 -0.2% 252,580.02 (66,002.65) -20.7% December 398,052.11 7.6% 409,399.53 2.9% January 450,312.94 3.7% 451,378.22 0.2% February 509,201.13 5.4% 505,970.80 -0.6% March 602,916.29 10.1% 583,611.14 -3.2% April 418,131.83 0.9% 479,271.22 14.6% May 357,976.20 4.0% 375,293.33 4.8% June 336,801.97 5.2% 354,437.57 5.2% July 402,989.63 10.0% 425,147.65 5.5% August 293,324.70 -0.1% 291,358.77 -0.7% September 224,593.38 7.1% 102,733.41 -54.3% Total 4,579,157.59 4,564,972.59 466,552.91 (119,818.04) -20.4% % inc /dec prior yr 6.6% -0.3% 80.0% 1.0% Fund 001 - Tourist Impact Tax 700,000.00 600,000.00 500,000.00 400,000.00 300,000.00 200,000.00 100,000.00 ■ 2016 ■ 2017 ■ 2018 Page 2 O Q d d V c ca c LL 06 d Cl m Office of Management and Budget packet Pg. 3444 J\A J5� et OG __o� F.1.a February 2018 Current FY18 allocation is split 89% to the General Fund 001 & 11% to the Plan, Build, Zoning Fund 148. 2018 Federal, State, and County Tax Rates on Motor Fuel and Diesel Fuel in Florida's Counties Prior Year % (242,312.80) % YTD -3.0% 2016 Change 2017 Change 2018 October 679,100.93 16.2% 699,042.24 2.9% 456,729.44 November 718,317.57 -9.9% 834,340.60 16.2% 808,988.58 December 878,785.21 14.7% 833,866.69 -5.1% 836,769.47 January 1,009,355.36 1.8% 1,030,124.91 2.1% IM sent February 913,648.46 -6.1% 1,008,684.13 10.4% SCETS F J Fud FueY March 1,044,546.13 4.3% 1,051,330.83 0.6% nnulilvxd April 1 -2.9% 1,239,182.16 11.5% Foal May 1,112,272.01 19.0% 1,093,188.95 -1.7% Tar Tax Tar June 842,989.39 -3.1% 955,578.90 13.4% Tax July 828,346.10 5.6% 882,265.57 6.5% Tar. August 1 26.5% 1,015,427.48 - 13.1% -2.7 September 784,614.98 - 18.8% 736,171.56 -6.2% 13.7 Total 001 + 148 % inc /dec prior yr 11,092,026.65 11,379,204.02 2,102,487.49 (264,762.04) -11.2% 3.3% 2.6% FY18 State Estimate - 100% 12,106,227 Fund 001- 89% 10,774,542 Fund 148 -11% 1,331,685 2018 Federal, State, and County Tax Rates on Motor Fuel and Diesel Fuel in Florida's Counties Prior Year Change (242,312.80) Met -Fuel Tax Rates # of Cents Per Galion -3.0% llnutiVized Cofr�ty- Imposed 0.3% Diesel Fuel Tax Rates of Cents Per Gallon Federal state Coun Lacal D ion % Motar Fuel Taxes Federal Stale cou Local ion Change 2017 Fuel Fuel Gms4L Gaunty �hAUniopal I I 1 Cen:s Change Vin=' 1 - 1 -Stems Total Fue! Fuel (2,913.10) Fuef IM sent 1d Ceram 9 -5 Gen¢ 39,836.60 -6.3% Ewe Safes SCETS F J Fud FueY Fuel Fuef FuN Total Fuel Fuel Fuel nnulilvxd Exase Sales 5CET5 Erase Fuel Foal Fu Total Tax Tax Tax T- Tax Tax Tar Tax Tar Tax Tax Tax Tax Tax Tax Tax Tax Tax. Tar Tax Tar. Tax donne F6.4 13.7 7.8 2 F 1 9 8 3 -2.7 0 0 2 2 24.4 13.7 7.6 4 I 8 n'a 56.7 11,092,026.65 11,379,204.02 2,102,487.49 (264,762.04) -11.2% 3.3% 2.6% FY18 State Estimate - 100% 12,106,227 Fund 001- 89% 10,774,542 Fund 148 -11% 1,331,685 Prior Year Change (242,312.80) - 34.7% 1 cent on every net gallon of motor and diesel fuel sold. -3.0% 2,902.78 0.3% % % YTD +/- % 2016 Change 2017 Change 2018 Prior Year Change October 42,711.45 11.6% 45,260.41 6.0% 42,347.31 (2,913.10) -6.4% November 42,533.94 7.2% 39,836.60 -6.3% 32,415.55 (7,421.05) - 18.6% December 36,951.47 12.5% 34,709.31 -6.1% 34,440.77 (268.54) -0.8% January 46,042.66 27.5% 43,298.20 -6.0% February 43,622.07 1.2% 42,529.78 -2.5% March 45,413.48 -8.1% 42,535.95 -6.3% April 51,521.83 5.9% 57,660.69 11.9% May 49,901.10 -2.0% 43,068.19 - 13.7% June 46,450.03 - 31.2% 54,927.69 18.3% July 49,603.05 8.9% 48,236.30 -2.8% August 53,448.24 -2.9% 54,283.60 1.6% September 54,754.48 60.6% 58,472.46 6.8% 11,092,026.65 11,379,204.02 2,102,487.49 (264,762.04) -11.2% 3.3% 2.6% FY18 State Estimate - 100% 12,106,227 Fund 001- 89% 10,774,542 Fund 148 -11% 1,331,685 Total 562,953.80 564,819.18 109,203.63 (10,602.69) -8.8% % inc /dec prior yr 4.0% 0.3% ►>y O CL d iY v c E LL r C1 m FY18 State Estimate 566,490 11 Payments were posted in FY17 instead of 12. The above has been corrected. Page 3 Office of Management and Budget packet Pg. 3445 Prior Year Change (242,312.80) - 34.7% ( -7 -, -3.0% 2,902.78 0.3% Total 562,953.80 564,819.18 109,203.63 (10,602.69) -8.8% % inc /dec prior yr 4.0% 0.3% ►>y O CL d iY v c E LL r C1 m FY18 State Estimate 566,490 11 Payments were posted in FY17 instead of 12. The above has been corrected. Page 3 Office of Management and Budget packet Pg. 3445 F.1.a February 2018 6 cents of the 1 to 6 cents fuel tax imposed on motor and diesel fuels & 3 cents of the 1 to 5 cents fuel tax imposed on motor fuel only. % YTD +/ % 2016 Change 2017 Change % Prior Year % YTD +/ % 88,962.57 3.8% 2016 Change 2017 Change 2018 Prior Year Change 1.8% October 145,285.85 15.9% 158,047.83 8.8% 143,393.08 (14,654.75) -9.3% 94,293.30 November 144,634.05 10.4% 133,980.78 -7.4% 96,996.95 (36,983.83) -27.6% December 123,564.40 21.8% 108,225.73 -12.4% 106,528.26 (1,697.47) -1.6% January 158,376.66 38.1% 146,348.24 -7.6% April February 150,677.40 2.1% 145,374.07 -3.5% May 88,029.17 March 156,164.23 -11.1% 143,559.82 -8.1% June 97,004.01 8.4% April 184,337.13 8.5% 212,055.65 15.0% July 99,263.36 -0.5% 95,962.28 May 176,222.01 9.6% 146,755.71 -16.7% 95,270.96 4.8% 92,746.02 Q September 92,239.86 6.7% 99,915.79 8.3% June 160,071.88 -2.3% 200,024.38 25.0% 1,147,550.11 281,335.37 3,152.45 July 176,475.45 11.6% 170,232.69 -3.5% August 194,413.75 -4.0% 198,324.08 2.0% c September 201,685.47 -8.6% 217,043.75 7.6% c LL Total 1,971,908.28 1,979,972.73 346,918.29 _ .. -13.3% 06 % inc /dec prior yr 5.4% 0.4% r FY18 State Estimate 2,002,490 m 11 Payments were posted in FY17 instead of 12. The above has been corrected 1 cent on every net gallon of motor fuel sold FY18 State Estimate 1,145,013 11 Payments were posted in FY17 instead of 12. The above has been corrected. Page 4 Office of Management and Budget Packet Pg. 3446 % % YTD +/ % 2016 Change 2017 Change 2018 Prior Year Change October 85,713.42 5.5% 88,962.57 3.8% 89,672.48 709.91 0.8% November 93,639.53 6.5% 95,355.37 1.8% 97,369.59 2,014.22 2.1% December 89,981.25 6.2% 93,864.98 4.3% 94,293.30 428.32 0.5% January 93,699.24 6.1% 96,413.17 2.9% February 91,706.88 2.8% 95,535.86 4.2% March 92,883.84 9.8% 90,233.50 -2.9% April 101,551.84 5.5% 105,675.65 4.1% May 88,029.17 -5.9% 96,137.26 9.2% June 97,004.01 8.4% 96,747.66 -0.3% July 99,263.36 -0.5% 95,962.28 -3.3% August 95,270.96 4.8% 92,746.02 -2.7% September 92,239.86 6.7% 99,915.79 8.3% Total 1,120,983.36 1,147,550.11 281,335.37 3,152.45 1.1% % inc /dec prior yr 4.5% 2.4% FY18 State Estimate 1,145,013 11 Payments were posted in FY17 instead of 12. The above has been corrected. Page 4 Office of Management and Budget Packet Pg. 3446 F.1.a February 2018 2 cents on every net gallon of motor fuel sold. % % YTD +/- % % 2016 % YTD +/ 2018 2016 Change 2017 Change 2018 Prior Year October 177,672.98 5.7% 201,504.06 13.4% 230,445.27 28,941.21 November 231,595.97 19.7% 233,967.92 1.0% 220,890.16 (1 ,u /.r6) December 201,896.72 -5.8% 191,053.11 -5.4% 190,791.29 (261.82) January 192,597.45 -5.2% 218,396.94 13.4% February 230,091.45 14.0% 236,734.65 2.9% March 187,983.52 -3.2% 187,879.39 -0.1% 1.0% April 233,414.71 - 10.0% 235,048.17 0.7% 2,468,135.42 4.8% May 220,028.52 4.3% 221,493.02 0.7% 5.0% 1,972,652.12 June 225,844.09 7.7% 222,536.58 -1.5% 1,641,060.41 4.5% July 195,106.87 -5.4% 234,802.17 20.3% July 1,803,754.92 August 168,807.05 2.6% 193,975.81 14.9% August September 262,589.06 1,878,652.21 217,504.34 - 17.2% Total 2,527,628.39 2,594,896.16 642,126.72 15,601.63 % inc /dec prior yr 3.7% 2.7% FY18 State Estimate 2,594,197 Change 14.4% -5.6% -0.1% 2.5% ieptember revenue for FY15 was posted to FY16. The above has been corrected. Total 20,817,676.03 21,510,929.28 3,679,152.50 (542,689.76) -12.9% % inc /dec prior yr 3.3% 3.3% FY18 State Estimate 23,950,492 Page 5 O CL d v c ca E LL 06 r d Cl m Office of Management and Budget Packet Pg. 3447 % % YTD +/- % 2016 Change 2017 Change 2018 Prior Year Change October 1,205,304.23 11.6% 1,233,289.39 2.3% 772,618.19 (460,671.20) - 37.4% November 1,415,337.45 -1.5% 1,491,046.98 5.3% 1,432,345.70 (58,701.28) -3.9% December 1,590,803.54 18.9% 1,497,505.89 -5.9% 1,474,188.61 (23,317.28) -1.6% January 2 3.1% 2,046,234.68 0.7% February 1,783,159.21 0.3% 1,825,694.64 2.4% March 1,904,018.36 3.7% 1,923,140.14 1.0% April 2 2.6% 2,468,135.42 4.8% May 1,759,183.23 5.0% 1,972,652.12 12.1% June 1,641,060.41 4.5% 1,726,607.09 5.2% July 1,803,754.92 3.4% 1,915,181.08 6.2% August 1,737,324.15 -1.8% 1,878,652.21 8.1% September 1,590,224.11 -4.7% 1,532,789.64 -3.6% Total 20,817,676.03 21,510,929.28 3,679,152.50 (542,689.76) -12.9% % inc /dec prior yr 3.3% 3.3% FY18 State Estimate 23,950,492 Page 5 O CL d v c ca E LL 06 r d Cl m Office of Management and Budget Packet Pg. 3447 F.1.a February 2018 EVENUE SOURCE AMENDED BUDGET FISCAL YEAR 2018 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET AMENDED BUDGET FISCAL YEAR 2017 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET D VALOREM TAXES 83,766,613.00 67,003,922.79 16,762,690.21 79.99 79,924,914.00 63,132,031.51 16,792,882.49 78.99 EL AD VALOREM TAX 180,000.00 82,529.68 97,470.32 45.85 238,000.00 4,260.69 233,739.31 1.79 OURIST DEV TAX -2 18,615,000.00 1,866,211.67 16,748,788.33 10.03 18,000,000.00 2,345,483.77 15,654,516.23 13.03 OURIST DEVELOP TA 18,615,000.00 1,866,211.67 16,748,788.33 10.03 18,000,000.00 2,345,483.77 15,654,516.23 13.03 OURIST IMPACT TAX 4,761,157.00 466,552.91 4,294,604.09 9.80 4,568,220.00 586,370.95 3,981,849.05 12.84 LS TX-COUNTY 9CE 575,000.00 167,676.09 407,323.91 29.16 560,000.00 119,806.32 440,193.68 21.39 UEL TAX-LOC OPTIO 2,023,000.00 563,962.04 1,459,037.96 27.88 1,875,000.00 400,254.34 1,474,745.66 21.35 ISCRET SALES TAX 21,500,000.00 3,679,152.50 17,820,847.50 17.11 21,000,000.00 2,828,090.58 18,171,909.42 13.47 OCCOMMUNICATION 615,000.00 193,363.26 421,636.74 31.44 665,000.00 157,224.64 507,775.36 23.64 OCAL BUSINESS TAX 460,000.00 111,666.59 348,333.41 24.28 440,000.00 91,622.32 348,377.68 20.82 (300.00) TOTAL TAXES 151,110,770.00 76,001,249.20 75,109,520.80 50.30 145,271,134.00 72,010,628.89 73,260,505.11 49.57 UILDING PERMITS 4,550,000.00 1,022,504.20 3,527,495.80 22.47 3,758,782.27 1,539,798.02 2,218,984.25 40.97 LDG PERMIT -1310 ED 10,240.00 (10,240.00) - 14,170.00 19,220.00 (5,050.00) 135.64 LDG PERMITS -FIRE - 630.00 (630.00) - 1,000.00 1,340.00 (340.00) 134.00 LDG PERMIT- COMPET 100,000.00 78,842.50 21,157.50 78.84 25,000.00 6,962.50 18,037.50 27.85 RANCHISE FEES -SOL 491,260.00 145,431.54 345,828.46 29.60 520,000.00 200,322.77 319,677.23 38.52 IISC -IMP FEE -SHERI 12,500.00 1,800.00 10,700.00 14.40 12,500.00 3,438.88 9,061.12 27.51 IISC -IMP FEE -FIRE/ 6,500.00 1,365.00 5,135.00 21.00 6,500.00 2,389.36 4,110.64 36.76 IISC -IMP FEE FR /EM 200.00 210.00 (10.00) 105.00 200.00 315.00 (115.00) 157.50 IISC -IMP FEE -FIRE/ 9,000.00 1,365.00 7,635.00 15.17 9,000.00 2,340.00 6,660.00 26.00 IISC -IMP FEE -FIRE/ - - - - - 38.94 (38.94) - IISC -IMP FEE -SHRF - 150.00 (150.00) - - 300.00 (300.00) - IISC -IMP FEE -SHRF- 11,500.00 1,200.00 10,300.00 10.43 11,500.00 3,450.00 8,050.00 30.00 91SC -IMP FEE -SHRF- - - - - - 77.88 (77.88) - IISC -IMP FEE -SOLID 5,000.00 768.00 4,232.00 15.36 5,000.00 1,538.96 3,461.04 30.78 IISC -IMP FEE SOLID - 64.00 (64.00) - - 64.00 (64.00) - IISC -IMP FEE -SOLID 4,300.00 512.00 3,788.00 11.91 4,300.00 1,408.00 2,892.00 32.74 IISC -IMP FEE -SOLID - - - - - 128.00 (128.00) - IISC -IMP FEE ROAD - 8,229.00 (8,229.00) - 35,000.00 15,694.24 19,305.76 44.84 IISC -IMP FEE ROADS 2,000.00 1,266.00 734.00 63.30 2,000.00 1,266.00 734.00 63.30 IISC -IMP FEE ROAD 40,000.00 8,229.00 31,771.00 20.57 50,000.00 14,559.00 35,441.00 29.12 91SC -IMP FEE DIST - - - - - 1,240.00 (1,240.00) - IISC -IMP FEE DIST 10,000.00 - 10,000.00 - 10,000.00 - 10,000.00 - IISC -IMP FEE - LIB 12,000.00 2,904.00 9,096.00 24.20 12,000.00 6,429.80 5,570.20 53.58 91SC -IMP FEE -PARK 20,000.00 4,420.00 15,580.00 22.10 15,000.00 7,480.00 7,520.00 49.87 IISC -IMP FEE PARKS 1,200.00 680.00 520.00 56.67 800.00 680.00 120.00 85.00 IISC -IMP FEE- PARK 20,000.00 4,420.00 15,580.00 22.10 20,000.00 7,820.00 12,180.00 39.10 IISC -IMP FEE -LIB D 6,000.00 3,574.60 2,425.40 59.58 6,000.00 1,863.40 4,136.60 31.06 91SC -IMP FEE -LIB D 12,000.00 1,936.00 10,064.00 16.13 12,000.00 5,566.00 6,434.00 46.38 IISC -IMP FEE -LIB -D - - - - - 484.00 (484.00) - PECASSESSMT -CAP 2,872,400.00 2,185,298.68 687,101.32 76.08 2,823,900.00 2,259,911.01 563,988.99 80.03 PEC ASSESSMT -SVC 96,096.00 76,761.85 19,334.15 79.88 75,000.00 68,702.50 6,297.50 91.60 TOTAL LICENSES AND PERMITS 8,281,956.00 3,562,801.37 4,719,154.63 43.02 7,429,652.27 4,174,828.26 3,254,824.01 56.19 ED GRANTS - PUBLIC 252,381.22 87,951.60 164,429.62 34.85 325,300.63 42,993.52 282,307.11 13.22 ED GRANTS -PHY ENV 180,000.00 - 180,000.00 - 172,350.00 - 172,350.00 - ED GRANTS -PHY ENV 121,103.32 42,010.03 79,093.29 34.69 152,157.77 152,157.77 Page 6 Office of Management and Budget Packet Pg. 3448 1 F.1.a February 2018 EVENUE SOURCE AMENDED BUDGET FISCAL YEAR 2018 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET AMENDED BUDGET EDERAL GRANTS TRA 6,078,450.00 L TO CLERK - 317,376.00 ED GTS- TRANS -ARP 20,590,479.09 1,782,475.35 18,808,003.74 8.66 11,773,991.06 ED GTS -TRANS ARPD 1,228,697.77 166,191.00 1,062,506.77 13.53 3,522,977.14 ED GRANTS- TRANS -0 - 2,467.00 (2,467.00) - 46,033.91 ED GRANTS - TRANS -0 326,341.06 32,053.01 294,288.05 9.82 732,188.52 ED GRANTS- ECONOMI 452,627.18 139,911.31 312,715.87 30.91 699,465.62 ED GRANTS -PHYS EN 23,543,176.58 - 23,543,176.58 - - ED GRANTS -OTHER H 796,728.23 113,724.92 683,003.31 14.27 904,578.79 ED GRANT TRANSPOR - 19,437.40 (19,437.40) - 212,850.00 T GRNT-PUBLIC SAF 24,666.08 24,013.00 653.08 97.35 34,184.97 TATE GRANT-PUBLIC 62,928.00 20,152.65 42,775.35 32.02 105,806.00 TGRANTS -PHY ENV- - - - - 90,909.00 T GRANTS -PHY ENV- 278,182.92 1,250,000.00 (1,250,000.00) - - T GRANTS -PHY ENV- 2,100,500.00 39,442.08 2,061,057.92 1.88 710,278.00 T GRANTS- TRANS -AR 4,583,482.78 280,681.30 4,302,801.48 6.12 5,451,819.26 T GRANTS - TRANS -AR 4,532,129.93 409,767.21 4,122,362.72 9.04 2,932,952.54 T GRANTS - TRANS -OT 2,630,731.67 1,733,960.17 896,771.50 65.91 6,226,943.63 T GRANTS - TRANS -OT 144,627.10 32,311.56 112,315.54 22.34 161,897.46 T GRANTS -PHSY ENV 5,545,946.13 - 5,545,946.13 - - T GRANTS -HUMAN SV 348,749.30 65,056.40 283,692.90 18.65 636,768.92 T AID TO LIBRARIE 20,000.00 - 20,000.00 - 46,114.72 TSHARED- SHARING 2,600,000.00 853,014.26 1,746,985.74 32.81 2,600,000.00 T SHARED -INS AGT 29,000.00 3,436.20 25,563.80 11.85 28,500.00 T SHARED - MOBILE H 17,250.00 9,082.97 8,167.03 52.65 17,250.00 T SHARED - ALCOHOL 106,500.00 3,697.30 102,802.70 3.47 106,500.00 T SHARED - RACING T 223,250.00 55,812.50 167,437.50 25.00 223,250.00 T SHARED -LOC GOVT 12,127,000.00 2,102,487.49 10,024,512.51 17.34 11,783,821.00 T SHARED - PUBLIC S 33,000.00 - 33,000.00 - 32,000.00 HARED -TRNS -FUEL U 1,150,000.00 381,251.16 768,748.84 33.15 1,100,000.00 ONSTITUTIONAL GAS 525,000.00 128,425.34 396,574.66 24.46 495,000.00 ONSTITUTIONAL GAS 2,200,000.00 513,701.38 1,686,298.62 23.35 1,985,000.00 T- SHARED -ECON ENV 420,000.00 360,494.00 59,506.00 85.83 420,000.00 OCAL GRANTS TRANS 150,000.00 - 150,000.00 - - OCAL GRANTS -TRANS 72,636.84 997.86 71,638.98 1.37 72,636.84 OCAL GRANTS -ECONO 19,852.23 4,885.50 14,966.73 24.61 59,785.20 TOTAL INTERGOVERNMENTAL REVENUE 87,158,784.51 10,658,891.95 76,499,892.56 12.23 53,863,310.98 L TO GENERAL FU 6,484,693.00 1,941,768.76 4,542,924.24 29.94 6,078,450.00 L TO CLERK 1,167,202.00 317,376.00 849,826.00 27.19 1,096,622.00 L TO LAND AUTHO 40,529.00 9,918.00 30,611.00 24.47 37,254.00 L TO TDC 79,905.00 25,096.00 54,809.00 31.41 78,654.00 L TO MCSO HIDTA 1,164,064.00 265,281.00 898,783.00 22.79 1,092,960.00 LTOSHERIFF - 122,500.00 - 122,500.00 - 101,601.00 LTO FINE & FOR 8,224,505.00 2,198,545.96 6,025,959.04 26.73 7,433,616.00 L TO ROAD & BRI 1,419,600.00 613,778.28 805,821.72 43.24 1,321,618.00 LTO GRANT FUND 129,387.00 23,464.96 105,922.04 18.14 119,179.00 L TO F &A DIST 1 1,978,873.00 513,224.08 1,465,648.92 25.94 1,746,996.00 L TO UPPER KEYS 2,367,249.53 - 20.09 - 3,579.00 Page 7 d 14 w 1 :Fe 1:4 0 ,11) IV i YTD ACTUAL BUDGET TO ACTUAL %OF BUDGET 475,000.00 (475,000.00) - 104,609.00 11,669,382.06 0.89 303,679.93 3,219,297.21 8.62 32,977.69 13,056.22 71.64 93,984.88 638,203.64 12.84 48,501.38 650,964.24 6.93 140,250.88 764,327.91 15.50 40,758.00 172, 092.00 19.15 34,384.75 (199.78) 100.58 - 105,806.00 - - 90,909.00 Q - 710,278.00 - 331,038.81 5,120,780.45 6.07 40, 515.31 2,892,437.23 1.38 1,094,430.38 5,132,513.25 17.58 115,832.02 46,065.44 71.55 100,683.95 536,084.97 15.81 49,155.88 (3,041.16) 106.59 821,080.61 1,778,919.39 31.58 6,861.36 21,638.64 24.07 9,745.14 7,504.86 56.49 9,373.70 97,126.30 8.80 55,812.50 167,437.50 25.00 2,367,249.53 9,416,571.47 20.09 - 32,000.00 - 278,182.92 821,817.08 25.29 125,305.01 369,694.99 25.31 501,220.08 1,483,779.92 25.25 478,041.00 (58,041.00) 113.82 2,899.08 69,737.76 3.99 13,288.24 46,496.96 22.23 2,241,977.06 3,836,472.94 36.88 145,785.00 950,837.00 13.29 N 4) 14,080.80 23,173.20 37.80 t 9,295.50 69,358.50 11.82 V 175,010.00 917,950.00 16.01 r - 101, 601.00 - Q 1,924,217.60 5,509,398.40 25.89 886,380.70 435,237.30 67.07 40,715.90 78,463.10 34.16 335,298.40 1,411,697.60 19.19 2,119.46 1,459.54 59.22 Office of Management and Budget ; Packet Pg. 3449 F.1.a February 2018 EVENUE SOURCE AMENDED BUDGET FISCAL YEAR 2018 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET AMENDED BUDGET FISCAL YEAR 2017 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET ILL TO UNINC PARK 355,185.00 123,058.68 232,126.32 34.65 329,733.00 157,852.20 171,880.80 47.87 ILL TO PLAN /BLDG/ 1,037,825.00 331,486.38 706,338.62 31.94 948,209.00 252,421.76 695,787.24 26.62 ILL TO MUNICIPAL 1,207,324.00 366,595.20 840,728.80 30.36 1,101,847.00 131,935.00 969,912.00 11.97 ILL TO BOATING IM 27,098.00 7,557.86 19,540.14 27.89 25,616.00 13,600.00 12,016.00 53.09 ILL TO 160ENVIRO 41,113.00 13,134.50 27,978.50 31.95 22,908.00 11,202.00 11,706.00 48.90 ILL TO COURT FAC 30,140.00 9,552.80 20,587.20 31.69 27,404.00 4,140.00 23,264.00 15.11 VCS - CT TECH -J CT - 25,577.00 (25,577.00) - 20,596.00 30,082.00 (9,486.00) 146.06 VCS -CT TECH -SA CT 15,346.20 (15,346.20) 12,357.60 18,049.20 (5,691.60) 146.06 VCS - CTTECH -PD CT - 10,230.80 (10,230.80) - 8,238.40 12,032.80 (3,794.40) 146.06 ILL TO BUILDING F 679,878.00 240,819.48 439,058.52 35.42 581,113.00 163,753.10 417,359.90 28.18 ERV - INTERNLSVC -R 850,000.00 175,863.90 674,136.10 20.69 785,000.00 220,273.80 564,726.20 28.06 ERV - INTERNLSVC -D 1,850,000.00 537,852.11 1,312,147.89 29.07 1,675,000.00 497,167.46 1,177,832.54 29.68 ERV - INTERNLSVC -C 30,000.00 15,977.00 14,023.00 53.26 30,000.00 18,880.00 11,120.00 62.93 VCS- INTERNAL -EMP 296,800.00 125,415.00 171,385.00 42.26 366,800.00 111,335.00 255,465.00 30.35 ERV- INTERNALSVC- - 5,195.98 (5,195.98) - - 878.61 (878.61) - ISK MGMT -PHU 32,259.00 - 32,259.00 - 29,512.00 - 29,512.00 - iUASI EXTNLVEHICL 34,168.00 1,685.80 32,482.20 4.93 31,919.00 6,741.30 25,177.70 21.12 ILL TO ONE CENT 1 249,418.00 75,800.12 173,617.88 30.39 205,537.00 47,028.56 158,508.44 22.88 ILL TO DUCK KEY W - - - - 35.00 - 35.00 - ILL TO CUDJOE REG 12,238.00 4,064.48 8,173.52 33.21 11,828.00 1,873.36 9,954.64 15.84 ILL TO CARD SOUND 413,349.00 155,620.48 257,728.52 37.65 356,939.00 174,813.80 182,125.20 48.98 ILL TO MARATHON A 169,550.00 46,160.64 123,389.36 27.23 153,184.00 103,452.50 49,731.50 67.53 ILL TO KEY WEST A 581,780.00 162,803.50 418,976.50 27.98 544,563.00 164,864.00 379,699.00 30.27 ILLTO ENVIRONMEN 778,276.00 207,481.26 570,794.74 26.66 717,046.00 485,151.00 231,895.00 67.66 ILL TO WORKER'S C 31,377.00 9,382.46 21,994.54 29.90 40,479.00 6,056.00 34,423.00 14.96 ILL TO GROUP INSU 52,201.00 15,745.64 36,455.36 30.16 47,341.00 10,632.50 36,708.50 22.46 ILL TO RISK MANAG 54,529.00 16,396.42 38,132.58 30.07 47,140.00 10,057.10 37,082.90 21.33 ILL TO CENTRAL SE 395,026.00 82,294.80 312,731.20 20.83 327,529.00 114,439.50 213,089.50 34.94 ERVICES- SHERIFF 525,560.00 525,560.00 - 100.00 490,962.00 490,962.00 - 100.00 IRCUIT COURT 55,000.00 13,220.00 41,780.00 24.04 66,500.00 12,130.00 54,370.00 18.24 ERV - OTHER -QUASI E 215,000.00 78,060.69 136,939.31 36.31 200,000.00 83,393.02 116,606.98 41.70 ERV -OTHER CHANNEL - 20.00 (20.00) - - - - - ERV- OTHER -RADON F 60,000.00 8,958.61 51,041.39 14.93 45,000.00 21,246.69 23,753.31 47.21 ERV - OTHER - PLANNIN 2,200,000.00 535,976.43 1,664,023.57 24.36 1,750,000.00 865,990.76 884,009.24 49.49 ERV- OTHER -LIFE SF 365,000.00 112,198.31 252,801.69 30.74 335,000.00 188,225.10 146,774.90 56.19 ERV - OTHER -CERT PR 60,000.00 12,064.16 47,935.84 20.11 45,000.00 21,182.23 23,817.77 47.07 LERK GOV CHG & FE 30,000.00 8,693.40 21,306.60 28.98 35,000.00 4,076.25 30,923.75 11.65 VCS -OTHR- PRTRIL P 20,000.00 2,631.44 17,368.56 13,16 20,000.00 5,029.59 14,970.41 25.15 ERV- OTHER -HISTR P - 1,587.00 (1,587.00) - - 400.00 (400.00) - DMIN FEES - BUILDIN 100,000.00 - 100,000.00 80,000.00 55,537.57 24,462.43 69.42 VCS -OTHR- SALARY R - - - 60,000.00 - 60,000.00 - ERV -PS -CITY POLIC 3,771,386.00 1,077,511.87 2,693,874.13 28.57 3,648,068.00 1,361,264.13 2,286,803.87 37.31 ERVICES -PUB SAFE- 2,800,000.00 339,600.00 2,460,400.00 12.13 2,000,000.00 824,399.00 1,175,601.00 41.22 ERVICES -PUB SAFE- 220,000.00 39,221.35 180,778.65 17.83 240,000.00 40,626.95 199,373.05 16.93 HGS SVCS-E911 WIR 295,000.00 71,314.64 223,685.36 24.17 260,000.00 74,369.64 185,630.36 28.60 VCS - PUB SFTY -AMBU 600,000.00 48,334.09 551,665.91 8.06 640,000.00 196,854.61 443,145.39 30.76 VC- PUB SFTY -FIRE 6,202,450.00 806,653.86 5,395,796.14 13.01 2,900,000.00 2,860,293.04 39,706.96 98.63 UBLIC SAFETY /OTHE 139,256.00 69,628.00 69,628.00 50.00 133,900.00 66,950.00 66,950.00 50.00 Page 8 Office of Management and Budget Packet Pg. 3450 F.1.a February 2018 REVENUE SOURCE AMENDED BUDGET FISCAL YEAR 2018 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET AMENDED BUDGET FISCAL YEAR 2017 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET SERV - WASTE - ASSESSM 12,570,090.00 9,715,156.94 2,854,933.06 77.29 12,491,732.00 9,605,030.77 2,886,701.23 76.89 SERV - WASTE- OTHER T 1,403,431.00 511,214.37 892,216.63 36.43 1,290,000.00 448,151.88 841,848.12 34.74 SERV- WASTE - SLUDGE 140,000.00 16,678.70 123,321.30 11.91 190,000.00 60,270.58 129,729.42 31.72 SERV - WASTE- COMMERC 3,554,124.00 1,115,863.03 2,438,260.97 31.40 3,600,000.00 1,278,333.62 2,321,666.38 35.51 SERV - WASTE -HAZ MAT 3,150.00 2,603.50 546.50 82.65 4,000.00 657.07 3,342.93 16.43 SERV - WASTE -SPEC HA 110,000.00 52,801.70 57,198.30 48.00 160,000.00 98,678.46 61,321.54 61.67 AIRLINE RENTS 1,660,000.00 348,506.76 1,311,493.24 20.99 1,660,000.00 384,594.35 1,275,405.65 23.17 SERV - AIRPORT -PASS 2,281,003.07 219,175.32 2,061,827.75 9.61 2,555,100.00 235,134.25 2,319,965.75 9.20 SERV - AIRPORT -PARKI 84,000.00 26,209.31 57,790.69 31.20 84,000.00 27,714.35 56,285.65 32.99 OTHER RENTS 630,000.00 132,171.15 497,828.85 20.98 630,000.00 191,011.79 438,988.21 30.32 OTHER RENTS 1,350,000.00 415,939.26 934,060.74 30.81 1,370,000.00 459,514.64 910,485.36 33.54 AIRLINE FEES 3,000.00 226.27 2,773.73 7.54 3,000.00 212.96 2,787.04 7.10 AIRLINE FEES 2,050,000.00 186,983.26 1,863,016.74 9.12 1,580,000.00 505,478.15 1,074,521.85 31.99 OTHER FEES 340,000.00 70,406.51 269,593.49 20.71 280,000.00 59,273.37 220,726.63 21.17 OTHER FEES 1,770,000.00 381,733.89 1,388,266.11 21.57 1,670,000.00 406,282.78 1,263,717.22 24.33 AIRLINE SECURITY 350,000.00 39,900.44 310,099.56 11.40 300,000.00 93,111.06 206,888.94 31.04 SVC - ARPT- PKG -CREDI 355,000.00 110,629.17 244,370.83 31.16 205,000.00 92,166.84 112,833.16 44.96 SERVICES - TRANS -TOL 1,100,000.00 (3,559.00) 1,103,559.00 0.32 1,100,000.00 398,238.60 701,761.40 36.20 SERV- TRANS - OTHER -F 30,000.00 2,454.00 27,546.00 8.18 30,000.00 1,940.45 28,059.55 6.47 SERV- TRANS -ROAD PE 4,000.00 1,725.00 2,275.00 43.13 3,000.00 1,346.25 1,653.75 44.88 TRAFFIC & HWY LIGH 52,000.00 - 52,000.00 - 45,000.00 - 45,000.00 - SERV- TRANS -SIGNS 1,500.00 343.00 1,157.00 22.87 1,500.00 37.48 1,462.52 2.50 SERV- TRANS -R &B 7,500.00 - 7,500.00 - 7,500.00 989.70 6,510.30 13.20 BILL TO GENERAL FU 141,500.00 38,359.23 103,140.77 27.11 146,042.00 8,680.13 137,361.87 5.94 BILL TO FINE & FOR 10,000.00 741.80 9,258.20 7.42 7,400.00 83.51 7,316.49 1.13 BILLTO ROAD & BRI 104,000.00 35,120.88 68,879.12 33.77 104,000.00 5,471.62 98,528.38 5.26 BILL TO GRANT FUND - 326.00 (326.00) - - 65.48 (65.48) - BILL TO F &A DIST 1 6,000.00 1,511.45 4,488.55 25.19 10,000.00 619.64 9,380.36 6.20 BILL TO UNINC PARK 22,000.00 6,607.99 15,392.01 30.04 22,000.00 2,219.21 19,780.79 10.09 BILL TO PLAN /BLDG/ 33,000.00 12,878.11 20,121.89 39.02 34,519.00 1,889.15 32,629.85 5.47 BILL TO 157 500.00 27.17 472.83 5.43 500.00 6.64 493.36 1.33 BILL TO ENVIRO RES 3,500.00 - 3,500.00 - 3,500.00 48.16 3,451.84 1.38 BILL TO BUILDING F 16,000.00 7,981.33 8,018.67 49.88 16,000.00 1,274.99 14,725.01 7.97 QUASI EXTERNAL GAS 120,000.00 40,407.72 79,592.28 33.67 120,000.00 6,806.93 113,193.07 5.67 BILLTO ONE CENT 1 14,000.00 2,906.66 11,093.34 20.76 14,000.00 751.77 13,248.23 5.37 BILLTO CARD SOUND 8,000.00 3,910.36 4,089.64 48.88 10,000.00 371.03 9,628.97 3.71 BILL TO MARATHON A 7,500.00 2,347.05 5,152.95 31.29 7,500.00 261.80 7,238.20 3.49 BILLTO KEY WEST A 17,955.00 7,017.91 10,937.09 39.09 17,955.00 1,422.39 16,532.61 7.92 BILL TO ENVIRONMNT 27,000.00 6,936.85 20,063.15 25.69 27,000.00 1,533.06 25,466.94 5.68 BILLTO WORKER'S C 500.00 63.76 436.24 12.75 500.00 8.73 491.27 1.75 BILL TO RISK MANAG 300.00 1,739.54 (1,439.54) 579.85 300.00 1,724.42 (1,424.42) 574.81 BILL TO FLEET MANA 12,000.00 2,581.42 9,418.58 21.51 12,000.00 200.98 11,799.02 1.67 SVCS -HMN SVC -ANML 40,000.00 9,809.00 30,191.00 24.52 40,000.00 15,949.00 24,051.00 39.87 SERV -HUMAN SVC -BAY 255,000.00 119,508.40 135,491.60 46.87 250,000.00 86,902.46 163,097.54 34.76 BAYSHORE FOODSTAMP 4,500.00 3,362.00 1,138.00 74.71 4,500.00 1,500.00 3,000.00 33.33 BAYSHORE RESPITE 20,500.00 - 20,500.00 - 40,000.00 - 40,000.00 - SVCS- LIB -NON RESIDE 6,000.00 2,500.80 3,499.20 41.68 6,000.00 3,106.30 2,893.70 51.77 SERVICES - PARKS /REC 45,000.00 - 45,000.00 - 40,000.00 13,415.00 26,585.00 33.54 Page 9 Office of Management and Budget 4 4 O Q N N V C C LL 06 N a1 7 m Packet Pg. 3451 F.1.a February 2018 VENUE SOURCE AMENDED BUDGET FISCAL YEAR 2018 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET AMENDED BUDGET FISCAL YEAR 2017 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET C- CULTURAL ST VS 275,000.00 55,664.45 219,335.55 20.24 255,000.00 64,245.40 190,754.60 25.19 C- CLTRL /CTYREG 0 465,000.00 98,906.48 366,093.52 21.27 430,000.00 110,751.18 319,248.82 25.76 TY CT- CRIM -ADDT' 490,000.00 89,273.83 400,726.17 18.22 530,000.00 117,204.36 412,795.64 22.11 IM -ADD COSTS -CT - 7,468.27 (7,468.27) - 3,635.36 6,352.21 (2,716.85) 174.73 IM -ADD COSTS -LEG 164.61 7,468.26 (7,468.26) 434,872.85 3,635.34 6,352.19 (2,716.85) 174.73 IM -ADD COSTS -LAW 94.11 7,468.27 (7,468.27) - 3,635.35 6,352.21 (2,716.86) 174.73 IM -ADD COSTS -JUV - 7,468.27 (7,468.27) 25,509.91 3,635.38 6,352.25 (2,716.87) 174.73 IM -CT COSTS -CRIM - 11,239.78 (11,239.78) - - 9,605.93 (9,605.93) - OPERTY USEAGE OT 40,000.00 1,698.95 38,301.05 4.25 48,000.00 10,093.09 37,906.91 21.03 OPERTY USEAGE - 400.00 (400.00) - - - - - RVCS -DJJ MAINT 28,000.00 2,053.84 25,946.16 7.34 30,000.00 36.08 30,000.00 - TOTAL CHARGES FOR SERVICES 79,740,997.07 26,383,703.79 53,357,293.28 33.09 72,008,922.43 30,556,314.17 41,452,608.26 42.43 :LERK FINES 78,500.00 13,682.07 64,817.93 17.43 85,000.00 11,667.50 73,332.50 13.73 MITIGATION PENALTY 455,000.00 171,812.00 283,188.00 37.76 255,000.00 379,050.37 (124,050.37) 148.65 )RUG COURT COSTS A 8,000.00 1,361.80 6,638.20 17.02 8,000.00 34.80 7,965.20 0.44 :INES- LIB -LOST BO - 269.15 (269.15) - 161.27 342.22 (180.95) 212.20 INES- LIB - OVERDUE 2,003.56 (2,003.56) - 1,436.61 2,364.86 (928.25) 164.61 :INES -LOC ORD -CODE 1,300,000.00 434,872.85 865,127.15 33.45 800,000.00 752,855.99 47,144.01 94.11 :INES- PARKING VIOL 600.00 - 600.00 - 600.00 - 600.00 - :INES -LOC ORD -RADI - 25,509.91 (25,509.91) - 33,435.26 (33,435.26) - FRAFFIC PENALTY -ED - 15,313.70 (15,313.70) - 13,952.68 20,638.83 (6,686.15) 147.92 "RAFFIC PENALTY - - 3,000.00 563.00 2,437.00 18.77 3,000.00 652.79 2,347.21 21.76 :INES -LOC ORD -HAND - 297.34 (297.34) - 227.71 297.34 (69.63) 130.58 TOTAL FINES AND FORFEITS 1,845,100.00 665,685.38 1,179,414.62 36.08 1,167,378.27 1,201,339.96 (33,961.69) 102.91 MISC- INTEREST -DIST 60,880.00 - 60,880.00 - 880.00 880.00 - MISC- INTEREST -DIST 3,605.00 3,605.00 3,605.00 3,605.00 MISC- INTEREST -DIST 6,365.00 6,365.00 6,365.00 6,365.00 MISC- INTEREST -KEY 145.00 145.00 145.00 145.00 NTEREST EARNINGS 42,500.00 - 42,500.00 - - - - - NTEREST EARNINGS 534,750.00 240,308.17 294,441.83 44.94 548,079.00 162,822.11 385,256.89 29.71 NTEREST - COUNTY 25.00 12,716.70 (12,691.70) 50,866.80 25.00 368.60 (343.60) 1,474.40 NTEREST -TAX COLLE 13,000.00 24,238.52 (11,238.52) 186.45 - 4,664.05 (4,664.05) - NTEREST- 2014 REV - 24,839.50 (24,839.50) - - 20,311.21 (20,311.21) - 2ENTS 475,000.00 176,331.01 298,668.99 37.12 500,000.00 122,761.98 377,238.02 24.55 2ENTS 52,000.00 22,025.00 29,975.00 42.36 55,000.00 15,088.00 39,912.00 27.43 2ENTS- ROWELLS MARI 8,000.00 - 8,000.00 - 15,000.00 - 15,000.00 - MISC IMP FEES -SOLI - - - - 64.00 (64.00) )ISPOSITION OF FIX - 5,505.05 (5,505.05) 2,000.00 - 2,000.00 :ONTRIB & DON FM P 154,922.00 - 154,922.00 - 207,445.00 207,445.00 )ONATIONS 9,388.00 16,888.00 (7,500.00) 179.89 - - - - )ONATIONS- LIB -KEY - 7,035.34 (7,035.34) - 736.02 405.98 330.04 55.16 )ONATIONS- LIB -BIG 650.00 (650.00) - 2,840.18 (2,840.18) - )ONATIONS -LIB MARA 1,443.00 (1,443.00) 436.00 (436.00) )ONATIONS- LIB -KEY 7,000.00 (7,000.00) - )ONATIONS- BAYSHORE - 698.00 (698.00) - - - 'ENSION FUND CONTR 37,000.00 24,448.00 12,552.00 66.08 28,709.00 28,709.00 Page 10 Office of Management and Budget 1 - Packet Pg. 3452 F.1.a February 2018 :VENUE SOURCE AMENDED BUDGET FISCAL YEAR 2018 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET AMENDED BUDGET FISCAL YEAR 2017 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET ISCELLANEOUS REVE 290,000.00 52,526.30 237,473.70 18.11 240,000.00 75,667.98 164,332.02 31.53 ISCELLANEOUS REVE 117,200.00 80,279.60 36,920.40 68.50 118,200.00 106,603.02 11,596.98 90.19 ISCELLANEOUS REVE - 3,372.00 (3,372.00) - - 4,972.65 (4,972.65) - ISCELLANEOUS REVS - 1,287.50 (1,287.50) - - - - - ISC COMMISSIONS 15,000.00 4,606.73 10,393.27 30.71 15,000.00 4,532.58 10,467.42 30.22 ISC- WELFARE REIMB 1,500.00 345.00 1,155.00 23,00 1,400.00 - 1,400.00 - ISC- OTHER - INSURAN - 497.76 (497.76) - - 746.84 (746.84) 908,519.00 ISC- OTHR- SUBROG R 908,519.00 4,214.04 (4,214.04) - 18,641.00 17,245.79 (17,245.79) TRSF FM PKS & REC ISC COLL UNDER /OV - 165.99 (165.99) - - (238.33) 238.33 1,606,070.76 ISC- OTHER -GAS TAX 21,500.00 11,818.12 9,681.88 54.97 21,500.00 - 21,500.00 - ISC -SHIP MORTG SA 180,000.00 34,541.80 145,458.20 19.19 180,000.00 253,243.80 (73,243.80) 140.69 ISC -HURR INSUR. P - 588,053.10 (588,053.10) - - - 509,033.00 - ISC -MORTG SATISFI - - 7,900.00 (7,900.00) 2,000,000.00 - TRSF FM 1 CENT INF 8,670.00 (8,670.00) 9,586,920.00 TTLEMENTS 378,858.20 96.05 1,305.00 (1,305.00) 340,969.10 341,030.90 50.00 682,000.00 - 61.80 99.99 TRANSFER FROM FUND ISC- OTHER - REIMBUR - 20,146,935.00 - 4,925.70 (4,925.70) 14,323,724.00 - - 3,939.20 (3,939.20) - ISC- OTHER- EXCSCL 1,500,000.00 87,351.54 (87,351.54) 474,441.18 100,000.00 25,442.48 74,557.52 25.44 ISC - OTHER -EXC CLM 50,153.00 10,894.37 (10,894.37) 50,153.00 - 207,797.22 (207,797.22) - TOTAL MISC. REVENUES 2,022,780.00 1,458,210.84 564,569.16 72.09 2,044,089.02 1,038,385.34 1,005,703.68 50 8 TRSF FM GENERAL 00 2,347,182.49 2,347,182.49 191,591.59 191,591.59 TRSF FM FINE & FOR 16,667.00 16,667.00 TRSF FM ROAD & BRI 4,159,720.00 4,159,720.00 4,104,459.83 4,104,459.83 TRSF FM 115 58,182.00 58,182.00 58,182.00 58,182.00 TRSF FM 116 39,610.00 39,610.00 39,610.00 39,610.00 TRSF FM 117 59,799.00 59,799.00 59,799.00 59,799.00 TRSF FM 118 23,290.00 23,290.00 23,290.00 23,290.00 TRSF FM 119 16,356.00 16,356.00 16,356.00 16,356.00 TRSF FM 120 12,023.00 12,023.00 12,023.00 12,023.00 TRSF FM 121 37,424.00 37,424.00 37,424.00 37,424.00 TRSF FM IMPACT ROA - - 77,483.00 77,483.00 TRSF FM FIRE & AMB 908,519.00 908,519.00 908,519.00 908,519.00 TRSF FM UP KEY TRA - - 18,641.00 18,641.00 TRSF FM PKS & REC 162,768.00 162,768.00 162,768.00 162,768.00 TRSF FM PLAN & BLD 1,588,801.00 1,588,801.00 1,606,070.76 1,606,070.76 TRSF FM MUNICIPAL 11,514.00 11,514.00 11,514.00 11,514.00 TRSF FM BOAT IMP F 60,000.00 60,000.00 80,877.00 80,877.00 TRANSFER FM FUND 1 - - 30,000.00 30,000.00 TRSF FM BLDG FUND 509,033.00 509,033.00 509,033.00 509,033.00 TRSF FM 1 CENT INF - - - 2,000,000.00 2,000,000.00 - TRSF FM 1 CENT INF 11,445,475.00 8,600 2,845,475.00 75.14 9,586,920.00 9,208,061.80 378,858.20 96.05 TRSF FM BIG COPPIT 682,000.00 340,969.10 341,030.90 50.00 682,000.00 681,938.20 61.80 99.99 TRANSFER FROM FUND 20,146,935.00 - 20,146,935.00 - 14,323,724.00 - 14,323,724.00 - TRANSFER FROM 314 - - 1,500,000.00 1,500,000.00 TRSF FM CARD SND B 474,441.18 474,441.18 1,041,367.73 1,041,367.73 TRSF FM MARATHON A 50,153.00 50,153.00 50,153.00 50,153.00 TRSF FM 404 331,280.00 331,280.00 331,280.00 331,280.00 TRSF FM PFC & OPR 36,142.86 36,142.86 20,000.00 20,000.00 TRSF FM MSD -414 263,190.00 263,190.00 263,190.00 263,190.00 Page 11 Office of Management and Budget. n Packet Pg. 3453 1 F.1.a February 2018 EVENUE SOURCE AMENDED BUDGET FISCAL YEAR 2018 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET AMENDED BUDGET FISCAL YEAR 2017 BUDGET YTD ACTUAL TO ACTUAL %OF BUDGET RSF FM WORKERS CO 61,030.00 61,030.00 61,030.00 61,030.00 RSF FM GROUP INS 117,760.00 117,760.00 117,760.00 117,760.00 RSF FM RISK MGMT 32,970.00 32,970.00 32,970.00 32,970.00 RSF FM FLEET MGNT 367,760.00 367,760.00 367,760.00 367,760.00 TOTAL INTERFUND TRANSFER 44,003,358.53 8,940,969.10 35,062,389.43 20.32 38,342,462.91 9,890,000.00 28,452,462.91 25.79 EBT PROCEEDS - 1,143,118.00 1,143,118.00 - RUFC LOAN PROCEED 12,455,276.00 12,455,276.00 14,724,600.00 25,397,527.00 (10,672,927.00) 172.48 TOTAL DEBT PROCEEDS 12,455,276.00 12,455,276.00 15,867,718.00 25,397,527.00 (9,529,809.00) 172.48 RSF IN CLK TO BCC 700,000.00 700,000.00 325,000.00 325,000.00 - RSF IN CLK CIRC C 300,000.00 300,000.00 425,000.00 425,000.00 RSF IN SHF- EXCESS 1,775,000.00 1,775,000.00 1,650,000.00 1,650,000.00 RSF IN PA- EXCESS 740,000.00 740,000.00 450,000.00 450,000.00 RSF IN TC EXCESS 2,810,425.00 2,810,425.00 2,755,425.00 2,755,425.00 RSF IN SOE- EXCESS 220,000.00 220,000.00 200,000.00 200,000.00 TOTAL TRANSFER IN EXCESS FEES 6,545,425.00 6,545,425.00 5,805,425.00 5,805,425.00 ESS 5% FL STATUTE (11,309,001.00) (11,309,001.00) (10,650,932.00) (10,650,932.00) UND BALANCE FORWA 143,332,212.00 143,332,212.00 157,759,969.00 157,759,969.00 ND BAL FORWARD -DI 178,351.00 178,351.00 178,085.00 178,085.00 ND BAL FWD -KEY CO 37,973.00 37,973.00 38,163.00 38,163.00 ND BAL FORWARD -DI 337,492.00 337,492.00 257,461.00 257,461.00 ND BAL FWD - COUNTY 3,560.00 3,560.00 3,560.00 3,560.00 ND BAL FWD - DISTRI 1,392,726.00 1,392,726.00 1,390,643.00 1,390,643.00 ND BAL FORWARD -T 150,739.00 150,739.00 ND BAL FORWARD -PR 52,137.00 52,137.00 ND BAL FORWARD -UP 97,438.00 97,438.00 UND BAL FWD -TDC -E 4,100,000.00 4,100,000.00 4,414,047.00 4,414,047.00 TOTAL SOURCES 138,073,313.00 138,073,313.00 153,691,310.00 153,691,310.00 TOTAL OF ALL FUNDS 531,237,760.11 127,671,511.63 403,566,248.48 24.03 495,491,402.88 151,986,879.17 343,504,523.71 30.61 Page 12 O Q N N V C C LL 06 r N a1 7 m O Q N w co CD N 7 L N LL to O 7 C N N L O . G (D C V Q a Office of Management and Budget Packet Pg. 3454