Atch__30_-_VPP_DART-TCIR_Chart.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Mechanical Electrical IDIQ Federal contract opportunity
- Solicitation number
- FA8501-18-R-0003
About this file
This document contains a spreadsheet template for tracking voluntary protection program metrics and injury rates, as well as details of a mechanical and electrical indefinite delivery indefinite quantity construction contract opportunity. The spreadsheet template instructs offerors to input manhours, total OSHA recordable injuries and illnesses, and cases involving days away from work or job restrictions for three consecutive years. It provides formulas to automatically calculate total recordable incident rates and days away restricted or transferred rates based on offeror inputs and Bureau of Labor Statistics industry averages.
The mechanical and electrical IDIQ contract provides maintenance support at Robins Air Force Base, including HVAC, controls, distribution systems, boilers, lighting, fire suppression and alarm systems. The contractor will perform repairs, renovations, upgrades and new construction on a task order basis, supplying all material, equipment, labor and general conditions.
Corrected Atch #30 - VPP DART/TCIR Chart
View the file
Other files for this federal contract opportunity
Show all 49
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
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 |
| 2015 | 0 | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| 2016 | 0 | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| 2017 | 0 | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| 2015-2017 | 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 .