SECURITY SERVICES FTE INCREASE 10.27.2023 V3.XLSX
Extracted text (via pymupdf)
6690 characters
Tier 2 - Security Specialist Security Specialist Rate-Midpoint Security Specialist Rate-Midpoint $ 27.13 Annual salary-7010 $ 56,430.40 Retirement Variable-7502 $ 6,935.30 Taxes Variable-7501 $ 4,316.93 Fixed Benefit-medical & dental $ 13,632.00 $ 81,314.62 Reoccuring Cost - Per FTE Uniform Cost $ 300.00 800 Hand Helds $ 1,604.64 Salary and Benefits $ 81,314.62 Total Per FTE $ 83,219.26 One Time Cost - Per FTE 800 Hand Helds $ 4,739.53 Initial Uniform Cost $ 4,091.07 Weapon/Holster $ 529.50 Taser $ 5,131.00 Total Per FTE $ 14,491.10 Tier 2 - Security Specialist Security Specialist Rate-Midpoint Security Specialist Rate-Midpoint $ 27.13 Annual salary-7010 $ 56,430.40 Retirement Variable-7502 $ 6,935.30 Taxes Variable-7501 $ 4,316.93 Fixed Benefit-medical & dental $ 13,632.00 $ 81,314.62 Reoccuring Cost - 4 FTEs Uniform Cost $ 1,200.00 800 Hand Helds $ 6,418.56 Salary and Benefits $ 325,258.49 Total for 5 FTEs $ 332,877.05 One Time Cost - 4 FTEs 800 Hand Helds $ 18,958.12 Initial Uniform Cost $ 16,364.28 Weapon/Holster $ 2,118.00 Taser $ 20,524.00 Total for 5 FTEs $ 57,964.40 Uniform Costs Tier 2/Sergeant (4) Shirts $ 320.00 (4) Pants $ 234.00 Duty Belt $ 63.90 Duty Belt Liner $ 27.50 Pepper Spray $ 11.30 Pepper Spray holder $ 24.46 Badge/Shield $ 173.75 Name Plate $ 16.99 Ballastic Vest $ 1,600.00 Tourniquet w/Case $ 65.00 Flashlight $ 107.50 Flashlight holder $ 35.77 Radio Holder $ 45.90 Lockers $ 1,365.00 Total $ 4,091.07 Sergeant Sergeant Rate-Midpoint Security Officer Rate-Midpoint $ 30.38 Annual salary-7010 $ 63,190.40 Retirement Variable-7502 $ 7,766.10 Taxes Variable-7501 $ 4,834.07 Fixed Benefit-medical & dental $ 13,632.00 $ 89,422.57 Reoccuring Cost - Per FTE Uniform Cost $ 300.00 800 Hand Helds $ 1,604.64 Salary and Benefits $ 89,422.57 Total Per FTE $ 91,327.21 One Time Cost - Per FTE 800 Hand Helds $ 4,739.53 Initial Uniform Cost $ 4,091.07 Weapon/Holster $ 529.50 Taser $ 5,131.00 Total Per FTE $ 14,491.10 Sergeant Sergeant Rate-Midpoint Security Officer Rate-Midpoint $ 30.38 Annual salary-7010 $ 63,190.40 Retirement Variable-7502 $ 7,766.10 Taxes Variable-7501 $ 4,834.07 Fixed Benefit-medical & dental $ 13,632.00 $ 89,422.57 Reoccuring Cost - 2 FTE Uniform Cost $ 600.00 800 Hand Helds $ 3,209.28 Salary and Benefits $ 178,845.13 Total Per FTE $ 182,654.41 One Time Cost - 2 FTE 800 Hand Helds $ 9,479.06 Initial Uniform Cost $ 8,182.14 Weapon/Holster $ 1,059.00 Taser $ 10,262.00 Total Per FTE $ 28,982.20 Radio Cost APX6000 $ 1,970.49 3 Yr Warranty $ 313.00 Programing $ 1,654.46 Charger $ 116.17 Earpiece $ 52.59 Extra Battery $ 87.11 Microphone $ 98.42 Tax $ 342.21 Total $ 4,634.45 Systems Administrator Velocity Tech Rate-Midpoint Velocity Tech-Min $ 28.85 Annual salary-7010 $ 60,008.00 Retirement Variable-7502 $ 7,374.98 Taxes Variable-7501 $ 4,590.61 Fixed Benefit-medical & dental $ 13,632.00 $ 85,605.60 Reoccuring Cost - Per FTE Salary and Benefits $ 85,605.60 Total Per FTE $ 85,605.60 One Time Cost - Per FTE Initial Uniform Cost $ 200.00 Total Per FTE $ 200.00 Management Assistant Management Assistant Management Assistant $ 23.25 Annual salary-7010 $ 48,360.00 Retirement Variable-7502 $ 5,943.44 Taxes Variable-7501 $ 3,699.54 Fixed Benefit-medical & dental $ 13,632.00 $ 71,634.98 Reoccuring Cost - Per FTE Salary and Benefits $ 71,634.98 Total Per FTE $ 71,634.98 One Time Cost - Per FTE Initial Uniform Cost $ 200.00 Total Per FTE $ 200.00 Admin Positions Shirts/Jacket $ 200.00 Initial Cost - Vehicle Cost Patrol Vehicle $ 58,000.00 Laptops $ 3,000.00 Laptop Tray/Mount $ 916.00 Pedestal $ 250.00 Antenna $ 200.00 GPS $ 324.71 First Aid $ 173.00 Cones $ 100.00 Wheel Blocks $ 20.00 Build out Cost $ 8,050.00 Total Vehicle Cost $ 71,033.71 3 Vehicles $ 213,101.13 Reocurring Cost - Vehicle Cost GPS $ 897.00 Fuel $ 4,000.00 PM $ 6,000.00 Car Washes $ 407.50 Total Reocurring Cost $ 11,304.50 3 Vehicles $ 33,913.50 One Time Cost Set up Post Desk/Cubicle $ 1,000.00 Filing Cabinet $ 250.00 Chair $ 1,600.00 Total One Time Cost $ 2,850.00 One Time Yearly (2) - Magnetometers (Walk-through metal detectors) w/ Accessories $ 13,774.70 OpenGate LTE Board $ 22,522.12 OpenGate Yearly License $ 1,260.00 (2) - Hand wands $462.16 (1) - X-Ray Unit w/Associated Equipment (includes roller table) $ 83,307.28 State Fee for X-Ray $ 95.00 Certification to verify Xray $ 400.00 Turn Styles $ 20,000.00 Lobby and Dock Hardening TBD Totals $ 140,066.26 $ 1,755.00 Executive Protection Trojan Securities 2 Trainers out to Phoenix $ 4,000.00 7 Students ($950 each) $ 6,650.00 Range Time $ 4,000.00 Ammo $ 1,000.00 $ 15,650.00 Position Additions Security Specialists Total Positions 4 Total Recurring Cost $ 332,877.05 Total One-Time Cost $ 57,964.40 Sergeant Total Positions 2 Total Recurring Cost $ 182,654.41 Total One-Time Cost $ 28,982.20 System Administrator Total Positions 1 Current Mgt Assistant Impact $ 71,634.98 Total Expected System Admin Cost $ 85,605.60 Total Recurring Budget Impact $ 13,970.61 Total One-Time Cost $ 200.00 MRT Increase MRT Base Increase $ 71,646.00 LE Experience $ 41,547.71 Speciality Assignement $ 3,481.05 Equipment Addition Vehicle Addi Security Desk Vehicles Desks Setups 1 Total Needed Total Recurring Cost Total Recurring Cost Total One-Time Cost $ 2,850.00 Total One-Time Cost Magnetometer Total Needed 3 Total Recurring Cost $ 1,260.00 Total One-Time Cost $ 36,296.82 Hand Wands Total Needed 2 Total Recurring Cost Total One-Time Cost $ 462.16 X Ray Unit w/ Equipment Total Needed 1 Total Recurring Cost $ 495.00 Total One-Time Cost $ 83,307.28 Turnstiles Total Needed Total Recurring Cost $ - Total One-Time Cost $ 20,000.00 Lobby/Dock Hardening Total Needed Total Recurring Cost $ - Total One-Time Cost TBD Executive Protection Training Total Needed 5-6 People Total Recurring Cost Total One-Time Cost $ 15,650.00 Total Total Recurring Cost $ 681,845.33 3 Total One-Time Cost $ 458,813.99 $ 33,913.50 $ 213,101.13 Radio cost increased slightly due to updated quote coming in itions s Current Payroll Estimate Increase LE Experience Salary $ 1,595,023.20 $ 1,654,844.40 $ 59,821.20 $ 1,689,484.32 Retirement $ 196,028.35 $ 203,380.38 $ 7,352.03 $ 207,637.62 Variable $ 122,019.27 $ 126,595.00 $ 4,575.73 $ 129,245.55 Fixed Benefit $ 408,960.00 $ 408,960.00 $ - $ 408,960.00 $ 71,646.00 SWA $ 34,639.92 $ 1,692,386.64 $ 2,902.32 $ 4,257.24 $ 207,994.32 $ 356.70 $ 2,650.55 $ 129,467.58 $ 222.03 $ - $ 408,960.00 $ - $ 41,547.71 $ 3,481.05 Object Code Activity Appropriation Amount Description 7000 SCRT 1000 Salary and Fringe