Skip to main content
Wednesday, May 16, 2012

SORM 200 Part I User Instructions

SORM 200

Risk Management Expenditures

  • Users must have security access to enter SORM 200 data. Your agency's risk manager can initiate the process for access approval.

  • Screens for Part I and Part II will be available for entry on the first business day of each fiscal year and will be closed 60 days after the close of the fiscal year.

  • Only one point of contact should review and enter final data. Enter expenditures for applicable categories. If there are no expenditures for the fiscal year, enter $0. Once data is submitted, a confirmation message will be displayed. Data can be updated as many times as necessary but final figures must be entered by closing date. Any corrections and/or additions after the closing date must be submitted in writing to SORM.

  1. Instructions for calculating Expenditures for Category F - Wages & Salary

    Job duties of all staff involved in risk management activities should be reviewed to determine the percentage of time spent only on risk management activities. If the amount of time spent is less than 100%, calculate the prorated amount by dividing the number of hours worked by the total number of hours per year (2000 hours).

  2. Calculate the % of time spent on risk management activities by dividing the number of hours spent per year by total number of working hours per year:

    2000 hours = total # of hours worked per year

    Example: Agency XY has four staff members involved in risk management activities. Each staff member is determined to work a number of hours per year in those activities as shown below.

    Staff# of Hours spent in RM Activities/yearCalculation% of Time Spent
    Risk Manager1000 hours1000/200050%
    Safety Officer300 hours300/200015%
    Tech Writer20 hours20/20001%
    Additional Safety Officer (ADSO)200 hours200/200010%

    Calculate the total amount of expenditures for Category F by multiplying the annual salary by the % of time spent for each staff member.

    StaffAnnual Salary% of TimeExpenditure
    Risk Manager$43,56050%$21,780.00
    Safety Officer$37,72815%$5,659.20
    Tech Writer$32,6641%$326.64
    Additional Safety Officer (ADSO)$35,30410%$3,530.40
    Total Expenditures: 76%$31,296.24

    Total Category F Expenditure: $31,296.24

    Calculate the total number of FTE's involved in risk management activities by adding the total % of time spent and converting the % to a decimal value and rounding up to whole number. Less than one full FTE is acceptable.

    Total FTEs    .76  =  .8 FTEs


  3. Instructions for calculating expenditures for Category G - Benefits (self-populated by the RMIS System)

    Using the same annual salaries shown above, the RMIS System will populate the benefits associated with risk management for you. The System will multiply the annual salary by 1.32 and subtract the annual salary to obtain the additional 32% for employee's benefits. The RMIS System will multiply the state paid annual benefit figure by the percentage of time each employee spends on risk management activities and add these figures to give the total benefits received for risk management activities by all risk management employees at your agency.

  4. Risk Management EmployeesSalaryState Paid Annual Benefits (Annual Salary X 1.32 - Annual Salary)% of time spent in Risk Management as a DecimalState Paid Annual Benefits X % of time spent in RM
    Risk Manager$43,560$13,939.200.5$6,969.60
    Safety Officer$37,728$12,072.960.15$1,810.94
    Tech Writer$32,664$10,452.480.01$104.52
    Additional Safety Officer (ADSO)$35,304$11,297.280.10$1,129.73
    Total Expenditures:   $10,014.79

    Total Category G Expenditure: $10,014.79


  5. Instructions for calculating Expenditures for Category J - Office Supplies & Consumables. Determine the prorated expenditure for risk management activities.

    Calculate total expenditures by determining the average total consumption per FTE. Divide the expenditure total by the total agency total FTE count. Then multiply the expenditure amount by FTE for risk management.

    Example: Agency purchased consumables in the amount of $153,397.00. Total agency FTE count is 125.

    $153,397/125 = $1,227.17 expenditure per FTE
    $ 1,227.17 X .8 = $981.74

    Total Category J Expenditure: $981.74


  6. Instructions for calculating expenditures for Category M - Telephone & Utilities. Determine the prorated expenditure for risk management activities.

    Calculate total expenditures by determining the average total consumption per FTE by dividing the expenditure by the total agency total FTE count. Then multiply the expenditure amount by FTE for risk management.

    Example: Agency spent $66,397.00 in utilities. The total agency FTE count is 125.

    $66,397/125 = $531.18 expenditure per FTE
    $531.18 X .8 = $424.94

    Total Category M Expenditure: $424.94


  7. Instructions for calculating expenditures for Category K - Capital Outlay.

    These are items that exceed the $5000 capitalization threshold. Examples are purchases for vehicles, sprinkler systems, fire equipment, storage buildings. Enter the total expenditure amount for Category K.

  8. For remaining Categories H, I, L, N, O, P, Q, and R enter the annual expenditures used for risk management activities.

    Example: Agency XY purchased the following safety supplies and equipment for risk management activities.

    Computer related purchases as result of ergo assessments: $2,348.00
    First aid kits: $150.00
    Safety Awards for accident prevention program: $250.00
    Total Annual Expenditure: $2,748.00

    Total Category O – Safety Supplies & Equipment Expenditure: $2,748.00