Okaloosa County BOCC — May 19, 2015 — 2nd Quarter 15-Final — reading text

$603,245 $539,238 $250,692 88.80% 89.39% 41.59% 41.56% 113 Street Lighting Fund $928,897 $328,191 $237,385 $925,462 $348,321 $232,375 35.33% 37.64% 25.56% 25.11% 115 Unincorporated County Parks $5,987,093 $1,058,340 $820,107 $6,435,748 $1,845,726 $1,199,048 17.68% 28.68% 13.70% 18.63% 119 Prisoner Benefit Fund $1,126,670 $210,688 $257,462 $1,221,618 $393,476 $319,278 18.70% 32.21% 22.85% 26.14% 120 Additional Court Cost Fund $2,028,586 $491,485 $523,206 $2,272,310 $569,778 $586,468 24.23% 25.07% 25.79% 25.81% 121 Drug Abuse Trust Fund $53,966 $5,788 $5,691 $58,254 $5,253 $2,956 10.73% 9.02% 10.55% 5.07% 122 Domestic Violence Trust Fund $273,322 $10,837 $61,917 $55,196 $11,061 $31,546 3.96% 20.04% 22.65% 57.15% 123 Traffic Education Fund $180,526 $34,286 $0 $185,053 $43,215 $7,393 18.99% 23.35% 0.00% 3.99% SPECIAL REVENUE FUNDS $62,678,101 $10,202,915 $11,833,280 $69,650,933 $13,656,619 $12,671,150 201 Okaloosa Debt Service Fund $6,621,212 $3,421,072 $3,849,278 $9,469,630 $4,465,069 $3,779,630 51.67% 47.15% 58.14% 39.91% 5 DEBT SERVICE FUNDS $6,621,212 $3,421,072 $3,849,278 $9,469,630 $4,465,069 $3,779,630 301 Capital Outlay Construction Trust $4,591,211 $1,004,128 $362,512 $26,352,343 $22,800,983 $7,739,238 21.87% 86.52% 7.90% 29.37% 302 Road/Bridge Construction Fund $16,337,480 $1,671,565 $1,714,382 $16,642,821 $1,657,265 $2,166,494 10.23% 9.96% 10.49% 13.02% CAPITAL OUTLAY FUNDS $20,928,691 $2,675,693 $2,076,894 $42,995,164 $24,458,248 $9,905,732 411 Water & Sewer Enterprise Fund $73,024,555 $13,199,827 $12,336,277 $75,418,768 $15,019,339 $15,336,032 18.08% 19.91% 16.89% 20.33% 421 Airport Enterprise Fund $37,717,558 $5,810,277 $7,556,577 $36,942,999 $5,181,044 $4,487,181 15.40% 14.02% 20.03% 12.15% 430 Solid Waste Fund $9,707,869 $3,572,163 $4,417,078 $9,306,498 $3,434,143 $3,366,209 36.80% 36.90% 45.50% 36.17% 441 Inspection & Code Enforcement $1,645,545 $724,573 $696,702 $1,826,554 $814,881 $756,689 44.03% 44.61% 42.34% 41.43% 450 Emergency Medical Services $7,758,061 $3,196,628 $3,975,868 $8,348,747 $5,233,229 $3,639,369 41.20% 62.68% 51.25% 43.59% ENTERPRISE FUNDS $129,853,588 $26,503,468 $28,982,502 $131,843,566 $29,682,636 $27,585,480 501 Self Insurance $16,460,431 $6,740,860 $5,583,613 $15,638,177 $6,019,851 $5,903,767 40.95% 38.49% 33.92% 37.75% 502 Garage Services $6,151,935 $2,262,055 $2,603,333 $6,346,539 $2,377,289 $2,313,910 36.77% 37.46% 42.32% 36.46% INTERNAL SERVICES FUNDS $22,612,366 $9,002,915 $8,186,946 $21,984,716 $8,397,140 $8,217,677 TOTAL ALL FUNDS $338,097,196 $104,430,410 $97,589,589 $371,642,618 $136,977,611 $109,993,523  Budget/Actual Comparison - Six Months $140,000,000 Six Months - 03/31/2014 Six Months - 03/31/2015 $120,000,000 $100,000,000 $80,000,000 6 $60,000,000 $40,000,000 $20,000,000 $0 SPECIAL DEBT SERVICE CAPITAL OUTLAY ENTERPRISE INTERNAL SPECIAL DEBT SERVICE CAPITAL OUTLAY ENTERPRISE INTERNAL GENERAL FUND GENERAL FUND REVENUE FUNDS FUNDS FUNDS FUNDS SERVICES FUNDS REVENUE FUNDS FUNDS FUNDS FUNDS SERVICES FUNDS Budget $95,403,238 $62,678,101 $6,621,212 $20,928,691 $129,853,588 $22,612,366 $95,698,609 $69,650,933 $9,469,630 $42,995,164 $131,843,566 $21,984,716 Revenue $52,624,347 $10,202,915 $3,421,072 $2,675,693 $26,503,468 $9,002,915 $56,317,899 $13,656,619 $4,465,069 $24,458,248 $29,682,636 $8,397,140 Expenditure $42,660,689 $11,833,280 $3,849,278 $2,076,894 $28,982,502 $8,186,946 $47,833,854 $12,671,150 $3,779,630 $9,905,732 $27,585,480 $8,217,677 Total Cash Comparison - Fund Report Six Months - FY2015  Okaloosa County Cash Comparison 10/01/13 10/01/14 03/31/14 03/31/15 Cash & Cash & % Cash & Cash & % Investment Investment (Inc/-Dec) Investment Investment (Inc/-Dec) Fund Description Balance Balance +/- Balance Balance +/- 001 General Fund $7,026,817.24 $4,833,468.86 -31.21% $18,321,187.93 $18,979,924.08 3.60% GENERAL FUND $7,026,817.24 $4,833,468.86 -31.21% $18,321,187.93 $18,979,924.08 3.60% 101 County Transportation Trust Fund $54,134.53 $325,762.27 501.76% $14,054.81 $863,137.71 6041.23% 104 Tourist Development Fund $22,741,513.25 $23,813,077.73 4.71% $20,365,390.51 $24,966,622.46 22.59% 105 Natural Disaster Fund $67,531.78 $113,916.96 68.69% $314,005.08 $60,488.67 -80.74% 106 SHIP Fund $837,216.20 $1,158,378.75 38.36% $772,678.63 $1,003,597.24 29.89% 108 E-911 Fund $1,423,783.63 $1,500,299.62 5.37% $1,340,474.06 $1,510,548.04 12.69% 109 Radio Comm Fund $61,638.55 $106,346.57 72.53% $75,746.79 $122,724.07 62.02% 110 Law Enforcement Trust Fund $21,865.95 $12,532.33 -42.69% $25,476.65 $14,260.61 -44.02% 111 Police Academy Fund $47,483.56 $15,026.08 -68.36% $37,220.78 $27,633.98 -25.76% 112 County Public Health Unit ($41,995.66) $56,965.33 235.65% $308,472.59 $290,130.33 -5.95% 113 Street Lighting Fund $506,484.20 $476,854.51 -5.85% $581,745.46 $565,315.37 -2.82% 115 Unincorporated County Parks $4,809,360.21 $4,435,893.37 -7.77% $5,060,470.62 $5,107,841.11 0.94% 119 Prisoner Benefit Fund $563,253.56 $698,191.86 23.96% $707,403.30 $739,602.95 4.55% 120 Addl Court Costs Fund $583,585.97 $577,451.13 -1.05% $588,381.20 $555,434.82 -5.60% 121 Drug Abust Trust Fund $40,811.18 $44,940.02 10.12% $40,933.01 $47,552.04 16.17% 7 122 Domestic Viol Trust Fund $250,388.14 $38,343.57 -84.69% $199,993.49 $7,711.48 -96.14% 123 Traffic Education Fund $93,351.51 $96,550.38 3.43% $134,312.95 $140,876.00 4.89% SPECIAL REVENUE FUNDS $32,060,406.56 $33,470,530.48 4.40% $30,566,759.93 $36,023,476.88 17.85% 201 Okaloosa Debt Service Fund $463,353.95 $621,933.55 34.22% $35,147.05 $1,189,091.98 3283.19% DEBT SERVICE FUNDS $463,353.95 $621,933.55 34.22% $35,147.05 $1,189,091.98 3283.19% 301 Capital Outlay Construction Trust $3,335,439.50 $3,626,158.53 8.72% $4,095,787.92 $20,211,139.44 393.46% 302 Road/Bridge Construction Fund $10,882,825.54 $11,807,552.93 8.50% $11,475,764.68 $11,736,565.65 2.27% CAPITAL OUTLAY FUNDS $14,218,265.04 $15,433,711.46 8.55% $15,571,552.60 $31,947,705.09 105.17% 411 Water & Sewer Enterprise Fund $32,169,637.51 $35,908,269.63 11.62% $31,659,862.53 $43,559,683.55 37.59% 421 Airport Enterprise Fund $19,845,721.45 $9,860,568.16 -50.31% $19,887,531.69 $20,487,279.61 3.02% 430 Solid Waste Fund $1,520,632.13 $1,237,035.88 -18.65% $2,186,318.44 $1,596,436.18 -26.98% 441 Inspection & Code Enforcement $287,850.88 $435,877.14 51.42% $278,848.08 $418,546.43 50.10% 450 Emergency Medical Services ($200,611.54) $362,091.71 280.49% $611,185.34 $1,930,534.04 215.87% ENTERPRISE FUNDS $53,623,230.43 $47,803,842.52 -10.85% $54,623,746.08 $67,992,479.81 24.47% 501 Self Insurance $127,877.91 $2,534,670.83 1882.10% $541,502.30 $1,941,534.74 258.55% 502 Garage Services ($745,259.17) ($1,393,540.10) -86.99% ($1,127,697.39) ($1,206,853.16) -7.02% INTERNAL SERVICES FUNDS ($617,381.26) $1,141,130.73 284.83% ($586,195.09) $734,681.58 225.33% TOTAL ALL FUNDS $106,774,691.96 $103,304,617.60 -3.25% $118,532,198.50 $156,867,359.42 32.34%  Cash Comparison 03/31/14 to 03/31/15 19.0 General Fund 18.3