Sample_-_Vance_CLIN_10_Revised_6_Feb_14.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- Vance AFB Base Operations Support Federal contract opportunity
- Solicitation number
- FA3002-13-R-0011
About this file
Sample - Vance CLIN 10 Revised 6 Feb 14
View the file
Other files for this federal contract opportunity
Show all 50
Vance AFB Base Operations Support has more files on GovTribe.
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
Vance Cost Estimate
| Productive Hour | |||||||||||
| TABLE 1 | 1892 | ||||||||||
| Total | 29% | 6.68% | 4.50% | ||||||||
| Labor Category | FTEs | HR/Rate | Labor-Hours | Direct Labor | Fringe | Subtotal | G&A | Fee | Total | TIER |
| CLIN | |||||||||||
| ENTOMOLOGY | 6.443 | 9.75 | 12,191 | $118,862 | $34,470 | $153,332 | $10,243 | $7,361 | X010 | $170,936 | 1 |
| ENTOMOLOGY | 6.188 | 9.75 | 11,708 | $114,150 | $33,104 | $147,254 | $9,837 | $7,069 | X010 | $164,159 | 2 |
| ENTOMOLOGY | 6.160 | 9.75 | 11,654 | $113,627 | $32,952 | $146,578 | $9,791 | $7,037 | X010 | $163,406 | 3 |
| ENTOMOLOGY | 4.722 | 9.75 | 8,934 | $87,105 | $25,260 | $112,365 | $7,506 | $5,394 | X010 | $125,265 | 4 |
| ENTOMOLOGY | 2.140 | 9.75 | 4,048 | $39,468 | $11,446 | $50,914 | $3,401 | $2,444 | X010 | $56,759 | 5 |
Average Hours Operations Indirect Man-hours RWP # Task/Hrs. Emergency # of/Hrs. Urgent # of/Hrs. Routine # of/Hrs. Work Order # of/Hrs. Other Operations: Exercises, Special Events, Disaster… # of/Hrs.
ENTOMOLOGY N/A 7868/2465 81/119 431/927 24501/ 8143 10/537 N/A
| TABLE 2 | |
| Legacy Classification | NexGen |
| RWP Hours | 2465 | 2A | 100% | Tier 5 | |
| Emergency Hours | 119 | 1 | 100% | Tier 5 | |
| Urgent Hours | 927 | 3A | 100% | Tier 5 | |
| Routine Hours | 8143 | 4885.8 | 3B | 60% of the Routine Hours | Tier 3 + Work Performed in Tiers 4 and 5 |
| 3257.2 | 3C | 40% of the Routine Hours | Tier 4 + Work Performed in Tier 5 | ||
| Work order | 537 | 483.3 | 4B | 90% of the Work Order Hours | Tier 1 + Work performed in 2, 3, 4 and 5 |
| 53.7 | 4A | 10% of the Work order Hours | Tier 2 + Work Performed in Tiers 3, 4 and 5 |
| Average | 12191 |
| Step 1 | Define the Government entomology requirements by reading and understanding PWS section 11-1 |
| Step 2 | Define the Government annual workload average for entomology use hours provide in PWS 11-B |
| Step 3 | Re-classify Legacy historical workload into NexGen workload classification by using the Legacy to NexGen Bridging Table located in PWS Para. 11.3.2.2 and Technical Library. Example table 2 above. |
| Step 4 | Calculate the total labor cost for 100% of the entomology requirements 23,403 hours; this is tier 1( See Table 1 E8) |
| Step 5 | Calculate the total labor cost for tier 2 entomology requirements 23,403 hours minus 4B hours ( Enter results in Table 1 E9) 23,403-483.3 hours ( 483.3 equals 90% of total Work Order hours from workload table in 11-B) |
| Step 6 | Calculate the total labor cost for tier 3 entomology requirements 23,403 hours minus 4B and 4A hours ( See Table 1) 23,403-537 hours ( 537 equals 100% of Work Order hours from workload table in 11-B, this includes hours from 4A (10% of the Work Order hours) and 4B (90% of the Work Order hours). Enter results in Table 1 E10 |
| Step 7 | Calculate the total labor cost for tier 4 entomology requirements 23,403 hours minus 4B and 4A hours and 3C 3257.2 ( See Table 2) 23,403-537 hours ( 537 equals 100% of Work Order hours and 3C 3257.2 (40% of the total Routine from workload table in 11-B. Enter results in Table 1 E11 |
| Step 8 | Calculate the total labor cost for tier 5 entomology requirements 23,403 hours minus 4B and 4A hours and 3C 3257.2 (40% of the total Routine hours and 3B 4885.8 (60% of the total Routine hours) ( See Table 2) 23,403-537 hours ( 537 equals 100% of Work Order hours and 8143 hours 100% Routine hours from workload table in 11-B. Enter results in Table 1 E12 |
| Step 9 | There will be NO deferred Reoccurring Maintenance (RWP) Predictive Maintenance 2A at any of the tiers, therefore there is no reduction of labor hours for this category |
| Step 10 | Calculate the RWP labor hour by utilizing the 7115, MAS and the associated requirements lised in the PWS, (all provided by the Governement) and verified by the historical workload provided. The Offerors should apply their own technical approach, skill cross utilization to reduce labor hours, time or cost. |
| Step 11 | Calculate any efficiencies gain or loss at each tier and apply to each tier total price. Identify all efficiencies gain or loss so they may be validated during proposal evaluation. |
File details come from the government source that posted it. Updated .