DART - TCIR Chart_(Attachment 9).xlsx

XLSX spreadsheet 26 KB Posted

Attached to
Industrial Process Waste (IPW) Cleaning Federal contract opportunity
Solicitation number
FA8571-23-R-0004
Issued by
Department of the Air Force Materiel Command Air Force Sustainment Center

About this file

This document contains a template for tracking total recordable injury rates (TCIR) and days away, restricted or transferred (DART) rates. The template requires offerors to input manhours and injury data for the previous three calendar years, as well as the North American Industry Classification System (NAICS) code for the work. It will automatically calculate the TCIR and DART rates for each year and the average rates. Offerors must also provide the most recent Bureau of Labor Statistics (BLS) industry average TCIR and DART rates for the identified NAICS code and calculate the percentage difference from their own rates.

The related federal contract opportunity is solicitation number FA8571-23-R-0004 for industrial process waste cleaning services from the Department of the Air Force Materiel Command Air Force Sustainment Center. Offerors responding to the solicitation will need to complete the injury rate template to comply with safety tracking and reporting requirements. The template collects manhour and injury data to calculate total recordable injury and days away from work rates for evaluation.

View the file

Other files for this federal contract opportunity

Other files attached to Industrial Process Waste (IPW) Cleaning, newest first.
File Type Posted
Pricing Excel Sheet (Attachment 8) Revised.xlsx XLSX spreadsheet
73500 - PWS_IPWRevised28July2023.docx DOCX document
Solicitation Amendment FA857123R00040002 SF 30.pdf PDF
IPW Questions II.pdf PDF
IPW Questions.pdf PDF
73500 - PWS_IPW_Revised21July2023.docx DOCX document
Solicitation Amendment FA857123R00040001 SF 30.pdf PDF
73500 - PWS_IPW.pdf PDF
Appendix 2 - IPWC - Map.pdf PDF
73500 - CDRL A001 (Exhibit A)- Status Report.pdf PDF
IPW CDRL A002 (Exhibit A) -Management Plan.pdf PDF
IPW WAGE DETERMINATION.pdf PDF
Appendix 3 - Directives - Publication.pdf PDF
Pricing Excel Sheet (Attachment 8)___.xlsx XLSX spreadsheet
Appendix 4 - Government POCs - IPW 18 MAY 23.pdf PDF
Appendix C for Industrial Process Waste Cleaning.pdf PDF
IPW CDRL A004 (Exhibit A)- Contractors Safety Plan.pdf PDF
Solicitation - FA857123R0004.pdf PDF
Appendix 1 Equipment List Revised_06 Jul 2023.pdf PDF
Appendix 5 Environmental Requirements 1 JAN 23.pdf PDF
73500 - Appendix 6 - HAZMAT Management Plan (May 2022)_.pdf PDF
73500 - Appendix 7 - Hazardous Waste Management Plan_.pdf PDF
IPW CDRL A003 (Exhibit A)- Quality Program Plan.pdf PDF
IPW CDRL A005 (Exhibit A)- Accident-Incident Report.pdf PDF
IPW CDRL A006 (Exhibit A) - Contract Invoicing and Payment Report.pdf PDF
Show all 25

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 blocksNote: *Tab 2: TCIR, DART Calculations is if not maintained
Note: *Tab 3: TCIR DART Rates is if already maintained
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 B:Average of TCIR/DART Rate for 2019, 2020, 2021
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

Tab 2 TCIR, DART Calculations

Site Name:
YearManhoursTotal Cases (injuries & Illnesses)TCIRTotal Cases with Days Away From Work and Restricted DutyDART
201900ERROR:#DIV/0!0ERROR:#DIV/0!
202000ERROR:#DIV/0!0ERROR:#DIV/0!
202100ERROR:#DIV/0!0ERROR:#DIV/0!
2019 - 2021ERROR:#DIV/0!ERROR:#DIV/0!
NAICS Code:0
BLS Most Recent Industry Averages:2.17/1.4

Percent Difference http://www.bls.gov/news.release/pdf/osh.pdfhttp://www.naics.com/search.htm Tab 3 TCIR DART Rates

NAICS Code:
YEARTCIRDART
2019
2020
2021

File details come from the government source that posted it. Updated .