TE 07 QC Spreadsheet.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- FEMA Individuals and Households Program (IHP) Field Services Contract Federal contract opportunity
- Solicitation number
- 70FB8024R00000028
About this file
This document appears to be a QC Spreadsheet for use in a federal contract opportunity. The spreadsheet is used to record quality control inspection results for damage assessments conducted under the FEMA Individuals and Households Program (IHP) Field Services Contract.
The spreadsheet includes fields to record details such as the disaster number, registration number, inspector name, inspection date, quality control inspector name, quality control inspection date, total quality control score, and indicators of customer service, FEMA ride-alongs, owner/renter status, and the need for an FCOR. The spreadsheet also includes fields to record specific assessment details and any errors found, with a scoring system to deduct points for errors. Inspections scoring below 90 require correction and an FCOR. The completed spreadsheets are to be delivered daily to FEMA through a secure data portal.
The related federal contract opportunity is for an IDIQ contract to conduct damage assessments in response to presidentially declared disasters throughout the U.S. and its territories. The solicitation number is 70FB8024R00000028, and it is being issued by the FEMA Community Survivor Assistance Section.
View the file
Other files for this federal contract opportunity
Show all 43
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
QC Form
| Assessor Details | Automatic FEMA Correction Reason (each error will be noted with a score of "12"; if no error, leave blank. Exception, RP/PP points will be recorded in 1 point increments up to 10 points, then 12 points when exceeding the total RP/PP error threshold. | Record Dollar Amt | ||||||||||||||||||||||||||
| DR# | REG # | INSPR | INSP. DATE | QC INSPR | QC INSP. DATE | SCORE | QMS Cust. Service Pass (Yes/No) | FEMA Ride-along (Yes/No) | Owner (O) Renter (R) | FCOR Needed (Yes/No) | Name, Address or Contact Information | Struct. / Contents Ins. Type | Like-kind room(s) | Occupancy | Ownership | Comment / Flag | Habitability | IA | Utilities Out | Special Cond. | Onsite Assmt. | Renter's Dmg. Lvl | Wrong COD | RP/PP Point | RP Error Amt | PP Error Amt | Total RP/PP $ Error | 10% of Assessed Damages |
Field QC Report
Attachment 24a April 2017 Page &P of &N
Legend
| Column Title | Column Description | Value to Record |
| DR# | Disaster Number (four digit disaster number) | Numerical |
| REG # | Registration Number (NEMIS Field: rgsn_id) | Numerical |
| INSPR | Inspector Last Name (NEMIS Field: inspr_last_nm) | Numerical |
| INSP. DATE | Inspection Date (NEMIS Field: cntr_return_dt) | Month/Day/Year |
| QC INSPR | QC Inspector Last Name (NEMIS Field: inspr_last_nm) | Numerical |
| QC INSP. DATE | QC Inspection Date (MO/DA/YEAR) | Month/Day/Year |
| SCORE | Total QC Score (0 - 100 score) (No decimals) | Numerical |
| Accept. Cust. Serv. (Y/N) | Did the assessor provide an acceptable level of customer service per the Contractor's QMS? | Yes / No |
| FEMA Ride-along (Y/N) | Did a FEMA member accompany the QC inspector | Yes / No |
| Owner (O) Renter (R) | Inspection performed on an Owner or Renter | O / R |
| FCOR Needed (y/n) | Scores below 90 will require an FCOR | Yes / No |
| Name, Address or Primary Contact Information | Automatic FEMA Correction Reason | 12 or Null |
| Structural or Contents Ins. Type | Automatic FEMA Correction Reason | 12 or Null |
| Like-kind room(s) | Automatic FEMA Correction Reason | 12 or Null |
| Occupancy | Automatic FEMA Correction Reason | 12 or Null |
| Ownership | Automatic FEMA Correction Reason | 12 or Null |
| Comment / Flag | Automatic FEMA Correction Reason | 12 or Null |
| Habitability | Automatic FEMA Correction Reason | 12 or Null |
| Inaccessible | Automatic FEMA Correction Reason | 12 or Null |
| Utilities Out | Automatic FEMA Correction Reason | 12 or Null |
| Special Condition | Automatic FEMA Correction Reason | 12 or Null |
| Onsite Inspection | Automatic FEMA Correction Reason | 12 or Null |
| Renter's Damage Level | Automatic FEMA Correction Reason | 12 or Null |
| Wrong Cause of Damage | Automatic FEMA Correction Reason | 12 or Null |
| Cumulative RP/PP Point | One (1) point deduction for every $100 in total dollar errors up to 10 points, or One (1) point deduction for each percentage of the error when exceeding $1,000 measured by 10% of assessed damages up to 10 points. When exceeding $1,000 or 10 percentage points, record a 12 point deduction. | Incremental Points to 10, then max. of 12 |
| RP Error Amnt | Real Property Dollar Error of missed or excessive items. (No decimals, round up above .50, round down below) | Dollar Amount |
| PP Error Amnt | Personal Property Dollar Error for missed or excessive items (No decimals, round up above .50, round down below) | Dollar Amount |
| Total RP/PP $ Error | Total Dollar Error (missed, excessive, or wrong cause of damage) (No decimals, round up above .50, round down below). | Dollar Amount |
| 10% of Assessed Damages | When exceeding $1,000 in combined RP/PP errors, identify 10% of the combined assessed damages of the corrected inspection using QC prices. Completing this field is only necessary when using the 10% factor. | Dollar Amount |
QC Spreadsheet Legend
Instructions
Completing the QC Spreadsheet:
Record all Quality Control (QC) inspection results using the supplied “QC Form” Spreadsheet. All fields below “Assessor Details” will be recorded with a value. Record a “12” for every error noted below the “Automatic FEMA Correction Reason”. Fields without error will be left blank (null value). Record the category dollar amounts for Real and Personal Property, then sum the two categories and record the Total RP/PP Error below the “Record Dollar Amount”.
The “Score” represents a 100 metric minus the recorded 12 point errors including up to 12 points of the cumulative differences for missed or excessive real and personal property when exceeding the greater of $1,000 or 10% of the assessed damages.
Example: Assessor incorrectly recorded the dwelling’s habitability and erred when recording occupancy for a combined 24 point deduction. Furthermore, the assessor under- recorded $1,700 in combined real and personal property damage creating an additional 12 point error for a total point deduction of 36 and comprehensive score of 64.
Another example: Assessor incorrectly recorded the dwelling’s habitability and erred when recording occupancy for a combined 24 point deduction. Additionally, under-recorded $2,000 in combined real and personal property damage exceeding $1,000 AND 10% of the total $18,000 in assessed damages. An additional 12 point error for the under recording of damages is added to the previous errors for a total point deduction of 36 and comprehensive score of 64.
Note, when exceeding $1,000 in RP/PP errors and that cumulative is not greater than 10% of assessed damages, record one (1) point deductions each one-percentage point of the cumulative assessed damages identified. Example: One percent of $18,000 is $180 where one-percentage point per $180 will be recorded up to 10 points to account for errant RP/PP recorded up to and including $1,800.00.
QC inspections with a score below 90 will be returned for correction and listed with a “Yes” response to the FCOR Needed field below “Assessor Details”.
The Spreadsheet will be completed after each QC inspection and electronically delivered daily to FEMA through the SharePoint portal or other secure data storage site designated by FEMA’s Contract Management Assessment Unit.
FEMA has acknowledged that QC assessments may offset the cause of damage for Hail/Rain/WDR and tornado/wind since considered similar perils and will not be considered errant when used interchangeably.
File details come from the government source that posted it. Updated .