Attachment_P3_Workforce_Hour_Matrix.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
Atlantic Test Range (ATR) & Atlantic Targets and Marine Operations (ATMO) Range Engineering, Technical, Operations and Maintenance Services
Solicitation number
N00421-11-R-0066
Issued by

About this file

Attachment P3

View the file

Other files

File Type Posted
Final_Industry_Q_and_A.xlsx XLSX spreadsheet
List_of_Attendees_at_the_ATR-ATMO_Industry_Day.xlsx XLSX spreadsheet
ATR-ATMO__Pre-Solicitation_Conf_Final_10May2013.pptx PPTX presentation
ATR-ATMO_One_on_One's_Rules_of_Engagement_FINAL.docx DOCX document
ATR-ATMO_Pre_Solicitation_Agenda_-_29APR2013.docx DOCX document
Attachment_P6_Summary_of_Corporate_Experience_Data.xlsx XLSX spreadsheet
CDRLs_303132.pdf PDF
CDRLs_789.pdf PDF
ATMO_Organizational_Chart_Feb_13.pptx PPTX presentation
CDRLs_222324.pdf PDF
ATR-ATMO_PreSolicitation_Conference_Registration_Form_-_Final_11April_2013.docx DOCX document
ATR_Organizational_Chart_October2012-1.pdf PDF
TE4_Acronym_List.doc DOC document
Attachment_5_DD254.pdf PDF
TE5_Workload_History.doc DOC document
Attachment_3_-_Surveillance_Activity_Checklist.docx DOCX document
Attachment_2_-_Labor_Categories_ _Hours_Worksheet_7_Feb_13.xls XLS spreadsheet
Attachment_P4_Past_Performance_Questionnaire.docx DOCX document
Attachment_P1_Relevant_Contract_Table.xlsx XLSX spreadsheet
Attachment_P2_Workforce_Qualifications.xlsx XLSX spreadsheet
CDRLs_131415.pdf PDF
CDRLs_333435.pdf PDF
CDRLs_192021.pdf PDF
TE3_ATR_Facilities _Systems _and_Equipment_TOC.docx DOCX document
CDRLs_252627.pdf PDF
CDRLs_3637.pdf PDF
CDRLs_2829.pdf PDF
CDRLs_101112.pdf PDF
022213_Attachment_1_-_Statement_of_Work_(SOW)_13_Jan_13.docx DOCX document
TE1_ATMO_Facility_ _Equip_Descriptions_20110315.doc DOC document
CDRLs_123.pdf PDF
N00421-11-R-0066_11_Apr_13_Final.doc DOC document
TE2_ATMO_Equip_Distro_Matrix_20110512.xls XLS spreadsheet
TE7_Overtime_Templates.doc DOC document
CDRLs_161718.pdf PDF
Attachment_P5_Summary_of_Relevant_Past_Performance_Contract_Data.xls XLS spreadsheet
Attachment_P7_CLIN_Breakout_spreadsheet_V6_____20_June_2011_without_CIC.xls XLS spreadsheet
CDRLs_456.pdf PDF
Show all 38

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

Example & Instructions

Example of Workforce Hour Matrix
PBSOW sectionLabor CategoryCLINBase Period HoursOption Period I HoursOption Period 2 HoursOption Period 3 HoursOption Period 4 HoursOption Period 5 HoursTotal Hours
3.1Chicken AnalystXX012,4004,8004,8004,8004,8002,50024,100
3.1Jr Chicken AnalystXX0118,00036,00036,00036,00036,00024,000186,000
3.1Sr Chicken AnalystXX011,0402,0802,0802,0802,0802,08011,440
Subtotal21,44042,88042,88042,88042,88028,580221,540
3.2Chicken AnalystXX024,7009,8009,8009,8009,8005,40049,300
3.2Jr Chicken AnalystXX0218,00036,00036,00036,00036,00026,000188,000
3.2Sr Chicken AnalystXX025701,0401,0401,0401,0402,0806,810
Subtotal23,27046,84046,84046,84046,84033,480244,110
3.3Chicken AnalystX0032,4004,8004,8004,8004,8003,60025,200
3.3Jr Chicken AnalystX00318,00036,00036,00036,00036,00028,000190,000
3.3Sr Chicken AnalystX0031,0402,0802,0802,0802,0801,80011,160
3.4Chicken AnalystX0032,6005,6005,6005,6005,6004,50029,500
3.4Jr Chicken AnalystX00342,00072,00072,00072,00072,00048,000378,000
3.4Sr Chicken AnalystX0039,0406,0406,0406,0406,0404,80038,000
Subtotal75,080126,520126,520126,520126,52090,700671,860
Total119,790216,240216,240216,240216,240152,7601,137,510
Instructions:
The Workforce Hour Matrix should be formatted as portrait or landscape for printing on letter size paper. Data in cells may be wrapped, if necessary.
Do not employ any special reduction or formatting for printing to reduce the size or font of the worksheet.
Under "SOW section" insert the sections of the SOW. Then for each SOW section insert the titles of all the labor categories to be utilized to support the specific SOW section in the column "Labor Category."
Under "CLIN" indicate the Contract Line Item Number from Section B of the solicitation that the specific labor category will be supporting, If the labor category is supporting multiple SOW sections and/or CLINS, it should be annotated individually for each instance.
Under the heading for each period of performance, annotate the total number of hours being proposed for the specific labor category. Utilize whole numbers only. Pay particular attention to the periods of performance as indicated in the solicitation, as there are occasions when the base period is less than twelve months, and a fifth option period may be utilized for a period of less than twelve months. If a fifth option period is not utilized insert "zeros" in the column.
At the end of each row insert a total for all periods of performance. Then, after each grouping of labor by CLIN, insert a subtotal for each of the periods of performance, and the entire CLIN. At the conclusion of all CLINs insert a total that tabulates the total number of hours per period of performance.
Utilization of colors in the matrix to highlight rows or columns is at the discretion of the Offeror. However, be advised that most Government printers only print black/grey on white.

Attachment P2

AIR-2.5.1 Form September 2008

WorkForce Hour Matrix

Workforce Hour Matrix
PBSOW sectionLabor CategoryCLINBase Period HoursOption Period I HoursOption Period 2 HoursOption Period 3 HoursOption Period 4 HoursOption Period 5 HoursTotal Hours

Attachment P3

AIR-2.5.1 Form September 2008

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