MFSS_IIA_-_Cost_Template.xlsx
XLSX spreadsheet 62 KB Posted
- Solicitation number
- W912DY-17-R-0028
About this file
This cost template and solicitation provide details for the Medical Facilities Support Services IIa (MFSS IIa) contract opportunity with the Department of the Army Corps of Engineers Engineering Support Center Huntsville. The template outlines estimated labor hours and rates for project management, quality verification, and functional specialist positions over a base period of 24 months plus four 1-year option periods and a potential 6-month extension. It also includes not-to-exceed amounts for travel and contract manpower reporting. The solicitation removes previous requirements for key personnel and provides an Excel version of the cost template. All other opportunity requirements remain the same. This represents a follow-on contract to continue providing support services at medical facilities.
Excel version of cost template.
View the file
Other files
Show all 12
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
Calc from Summary
COST ESTIMATE SUMMARY
| PROJECT: | ERROR:#REF! |
| CONTRACT # | TBD |
Description Quantity U/M Total Cost
| BASE PERIOD | ||||||||||
| PROJECT MANAGEMENT II | 115000 | HRS | $ - 0 | 0.185483871 | 0.1630391697 | 90000 | 45000 | 44000 | 43000 | |
| PROJECT MANAGEMENT I | 100000 | HRS | $ - 0 | 0.1612903226 | 0.1592552753 | 88000 | 44000 | 43000 | 42000 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE II | 70000 | HRS | $ - 0 | 0.1129032258 | 0.1131957156 | 63000 | 31000 | 30000 | 29000 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE I | 100000 | HRS | $ - 0 | 0.1612903226 | 0.1592552753 | 88000 | 44000 | 43000 | 42000 | |
| FUNCTIONAL SPECIALIST III | 55000 | HRS | $ - 0 | 0.0887096774 | 0.1072732189 | 59000 | 29000 | 28000 | 27000 | |
| FUNCTIONAL SPECIALIST II | 80000 | HRS | $ - 0 | 0.1290322581 | 0.1363909557 | 75000 | 37000 | 36000 | 35000 | |
| FUNCTIONAL SPECIALIST I | 100000 | HRS | $ - 0 | 0.1612903226 | 0.1615903895 | 89000 | 44000 | 43000 | 42000 | |
| ERROR:#VALUE! | ||||||||||
| Total | 620000 | $ - 0 | 1 | |||||||
| OPTION YEAR 1 | ||||||||||
| ERROR:#REF! | 52500 | HRS | ERROR:#REF! | 0.175 | ||||||
| ERROR:#REF! | 50000 | HRS | ERROR:#REF! | 0.1666666667 | ||||||
| ERROR:#REF! | 35000 | HRS | ERROR:#REF! | 0.1166666667 | ||||||
| ERROR:#REF! | 50000 | HRS | ERROR:#REF! | 0.1666666667 | ||||||
| ERROR:#REF! | 30000 | HRS | ERROR:#REF! | 0.1 | ||||||
| ERROR:#REF! | 40000 | HRS | ERROR:#REF! | 0.1333333333 | ||||||
| ERROR:#REF! | 42500 | HRS | ERROR:#REF! | 0.1416666667 | ||||||
| Total | 300000 | ERROR:#REF! | ||||||||
| OPTION YEAR 2 | ||||||||||
| ERROR:#REF! | 45000 | HRS | ERROR:#REF! | 0.1525423729 | ||||||
| ERROR:#REF! | 45000 | HRS | ERROR:#REF! | 0.1525423729 | ||||||
| ERROR:#REF! | 32500 | HRS | ERROR:#REF! | 0.1101694915 | ||||||
| ERROR:#REF! | 45000 | HRS | ERROR:#REF! | 0.1525423729 | ||||||
| ERROR:#REF! | 35000 | HRS | ERROR:#REF! | 0.1186440678 | ||||||
| ERROR:#REF! | 42500 | HRS | ERROR:#REF! | 0.1440677966 | ||||||
| ERROR:#REF! | 50000 | HRS | ERROR:#REF! | 0.1694915254 | ||||||
| Total | 295000 | ERROR:#REF! | ||||||||
| OPTION YEAR 3 | ||||||||||
| ERROR:#REF! | 40000 | HRS | ERROR:#REF! | 0.1391304348 | ||||||
| ERROR:#REF! | 45000 | HRS | ERROR:#REF! | 0.1565217391 | ||||||
| ERROR:#REF! | 32500 | HRS | ERROR:#REF! | 0.1130434783 | ||||||
| ERROR:#REF! | 45000 | HRS | ERROR:#REF! | 0.1565217391 | ||||||
| ERROR:#REF! | 35000 | HRS | ERROR:#REF! | 0.1217391304 | ||||||
| ERROR:#REF! | 40000 | HRS | ERROR:#REF! | 0.1391304348 | ||||||
| ERROR:#REF! | 50000 | HRS | ERROR:#REF! | 0.1739130435 | ||||||
| Total | 287500 | ERROR:#REF! | ||||||||
| 1502500 | 300500 | 1652750 | ||||||||
| TOTAL | ERROR:#REF! | 276460 | ||||||||
| 138230 | 0.0909090909 | |||||||||
| PROJECT MANAGEMENT II | 10000 | HR | 1209320.9709 | -0.100 | ||||||
| PROJECT MANAGEMENT I | 11250 | HR | 1061024.2579125 | 0.0909090909 | ||||||
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE II | 8125 | HR | 752888.903 | |||||||
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE I | 11250 | HR | 792541.2340125 | |||||||
| FUNCTIONAL SPECIALIST III | 8750 | HR | 930894.1313 | |||||||
| FUNCTIONAL SPECIALIST II | 10000 | HR | 708087.096 | |||||||
| FUNCTIONAL SPECIALIST I | 12500 | HR | 765591.854375 | |||||||
| 150250 |
Base Period
| BASE PERIOD (24 Months) | |||
| Labor Category | Estimated Hours | Rate | TOTAL |
| PROJECT MANAGEMENT II | 90000 | $ - 0 | |
| PROJECT MANAGEMENT I | 88000 | $ - 0 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE II | 63000 | $ - 0 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE I | 88000 | $ - 0 | |
| FUNCTIONAL SPECIALIST III | 59000 | $ - 0 | |
| FUNCTIONAL SPECIALIST II | 75000 | $ - 0 | |
| FUNCTIONAL SPECIALIST I | 89000 | $ - 0 | |
| Travel (NTE) | NA | NA | $ 500,000.00 |
| Contract Manpower Reporting (CMRA) | NA | NA | NSP |
| BASE PERIOD TOTAL AMOUNT |
*Estimated hours are based on historical data
&A &F
Option Year 1
| OPTION YEAR 1 | |||
| Labor Category | Estimated Hours | Rate | TOTAL |
| PROJECT MANAGEMENT II | 45000 | $ - 0 | |
| PROJECT MANAGEMENT I | 44000 | $ - 0 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE II | 31000 | $ - 0 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE I | 44000 | $ - 0 | |
| FUNCTIONAL SPECIALIST III | 29000 | $ - 0 | |
| FUNCTIONAL SPECIALIST II | 37000 | $ - 0 | |
| FUNCTIONAL SPECIALIST I | 44000 | $ - 0 | |
| Travel (NTE) | NA | NA | $ 250,000.00 |
| Contract Manpower Reporting (CMRA) | NA | NA | NSP |
| BASE PERIOD TOTAL AMOUNT |
*Estimated hours are based on historical data
&A &F
Option Year 2
| OPTION YEAR 2 | |||
| Labor Category | Estimated Hours | Rate | TOTAL |
| PROJECT MANAGEMENT II | 44000 | $ - 0 | |
| PROJECT MANAGEMENT I | 43000 | $ - 0 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE II | 30000 | $ - 0 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE I | 43000 | $ - 0 | |
| FUNCTIONAL SPECIALIST III | 28000 | $ - 0 | |
| FUNCTIONAL SPECIALIST II | 36000 | $ - 0 | |
| FUNCTIONAL SPECIALIST I | 43000 | $ - 0 | |
| Travel (NTE) | NA | NA | $ 250,000.00 |
| Contract Manpower Reporting (CMRA) | NA | NA | NSP |
| BASE PERIOD TOTAL AMOUNT |
*Estimated hours are based on historical data
&A &F
Option Year 3
| OPTION YEAR 3 | |||
| Labor Category | Estimated Hours | Rate | TOTAL |
| PROJECT MANAGEMENT II | 43000 | $ - 0 | |
| PROJECT MANAGEMENT I | 42000 | $ - 0 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE II | 29000 | $ - 0 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE I | 42000 | $ - 0 | |
| FUNCTIONAL SPECIALIST III | 27000 | $ - 0 | |
| FUNCTIONAL SPECIALIST II | 35000 | $ - 0 | |
| FUNCTIONAL SPECIALIST I | 42000 | $ - 0 | |
| Travel (NTE) | NA | NA | $ 250,000.00 |
| Contract Manpower Reporting (CMRA) | NA | NA | NSP |
| BASE PERIOD TOTAL AMOUNT |
*Estimated hours are based on historical data
&A &F
Six Month Extension
| SIX MONTH EXTENSION | |||
| Labor Category | Estimated Hours | Rate | TOTAL |
| PROJECT MANAGEMENT II | 21500 | $ - 0 | |
| PROJECT MANAGEMENT I | 21000 | $ - 0 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE II | 14500 | $ - 0 | |
| QUANTITY VERIFICATION & ANALYSIS REPRESENATIVE I | 21000 | $ - 0 | |
| FUNCTIONAL SPECIALIST III | 13500 | $ - 0 | |
| FUNCTIONAL SPECIALIST II | 17500 | $ - 0 | |
| FUNCTIONAL SPECIALIST I | 21000 | $ - 0 | |
| Travel (NTE) | NA | NA | $ 125,000.00 |
| Contract Manpower Reporting (CMRA) | NA | NA | NSP |
| BASE PERIOD TOTAL AMOUNT |
*Estimated hours are based on historical data
&A &F
File details come from the government source that posted it. Updated .