Okaloosa County BOCC — April 15, 2014 — Budget Info 35-14

Budget Expense Report - Departments (Approved) 2nd Prior 1st Prior Current Budget BCT Account Account Title Actual Actual Original Approved +4 +. 546012 RM-W&S SEWER SYSTEMS $196,740.76 $99,041.41 $200,000.00 $200,000.00 30.00 0.0% 546013 RM-RECLAIM SEWER SYSTEM $30,179.98 $3,203.84 $15,000.00 $3,000.00 ($12,000.00) (80.0%) 546022 RM-W&S LIFT STATIONS $178,639.30 $271 842.12 $200,000.00 $200,000.00 $0.00 0.08 546030 RM-OFFICE MACHINES. $188,611.39 $184,882.74 $200,000.00 $200,000.00 $0.00 0.0& 346620 RM-PACILITIES $33,518.08 $100,541.39 $50,000.00 $50,000.00 $0.00 0.0% 346621 RM-WATER WELLS $173,810.86 $75,025.43 $125,000.00 $125,000.00 $0.00 0.08 546623 RM-W&S SEWER PLANTS $147,410.08 $200,776.77 $140,000.00 $175,000.00 $35,000.00 25.0% 546524 RM-EFFLUENT DISPOSAL $1,039.46 $1,864.46 © $5,000.00 $5,000.00 $0.00 0.0& 546630 RM-W&S TANKS $712,076.63 $772,327.26 $700,000.00 $700,000.00 $0.00 0.0& $46640 RM-BQUIPMENT $29,764.16 $20,958.78 $25,000.00 $25,000.00 $0.00 0.08 $46644 RM-VEHICLES-FLEET $239,141.49 $222,447.17 $344,679.00 $388,048.00 $43,369.00 12.6% 546645 RM-MOTOR VEHICLE $0.00 $7,269.98 $1,000.08 $1,000.00 $0.00 0.0& $46900 RM-TECHINCAL SUPT SERVICE $6,982.50 $12,190.00 $15,000.00 $0.00 ($15,000.00) (100.0%) 547002 PRINTING & BINDING $1,651.38 $1,564.59 $1,500.06 $1,500.00 $0.00 = 0.08 549122 BANK CHARGES $133,693.30 $133,068.89 $125,000.00 $150,000.00 $25,000.60 20.0% 549307 PUBLIC RELATIONS $3,395.77 $3,057.36 $10,000.00 $10,000.00 30.00 0.0& 549703 CLAIMS-PROPERTY $0.00 $0.00 $2,500.00 $2,500.00 $0.00 0.0& $49900 MISCELLANEOUS CHARGES $7,213.76 $5,236.90 $3,000.00 $5,000.00 $0.00 0.0& 549901 LEGAL ADVERTISING $1,912.04 $5,142.82 $4,000.00 $4,000.00 $0.00 0.08 549903 BAD DEBT EXPENSE $215,309.45 $195,393.17 $0.00 $0.00 $0.00 NA 549904 JOB LISTING EXPENSES $498.00 $683.00 $1,000,00 $1,000.00 $0,00 0.0& 549905 MOTOR VEHICLE REPORTS $41.34 $172.00 $100.00 $100.00 $0.00 0.0% $49906 BACKGROUND CHECKS $250.00 $991.50 $1,000.00 $1,000.00 $0.00 0,08 $49907 RANDOM DRUG TESTING $1,258.00 $1,110.00 $2,000.00 $2,000.00 $0.00 0.08 $51001 OFFICE SUPPLIES $17,468.82 $10,448.05 $15,000.00 $15,000.00 $0.00 0.08% 552016 FLEET FUBL $252,071.83 $268,618.35 $439,051.00 $434,778.00 (64,273.00) 4.0%) 55201] GREASE, OIL & LUBRICANTS $9,478.67 $5,777.42 $10,000.00 $10,00000 $0.00 0.0% 552012 SPECIAL FUELTAX $0.00 30.00 $1,000.00 $0.00 ($1,000.00) (100.0%) 552014 GASOLINE & SPECIAL FUEL. $440.12 $197.01 $1,000.00 $1,000.00 $0.00 0.0% 52101 PROTECTIVE APPAREL $17,32457 $19,810.90 $25,000.00 $25,000.00 $0.00 0.0% 552200 SAFETY SUPPLIES $6,842.04 $18,418.95 $15,000.00 $20,000.00 $9,000.00 33.3% 352500 TOOLS & SMALL IMPLEMENTS $35,362.26 $30,935.43 $40,000.00 $40,000.00 $0.00 0.0% 552602 CHEMICALS-WATER SYSTEMS $35,557.60 $29,825.48 $40,000.00 $40,000.00 $0.00 0.08 552603 LABORATORY SUPPLIES $32,21998 $21,061.66 $35,000.00 $35,000.00 30.00 0.0% $52612 CHEMICALS-SEWER SYSTEMS $283,633.04 $299,003.07 $200,000.00 $200,000.00 $0.00 0.0& 352622 CHEMICALS-LIFT STATION $25,732.90 $10,897.37 $25,000.00 $19,000.00 ($15,000.00) (60.0%) 352700 JANITORIAL SUPPLIES $22,20038 $24,960.50 $25,000.00 $25,000.00 $0.00 0.08% $52800 COMPUTER SUPPIIES $8,939.50 $19,334.93 $15,000.00 315,000.00 $0.00 0.0& 592801 COMPUTER SOFTWARE $18,257.32 35,007.80 $27,100.00 $27,100.00 30.00 0.08 552990 OTHER SUPPLIES $25,896.95 $32,492.48 $40,000.00 340,000.00 $0.06 0.0& 384001 BOOK/PUB/SUB/MEMBERSHIPS $22,278.64 $20,591.74 $20,000.00 $20,000.00 $0.00 0.0% 559001 TRAINING/EDUCATION [XPENS $20,048.59 $10,068.51 $25,000.00 $25,000.00 $0.00 0.0& 55900] DEPRECIATION EXPENSE $6,475523.08 $6,487,983.74 $0.00 $0.00 30.00 NA OPERATING EXPENSES $16,113,045.20 $15,919,239.91 $9,780,456.00 — $9,816,700.00 $34,244.00 0.4% 562300 BLDG-PHYSICAL ENVIRONMENT $39,400.00 30.00 $53,045.00 $54,045.00 $1,000.00 19% 563155 FIBER OPTIC NETWORK $0.00 $0.00 $27,318.00 $27,318.00 $0.00 0.0% 563317 INVENTORY-METERS $0.00 $0.00 $200,000.00 $200,000.00 $30.00 0.0% $6331 8 INVENTORY-OTHER 30.00 $0.00 $600,000.00 $500,000.00 ($100,000.00) (16.7%) 564301 OFFICE MACHINES $0.00 $0.00 $43,000.00 $36,000.00 ($7,000.00) 16.3%} 564302 PHYSICAL ENVIRONMNT EQUIP $117,375.28 $305,907.76 $301,500.00 $555,500.00 $254,00000 84.2% 564303 COMPUTER EQUIPMENT $23,882.21 $50,975.01 $174,500.00 $79,000.00 ($99,500.00) (54.7%) 564304 VEHICLES 344,898.00 $100,957.60 $264,00000 . $275,000.00 $1,000.00 42% 568300 PHYSICAL ENVIRONMENT $0.00 $0.00 $44,000.00 $113,000.00 $69,000.00 156.8% Page 4-155 Okaloosa County Capital Improvement Program ae wee Fiscal Years 2614-2618 eee a [WATER & SEWER 1 FY Fund Amount Project Name Cat Narrative FY14 = 411 5,000 Small Back UPS (12) E Information Technology FY14 411 10,000 I Series AS400 CPU Upgrade E Information Technology FY14 411 15,000 Blade Server Migration E Information Technology FY14 = 411 5,000 API Document Imaging Scanners E Information Technology Fyi4 9 411 10,000 — Click2Gov Server upgrade E Information Technology FY14 411 12,000 Credit Card Machine Replacement E Information Technology FYi4 411 25,000 PCs (replace aging/outdated) E Information Technology FY14 Al 40,000 One Point Kiosk (Install) E Information Technology Fyl4 411 18,000 SunGard Quatred Bar Coding E Information Technology 7 FyYl4 411 5,000 Selectron Upgrades E Information Technology & FY14 9 411 30,000 Qrep Web E Information Technology mo FYI4 411 8,000 Misc. PC Hardware E _ Information Technology 8 Fyl4 411 5,000 Red Flag Setup & Maintenance E Information Technology FY14 9 411 20,000 SCADA Equipment & Software E System Control and Data Acquisition. FY14 411 10,000 — Roller Packer E Water and Sewer Maintenance FY14 411 60,000 Excavator BE Water and Sewer Maintenance FY14 = 411 7,000 Tap Mate ff Machine E Water and Sewer Maintenance Fyl4 41 7,000 Root Camera E Water and Sewer Maintenance FY14 = 411 8,000 3" Trash Pump E Water and Sewer Maintenance FY14 411 5,000 14" Stihl Pipesaw E Water and Sewer Maintenance FY14 411 7,000 Pole Barn for Materials E Logistics FY14 = 411 60,000 Ford F450 Utility E Replace 97G5724 FYI4 411 32,000 Dodge 1500 1/2 ton, 4X2 E Replace 99C7559 FYi4 411 30,000 F250 Ext Cab E Replace 96C5686 FYi4 9 411 60,000 Ford F450 4X4 Utility E Replace 01G9955 FY14 411 60,000 Ford F450 4X4 Utility £ Replace 02G14560 FY14 All 33,000 Chevy 1500 4x4 E Replace 0007577 FYi4 411 5,000 Ice Machine E Logistics FYI4 All 60,000 Warehouse Improvements E Logistics FY14 4ll 5,000 35-C Incubator E Lab Fy14 411 10,000 = Auto Clave E Lab FY14 411 7,000 Portable Load E Electric Pump FY14 411 3,000 Chlorine Leak Detectors E Water Operations Fyl4 411 5,000 Chlorine High-Low Vacuum Alarm E Water Operations