Attachment_P2_Workforce_Hour_Matrix.xls
XLS spreadsheet 44 KB Posted
- Attached to
- Research, Development, Test and Evaluation (RDT&E) Infrastructure Division NAVAIR 5. 4. 1
- Solicitation number
- N00421-15-R-0003
About this file
P2 Workforce Hour Matrix
View the file
Other files
Show all 35
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 | |||||||||
| PBSOW section | Labor Category | CLIN | Base Period Hours | Option Period I Hours | Option Period 2 Hours | Option Period 3 Hours | Option Period 4 Hours | Option Period 5 Hours | Total Hours |
| 3.1 | Chicken Analyst | XX01 | 2,400 | 4,800 | 4,800 | 4,800 | 4,800 | 2,500 | 24,100 |
| 3.1 | Jr Chicken Analyst | XX01 | 18,000 | 36,000 | 36,000 | 36,000 | 36,000 | 24,000 | 186,000 |
| 3.1 | Sr Chicken Analyst | XX01 | 1,040 | 2,080 | 2,080 | 2,080 | 2,080 | 2,080 | 11,440 |
| Subtotal | 21,440 | 42,880 | 42,880 | 42,880 | 42,880 | 28,580 | 221,540 | ||
| 3.2 | Chicken Analyst | XX02 | 4,700 | 9,800 | 9,800 | 9,800 | 9,800 | 5,400 | 49,300 |
| 3.2 | Jr Chicken Analyst | XX02 | 18,000 | 36,000 | 36,000 | 36,000 | 36,000 | 26,000 | 188,000 |
| 3.2 | Sr Chicken Analyst | XX02 | 570 | 1,040 | 1,040 | 1,040 | 1,040 | 2,080 | 6,810 |
| Subtotal | 23,270 | 46,840 | 46,840 | 46,840 | 46,840 | 33,480 | 244,110 | ||
| 3.3 | Chicken Analyst | X003 | 2,400 | 4,800 | 4,800 | 4,800 | 4,800 | 3,600 | 25,200 |
| 3.3 | Jr Chicken Analyst | X003 | 18,000 | 36,000 | 36,000 | 36,000 | 36,000 | 28,000 | 190,000 |
| 3.3 | Sr Chicken Analyst | X003 | 1,040 | 2,080 | 2,080 | 2,080 | 2,080 | 1,800 | 11,160 |
| 3.4 | Chicken Analyst | X003 | 2,600 | 5,600 | 5,600 | 5,600 | 5,600 | 4,500 | 29,500 |
| 3.4 | Jr Chicken Analyst | X003 | 42,000 | 72,000 | 72,000 | 72,000 | 72,000 | 48,000 | 378,000 |
| 3.4 | Sr Chicken Analyst | X003 | 9,040 | 6,040 | 6,040 | 6,040 | 6,040 | 4,800 | 38,000 |
| Subtotal | 75,080 | 126,520 | 126,520 | 126,520 | 126,520 | 90,700 | 671,860 | ||
| Total | 119,790 | 216,240 | 216,240 | 216,240 | 216,240 | 152,760 | 1,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 "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 | |||||||
| Labor Category | CLIN | Base Period Hours | Option Period I Hours | Option Period 2 Hours | Option Period 3 Hours | Option Period 4 Hours | Total Hours |
| Computer Systems Analyst I | 0001 | 5760 | 5760 | 5760 | 5760 | 5760 | 28800 |
| Computer Systems Analyst II | 0001 | 7680 | 7680 | 7680 | 7680 | 7680 | 38400 |
| Computer Systems Analyst III | 0001 | 9600 | 9600 | 9600 | 9600 | 9600 | 48000 |
| Computer Systems Analyst III | 0001 | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 |
| Computer Systems Analyst III | 0001 | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 |
| Computer Systems Analyst III | 0001 | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 |
| Computer Systems Analyst III | 0001 | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 |
| System Analyst | 0001 | 9600 | 9600 | 9600 | 9600 | 9600 | 48000 |
| System Analyst | 0001 | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 |
| Management Analyst I | 0001 | 7680 | 7680 | 7680 | 7680 | 7680 | 38400 |
| Management Analyst II | 0001 | 3840 | 3840 | 3840 | 3840 | 3840 | 19200 |
| Information Assurance Analyst | 0001 | 3840 | 3840 | 3840 | 3840 | 3840 | 19200 |
| Information Assurance Analyst | 0001 | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 |
| Information Assurance Analyst | 0001 | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 |
| Information Assurance Analyst | 0001 | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 |
| System Admin, Senior | 0001 | 7680 | 7680 | 7680 | 7680 | 7680 | 38400 |
| System Admin, Junior | 0001 | 11520 | 11520 | 11520 | 11520 | 11520 | 57600 |
| Computer Scientist, Sr | 0001 | 13440 | 13440 | 13440 | 13440 | 13440 | 67200 |
| System Analyst, Sr | 0001 | 9600 | 9600 | 9600 | 9600 | 9600 | 48000 |
&CN00421-15-R-0003&RAttachment P2 &RAIR-2.5.1 Form September 2008
File details come from the government source that posted it. Updated .