HomeMy WebLinkAboutShelton Academy 2020 User FeesTrainingAcademyUserRateStudyBeginningFiscalYear2020WashingtonStatePatrolJune2018
TABLEOFCONTENTSPageOverview....................................1Methodology.....................................1-2ConclusionsandRecommendations.....................................3SignaturePage...................................4AttachmentA....................................6AttachmentB.....................................9AttachmentC...................................11AttachmentD...................................16AttachmentE.......................................19
WASHINGTONSTATEPATROLTrainingAcademyUserRateStudyBeginningFiscalYear2020OverviewTheBudgetandFiscalServicesDivisionconsultswithotherWashingtonStatePatroldivisionsandsectionsinthepreparationofratestudiesforvariousactivities.Thepurposeofthesestudiesistodevelopoptionsforsettingratestochargethird-partyusersofWashingtonStatePatrolservicesandfacilities.Ratestudiesareconductedinaccordancewithgenerallyacceptedaccountingprinciples,federalcostallocationguidelinesandgovernmentalaccountingstandards.AlthoughtheChieforhisdesigneemayapproveawaivertochargelessthanthedeterminedfullrate,itistheagency'sintenttoalsocomplywithRevisedCodeofWashington39.34.130,whichstatesinpart:"...thefullcostsofastateagencyincurredinprovidingservicesorfurnishingmaterialstoorforanotheragencyunderchapter39.34RCWoranyotherstatuteshallbechargedtotheagencycontractingforsuchservicesormaterialsandshallberepaid..."ThisratestudywasconductedtodeterminetheratestobechargedtousersoftheclassroomsandothertrainingfacilitiesattheWSPTrainingAcademy.MethodologyThisstudywasbasedonactualcostsforthe2015-17Biennium(July1,2015throughJune30,2017).Usingdatafromthetwo-yearperiodhastheeffectofstabilizingthehighsandlowsoffacilityuseandpresentsabroaderpictureoftheuseoftheTrainingAcademy.TheactualcostswereadjustedtoincludevehiclefuelandmaintenancecostspaidbythePropertyManagementDivision,aswellassalariesandbenefitsforstafffundedbyotheragencydivisions,including:oSeveraltemporaryoron-callinstructorsfromtheFieldForce;oOneautomechanicpositionfromthePropertyManagementDivision.PreparedbyBudgetandFiscalServicesPage1June2018
WASHINGTONSTATEPATROLTrainingAcademyUserRateStudyBeginningFiscalYear2020.Costsweredividedintoelevencostpoolsforanalysis:oInstructionoRoomandBoardoGroundsandClassroomsoVehiclesoDriveCourseoFiringRangeoTrainingTankoFirearmsSimulatoroGymoDrivingSimulatoroMotorcycles.Dataforanalyzingandallocatingthecostswasderivedfromvarioussources.Activityusewascalculatedforeachcostpoolbyusingactualbiennialusestatisticsforthe2015-17Biennium,orinsomecasesbyusingavailabilityofanasset.Actualfinancialdatawasobtainedfromthestate'sAgencyFinancialReportingSystem(AFRS)forthe2015-17Biennium..Thecalculatedratesarebasedonlyonthosecostsdirectlyassociatedwithfacilityuse.NoadministrativecostsfortheTrainingAcademyareincluded..TheFiringRangerateincludesthecostoftheclassroomsincetheclassroomisunavailableforotherusewhentheFiringRangeisbeingused..TheDriveCourserateincludesthedailycostofaninstructorwhichisconsistentwithpriorratestudies..TheDrivingSimulatorincludesaninstructorwhentheSimulatorisbeingused.TheSimulatormaybeusedoff-site..Duetolowusageduring2015-17,theFirearmsSimulatorratefromthepriortworatestudiesiscarriedforward.Inaddition,thedrivingsimulatorwasnotoperableforaconsiderableamountoftimeduring2015-17,whichreducedtheusageduring2015-17,soitsratefromthepriorratestudyisalsocarriedforward.Asisthecaseineveryratestudy,thecalculatedratesarebasedontheuniquemixoftrainingactivitiesthatoccurredspecificallyinthe2015-17Bienniumandtheirassociatedcosts.Theresultingratesmaybehigherorlower,butareclearlylinkedtothespecificcostsexperiencedinthosetwoyears.Attachmentstothisdocumentaredescribedonpage5anddisplaythecalculationsmadeinthestudy.AttachmentsDandEcomprisebillingsheetstobeusedbyTrainingAcademystaffincalculatingthetotaldirectandindirectcostschargedtoauserofTrainingAcademyspaceorprograms.PreparedbyBudgetandFiscalServicesPage2June2018
WASHINGTONSTATEPATROLTrainingAcademyUserRateStudyBeginningFiscalYear2020ConclusionsandRecommendations1.Basedonthecomputationofrates(seeAttachmentB),thestudyresultsrecommendthefollowingrates.WerecommendtheybeimplementedJuly1,2019:RatePerUnitDormitory$37.00PerroompernightInstructor$791.00PertrainingdayInstructor$99.00PertraininghourVehicle$255.00PervehicleperdayClassroom$319.00PertrainingdayTrainingTank$106.00PertrainingdayFiringRange(includesClassroom)$357.00PertrainingdayFirearmsSimulator$600.00PertrainingdayDriveCourse(includesInstructor)$840.00PerdayMeals$8.00PermealSaladBar$5.00PermealDrinksonly(ifnomeallsaladbar$2.00Perdaypurchasedduringtheday)Gym$177.00PertrainingdayDrivingSimulator(includesInstructor)$244.00PerhourMotorcycle$44.00Pertrainingday2.Forotheragenciesthatusethefacilityoutsideofnormalbusinesshours(weekends,nightdriving,etc.),werecommendthatadutysafetyofficerbechargedattheovertimerate.3.TheAcademyperiodicallywillallowusageofitsdrivecourseforevents,suchasfilming.Wehavechargedaflatfeeof$1,500forthisusagewiththechargebeingbroughtinasrevenuetothestateratherthanarecoveryofexpendituretotheagency.Weintendtocontinuetodoso;howeveranyassociatedactualcostsincurredbytheAcademywillbebilledinadditiontothisfee.PreparedbyBudgetandFiscalServicesPage3June2018
WASHINGTONSTATEPATROLTrainingAcademyUserRateStudyBeginningFiscalYear2020SIGNATUREPAGEThefeeswillbeimplementedasoutlinedonAttachmentsDandEoftheratestudy.Thefeeswillbeimplementedwiththemodificationsproposedbelow,subjecttoBFSapproval:EffectiveDateJuly1,2019DivisionCommanderAy°l4Hÿ54EedDateBureauDirector.//9DatePreparedbyBudgetandFiscalServicesPage4June2018
WASHINGTONSTATEPATROLTrainingAcademyUserRateStudyBeginningFiscalYear2020ATTACHMENTSAttachmentAScheduleofCostsEachCostPoolisdisplayedinaseparatecolumn.Eachrowisanexpenditurebysub-object.AttachmentBComputationofRatesEachcolumnisaseparatecostpool.Rowsdisplayadjustments,basisanddirectcost,indirectcostandtotalcostforeachCostPool.AttachmentCFootnotesFootnotescontainexplanationsofallocationsandcosts.AttachmentDWorksheetforBillingNon-StateOrganizationsTobeusedtopreparebillingstonon-stateorganizations.AttachmentEWorksheetforBillingStateAgenciesTobeusedtopreparebillingstostateagencies.PreparedbyBudgetandFiscalServicesPage5June2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
TRAINING D1V1SION
Data from 2013-15 Biennium
ATTACHMENT A -SCHEDULE OF COSTS
COST POOLS
EXPEND1TURES ADMIN INSTRUCTION ROOM/GROUNDS/VEHICLE DRIVE FIRING FlRE ARMS TRAIN1NG GYM DRIVING UNALLOCATED FOOT
13-15 BOARD CLASS COURSE RANGE SIMULATOR TANK SIMULATOR NOTES
DESCRIPTION OF ALLOCATIONS
NO OF VEHICLEs 83 31 ---51 -----1 -(1)
SQ FOOTAGE (Shown by area)62,530 11,641 600 24,066 8,434 2,565 -1,020 844 4,912 _8,198 250 -(2)
SQ FOOTAGE (Shown by %)18.62%1%38.49%13.49%4.10%0%1.63%1.35%7.86%13.11%0.40%0.00%
FTE STAFF:
Academy 33.53 7.36 16.35 7.18 1.97 0.08 0.09 0.03 0.03 0.16 0.26 0.01 0.01 (3)
Other 3.6 -2.89 --0.71 -------(3)
Totat FTES 37.13 7.36 19.24 |7.18 1.97 |0.79 0.09 0.03 0.03 0.16 0.26 0.01 0.01
SALARIES AND WAGES:
PI 320,ACADEMY
AA Classlfled 948,880 173,073 100,585 462,655 167,187 5,300 7,882 2,108 1,744 10,150 16,940 517 739 (4)
AG Commissioned 2,952,741 843,403 2,109,338 ----------(5)
AS -Sick Leave Buy-Out 32,090 9,166 22,924 ----------(6)
AT-TerminalLeave 32,269 8,427 18,395 3,732 1,349 43 64 17 14 82 137 4 6 (7)
AU Overtime &Cal1-Back 121,162 31,641 69,070 14,013 5,064 161 239 64 53 307 513 16 22 (8)
TOTAL Salaries &Wages,Academy 4,087,142 1,065,709 2,320,313 480,400 173,600 5,504 8,184 2,189 1,811 10,539 17,590 536 767
OTHER SECTIONS
AA Classifed 65,304 ----65,304 -------(9)
AG Commissioned 438,727 -438,727 ----------(10)
AS -Sick Leave Buy-Out
AT -Terminal Leave
AU Overtime &Call-Back 2,429 -2,429 ----------(11)
TOTAL Salaries &Wages,other sections 506,460 -441,156 --65,304
EMPLOYEE BENEFITS
Pl 320,Academy:
BASocialSecurity/OASI 57,014 10,518 6,182 27,540 10,181 297 484 118 98 569 950 29 47 (12)
BB Retirement &Pensions 335,870 86,670 186,570 42,796 15,661 485 740 193 160 929 1,550 47 70 (12)
BC Disability Insurance/Med Aid +Ind los 99,527 18,150 48,892 23,575 6,634 274 302 109 90 525 876 27 72 (12)
BD Health Insurance 546,321 121,231 262,164 116,722 34,746 1,424 1,582 566 469 2,727 4,551 139 -(12)
BH Medicare 56,954 15,041 32,485 6,441 2,381 70 113 28 23 133 222 7 11 (12)
TOTAL BENEFITS,Academy 1,095,686 251,611 536,293 217,075 69,603 2,550 3,222 1,014 839 4,883 8,150 249 200
I
OTHER SECT10NS
BA Social security 3,904 ----3,904 -------(12)
BB Retirement &Pensions 41,300 -37,209 --4,091 -------(12)
BC Disability Insurance/Med Aid +[nd 1ns 11,395 -9,864 --1,531 -------(12)
BD Health insurance 60,026 -51,167 --8,859 -------(12)
BH Medicare 7,123 -6.506 --618 -------(12)
TOTAL BENEFITS,Other Sectlons 123,749 -104,746 --19,003
CJ Employee Training Services 29,839 29,839 -(13)
GOODS &SERVICES
EA Supplies
-Not Specified
1000 -Gen Supp1\es &Materlats 103,996 22,836 50,713 22,264 6,104 254 277 101 84 486 811 25 41 (14)
2000 -Public Record DOC Recoveries -57 -57 (17)
3000 -Uniforns 15,906 3,493 7,756 3,405 934 39 42 15 13 74 124 4 6 (14)
4000 -Janitor/Lndry/Yrd Splys 30,022 |30,022 -(15)
Prepared by Budget and Fiscal Services Page 6 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
5000 -Food-Academy 216,389 216,389 -(16)
5001 -Meal Charges-Academy -64,658
-64,658 (17)
9000-sottledwater 15,109 3,318 7,368 3,235 887 37 40 15 12 71 118 4 6 (14)
9001 -Portable Restroom services 11,705 8,778 2,926 -(18)
EB communications 26,062 5,723 12,709 5,580 1,530 64 70 25 21 122 203 6 10 (14)
Ec Utilities 317,435 58,433 3,012 126,667 42,335 12,875 -5,120 4,237 24,656 41,151 1,255 -2,306 (17)(19)
ED -Rentals and Leases
-Not Specified -15 -15 (17)
1000 -Bldg/Room Rentals 3,900 3,900 -(20)
1001 -Prop Lease/Com Site Lease/Dorm costs -84,293
-84,293 (17)
1002 -Train Academy Classroom Costs -18,135
-18,135 (17)
1003 -Train Academy Tank -375 -375 (17)
1004 -Train Academy Firing Range -(17)
1007 -Train Academy Gymnasium -886 -886 (17)
EE Repairs 108,601 18,505 954 38,257 13,407 4,077 -1,621 1,342 7,808 13,032 9,597 -(21)
EF Printlnq 845 845 -(22)
EG Education 40,314 40,314 -(22)
EH Rental &Leases -Fum &Equipment 13,520 2,969 6,593 2,895 794 33 36 13 11 63 105 3 5 (23)
EJ Subscriptons 70 70 -(22)
EK Facllities and Services 665 665 -(24)
EN Personnel services 810 148 86 395 143 5 7 2 1 9 14 0 1 (25)
ER Purchased Services
-Not Specified 40,169 40,169 -(26)
1200 -Software-1T Portfolio-Purchase Services
2000 -Laundry 19,656 19,656 -(27)
3000 -Janitor Yard Windows srva 779 779 -(26)
6000 -Inter-Agency Agreements -
-(26)
ES Veh Maint -Fuel/Repairs
1000 -Veh/Aircraft Fuel Oil --(28)
2000 -Repairs-Tires/Parts/Splys 2,700 2,700.24 -(28)
2003 -Train Academy Vehicle costs 106,453 106,452.72 -(28)
2004 -Train Academy Pitt cars -17 -17 (17)
3000 -Drive course usage -5,431 -5,431 (17)
EY Software Licenses and Maintenance 17,698 17,698 -(26)
EZ Other Goods and services 4,290 4,290 -(26)
ES Veh Maint -paid by fleet
1000-veh/AircraftFueloli 246,809 92,182 ---151,654 -----2.974 -(29)
2000-Repairs-Tires/Parts/Sp1vs 206,464 77,113 ---126,864 ----|-2,488 -(29)
ToTALGoods&selvices 1,376,499 348,321 134,318 468,765 66,133 405,054 9,251 9,839 5,720 33,289 Í 55,559 16,355 -176,105
TRAVEL:
GAln-StateTravel 30,681 8,012 17,490 3,548 1,282 41 60 16 13 78 130 4 6 (30)
GC Private Automobile Mileage 1,254 327 715 145 52 2 2 1 1 3 5 0 0 (30)
GD -Other Travel Expenses
-Not Specified 2,877 751 1,640 333 120 4 6 2 1 7 12 0 1 (30)
2000-Move/Reloc-commissioned 3,9461,031 2,250456 165 5 8 2 2 1017 1 1(30)
3000 -Tacoma Narrows Bridge Toll -----------(30)
GF-Out-Of-StateSubsistence&Lodq1nq 7,619 1,990 4,343 881 318 10 15 4 3 19 32 1 1 (30)
GG-Out-Of-StateAirTransportation 8,103 2,116 4,619 937 339 11 16 4 4 21 34 1 1 (30)
ToTALTravel 54,479 14,227 31,056 6.301 2,277 72 107 29 24 138 231 7 10
JA -Non-capitalized Equipment
1000 -Smail/Attractive Tagged 4,747
1300 -Hardware-IT Portfolio Not Taqqed 1,466 1,466 -(31)
1301 -Hardware-lT Portfolio Taqqed --(31)
2000 -Non-inventorlable-No Tag 27,173 27,173 -(31)
3000 -cell Phone Equipment 30 30 -(31)
JB Non-capitalized Software 216 216 -(31)
JC -Fumishings &Equipment
-Not Specified 19,530 19,530 (g)
Prepared by Budget and Fiscal Services Page 7 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
3000 -Vehicles -(32)
JH -1mprovements Other Than Buildings 90,438 90,438 (32)
TOTALCapitaloutlays 143,600 28,885 ---109,968
DEBT SERVICE
PD -Pducipa1-COP Lease/Purch Agreements 62,495 62,495 (32)
PE -Interest-COP Lease/Purch Agreements 11,365 11,365 (32)
TOTALDebtservice 73,860 ---73,860
INTERAGENCY REIMBURSEMENTS
SA -salaries and Waqes -220,929 -220,929 (33)
SB -Employee Benefits -39,048 -39,048 (33)
SE -Goods and Services -343,836 -343,836 (33)
SG -Travel -(33)
TOTAL 1nteragency Reimbursements -603,812
--
-603,812
INTRA-AGENCY REIMBURSEMENT
TA Salades &Wages -not specified
1000 -ind1rect Rate charge 171,366 171,366 (33)
2000 -Indirect Rate Distributions -283,200 -283,200 (33)
TOTALObiectT -111,834
---
-111,834
TOTAL COSTS BEFORE ADJUSTMENT 6,775,667 1,708,753 3,597,721 1,172,540 311,612 497,486 20,764 13,070 8,394 48,850 81,529 17,147 -706,946
ADJUSTMENTS
REMOVE OBJECT E REIMBURSEMENTs 176,105 176.105 (34)
REMOVEOBJECTS 603,812 603,812 (33)
REMOVEOBJECTT 111,834 111,834 (33)
|
TOTALAdjustedcosts 7,667,418 |1,708,753 3,597,721 1,172,540 |311,612 |497,486 |20,764 13,070 8,394 48,850 81,529 17,147 184,805 |
Prepared by Budget and Fiscal Services Page 8 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
TRAIN1NG DIVlSION
Rates Starting July 1,2017
ATTACHMENT B -COMPUTATION OF RATES UPDATED INDIRECT
COST POOLS
FOO
EXPEN-FIRE ARMS ORIV1NG T
D1TURES INSTRUC-ROOM/GROUNDSI DRlVE FIR]NG SIMU-TRAINING SIMULATO NOT
11-13 ADMIN TION BOARD CLASS VEHICLE COURSE RANGE LATOR TANK GYM R ES
TOTAL ADJUSTED COSTS 7,667,418 1,708,753 3,597,721 1,172,540 311,612 497,486 20,764 13,070 8,394 48,850 81,529 17.147
SUPPORT COSTS ADJUSTMENTS 29.90%
AGENCYlNDIRECTRATE 2,235.882 510,917 1,075,719 350,589 93,172 148,748 6,209 3,908 2,510 14,606 24,377 5.127 (35)
TOTAL COSTS 9,903,300 2,219,670 4,673,440 1,523,129 404,784 646,234 26,973 16,978 10,903 63,456 105.906 22.274
APPORTION ROOM &BOARD
Subsistence (Meals)554,854 (36)
Room (Lodging)968,275 (36)
RATE COMPUTAT10NS:
ACADEMYADM1NlSTRATION 2,219,670
ACADEMY SECTION ADMIN1STRATlON RATE 0.00%
DISTRIBUTION OF ACADEMY SECTION ADMINISTRATION RATE -(37)
TOTAL COSTS WlTHOUT ADM1N1STRATIVE RATE 4,673,440 1,523,129 404.784 646,234 26,973 16,978 10,903 63,456 105,906 __22,2¶
Subsistence (Meals)554,854
Room (Lodging)968,275
NUMBER OF MEALS 72.070 ___(38)
COST PER MEAL 5 7.70 I
Indirect rate potiion of meal cosl S 1.77
I Direct cost per meal 5 5.93
TOTAL STUDENT RES1DENT DAYS 23.000 __(38)
!COST PER STUDENT RESIDENT DAY |5 42.10
lndirect rate portlon of student resident day .S 9.69
Dlrect cost per student resident day S 32.41
TOTAL STUDENT TRAINING DAYS 39,530 39,530 (38)
COST PER STUDENT TRAINlNG DAY S 118.23 5 10.24
COST PER ClASSROOM PER DAY (Avp 30 students)S 307.20
Indirect cost porllon Student Training day/Classroom per day 5 27.21 5 70.71
Direct cost per student trainlnq day/classroom per day 5 91.01 5 236.49
TOTAL 1NSTRUCTORTRAINING DAYS 6,640 (39)
COST PER INSTRUCTOR TRAINING DAY 5 703.81
indirect rate port1an of cost per instructor training day 5 162.00
Direct cost per Instructor tra1n1nq day $541.81
I I
Prepared by Budget and Fiscal Services Page 9 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
TOTAL AUTO TRAINlNG VEH1CLE DAYS 3,170 (38)
COST PER AUTO TRA1NING VEHICLE DAY 5 203.86
Indirect cost portion of cost of aula trainInq vehlcle day S 46.92
Direct cost per auto lralning vehicle day S 156.94
TOTAL PlT CAR USE DAYS (38)
COST PER PIT CAR USE (8 Cars)
Indirect cost portlon of pil car use
Direct cost per pll car use (B cars)
TOTAL DRIVE COURSE DAYS 521 (38)
COST PER DRIVE COURSE PER DAY 5 51.77
Indirecl cost portlon of drive course use
S 11.92
Direel cost per drive course per day
S 39.86
TOTAL F1RING RANGE DAYS 312 (38)
COST PER FIRING RANGE PER DAY
S 54.42
Indirect cosl portlon of firing range per day 5 12.53
Direct cost per firing range per day 5 41.89
TOTALF1REARMSTRAININGSIMULATORTRAININGHOURS 22 (38)
COST PER FlRE ARMS TRA1NING SIMULATOR PER DAY
S 3,964.81
Indirect cost per dre arrns tralning slmulator per day 5 912.61
Direct cost per fire arms tralning simulator per day
S 3,052.20
TOTAL TRAINING TANK DAYS 502 (40)
COST PER TRAINING TANK PER DAY 5 126.41
Indirect cost portlon of tralning tank use 5 29.10
Direct cost per trainlnq lank day 5 97.31
TOTAL GYM TRA1N1NG DAYS 502 (40)
COST PER GYM PER DAY 5 210.97
Indirect cost per gym per day 5 48.56
Direct cost per gym per day 5 162.41
TOTAL DRIVING SIMULATOR TRAINING HOURS 143 (38)
COST PER DR1VlNG SIMULATOR PER HOUR ___S 155.77
Indirect cost per drivlnq simulator per hour 5 35.85
Direct cost per driving simulalor per hour
S 119.91
Prepared by Budget and Fiscal Services Page 10 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
TRAINING DIVISION
ATTACHMENT C -FOOTNOTES
Note:Source for costs:Enterprise Reporting System 2013-2015 Biennium
(1)Vehicle data based on following information:
Drive Firearms Driving
Room/Cours Firing Simulato Training Simulato
Total Admin Instruction Board Grounds/Class Vehicle e Range r Tank Gym r
Van 2 2
Drive Course 43 43
Pit Cars 8 8
Pickup 3 2 1
Dump truck i 1
tractor 3 3
Assigned 23 23
TOTAL 83 31 ---51 -----1
(2)Square footage of buildings
Drive Firearms Driving
Room/Cours Firing Simulato Training Simulato
Description Total Admin Instruction Board Grounds/Class Vehicle e Range r Tank Gym r
"A"Administration 7,343 7,343
"B"Classroom 5,798 5,798
"C"Dorm 6,195 6,195
"D"Dorm 6,195 6,195
"E"Dorm 5,784 5,784
"F"Kitchen 5,722 5,722
"G"Service Station 180 180
Firing Range Classroom 1,020 1,020
Mobile Classroom K-9 2,496
Prepared by Budget and Fiscal Services Page 11 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
2,496
Carpenter Shop 1,500 1,500
Multi-Purpose Building 16,970 2,416 600 -844 4,912 8,198
Vehicle Shop 2,385 2,385
Driving Simulator 250 250
Radio Equip 332 332
Subtotal 62,170 11,591 600 23,896 8,294 2,565 -1,020 844 4,912 8,198 250
Well House 360 50 170 140 -
TOTAL .62,530 11,641 600 24,066 8,434 2,565 -1,020 844 4,912 8,198 250
(3)FTE is allocated based on the Salary schedule worksheet (HRMS 7/2013-6/2015)
FTE are assigned to cost pools as follows:
Captain and Lieutenant are 100%Administration.Sergeants are 90%Administration,10%Instruction.
Trooper Instructors are 100%Instruction.Clerical Personnel are 60%Administration,40%Instruction.
Cooks and Food Manager are 100%Room/Board.Custodians and Plant Mechanic are allocated by square footage (see footnote 2).
Groundskeeping Personnel are 95%Grounds/Class,5%Drive Course.Auto Mechanic is allocated to Vehicles.
(4)AA (State Classified)for Academy personnel is allocated by calculated percentage of Academy classified staff from salary
schedule worksheet.Administration:18.24%,Instruction:10.6%;Room/Board 48.76%;Grounds/Class:17.62%;Vehicles:0.56%;
Drive Course:0.83%;Firing Range:0.22%;Firearms Simulator:0.18%,Training Tank:1.07%,Gym:1.79%;Driving Simulator:0.05%.
(5)AG (Commissioned)is allocated by calculated percentage of Aòademy commissioned staff from salary schedule worksheet.
Administration:28.56%,Instruction:71.44%.
(6)AS (sick leave buy-out commissioned personnel)is allocated by calculated percentage of Academy
commissioned staff from salary schedule worksheet.
(7)AT (Terminal Leave)is allocated by calculated percentage of all Academy staff from salary schedule worksheet.
Administration:26.11%,Instruction:57.01%,Room/Board:11.57%,Grounds/Class:4.18%,Vehicles:0.13%,Drive Course:0.2%,
Firing Range:0.05%,Firearms Simulator:0.04%,Training Tank:0.25%,Gym 0.42%,Driving Simulator 0.01%.(Combined Classified and Commissioned Staff)
(8)AU (Overtime &Call-Back)is allocated by calculated percentage of all Academy staff from salary schedule worksheet.
(See footnote 7).
Prepared by Budget and Fiscal Services-Page 12 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
(9)AA (State Classified)for Non-Academy personnel is allocated to Vehicles.
(10)AG (Commissioned)for Non-Academy personnel is allocated to Instruction.
(11)AU (Overtime &Call-Back)is allocated by calculated percentage of all Non-Academy staff from salary schedule worksheet.
(12)Benefits for personnel are allocated by percentages from benefit schedule worksheet.
(13)Employee Training-training personal services allocated to instruction.
(14)Allocated based on number of FTEs.
(15)EA 4000 Janitorial/Laundry allocated to Room/Board.
(16)Food allocated to room/board.
(17).Reimbursement -Not Allocated
(18)Portable restroom located at drive course-3 &firing range-1.
(19)Utility costs are distributed based on square footage (except Comcast)
Drive Driving
Instructio Room/Grounds/Clas Cours Firing Firearms Training Simulato
TOTAL Admin n Board s Vehicles e Range Sirnulator Tank Gyrn __r
"A"Administration 11.74%11.74%
"B"Classroom 9.27%9.27%
"C"Dorm 9.91%9.91%
"D"Dorm 9.91%9.91%
"E"Dorm 9.25%9.25%
"F"Kitchen 9.15%9.15%
"G"Service Station 0.29%0.29%
Firing Range Classroom 1.63%.1.63%
Mobile Classroom K-9 3.99%3.99%
Carpenter Shop 2.40%2.40%
Multi-Purpose Building 27.14%3.86%0.96%0.00%1.35%7.86%13.11%
Vehicle Shop 3.81%3.81%
Prepared by Budget and Fiscal Services Page 13 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
Drivinq Simulator 0.40%0.40%
Radio Equip 0.53%0.53%
Well House 0.58%0.08%0.27%0.22%0.00%
TOTAL 100.00%18.62%0.96%38.49%13.49%4.10%0.00%1.63%1.35%7.86%13.11%0.40%
ACME Fuel 93.55 17.42 0.90 36.00 12.62 3.84 -1.53 1.26 7.35 12.26 0.37
Cascade Natural Gas 77,816.68 14,486.87 746.68 29,949.40 10,495.86 3,192.06 -1,269.36 1,050.33 6,112.83 10,202.16 311.12
Comcast (cable)5,865.87 5,865.87
Mason Co PUD #3 95,828.37 17,840.05 919.51 36,881.59 12,925.26 3,930.91 -1,563.17 1,293.45 7,527.73 12,563.59 383.13
City of Shelton 124,005.93 23,085.77 1,189.89 47,726.32 16,725.83 5,086.76 -2,022.81 1,673.77 9,741.20 16,257.81 495.79
Port of Shelton 4,560.88 849.08 43.76 1,755.35 615.17 187.09 -74.40 61.56 358.28 597.95 18.23
Waste Connections Inc 11,569.93 2,153.93 111.02 4,452.93 1,560.54 474.60 -188.73 156.17 908.87 1,516.88 46.26
TOTAL 319,741.21 58,433.12 3,011.76 126,667.47 42,335.2T 12,875.26 -5,119.99 4,236.54 24,656.26 41,150.65 1,254.90
(20)Rentals and Leases allocated for Instruction for inactive runway rental
(21)Repairs allocated on basis of square footage (except $9,200 for driving simulator maintenance)
Administration:18.62%,instruction:0.96%,Room/Board:38.49%,Grounds/Class:13.49%,Vehicles:4.03%,PlT Cars:0.07%,Firing Range:1.63%,
Firearms Simulator 1.35%,Training Tank 7.86%,Gym:13.11%,Driving Simulator:0.4%.
(22)Printing,professional education,and subscriptions allocated 100%to instruction cost pool
(23)Rental &Lease equipment allocated based on number of FTEs.
(24)Facilities and Services allocated to Administration for annual admin fee.
(25)Personnel Services allocated on basis of academy classified employees salaries percentage from salary schedule worksheet.
Administration:18.24%,Instruction:10.6%;Room/Board 48.76%;Grounds/Class:17.62%;Vehicles:0.55%;
PIT Cars:0.01%;Drive Course:0.83%;Firing Range:0.22%;Firearms Simulator:0.18%,Traininq Tank:1.07%.
Gym:1.79%;Driving Simulator:0.05%.
(26)Purchased Services,Janitorial,Inter-Agency Agreements,Software Licenses &Maintenance and Other Goods &Services allocated to Admin
(27)Laundry costs allocated to room/board
Prepared by Budget and Fiscal Services Page 14 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
(28)Vehicle costs allocated to Vehicles
(29)Vehicle costs from fleet (data provided by Erica Soha,6/13/2016),allocated by percentage of vehicles
(30)Travel costs allocated by all academy salary expenditures.
(31)Equipment and software purchases/improvem_ents allocated to academy administration.
(32)Capitalized equipment,improvements and financing is not included in the study.
(33)Object S and T are removed from the budgeted costs in order to reflect true costs of providing services.
(34)Object E expenditure recoveries are removed from the budgeted costs in order to reflect true costs of providing services.
Agency indirect cost rate for
(35)7/1/16 is 29.90%of all costs.
Indirect rate:29.90%
(36)Room and board costs apportioned according to per diem ratios from OFM travel regulations
Amount Percentage
Meals 51 36.43%
Lodging 89 63.57%
Total 140 100.00%
(37)Historically,academy administration costs are not charged to facility users
(38)Usage according to Academy's facility usage statistics for 13-15 biennium
(39)Total instructor days according to the following calculation...
TOTAL FTE INSTRUCTORS *17.76 **Based on 13-15 staffing levels
multiplied by the average #of on-duty hours per year ++1662 ++Standard from PAM model
total paid hours in a year
TOTAL AVAILABLE INSTRUCTOR HOURS 29513.24
TOTAL AVAILABLE INSTRUCTOR DAYS 3689
%ESTIMATED TIME SPENT INSTRUCTING 90%
INSTRUCTOR DAYS PER YEAR 3320.1
._(40)Usage is days Training Tank and Gym are available for use
Prepared by Budget and Fiscal Services Page 15 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
Attachment D
Worksheet for Billing Non-State Organizations
CLASS:DATE:
Rate Nights in Dorm Dorm Costs BrAecackdow for
1.Dorm Costs $32 $081-030-00320-ED-1001
(per room/night)S 10 X X =5 -
S
-081-030-00343-TA-1000
5 42 5 -Total
Rate Days of Class Instruction Cost
$542 D81-030-00320-AG-1001
2a.Instruction Costs (per
instructorday)5 162 X X =$-
S 081-030-00320-BD-1DO1
$704 5 -081-030-00343-TA-1000
Total
Rate e Hours of Class Instruction Cost
$68 081-030-00320-AG-1001
$20 X X =5 -S -081-030-00320-BD-1001
2b.Instruction Costs (per
instructor hour)4 88 $081-030-00343-TA-10DO
Total
Rate Vehicle Days Vehicle Costs
5 157 081-030-00357-ES-2003
3.Vehicle Costs (pervehicle
day)$47 X 081-030-00343-TA-1000
5 204 $-Total
Rate e Days of Class Classroom Cost
S 236 $-081-030-00320-ED-1002
4.Classroom Costs (per
training day)5 71 X X 081-030-00343-TA-1000
$307 8 Total
Rate Days of Class Training Tank Cost
5 97 5 -081-030-00320-ED-1003
5.Training Tank (per training
day)$29 X OBi-030-0D343-TA-1000
$126 $Total
Prepared by Budget and Fiscal Services Page 16 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
Rate Days of Class Firing Range Cost
5 279
$-081-030-00320-ED-10026.Firing Range (includes
S 83
S -
S
classroom)X =081-030-00320-ED-1004
$362
$-081-030-00343-TA-1000
Tota1
Rate Days of Class SLe sr
3 478
$-081-030-00320-ED-10027.Fire arms Simulator
(¡ncludes classroom)S 122
$-$081-030-00320-ED-1005
$600
$081-030-00343-TA-1000
Total
Rate Days on Course Field Costs
5 582
S 081-030-00320-AG-1001Ba.Drive Course (includes
instructor)$174 ..5 -
S 081-030-00320-BD-1001
$756
$-081-030-00320-ES-3000
081-030-00343-TA-1000
Total
Rate Days on Course Field Costs
081-04-99Sb.Drive course usage (e.g"$1,500
S -
S
filming)X =Total
Rate Days of class Gym Costs
5 162
5 081-030-00320-ED-10079.Gymnasium (per training
day)5 49
..$--$081-030-00343-TA-1000
$211
$Total
Rate Number of Hours Driving S ulator
S 188
$081-030-00320-ED-100610.Driving Simulator (per hour
includes instructor $56
$-$-081-030-00320-AG-1001
5 244
5 081-030-00320-BD-1001
081-030-00343-TA-1000
Total
Prepared by Budget and Fiscal Services Page 17 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
Rate Number of Meals Meal Costs
$6.2D $081-030-00320-EA-5001
11a.Meal costs (per
meal)$1.80 5 -S 081-030-00343-TA-1000
$8.00 S Total
Rate Number of Meals Meal Costs
S 4.00 $081-030-00320-EA-5001
11b.Salad Bar (per
meal)S 1.00 $-S 081-030-00343-TA-10DO
$5.00 $-Total
Rate NSt dbeenr Numberof Days Surcharge Costs
12.Surcharge 5 5.97 5 -S -081-04-20-SURCHG
$-081-030-00320-AG-1001
TOTAL COST FOR CLASS S -081-030-00320-BD-1001
Number of Students (Add 1 +2 +3 +4 +5 +6 +7 +8 +9 +10 +11 +12)081-030-00357-ES-2003
081-030-00320-ED-1001
081-030-00320-ED-1002
081-030-00320-ED-1003
TOTAL COST PER STUDENT 081-030-00320-ED-1004
(DMde Class Cost by Students)081-030-00320-ED-1005
081-030-00320-ED-1006
081-030-00320-ED-1007
081-030-00320-ES-3000
081-030-00320-EA-5001
081-030-00343-TA-1000
081-04-20-SURCHG
081-04-99
Total
Prepared by Budget and Fiscal Services Page 18 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
Attachment E
Worksheet for Billing State Agencies
||
CLASS:
DATE:
Rate Nights in Dorm Dorm Costs Breackdon in for
1.Dorm Costs S 32
$-081-030-00320-SE(perroom/night)S 10 X X =5 -$-081-030-00343-TA-1000
$42
$Total
Rate ce
Days of Class Instruction Cost
$542
081-030-00320-SA2a.Instruction Costs (per
instructor day)S 162 X X -
S -$-081-030-00320-SB
S 704
$-081-030-00343-TA-1000
Total
Rate ce
Hours of Class Instruction Cost
$68
081-030-00320-SA
5 20 X X -
5 -$081-030-00320-SB2b.Instruction Costs (per
instructor hour)$88
$081-030-DO343-TA-1000
Total
Rate Vehicle Days Vehicle Costs
5 157
081-030-00357-SE3.Vehicle Costs (per vehicle
day)$47 X =081-030-00343-TA-1000$204
$Total
Rate u e
Days of Class Classroom Cost
$236
$081-030-00320-SE4.Classroom Costs (per
training day)3 71 X X 081-030-00343-TA-1000
S 307
5 -Total
Rate .Days of Class Training Tank Cost
5 97
S -081-030-00320-SE5.Training Tank (per training
day)$29
$-
S 081-030-00343-TA-1000
$126
$-TotalRateDaysofClassFiringRangeCost
Prepared by Budget and Fiscal Services Page 19 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
$279 s 081-030-00320-SE
6.Firing Range (includes
classroom)S 83 X =S
-5 081-030-00343-TA-1000
$362 $Total
Rate Days of Class e sr
$478 5 081-030-00320-SE
7.Fire arms Simulator
(includes classroom)X =2 ¯081-030-00343-TA-1000
$600 $Total
Rate Days on Course Field Costs
$582 $081-030-00320-SA
Ba.Drive Course (includes
instructor)$174 X -081-030-00320-SB
5 756 $-081-030-00320-SE
081-030-00343-TA-1000
Total
Rate Days on Course Field Costs
081-04-99
Bb.Drive course usage (e.g.'
$1,500 $-5
filming)X -Total
Rate DaysofClass GymCosh
$162 S 081-030-00320-SE
9.Gymnasium (per training
day)5 49 X 081-030-00343-TA-1000
$211 5 Total
Rate Number of Hours Driving Simulator
S 188 5 -081-030-00320-SE
10.Driving Simulator (per hour
includes instructor $56 y ..5 -$081-030-00320-SA
$244 5 -081-030-00320-SB
081-030-00343-TA-1000
Total
Prepared by Budget and Fiscal Services Page 20 May 2018
WASHINGTONSTATE PATROL
Training Academy User Rate Study
Beginning Fiscal Year 2020
Rate Number of Meals Meal Costs
5 6.20
$081-030-00320-SE11a.Meal Costs (per
meal)5 1.80
..5 -
S
-081-030-00343-TA-1000
$8.00
$Total
Rate Numberof Meals Meal Costs
5 4.0D
$081-030-00320-SEiib.Salad Bar (per
meal)$1.00 X S -5 081-030-00343-TA-1000
$5.00
$-Total
Rate Number of Days surcharge costs
12.Surcharge $5.97
5 -$-081-04-20-SURCHG
TOTAL COST FOR CLASS
$-081-030-00320-SANumberofStudents(Add 1 +2+3 +4+5+6+7+8 +9 +10 +11 +12)5 -081-030-00320-SB
081-030-00320-SE
081-030-DO357-SE
081-030-00343-TA-1000
TOTAL COST PER STUDENT 081-04-20-SURCHG
(DMde Class Cost by Students)
S
-081.04-99
Total
Prepared by Budget and Fiscal Services Page 21 May 2018