Loading...
HomeMy WebLinkAboutResolution Recinding and approving revised rateKITTITAS COUNTY BOARD OF COUNTY COMMISSIONERS RESOLUTION NO. 2021- A Resolution rescinding Resolution 2021-085 and adopting a new Resolution for the Kittitas County Sheriff Cost per Deputy for the Budget Year 2021 WHEREAS, on June 1, 2021, the Board of County Commissioners adopted Resolution 2021- 085, adopting the Sheriff's 2021 Cost per Deputy rate, and WHEREAS the Budget & Finance Manager presented the incorrect rate for the Board to adopt at the rates of: Regular hours non-federal $75.00 Overtime hours non-federal $112.00 Regular hours federal $61.00 Overtime hours federal $92.00 WHEREAS, Kittitas County receives Federal Grant Dollars and bills other organizations, and WHEREAS, according to the United States Office of Management & Budget, 2 CFR Part 200, Uniform Administration Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance), Kittitas County Sheriff needs to adopt a rate for the Cast of a Deputy, and, WHEREAS, the County Auditor has reviewed and approved the corrected Cost Plan and determined the Kittitas County Sheriff Rate's to comply, and WHEREAS the attached documentation shows the calculation rate for the Cost per Deputy as per the requirements for 2 CFR Part 200, Uniform Administration Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance). NOW, THEREFORE BE IT RESOLVED that the Board of County Commissioners resends Resolution 2021-085 and adopts the corrected rates as follows Regular hours non-federal $79.00 Overtime hours non-federal $119.00 Regular hours federal $66.00 Overtime hours federal $99.00 for the Cost per Deputy for Kittitas County Sheriff as certified by the County Auditor, effective January 1, 2021. Resolution 2021 - Page 2 ADOPTED this 15th day of June 2021. ATTEST BOARD OF COUNTY COMMISSIONERS KITTITAS COUNTY, WASHINGTON Chairman Vice -Chairman Commissioner Clerk of the Board/Deputy Clerk of the Board Page Page CERTIFICATE OF COST PER DEPUTY This is to certify that I have reviewed the cost per deputy plan submitted herewith and to the best of my knowledge and belief: (1) All costs included in this proposal, dated January 1, 2021, to establish a billing rate for the cost per deputy for 2021 are allowable in accordance with the requirements of the Federal award(s) to which they apply and the provisions of this Part. Unallowable costs have been adjusted for in allocating costs as indicated in the cost plan. (2) All costs included in this proposal are properly allocable to Federal awards on the basis of a beneficial or causal relationship between the Adopted Budget and the awards to which they are allocated in accordance with applicable requirements. Further, the same costs that have been treated as indirect costs have not been claimed as direct costs. Similar types of costs have been accounted for consistently and the Federal Government will be notified of any accounting changes that would affect the pre -determined rate. I declare that the foregoing is true and correct. Governmental Unit: Kittita County Sheriff Signature: Name of Official: Jerald V. Pettit Title: _Kittitas County Auditor , Date of Execution: January 1, 2021 The 2021 Cost per Deputy Rate is approved based upon the 2021 adopted budget and completed review 5-27-2021. The rates approved are: Regular hours non-federal $79.00 Overtime hours non-federal $119.00 Regular hours federal $66.00 Overtime hours federal $99.00 NOTE: Originally presented to the Board of County Commissioners on June 1, 2021 and adopted amounts per Resolution 2021-085. The rates presented at that time were pulled from an incorrect tab on the Excel spreadsheet. The above rates are correct. Vi V ' N V a N YI N a H N ° N f9 N N N di Z - - m 3 LU a - Q S[w p - B - ❑ O W v d v E c F- A 4-6 •. 3 o ~ `p d19a Q E Bi C E 3 4 µ a c ¢ - e s - i - - F � - N O N ,It Ol 1p N t0 N 1 N t7 N t0 p - � r R - N vi i M N T N W O ❑ # 3 2 5 5d - dal 3 o 3 ? u obiv o `o _ - - 'o _ -° Ci 9 L m o Ic a U p 0w o c i. > n x E c E E E E `o E _ E'6 :p27 c U aW c ? uoTN Y b E m�n Y N ¢gg d ggO= r O N N 1p J � V N YI N a H m 3 LU a p B - ❑ O W v d > E c F- A 4-6 •. 3 o ~ - v - - � r N O N Ol 1p N t0 N N t7 t0 - i m W cz 'o -° '° L m o a U p 0w o c i. > n x E c E E E `o _ ui U �. c ? uoTN fn m° m S m�n Y N Page 4 LL LL w 2 a ai o Z- Z) a O w 00 � r � O � N Y CM fR fA r J tl N N O (� ID N EH CO EA p F L7 W -Cl N M c �' W d m R o D)- C (O co N O [7 (7 N V Omi W O O m O O (O y� N T T a O O N m U N U m m m N a T N N m T 6 O 5 Q' LL N U L 10 L m m N � d o � o N D C L m N °' O U "� Ul Ul O n O D> p m U m X U m L U Q 2)v N _ R yaj ti 0 w 0 vU U 2] ° C U U 3 N � fA .N.. O O N (n >` ►N+ n r O y0 U V O N d a�p� C «° p "X H3 m N m ~M O pm m o l? t7 O U U fA p I � fA fA fA fA f9 fA p - "' m OI N N R c— m v. c T m 0l 10 or -m - O bl C N R m C OOC ~ J :.i O W x U a E C7 J R NIV J N a T N Q c W C N U— C N '� m m v a' p bO o noa W U N'° m K n m U .0 a0i a°i z O ~ ~ E'N 3 mN Noo oaxi R co oo �C ° cT. 10 ` E c c°i w E.4 O1 J� O cam- 'F y a N o o. c 3 L wm o m 0 (7 O b9 U 1 U $ C !0 J o m m U W C J RQR('Wo C Ov W U O V O 10 l0 U C R O O > E O J R V O U W y V ~ C hR m m j d a J dLL Q W m ~ v m E O w O y m m U Z_ O v N m N .CN yU, d 3 U « R O LL Q �lfC4 � tV fA p 0 R LL a Fa rn Q m R W Tp J F T IL L LUW Oc m Ip m o m LL m N J � A Z It j LL G Q N l" N W N � (D 0 O O N m m N ON O 10 � fR fA p J tl N N O (� FA fA EH CO EA p F L7 W -Cl >� c �' Ol R d m R o D)- C _ « 00 Q0 W W m .� LL` 7 p W O V m m m N a T N N m T 6 O 5 Q' LL N U L 10 L m m N � d L C L m N °' O U "� Ul Ul O n O D> p m U m X U m L U Q 2)v N _ R yaj ti 0 w 0 vU U 2] ° m E N N N N ° N p m n t .N.. O O N (n >` ay .. V% n r O y0 U V O N d a�p� C «° p "X H3 m C� ° ~M O pm m o l? t7 O U U — V R I U Q)v d �+ m L m _ m m U o> mc2'om E° R c— o QLL a OOC ~ J Nr H g . R E ~ U _ Q .., Q Q c aW R m v E� U .0 O O z O ~ ~ Q D Page 5 D m J tl m O N O U O N m C 0 U IL p C Q W o « 00 3 3 C ti R ° 7 p W O O�E y 0 I v m C E' m m C R W O R U U y F m N � � C C O H Z i m m E c VO p U 2)v N _ R yaj ti 0 Q vU U 2] c Q V 0 Page 5 D m J tl m O N � U O N m C m J p C o y 0 3 3 n v m m ° w v m m m m U t0 � C C D m G Ip m m E c VO p U 2)v N _ R m C > R m vU U 2] O V 0 m 3 U L « m U N o o (n >` L C N J VJ O C OI C J -O E v m C « a am R U U m N C O o c C m L p E C c m L I m R N O p o Z N L C O E N O m m L z m N E o L T V O n E o m J R U co m =N E o 7 > mm R O n t F J L m m L O O X N EU Q o m m J C U O Q o m Page 5 6/11/2021 10:52 AM New Deputy $ (Filling Vacancy) KITTITAS COUNTY SHERIFF'S OFFICE PATROL DEPUTY COSTS PRE-EMPLOYMENT MEDICAL SCREENING POLYGRAPH PSYCH SCREENING UNIFORMS ISSUED COST PER QTY ITEM 1 $796.50 1 $200.00 1 $600.00 SUB- TOTAL $796.50 $200.00 $600.00 Page Updated: 6 1/1/2021 -SM $12,336.76 TOTAL $1.596.50 $1,999.40 JACADEMY PACK (ENTRY LEVEL DEPUTY) $3,809,37 ACADEMY TUITION 1 $3,347.00 $3,347.00 ACADEMY CLOTHING 1 $462.37 $462.37 BP VEST $1,648.21 ABA XTREME LEVEL II BP VEST W/THREAT PLATES, EXTERNAL CARRIER, POUCHES, PLACARDS, ETC. 1 $1,648.21 $1,648.211 DUTY GEAR DUTY BELT LINER BELT CUFF CASES UNIFORM PANTS - STRYKE PANTS UNIFORM PANTS - FECHHEIMER CARGO PANTS 2 2 $64.93 $129.86 1 $80.09 $160.18 UNIFORM S/S SHIRT - FECHHEIMER UNIFORM L/S SHIRT - FECHHEIMER UNIFORM L/S SHIRT - BLAUER ARMORSKIN 2 $69.26 $138.52 2 $74.71 $149.42 2 $59.59 $119.18 UNIFORM S/S SHIRT - BLAUER ARMORSKIN 2 $58.64 $117.28 BOOTS 1 $250.00 $250.00 GREEN TIE 1 $8.01 $8.01 STOCKING HAT 1 $18.12 $18.12 BALL CAP 1 $17.26 $17.26 JUMPSUIT 1 $516.05 $516.05 NAME TAG 1 $10.82 $10.82 BADGE 1 $97.20 $97.20 STREETGUARD GLOVES 1 $40.60 $40.60 WINTER JACKET W/ LINER 1 $226.90 $226.90 JACADEMY PACK (ENTRY LEVEL DEPUTY) $3,809,37 ACADEMY TUITION 1 $3,347.00 $3,347.00 ACADEMY CLOTHING 1 $462.37 $462.37 BP VEST $1,648.21 ABA XTREME LEVEL II BP VEST W/THREAT PLATES, EXTERNAL CARRIER, POUCHES, PLACARDS, ETC. 1 $1,648.21 $1,648.211 DUTY GEAR DUTY BELT LINER BELT CUFF CASES 1 1 2 $37.46 $20.79 $24.90 $0.00 $0.00 $0.00 BELT KEEPERS SET OF 4 1 $13.00 $0.00 OC SPRAY 1 $16.90 $0.00 OC CASE 1 $14.73 $0.00 CHAIN HANDCUFFS 1 $30.27 $0.00 HINGED HANDCUFFS 1 $41.70 $0.00 GUN HOLSTER 1 $154.82 $0.00 SERPA TASER HOLSTER 1 $62.51 $0.00 KEY HOLDER 1 $15.39 $0.00 GLOVE POUCH 1 $12.35 $0.00 FLASHLIGHT HOLDER 1 $23.29 $0.00 $43.11 G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY.xlsx 6/11/2021 10:52 AM New Deputy $ (Filling Vacancy) PURCHASE & LICENSING - FORD PI SUV DELL TOUGHBOOK RADIO HOLDER 1 $44.86 $0.00 $2,436.00 $0.00 $5,67.0.00 $0.00 $4,510.00 $0.00 RADIO EARPIECE 1 $43.11 $43.11 1 MAG HOLDER 1 $26.81 $0.00 $430.00 ASP/BATON 1 $75.80 $0.00 $1,650.00 ASP SIDEBREAK HOLDER 1 $37.37 $0.00 FIREARMS HANDGUN W/3 MAGS 1 $596.42 $0.00 HANDGUN AMMO 1 $250.00 $250.00 RIFLE 1 $923.07 $0.00 SUPPRESSOR 1 $332.38 $0.00 LESS LETHAL SHOTGUN 1 $611.90 $0.00 LESS LETHAL AMMO 15 $6.77 $6.77 TASER 60 - ANNUAL PMT 1 1 $525.721 $525.72 EQUIPMENT PORTABLE RADIO W/CHARGER & EXTERNAL MIC, PROGRAM HEADLAMP CELL PHONE 1 $1,002.30 $0.00 1 $32.22 $0.00 1 $50.00 $50.00 CELL PHONE - MONTHLY SERVICE 12 $45.00 $540.00 GUN VAULT SAFE 1 $99.00 $0.00 FIRST AID KIT 1 $69.05 $0.00 QUIKCLOT 1 $42.01 $0.00 10OFT MEASURING TAPE 1 $25.78 $0.00 CPR MASK 1$8.67 $8.67 1DIGITAL VOICE RECORDER 1 $250.31; $0.00 PBT � DIGITAL CAMERA W/SD CARD & CASE _ BINOCULARS FINGERPRINT KIT CRIME SCENE TAPE 1 1 1 1 1 J $479.33 . $314.641 $181.78 $112.95 $9.74 $0.00 $0.00 $0.00 $0.00 $9.74 BIOHAZARD CONTAINERS 2 $5.00 $0.00 BIOHAZARD PICKUP KIT 1 $17.32 $0.00 RUBBER GLOVES 1 $7.57 $7.57 DISINFECTANT 1 $3.00 $3.00 C -A -T TOURNIQUET 1 $27.20 $0.00 LIFEJACKET 1 $80.00 $80.00 TECHNOLOGY OFFICE 365 LICENSE 1 $385.58 $385.58, VEHICLE PURCHASE & LICENSING - FORD PI SUV DELL TOUGHBOOK 1 $38,647.85 $0.00 1 $2,436.00 $0.00 $5,67.0.00 $0.00 $4,510.00 $0.00 DATA1911 VERUS SOLO VIDEO SYSTEM _ MAINTENANCE & SERVICE CONTRACTS 1 1 PATROL BUILD 1 $16,700.00 $0.00 GRAPHICS 1 $430.00 $0.00 RADAR, PRINTER, SCANNER, IMPACT CHARGER 1 DIAMOND HARD TRUCK COVER 1 $3,510.00 $0.00 $1,650.00 $0.00 Page 7 $782.49 5 plus 10 for training $698.98 $385.58 $1,373.12 G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY.xlsx 6/11/2021 10:52 AM New Deputy $ (Filling Vacancy) Page KENWOOD RADIO 1 $2,600.00 $0.00 COMPUTER WIRELESS - MONTHLY SERVICE 12 $40.01 $480.12 MAGLITE W/CHARGER 1 $100.27 $0.00 INOVA LIGHT W/CHARGER 1 $243.08 $0.00 RADAR CALIBRATION & CERTIFICATE - ANNUAL 1 $86.00 $86.00 PORTABLE RADIO CHARGER 1 1 SET $87.19 $807.00 $0.00 $807.00 GOODYEAR ALL SEASON TIRES JUMPER CABLES SHOVEL SAFETY CONES 1 $34.65 $0.00 1 $17.31 $0.00 3 $13.94 $0.00 ROAD FLARES 1 CASE 1 $48.55 $0.00 WOOL BLANKET 1 $11.91 $0.00 ORANGE TRAFFIC PAINT --i $7.24 $0.00 ANNUAL ANNUAL G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriffl2021 COST OF A DEPUTY.xlsx 6/11/2021 10:52 AM KITTITAS COUNTY SHERIFF'S OFFICE PATROL DEPUTY COSTS UNIFORMS Exisiting Deputy Annual Costs ISSUED COST PER SUB - QTY ITEM TOTAL UNIFORM PANTS 2 $64.93 $129.86 UNIFORM S/S SHIRT 2 $69.26 $138.52 UNIFORM L/S SHIRT 2 $74.71 $149.42 BOOTS 0.5 $325.00 $162.50 GREEN TIE 1 $8.01 $0.00 STOCKING HAT 1 $18.12 $0.00 BALL CAP 1 $17.26 $0.00 JUMPSUIT NAME TAG BADGE 1 1 1 $516.05 $10.82 $97.20 $0.00 $0.00 $0.00 VVIN I CK JHI:Kt I VV/ LINtK 1 $226.90 $0.00 BP VEST CRIME SCENE TAPE 1 $9.74 $9.74 BIOHAZARD CONTAINERS 2 $5.00 $10.00 BIOHAZARD PICKUP KIT 1 $17.32 $17.32 ABA XTREME LEVEL II BP DISINFECTANT 1 $3.00 $3.00 C -A -T TOURNIQUET 1 $27.20 $27.20 $86.00 $807.00 GOODYEAR ALL SEASON TIRES VEST W/THREAT PLATES, EXTERNAL CARRIER, ,POUCHES, PLACARDS, ETC. 0.20 $1,648.21 $329.64 FIREARMS HANDGUN AMMO 1 $250.00 $250.00 LESS LETHAL AMMO 5 $6.771 $33.85 EQUIPMENT Updated: 1/1/2021 -SM $3,500.27 TOTAL $580.30 Page 9 $325.00 N $329.64 REPLACE $283.85 $547.78 TECHNOLOGY $385.58 CELL PHONE MONTHLY SERVICE 12 $45.00 $360.00 VEHICLE $1,373.92 FINGERPRINT KIT 1 $112.95 $112.95 CRIME SCENE TAPE 1 $9.74 $9.74 BIOHAZARD CONTAINERS 2 $5.00 $10.00 BIOHAZARD PICKUP KIT 1 $17.32 $17.32 RUBBER GLOVES 1 $7.57 $7.57 DISINFECTANT 1 $3.00 $3.00 C -A -T TOURNIQUET 1 $27.20 $27.20 TECHNOLOGY $385.58 OFFICE 365 LICENSE 1 1 $385.581 $385.58 VEHICLE $1,373.92 COMPUTER WIRELESS MONTHLY SERVICE 12 $40.01 $480.12 $86.00 ANNUAL $807.00 ANNUAL RADAR CALIBRATION 1 1 SET $86.00 $807.00 GOODYEAR ALL SEASON TIRES G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriffl2021 COST OF A DEPUTY.xlsx LU m F.. w LU Oa.W O F - Z N Q w W LU H N w LUJ 7 a' Q o a o w F. Q Q J LL O V J N U O U N 0 N Q N O O N W Wcoor,ocq w n 00 O N N O Q1 LL N� a� h N h If7 IA b O � r fA fq fA ff> N> fA to fq fq c41 I N w m O mMN -04 Nw A ffw ffffa f O Omm R 00 Jo0o0000 COD01 0 U3, 69 CS to d m o c o Lo m m I S'0 O N M W W O u7 Io to C — fi9 f!> Eq Ef> V> 64 v> En v> m o 0 0 0 o o o 0 o O O O O O O O O O V r-� r- r- r- N N M mm M M M M M M y W W W W ao m W W W Q m o r `�° aoo m w ro 0E 0 0 0 0 0 0 0 0 0 2 d o o o o o o 0 0 o C O 0 o O o o o O o v> v> v> V) vi Ur v> v> VW V W W W m W N N O. T W M d W f- W m 0 N Cl) to I Ni N N N N ff> vi v> ff> H> v> v> V> v> c m i�: i�: r7 In (D ID In m (D ID (n In M M M M M M M M M to Ef> f9 v> v> a "I K> E!> NM g! "t W m W W N Q WW W r o W N W M N m o m N W LL N N N CV N M M M M U3. ff> 49 fA Y> v> w v> (A T V W N V m N Ql m O r O m v Op 2 MM W W m O N co � (7 M M M M V' V V O E y M M M M M M M M M V M M M M M M M M M � M M M M M M M M M O M M M M M M M M M d O O 6 O O O O O O O O O O O o O O O (D O W W W V W V O W V WW W V W O N( O N O I11 m M W W Iq � bq W W W m 7 fA f9 EA b9 U> (» b9 ff> f9 c c Q O O O O O O O O O 0 o O o o O o O O m O� W W I� V N (D m N LQ r m N Lo W 0 V W �O m m W W W r- t` Q) Wf ff> v> (A fA fA fA vi u) y m m 4) V! N N N N N NN N N +�•' N N N N N N N NLU N 0 a a a a a J J CL w w w w w m a t7 C7 Q f j co N N w U U to rn w 0 c LL >n 10 O O N H L M N (O Ni M V n N N> M N o N fi1 N (O N fD ff> n O w W fi► n O o W tO N o n fA n OO m n OW w n w n N'> C C E — O c q co A (I n N 0 c >n M 6 W M (O O N a o mmm(onnnaoao X r= X w N •LL7 lD M N_ - M d F- 04 N d O 0 0 W O O r- Cl) 0 O 0 0 N L ff> ff> !A fA fq fR fA fR ER w O w CD a a d r w m Of E J to r � U m 0 C CL C ' V W OIO l� I- m m In m co l- m 0 N In In (D O 3 9 of N m M M Ln m W I- O C w O W I- r r W co — fA ffi ff> v> ER Vi fA fA v> m Lo m IC (d m IE Q Q Q Q d V% fA M1 e% H> ff> (0 Ga ff> ` Wm N co O N W N O. m m 0 0 T N N N M O E O 0 O 0 0 0 0 0 0 0 0 i O O o 0 0 0 0 0 0 O m Nm n O 0i C CL W V t N 0 m m In N O 0 d 'oW I� W 0 O N V IO r NN N N M M M M M N U, fA V> v> M m fA v> v> c m Lo Lo Lo X) I) n to In M Lo M Lo (D M u) M In M u� M In M m (n M In M v> v> v> v> v> fH fR v> v> V V W ID m W N m co co U (D N m M ID W m 0 LL M M M V V r V to Y) v> v> v> v> v> v> v> vi Of` W V lD M W V N O W V M M N V m W m M W W I� H S NI- u7 N N 0 m W O i.., f` m V n m v (O v V V ll7 ID lD lD W (D co 10 E 2 H O O OO O O 0 O O O SO 00000 O 0 l0 O 't W W I'- a N N m (N r N LQ C iA m (D u7 0 W (OD W W I- V n h d f9 M V> 69 v> vi w fA f!> U) m m 7 N� NJ C11 04 N� N N N N LU T r N M a (D N N EL a 00 U U (A rn Page 10 O O W (D 04 C C E E N N E n N N y y M M Cl) M M Cl) C c c c L N w N o UU1 x X X X r= X w N •LL7 lD M N_ - M d a 04 N d O 0 0 W O O r- Cl) 0 O 0 4' C C E C w O Y N 7 E E J m U In 10dcn O w CD a a d r w m Of E to r � U m 0 C CL C ' (C Q = (0 3 9 of m w O LL w O O M O n O, O� Im 0) om 0) Lo P, Lo m IC (d m IE Q Q Q Q Page 10 O O W (D 04 E E E N N E n N N y y M M Cl) M M Cl) m m L N w N o UU1 x X X X r= X w N •LL7 lD M N_ - M r- (D O W 04 N O lD O O m 0 O 0 0 W O O r- Cl) 0 O 0 4' C C E C w O J N E N 7 E E J m In O O w a a ¢ m Of E U r � U U a� C Page 10 6/11/2021 10:52 AM Direct Costs (non-sal_ben) Page DIRECT COSTS ALLOCABLE TO DEPUTIES 1 11 Cost of On -boarding a New Deputy: $ PRE-EMPLOYMENT COSTS $ 1,596.50 UNIFORMS $ 1,999.40 ACADEMY PACK ENTRY LEVEL DEPUTY $ 3,809.37 BP VEST $ 1,648.21 DUTY GEAR $ 43.11 FIREARMS $ 782.49 EQUIPMENT $ 698.98 TECHNOLOGY1 $ 385.58 VEHICLE $ 1,373.12 Example of average cost/gal: DOT Annual fuel cost range (2019): JAN $ FEB $ MAR $ APR $ MAY $ JUNE $ JULY $ AUG $ SEPT $ OCT NOV DEC (This is the invoice total, not just Patroi) $ Cost of Maintaining a Deputy/Year: $ UNIFORMS $ 580.30 BP VEST $ 329.64 FIREARMS/AMMO $ 283.85 EQUIPMENT $ 547.78 TECHNOLOGY1 $ 385.58 VEHICLE GENERAL ANNUAL COSTSI $ 1,373.12 Example of average cost/gal: DOT Annual fuel cost range (2019): JAN $ FEB $ MAR $ APR $ MAY $ JUNE $ JULY $ AUG $ SEPT $ OCT NOV DEC (This is the invoice total, not just Patroi) $ $ $ $ $ 12,336.76 $ 3,500.27 Total cost/invoice Total gal fuel/invoice Avg Cost/Gal 9,448.31 4.159.82 $ 2.27 7,650.53 3,496.38 $ 2.19 8,486.64 3,721.36 $ 2.28 9,350.57 3,468.93 $ 2.70 11, 381.10 3,862.19 $ 2.95 11,358.80 3,933.24 $ 2.89 10,367.30 3,859.95 $ 2.69 10,469.78 3,938.89 $ 2.66 10,074.78 3,853.57 $ 2.61 10,187.56 3,653.12 $ 2.79 10,313.44 3,608.51 $ 2.86 9,399.73 3,665.14 $ 2.56 118,488.54 45,221.10 $ 2.62 2021 budgeted fuel cost for GF and L&J vehicles: $84,250 Average cost/mile (using $2.37/gal, & assume 15 mpg avg) $ 0.16 Assume av-q total miles driventhour 50.00 Avg fuel cost/mile/hour $ 7.90 G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY.xlsx 6/11/2021 10:52 AM Direct Costs (non-sal_ben) 2021 KITTCOMISPILLMAN COST $ 412,858.84 (Per contract) 2021 Insurance Budget (property & liability) $ 106,169.00 _ (non jail, non -boating portion only) Page 12 From OMB Super Circular 200: E Direct Costs 1. General. Direct costs are those that can be identified specifically with a particular final cost objective. 2. Application. Typical direct costs chargeable to Federal awards are: a. Compensation of employees for the time devoted and identified specifically to the performance of those awards b. Cost of materials acquired, consumed, or expended specifically for the purpose of those awards c. Equipment and other approved capital expenditures. d Travel expenses incurred specifically to carry out the award. 3. Minor items. Any direct cost of a minor amount may be treated as an indirect cost for reasons of practicality where such accounting treatment for that item of cost is consistently applied to all cost objectives. 4. Factors affecting allowability of costs. To be allowable under Federal awards, costs must meet the following general criteria: a. Be necessary and reasonable for proper and efficient performance and administration of Federal awards 5 Reasonable costs. A cost is reasonable if, in its nature and amount, it does not exceed that which would be incurred by a prudent person under the circumstances prevailing at the time the decision was made to incur the cost. G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY.xlsx 2021 Vehicle maintenance budget for GF and L&J vehicles: $ 119,091.00 2020 Depreciation Values (from Kay's Depr Schedule): $ 153,063.31 2020 Allocated vehicle warranties for NEW LE and L&J $ 31,881.94 vehicles warranties not ca italized 2020/2021 Estimated cost for allocated depreciation, warranties and repairs $ 304,036.25 From OMB Super Circular 200: E Direct Costs 1. General. Direct costs are those that can be identified specifically with a particular final cost objective. 2. Application. Typical direct costs chargeable to Federal awards are: a. Compensation of employees for the time devoted and identified specifically to the performance of those awards b. Cost of materials acquired, consumed, or expended specifically for the purpose of those awards c. Equipment and other approved capital expenditures. d Travel expenses incurred specifically to carry out the award. 3. Minor items. Any direct cost of a minor amount may be treated as an indirect cost for reasons of practicality where such accounting treatment for that item of cost is consistently applied to all cost objectives. 4. Factors affecting allowability of costs. To be allowable under Federal awards, costs must meet the following general criteria: a. Be necessary and reasonable for proper and efficient performance and administration of Federal awards 5 Reasonable costs. A cost is reasonable if, in its nature and amount, it does not exceed that which would be incurred by a prudent person under the circumstances prevailing at the time the decision was made to incur the cost. G:\Spreadsheets\Accounting\Cost Allocation (includes Excel & Word)\Sheriff\2021 COST OF A DEPUTY.xlsx Q cu E E N cn O U rn c m H Q N Lq O N O N co N ' O M N Cf J N m O W LD LD c0 Ln Ln r� in Ln N0 d o cD N� O M LD r -I !'ICA Z r% ri M e I e 9i O F- LU `� M N u a Q x N W ko W LDcDD c0 mD O O r14 1-1 M P^iZ 00 N N N Lfl lD c -I N Lfl m O H LU Ln N u d Q xui M N ' Ln M M cD 14 LD ' r -1 N N Ln 4n ri ri J N co LD Olt.0 CO r- N 00 UJ Ln Ln N Rt It O r- m r I 00 � D z ri m fV ri ri ri (p O H ui `� O N u a Q x N ui L. ! W W ai M tD Ln H U H Ln M ri r -I r -I m ri r -I r -I 0 0 0 0 0 0 0 0 N o 0 o m m m o m 0 m o m M m m m m m rn m O a �t�� J J W Z u cc + z Z_ Z _Z Z_ Z_ Z (' Z Z Z Z Z Z Z Z Z Z O a a a a a a ,r1 Z z F- Lu 0 Z Q w w w > > > w > w > w > > z z z z z z w°C C7 a a a a a a O o 0 0 0 0 a � � CC = = °O >� aaaaaa� LL o: c oC Ln N N N N N � II' LL Lu Ln ~ M Ln rl O O Z r -I r -I O r -I r -I r I cD (D lD lD WD W rI O O O O %.D O O O O O LL O mm a m m m o a) a, a) 0, a) mI;t It p zt Ln Ln Ln Rt m I Ln rn1:4- Ln t Ln I;zj- Ln It Ln It Ln U Ln LntLD N Ln M Ln Ln�o r` Ln rn N 0 0 J O N N 0 N r -I N a) N N O O N O N O N r -I N m N Ve O O O O O O O O O O O O m O O O O O m0 O O O O m m m m m m m m m m W Q Z w D w Z) Z Q �o L Ln J = J J = J W = w = a F- U Q H F- Dr F- U Q H in- to Ln a a vai n a Page 14 X X i W Q LL O f— U) O U r - N O �L U)'�L� O N U X W to m a 73 U ` O V O N N N r, n N n n n O ri N n n n H Ln W O O V d' �t tT N CL ID M N M M M W W OR W M W W 10 W Ln Ln M r, V 01 W W rn M M n n 0 .2 N n m H HH m M m m m m m V n w t O m 0 Ln w m W w w N ri va m i. H 0 0 0 N N N N N N m co O N N N m N m N N w w w 0 0 m Ln w'IR m'R M m m m m m- N m m m a w a w v m m Ln V w E v w m Oi m m o0 00 00 00 00 00' o Di m o 0 o m nS rri m m v v v rl u C N N N N N N r-4 NN N N N M N NN N NN N H H r-1 H H H u 00 Q M V W G 0 0 a u i H O O^1 O rq o Ln w H v H rq m n o n rn Di m m N N O 7 O N N N r\ n n r\ N n N m m r-' H H m m m Ln Ln m Ln m w w LD H H R H 01 O1 m V Ln 01 N LO CO N al 01 01 ll� V14: V a V rl N 1n n n n 7 W m V rl! 't V V LD lD LD 01 Ln N Ul lO lO 01 H O 1' O N N m H H ri m In Ln Ln m m N M N N N N m N w 01 r, 01a) Ol LD N N O a v a LD w w O m Ln m M rl H O O O W LO LO w w LO co 00 C It C V W W 0 m H m m m W w w N m m M m m N N W H 1p m Lr1 LD l0 LD N N N N N N m m N m m M m m 01 N N N N N c} V V V Ln L11 N Ln Ln H H N m r, N N N N N N O O O O O O m m N m M m m m N m m M m m m m M m a V c7 m m * m M N N CD 'T O N N N N N N n r n N M m H H H M m m In Ln In M 0 W W LDH -I H H 'IR W N Ol 01 Ol V [t V Ch 14: V r- N Ln r� n n V W M N V V LD LD LD v 01 Ln Ln 111 N rl m ry H r-1 N 0 Ln In Ln N N m n rn N m N w m n Ol m 0) w N a N O V V V m r- H O 0 O LD LO LD l0 LD w W co V V C C- o0 00 Ln m H 01 m 01 00 co co NM M M E LD M In LD lO LD N N N N NN M M r, Ln Ln Ln M Ln 01 N N N N N V Ln Ln In m r m a L; a i:z Z o 0 0 0 0 0 O O O O O O N N O o 0 O o 0 OJ N N N N N N N N N N N M m M M M M M N M m m m m m m M M V V V s O1 > O 4 O O O O O O N N N m M m I� M 01 r a 'c7 V H N N O O O O O V w O l0 LO lO l0 LD 01 to n O O O H 01 01 H H-1 H H Lr1 01 01 Lr1 Ol 01 01 V 01 LD Q N ry H ry r4 H ry M W LO M M M 1, N H ri M ry ri rj O Co 00 M Ln Ln Ln co O co ' � O1 01 01 0) 01 01 N a1 V N N Nm 00 N m 00 m m m N H H O O1 m m H et 01 W O W 00 W OO OOO O LO Ln N N N m m I� w m LD w LD co 00 co � H O Ln Ln Ln 1 w Q N ri rti H ri r-1' N N' r4 n n r,W W lD' I� n r - r- OO o0 00 LD N N N' V V N ` O V O N N N r, n N n n n O ri N n n n H Ln W O O V d' �t tT N CL ID M N M M M W W OR W M W W 10 W Ln Ln M r, V 01 W W rn M M n n 0 .2 N n m H HH m M m m m m m V n w t O m 0 Ln w m W w w N ri va m i. H 0 0 0 N N N N N N m co O N N N m N m N N w w w 0 0 m Ln w'IR m'R M m m m m m- N m m m a w a w v m m Ln V w E v w m Oi m m o0 00 00 00 00 00' o Di m o 0 o m nS rri m m v v v rl u C N N N N N N r-4 NN N N N M N NN N NN N H H r-1 H H H u 00 Q M V W G 0 0 a u i H O O^1 O rq o Ln w H v H rq m n o n rn Di m m N N O 7 O N N N r\ n n r\ N n N m m r-' H H m m m Ln Ln m Ln m w w LD H H R H 01 O1 m V Ln 01 N LO CO N al 01 01 ll� V14: V a V rl N 1n n n n 7 W m V rl! 't V V LD lD LD 01 Ln N Ul lO lO 01 H O 1' O N N m H H ri m In Ln Ln m m N M N N N N m N w 01 r, 01a) Ol LD N N O a v a LD w w O m Ln m M rl H O O O W LO LO w w LO co 00 C It C V W W 0 m H m m m W w w N m m M m m N N W H 1p m Lr1 LD l0 LD N N N N N N m m N m m M m m 01 N N N N N c} V V V Ln L11 N Ln Ln H H N m r, N N N N N N O O O O O O m m N m M m m m N m m M m m m m M m a V c7 m m * m M N N CD 'T O N N N N N N n r n N M m H H H M m m In Ln In M 0 W W LDH -I H H 'IR W N Ol 01 Ol V [t V Ch 14: V r- N Ln r� n n V W M N V V LD LD LD m m n 01 Ln Ln 111 N rl m ry H r-1 N 0 Ln In Ln N N m n rn N m N w m n Ol m 0) w N H O rl O N O V V V m r- H O 0 O LD LO LD l0 LD w W co V V C C- o0 00 Ln m H 01 m 01 00 co co NM M M O In Ln Ln N 00 H LD M In LD lO LD N N N N NN M M r, Ln Ln Ln M Ln 01 N N N N N V Ln Ln In O O O O O O N N N N N N N M m M M M M M N M m m m m m m M M V V V m M N N z p � � LL N ZO O Q W H al > Z O O G Z❑ C7 ., 5¢ O O w w 5 Q s z ca U M� .--. U W �' Z W w N Y CC Z v H O ¢ C CD m l.L J 'a w >> U U --1 U > 2 w C7 w H>>> (7 p _ k❑ w w in u U Q m 2 a w U U Y m❑ w Q v❑i v=i r=if w= Lu O W H Z O> O= >❑❑❑>>>>>> m Z Z 2 C w> w a Vl w C cr J w rr Q❑ U 0 0 of U U > fir m m m v❑i v❑i v=i v❑i v❑i v=i ❑❑ m 0 0 0 0 j OO O w C7 _zi U U O w Z Z m 2 H F- F- w K w w w m m w w w O O w n —Cr.¢ W p❑ a> O rn a Z 0 0 0 0 0 0 0 E F ❑ U U U = U O �' O O O cc. ccw O O O U V V U 0~ w m Q H F- O O O F- F- F- F- F- F- = m F- F- F- F- O w a F- ❑ a 0 N a w w w w w w w O O Q F F- F Ln LnLn H w m a:C7 w w w M U U w Om Ln Lo Ln Ln 0 0 0 0 F a u a w o d a o_ w w= w w= to !n m Z Z Z IHL LL Z= Q LL' OC LL' U W W LL LL LL LL LL Z O_ W W W o F Y Y Y w w w w w w O o Q p p p❑ p p w= w w w w F F- w p p❑ p❑ p p O p❑ W U U U N N vUi oC ~ U F- F- F- F Z Z_ F- w [[ W w K w w O Z a Z Z Z Z Z Z LL LL w 0 0 0 0 0 0 Z W Z Z Z Z w w z 0 0 0 0 0 0 0 0 0 0 m S-0 Q Ln Ln o O O O Cc C== w O_ w O_ O_ H H H H H W�❑ K W p w tr O O O O O O O O HH H o= O N N N O O O O O O O O O O o O o O o 0 O 0 0 0 3 0 0 0 O O O O o O O 0 0 0 N U LL LL LL W LL LL LL LL LL LL LL LL LL N N N N r.4 N LL ❑ LL LL LL Q M D_ LL N N N N N N N N N N O LO 00 01 O O H rV M V Ln LD r, 00 O H N M H N mzt Ln LD H N co CT rn V Ln LD n W y, wm M m� 0 0 0 O O O O O O H H H H H �� -} V rn V o to Ln O O O O O O H W N v n m o o O O n n N r' N r' n n n v a v a n m 0 0 0 m HH H H w w w w w w w n 00 m O 0 Ln O m m m m m m m m m m m m m a a a q� o Ln mm Ln m w w to w n F, N r, r, r, w m m m Q 0 0 0 0 O O O O O O o O O O 0 0 O 0 O 0 O 0 O 0 0 o O O O 0 O 0 O O O O N CN rl Cl) W tna F-� W > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > a u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u u a W K Q F- W N W w W w W W W W w w w W w W w w W W w W w W W w W w W W w w w W W w W w w W w W Page 15 a� m �U N Q 0) O C N 0 2 CD .r- 0 N N a U O c N r0 y 0 N W F- O Z Page a 16 w 3 w a zu a 3 :Iry ry ry ry ry ry �' Zcq ONo > N W � W O p - ma wwwww m _ N O 0 0 Z LL y N N R' a d w w w w ww w LL a No N ry ry N 0 Q N m "s Z ww o s _ m a 0 U O O O mm o Q a O Qz xY �r mrwao a m Q m m r w a LL U >> V Q a 7 N Q R Q Q Q Q a 7 a O wW rrNwzrOWa O a j r a a O W h S O O Iy W W¢ S y W J W Q x W S 0 y W m U a a w O m m U a a a m W O a, O Q as MwOOw w o o w d W z z a U Z QQ m>Uw>��0 m> U w> W m O O w J J m Q 6 O m 0 to ? w w w w w m w w w N N w w w w w w w N M W ry w �a WM wI Iq LL.+ � _ �n �b w O v _ _ _ _ _ Fy _ _ _ N O ow wwwww fnw dw ww �ww� w ww w w Lm m O N� C; U U w� rJJJJJJ _o Q»»» HF ammm.m. Zo------ mm ft-- m m m mu. m m ow aaaaaaa f/a1 U F W > Y N w w w W J m `Zw 66w w gUggw'nU U W mom W aaLLLLW K M� S o 2 z z z z z > U z o o m o w w aaLL w W U >O U w w w W w U OU UO W m> U 0 0 0 0 g g K U> U U K U U U i° U V U U Z U m aiwwwaw ww� D b www rc) a�¢ z u� m Kw'KK�M> Qmm pe QQQ JN NmN O m K f/1 00 00 S Qb OOQ 222 uOuQm °� a0b r r O W� LLILL LLI�LLLL¢. �Q R'Z W W W rm ZU ZUU Z Q K Z ❑ O O o m o O aHam=00 aaa ti> Q Q Q m Q m �= o O 0000000 w�w�zo QNQ www �� FZwF Zwz U U az o ¢ LL LL LL LL LL LL U Q Z U 0 3 N U U U ¢ Q 2 2 Z U ¢ a Q o 3 w N N N N N 2 r- w z J S W S r r = O❑ `d Z N NNNNN N > O > O Y Q >>> O O G` 1 1 > R o❑ Y Q r W > > W N m O O K W N N w w w O W OQKoo LLa LLlim Y Z U d m f K " 6 N 0 0 0 0 0 0 O Z Z Z z z z z D u LL D LL. IMMm QJQ QJQ QJQ QJQ QJQ z = � K LL M Z o w W w W W w NZ LL Z Z Z Z Z Z w W W (7 (7 W W W dad S n d w W O w