facilities toolbox logo

How Do I Determine the Facility Rating Codes?

Toolbox Home | MTDC Home

Facility Rating Codes are used in the database to determine the buildings condition. The following are the Facility Rating Codes to be used on the blank spreadsheet. For further help, see an example of a completed spread sheet here.

Facility Rating Codes

Below are explanations for each column used within the Facility Database Spreadsheet:
  1. Description = Brief description of the facility (user input)

  2. Maintenance Levels = The Maintenance Level codes have been adopted from FSH 7309.11, 42.2-Exhibit 01-Maintenance Levels. (user input)

    I = 10

    II = 20

    III = 30

    IV = 40

    V = 50

  3. Year Constructed = The year when the building was constructed (user input)

  4. Years Old = (calculated) by subtracting the current year minus the year constructed

  5. Building Condition (Overall) F. Minimum Suitability Standards (user input) Dilapidated = 0 Poor = 10 Fair = 20 Good = 30 Excellent = 40

  6. Minimum Suitability Standards (user input) Does not meet any = -40 Partially meets = -20 Fully meets = 0 Not a dwelling = 0

  7. Accessibility (user input) Does not meet = 0 Partially meets = 20 Fully meets = 40

  8. Miles to main Office(user input)

  9. Miles to main Office score = Miles to main office/30 miles = +score(calculated)

  10. $'s to bring to Standard (user input) $15k = lead base paint $5k = exhaust system $5k = bedroom or bath remodel $10k = kitchen or accessibility remodel or structural problems

  11. $'s Standard score = $'s to bring to Standard/$3000 (calculated)

  12. Standards Remarks (user input)

  13. Liability Score = Standards required when rating government housing adopted from FSH 7309.11, 34.13c-Exhibit 01 -Minimum Suitability Standards for Government Furnished Housing. (user input) Bldg to Standard = 0 Moderate Risk = -3 High Risk = -5

  14. Liability Remarks (user input)

  15. Potential revenue days Generated (REC) (user input)

  16. Potential Revenue Score ($30 per night) x (Potential Revenue Days)/$3000 (calculated)
Back