FA855226RB001 RFP Attachment 10 VPP DART-TCIR Chart.xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- FA8552-26-R-B001
About this file
This is a pricing template and data collection spreadsheet for the HH-60W Degraded Visual Environment System (DVES) solicitation FA8552-26-R-B001. The template, titled "VPP DART-TCIR Chart," requires offerors to input occupational safety and health data for evaluation purposes in connection with the Air Force's request for proposals on this helicopter system development effort.
The spreadsheet captures Total Case Incident Rate (TCIR) and Days Away, Restricted duty, or Job transfer (DART) metrics across three calendar years (2013, 2015) to establish baseline safety performance. Offerors must provide the offeror name and location, total manhours, total OSHA reportable injuries and illnesses, and total cases resulting in days away from work or restricted duty for each year. The template includes automated calculations for TCIR and DART rates once data is populated. Offerors must also identify the NAICS code applicable to their organization and input corresponding Bureau of Labor Statistics (BLS) industry average rates for comparison purposes. The template calculates percent differences between the offeror's safety performance metrics and BLS industry averages, with notes indicating that the government evaluation team will verify offeror inputs and BLS rate selections to ensure accuracy in the safety performance evaluation component of the proposal.
View the file
Other files
Show 40 more
Latest 50 of 51 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 .