ATT_P-2_Workforce_Hour_Matrix.xls
XLS spreadsheet 48 KB Posted
- Attached to
- RFP N00421-17-R-0055; AIRCREW SERVICES
- Solicitation number
- N00421-17-R-0055
About this file
This document contains a workforce hour matrix template and details of a solicitation for aircrew services. The workforce hour matrix template provides an example format for contractors to estimate staffing levels and hours by labor category, contract line item, and period of performance over five years.
The solicitation is requesting proposals for certified and qualified operational aircrew to support the Naval Test Wing mission at various Naval Air Systems Command locations. Services include ensuring completion of mission essential testing and evaluation for wing squadrons. The single-award IDIQ contract will have a base period of five years and ceiling of 852,385 man-hours. It is intended as a follow-on to an existing contract for similar aircrew services. The Naval Air Warfare Center Aircraft Division is the contracting activity. Proposals were due by the date listed on the Federal Business Opportunities website.
Workforce Hour Matrix
View the file
Other files
Show all 33
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
| Example of Workforce Hour Matrix | ||||||||
| SOW section | Labor Category | CLIN | Year I Hours | Year 2 Hours | Year 3 Hours | Year 4 Hours | Year 5 Hours | Total Hours |
| 3.1 | Chicken Analyst | XX01 | 4,800 | 4,800 | 4,800 | 4,800 | 2,500 | 21,700 |
| 3.1 | Jr Chicken Analyst | XX01 | 36,000 | 36,000 | 36,000 | 36,000 | 24,000 | 168,000 |
| 3.1 | Sr Chicken Analyst | XX01 | 2,080 | 2,080 | 2,080 | 2,080 | 2,080 | 10,400 |
| Subtotal | 42,880 | 42,880 | 42,880 | 42,880 | 28,580 | 200,100 | ||
| 3.2 | Chicken Analyst | XX02 | 9,800 | 9,800 | 9,800 | 9,800 | 5,400 | 44,600 |
| 3.2 | Jr Chicken Analyst | XX02 | 36,000 | 36,000 | 36,000 | 36,000 | 26,000 | 170,000 |
| 3.2 | Sr Chicken Analyst | XX02 | 1,040 | 1,040 | 1,040 | 1,040 | 2,080 | 6,240 |
| Subtotal | 46,840 | 46,840 | 46,840 | 46,840 | 33,480 | 220,840 | ||
| 3.3 | Chicken Analyst | X003 | 4,800 | 4,800 | 4,800 | 4,800 | 3,600 | 22,800 |
| 3.3 | Jr Chicken Analyst | X003 | 36,000 | 36,000 | 36,000 | 36,000 | 28,000 | 172,000 |
| 3.3 | Sr Chicken Analyst | X003 | 2,080 | 2,080 | 2,080 | 2,080 | 1,800 | 10,120 |
| 3.4 | Chicken Analyst | X003 | 5,600 | 5,600 | 5,600 | 5,600 | 4,500 | 26,900 |
| 3.4 | Jr Chicken Analyst | X003 | 72,000 | 72,000 | 72,000 | 72,000 | 48,000 | 336,000 |
| 3.4 | Sr Chicken Analyst | X003 | 6,040 | 6,040 | 6,040 | 6,040 | 4,800 | 28,960 |
| Subtotal | 126,520 | 126,520 | 126,520 | 126,520 | 90,700 | 596,780 | ||
| Total | 216,240 | 216,240 | 216,240 | 216,240 | 152,760 | 1,017,720 | ||
| 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 "PBSOW section" insert the sections of the PBSOW. Then for each PBSOW section insert the titles of all the labor categories to be utilized to support the specific PBSOW 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 PBSOW 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. |
&RAttachment P2 &RAIR-2.5.1 Form September 2008
WorkForce Hour Matrix
| Workforce Hour Matrix | ||||||||
| SOW section | Labor Category | CLIN | Year I Hours | Year 2 Hours | Year 3 Hours | Year 4 Hours | Year 5 Hours | Total Hours |
&RAttachment P2 &RAIR-2.5.1 Form September 2008
File details come from the government source that posted it. Updated .