FA855226RB001 RFP Attachment 10 VPP DART-TCIR Chart.xlsx
XLSX spreadsheet 26 KB Posted
- Solicitation number
- FA8552-26-R-B001
About this file
This is an Excel template attachment for submitting Occupational Safety and Health (OSHA) safety performance data as part of the HH-60W Degraded Visual Environment System (DVES) RFP. The template requires offerors to input occupational health and safety metrics for three calendar years (2013, 2014, and 2015) to demonstrate their safety performance record. Offerors must provide total manhours worked, total OSHA reportable injuries and illnesses, and total cases resulting in days away from work or restricted duty for each year. The template automatically calculates the Total Case Incident Rate (TCIR) and Days Away, Restricted, or Job Transfer (DART) rates based on the input data. Offerors must also input the relevant NAICS code and corresponding Bureau of Labor Statistics (BLS) industry average rates for TCIR and DART to allow comparison of their safety performance against industry benchmarks. The template then calculates the percent difference between the offeror's rates and the BLS industry averages, enabling evaluation of the offeror's safety performance relative to comparable industries. This safety performance data submission is required as part of the Voluntary Protection Program (VPP) DART-TCIR evaluation criteria for the Air Force contract opportunity.
View the file
Other files
Show 40 more
50 files listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| 1. Blocks highlighted in yellow require offeror input |
| 2. Blocks highlighted in green automatically calculate based on offeror input into yellow blocks |
| Row 1: Input offeror name and location beginning in column B |
| Row 2: Do not enter anything |
| Row 3: |
| Column B: Input the total number of manhours for calendar year 201X |
| Column C: Input the total number of OSHA reportable injuries and illnesses |
| Column D: Do not enter anything, as this column will automatically calculate |
| Column E: Input the total number of cases from Column C that resulted in days away from work or restricted duty |
| Column F: Do not enter anything, as this column will automatically calculate |
| Row 4: |
| Column B: Input the total number of manhours for calendar year 201X |
| Column C: Input the total number of OSHA reportable injuries and illnesses |
| Column D: Do not enter anything, as this column will automatically calculate |
| Column E: Input the total number of cases from Column C that resulted in days away from work or restricted duty |
| Column F: Do not enter anything, as this column will automatically calculate |
| Row 5: |
| Column B: Input the total number of manhours for calendar year 201X |
| Column C: Input the total number of OSHA reportable injuries and illnesses |
| Column D: Do not enter anything, as this column will automatically calculate |
| Column E: Input the total number of cases from Column C that resulted in days away from work or restricted duty |
| Column F: Do not enter anything, as this column will automatically calculate |
| Row 7: |
| Column D: Do not enter anything, as this column will automatically calculate |
| Column F: Do not enter anything, as this column will automatically calculate |
| Row 8: Input NAICS Code identified on the face page of the RFP |
| Row 9: |
| Column D: Enter the BLS TCIR rate for the NAICS Code identified in cell B8 |
| Column F: Enter the BLS DART rate for the NAICS Code identified in cell B8 |
| Row 11: |
| Column D: Do not enter anything, as this column will automatically calculate |
| Column F: Do not enter anything, as this column will automatically calculate |
TCIR, DART Calculations
| Site Name: | |||||
| Year | Manhours | Total Cases (injuries & Illnesses) | TCIR | Total Cases with Days Away From Work and Restricted Duty | DART |
| 2013 | 0 | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| 2014 | 0 | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| 2015 | 0 | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| 2013 - 2015 | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| NAICS Code: | 0 | ||
| BLS Most Recent Industry Averages: | CY201X |
OWENS, BRANDI R GS-13 USAF AFMC AFLCMC/WLNKB: OWENS, BRANDI R GS-13 USAF AFMC AFLCMC/WLNKB:
Input the Calendar Year of the BLS rates
OWENS, BRANDI R GS-13 USAF AFMC AFLCMC/WLNKB: OWENS, BRANDI R GS-13 USAF AFMC AFLCMC/WLNKB The team will need to double check this offeror input OWENS, BRANDI R GS-13 USAF AFMC AFLCMC/WLNKB: OWENS, BRANDI R GS-13 USAF AFMC AFLCMC/WLNKB:
The team will need to double check this offeror input Percent Difference http://www.bls.gov/news.release/pdf/osh.pdfhttp://www.naics.com/search.htm
File details come from the government source that posted it. Updated .