Attach 17 - Manpower Matrix Template_28 Feb 22.xlsx
XLSX spreadsheet 25 KB Posted
- Solicitation number
- FA300221R0012
View the file
Other files
Show 40 more
Latest 50 of 104 listed here. See the rest on GovTribe.
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
Sheet 1 FA300221R0012 Attachment 17 MANPOWER MATRIX - 28 Feb 22 (see 2nd Tab for Example) Keesler AFB Base Operations Support (BOS)
| DESCRIPTION | Mobilization | ||||||||||||||||
| (2 months/60 days) | Base Period (10 months) | Option Yr 1 | Option Yr 2 | Option Yr 3 | Option Yr 4 | Incentive Option 1 | Incentive Option 2 | ||||||||||
| Man-Years | Man-Years | Man-Years | Man-Years | Man-Years | Man-Years | Man-Years | Man-Years | ||||||||||
| F/T | P/T | F/T | P/T | F/T | P/T | F/T | P/T | F/T | P/T | F/T | P/T | F/T | P/T | F/T | P/T | ||
| DIRECT | |||||||||||||||||
| 2. All Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 10. Installation Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 11. Operations Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 12. Installation Engineering | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 13. Grounds Maintenance | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 14. Emergency Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 15. Vertical Transportation Equipment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 23. Supply/Logistics | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 28. Community Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 30. Human Resources | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 32. Weather Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| TOTAL DIRECT | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| INDIRECT | |||||||||||||||||
| 2. All Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 10. Installation Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 11. Operations Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 12. Installation Engineering | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 13. Grounds Maintenance | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 14. Emergency Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | S |
| 15. Vertical Transportation Equipment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 23. Supply/Logistics | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 28. Community Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 30. Human Resources | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| 32. Weather Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
| TOTAL INDIRECT | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| OVERHEAD | ||||||||||||||||
| 2. All Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 10. Installation Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 11. Operations Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 12. Installation Engineering | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 13. Grounds Maintenance | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 14. Emergency Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 15. Vertical Transportation Equipment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 23. Supply/Logistics | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 28. Community Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 30. Human Resources | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 32. Weather Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| TOTAL OVERHEAD | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| TOTAL DIRECT | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| TOTAL INDIRECT | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| TOTAL OVERHEAD | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| TOTAL PROGRAMMED MANYEARS (Note 2) |
| LAPSE MANYEARS (Note 3) |
| AVAILABLE MANYEARS (Note 4) |
| OVERTIME MANYEARS (Note 5) |
| TOTAL MANYEARS PRICED (Note 6) |
| NOTES: |
| Note 1: Direct, Indirect, and Overhead labor (total full and part time numbers appearing in the matrix should include lapse because you do not know specifically where the lapse will occur). |
| Note 2: Total programmed manyears should represent the total of Direct, Indirect, and Overhead figures in the previous upper portion of the chart (and thus include lapse figures and mobilization). |
| Note 3: Total projected lapse extracted from the total programmed manyears. |
| Note 4: Available manyears are programmed manyears less lapse manyears. |
| Note 5: Total of projected overtime hours (hours worked at a premium rate of pay), as indicated in the cost proposal (translated to overtime manyears). |
| Note 6: Priced manyears is the total programmed manyears less lapse manyear plus overtime manyears. |
| Note 7: This matrix may be completed jointly by the prime and each subcontractor. Due to the proprietary nature of this data, a subcontractor may opt to submit their portion of this data directly to the contracting officer in lieu of submitting through it's prime contractor. |
| INSTRUCTIONS: |
| This spreadsheet is a tool used by the USAF to have offerors provide their Full Time Equivalent (FTE) and part time (PT) personnel. The USAF will use these numbers to determine what FTE and PT manning levels the offerors are proposing. |
| DEFINITIONS |
| Applies to technical proposal and should not affect cost summaries previously submitted |
Direct Labor: Direct labor involves those tasks that are readily identifiable with a work center's specific product or service. For example, fuels distribution or vehicle maintenance. Supervision of direct labor tasks is considered direct labor when direct labor encompasses fifty percent or more of the tasks.
Indirect Labor - Indirect labor involves those tasks that are not readily identifiable with a work center's specific product or service. The major categories of standard indirect work are: Directs work center activity, provides administrative support; prepares for and conducts/attends meetings; performs planning and scheduling; maintains system and equipment status, configuration, usage, location and historical records; administers training, quality, budget, data collection and analysis programs, manages supplies and tools, monitors and coordinates work center production, and performs clean-up, Supervision of indirect tasks is considered indirect labor when indirect labor encompasses fifty percent or more of the tasks.
LAPSE MANYEARS: The lapse rate factor is comprised of pricing/manning figures to compensate for personnel turnover, excess sick leave, etc. Basically, it is the timeframe from when a job is vacated up until a trained replacement is back in the position. Note: A zero lapse rate is unrealistic since it assumes that no employee will quit, retire, die or require excess sick leave or annual leave without a trained replacement being in place.
OVERHEAD Labor: Work and tasks related to overall management of both support and production activities. This category includes staff support activities, (for example human resource, contract management and overhead administration). Work is considered overhead when tasks encompasses fifty percent or more of management tasks. Overhead labor refers to on-site management overhead only.
Example FA300221R0012 Attachment 17 - EXAMPLE MANPOWER MATRIX - 28 Feb 22 Keesler AFB Base Operations Support (BOS)
| DESCRIPTION | Mobilization | ||||||||||||||||
| (2 months/60 days) | Base Period (10 months) | Option Yr 1 | Option Yr 2 | Option Yr 3 | Option Yr 4 | Incentive Option 1 | Incentive Option 2 | ||||||||||
| Man-Years | Man-Years | Man-Years | Man-Years | Man-Years | Man-Years | Man-Years | Man-Years | ||||||||||
| F/T | P/T | F/T | P/T | F/T | P/T | F/T | P/T | F/T | P/T | F/T | P/T | F/T | P/T | F/T | P/T | ||
| DIRECT | |||||||||||||||||
| 2. All Services | 0.00 | 0.00 | 4.00 | - | 4.00 | - | 4.00 | - | 4.00 | - | 4.00 | - | 4.00 | - | 4.00 | - | |
| 10. Installation Management | 0.00 | 0.00 | 12.00 | - | 12.00 | - | 12.00 | - | 12.00 | 12.00 | 12.00 | 12.00 | 12.00 | - | 12.00 | - | |
| 11. Operations Management | 0.00 | 0.00 | 100.00 | - | 100.00 | - | 100.00 | - | 100.00 | - | 100.00 | - | 100.00 | - | 100.00 | - | |
| 12. Installation Engineering | 0.00 | 0.00 | 16.00 | - | 16.00 | - | 16.00 | - | 16.00 | - | 16.00 | - | 16.00 | - | 16.00 | - | |
| 13. Grounds Maintenance | 0.00 | 0.00 | 20.05 | - | 20.05 | - | 20.05 | - | 20.05 | - | 20.05 | - | 20.05 | - | 20.05 | - | |
| 14. Emergency Management | 0.00 | 0.00 | 6.00 | - | 6.00 | - | 4.98 | - | 6.00 | - | 6.00 | - | 6.00 | - | 6.00 | - | |
| 15. Vertical Transportation Equipment | 0.00 | 0.00 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |
| 23. Supply/Logistics | 0.00 | 0.00 | 18.92 | - | 18.92 | - | 18.92 | - | 18.92 | - | 18.92 | - | 18.92 | - | 18.92 | - | |
| 28. Community Services | 0.00 | 0.00 | 18.05 | - | 18.05 | - | 18.05 | - | 18.05 | - | 18.05 | - | 18.05 | - | 18.05 | - | |
| 30. Human Resources | 0.00 | 0.00 | 7.54 | 0.97 | 7.54 | 0.97 | 7.54 | 0.97 | 7.54 | 0.97 | 7.54 | 0.97 | 7.54 | 0.97 | 7.54 | 0.97 | |
| 32. Weather Services | 0.00 | 0.00 | 5.00 | - | 5.00 | - | 5.00 | - | 5.00 | - | 5.00 | - | 5.00 | - | 5.00 | - | |
| TOTAL DIRECT | 0.00 | 0.00 | 207.56 | 0.97 | 207.56 | 0.97 | 206.54 | 0.97 | 207.56 | 12.97 | 207.56 | 12.97 | 207.56 | 0.97 | 207.56 | 0.97 |
| INDIRECT | ||||||||||||||||
| 2. All Services | 0.00 | 0.00 | - | 0.00 | - | 0.00 | - | 0.00 | - | 0.00 | - | 0.00 | - | 0.00 | - | 0.00 |
| 10. Installation Management | 0.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 |
| 11. Operations Management | 0.00 | 0.00 | 3.00 | 0.00 | 3.00 | 0.00 | 3.00 | 0.00 | 3.00 | 0.00 | 3.00 | 0.00 | 3.00 | 0.00 | 3.00 | 0.00 |
| 12. Installation Engineering | 0.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 |
| 13. Grounds Maintenance | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 |
| 14. Emergency Management | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 |
| 15. Vertical Transportation Equipment | 0.00 | 0.00 | - | 0.00 | - | 0.00 | - | 0.00 | - | 0.00 | - | 0.00 | - | 0.00 | - | 0.00 |
| 23. Supply/Logistics | 0.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 |
| 28. Community Services | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 |
| 30. Human Resources | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 |
| 32. Weather Services | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 |
| TOTAL INDIRECT | 0.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 |
| OVERHEAD | ||||||||||||||||
| 2. All Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 10. Installation Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 11. Operations Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 12. Installation Engineering | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 13. Grounds Maintenance | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 14. Emergency Management | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 15. Vertical Transportation Equipment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 23. Supply/Logistics | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 28. Community Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 30. Human Resources | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| 32. Weather Services | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| TOTAL OVERHEAD | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| TOTAL DIRECT | 0.00 | 0.00 | 207.56 | 0.97 | 207.56 | 0.97 | 206.54 | 0.97 | 207.56 | 12.97 | 207.56 | 12.97 | 207.56 | 0.97 | 207.56 | 0.97 |
| TOTAL INDIRECT | 0.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 |
| TOTAL OVERHEAD | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| TOTAL PROGRAMMED MANYEARS (Note 2) | 0.00 | 0.00 | 221.56 | 0.97 | 221.56 | 0.97 | 220.54 | 0.97 | 221.56 | 15.97 | 221.56 | 12.97 | 221.56 | 0.97 | 221.56 | 0.97 |
| LAPSE MANYEARS (Note 3) | ||||||||||||||||
| AVAILABLE MANYEARS (Note 4) | ||||||||||||||||
| OVERTIME MANYEARS (Note 5) | ||||||||||||||||
| TOTAL MANYEARS PRICED (Note 6) |
| NOTES: |
| Note 1: Direct, Indirect, and Overhead labor (total full and part time numbers appearing in the matrix should include lapse because you do not know specifically where the lapse will occur). |
| Note 2: Total programmed manyears should represent the total of Direct, Indirect, and Overhead figures in the previous upper portion of the chart (and thus include lapse figures and mobilization). |
| Note 3: Total projected lapse extracted from the total programmed manyears. |
| Note 4: Available manyears are programmed manyears less lapse manyears. |
| Note 5: Total of projected overtime hours (hours worked at a premium rate of pay), as indicated in the cost proposal (translated to overtime manyears). |
| Note 6: Priced manyears is the total programmed manyears less lapse manyear plus overtime manyears. |
| Note 7: This matrix may be completed jointly by the prime and each subcontractor. Due to the proprietary nature of this data, a subcontractor may opt to submit their portion of this data directly to the contracting officer in lieu of submitting through it's prime contractor. |
| INSTRUCTIONS: |
| This spreadsheet is a tool used by the USAF to have offerors provide their Full Time Equivalent (FTE) and part time (PT) personnel. The USAF will use these numbers to determine what FTE and PT manning levels the offerors are proposing. |
| DEFINITIONS |
| Applies to technical proposal and should not affect cost summaries previously submitted |
Direct Labor: Direct labor involves those tasks that are readily identifiable with a work center's specific product or service. For example, fuels distribution or vehicle maintenance. Supervision of direct labor tasks is considered direct labor when direct labor encompasses fifty percent or more of the tasks.
Indirect Labor - Indirect labor involves those tasks that are not readily identifiable with a work center's specific product or service. The major categories of standard indirect work are: Directs work center activity, provides administrative support; prepares for and conducts/attends meetings; performs planning and scheduling; maintains system and equipment status, configuration, usage, location and historical records; administers training, quality, budget, data collection and analysis programs, manages supplies and tools, monitors and coordinates work center production, and performs clean-up, Supervision of indirect tasks is considered indirect labor when indirect labor encompasses fifty percent or more of the tasks.
LAPSE MANYEARS: The lapse rate factor is comprised of pricing/manning figures to compensate for personnel turnover, excess sick leave, etc. Basically, it is the timeframe from when a job is vacated up until a trained replacement is back in the position. Note: A zero lapse rate is unrealistic since it assumes that no employee will quit, retire, die or require excess sick leave or annual leave without a trained replacement being in place.
OVERHEAD Labor: Work and tasks related to overall management of both support and production activities. This category includes staff support activities, (for example human resource, contract management and overhead administration). Work is considered overhead when tasks encompasses fifty percent or more of management tasks. Overhead labor refers to on-site management overhead only.
File details come from the government source that posted it. Updated .