Sample_-_Maxwell_CLIN_X016.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- Maxwell-Gunter BOS Federal contract opportunity
- Solicitation number
- FA300213R0012
About this file
Sample - Maxwell CLIN X016
View the file
Other files for this federal contract opportunity
Show all 50
Maxwell-Gunter BOS 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
Maxwell Cost Estimate
| ***ALL NUMBERS AND VALUES ARE NOTIONAL FOR ILLUSTRATION PURPOSES ONLY*** | |||||||||||
| 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 | 12.369 | 9.75 | 23,403 | $228,179 | $66,172 | $294,351 | $19,663 | $14,131 | X016 | $328,145 | 1 |
| ENTOMOLOGY | 12.114 | 9.75 | 22,920 | $223,467 | $64,805 | $288,273 | $19,257 | $13,839 | X016 | $321,368 | 2 |
| ENTOMOLOGY | 12.086 | 9.75 | 22,866 | $222,944 | $64,654 | $287,597 | $19,211 | $13,806 | X016 | $320,615 | 3 |
| ENTOMOLOGY | 10.648 | 9.75 | 20,146 | $196,422 | $56,962 | $253,384 | $16,926 | $12,164 | X016 | $282,474 | 4 |
| ENTOMOLOGY | 8.066 | 9.75 | 15,260 | $148,785 | $43,148 | $191,933 | $12,821 | $9,214 | X016 | $213,968 | 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 4000 7868/2465 81/119 431/927 24501/ 8143 10/537 7212
| TABLE 2 | |||||
| Legacy Classification | NexGen | ||||
| Indirect hours | 4000 | 100% | Tier 5 | ||
| 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 2 + Work Performed in Tiers 3, 4 and 5 |
| 53.7 | 4A | 10% of the Work order Hours | Tier 1 + Work performed in 2, 3, 4 and 5 | ||
| Other Operations | 7212 | 100% | Tier 5 | ||
| Average | 23403 | ||||
| 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 .