Attachment 0008 - Pricing Sheet.xlsx
XLSX spreadsheet 153 KB Posted
- Solicitation number
- RFP_W911QY26RA007_MaterielFielding_MedicalLiaisonSupportServices
About this file
This is a pricing sheet for contract W911QY26RA007, which covers Materiel Fielding and Medical Liaison Support Services for the Army. The sheet establishes labor categories, direct labor hours, and fully loaded hourly rates across multiple fiscal years, with pricing organized into baseline support and surge support sections. The baseline support section includes 39 total personnel across 18 labor categories, predominantly comprised of Logistics Analysts at various levels (I-IV), with additional positions including Program Manager, Management Analyst, and Administrative Assistant roles. Key personnel are designated across multiple military installations including Fort Detrick, Fort Carson, Fort Hood, Fort Bragg, Fort Campbell, Joint Base Lewis-McChord, and overseas locations in Germany and Alaska. The baseline support pricing covers a six-month period with consistent costs of $405,000 per period across the base year and option years, with reduced costs of $231,000 for the partial option year, totaling $2,256,000 for baseline support.
The surge support section provides additional capacity with 22 total personnel (11 Logistics Analysts II and 1 Logistics Analyst III split across two six-month periods), generating $420,000 in total costs across all option years. Both baseline and surge sections include provisions for travel and other direct costs, with travel budgeted at $385,000 for baseline and $25,000 per six-month period for surge, and supplies budgeted at $20,000 for baseline and $10,000 for surge. The pricing sheet includes a task pivot table detailing personnel allocation across multiple organizational divisions (ICS, PM AD, PM ILS, PM MOD, BSO, CM3, DOC, FPD, FSD, IMD, M3D, OPS, PAO, PM MEDVAC, and PPAE) and geographical duty locations. The total evaluated price across all services is $2,676,000. The sheet also references an Independent Government Cost Estimate (IGCE) for immediate requirements with labor categories, hourly rates, and estimated costs with escalation factors of 3.5% annually.
View the file
Other files
Show all 24
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
Pricing Sheet - W911QY26RA007
| BASELINE SUPPORT | The Government provides Plug Numbers for Travel, ODCs, Surge Travel and Surge ODCs CLINs. | Apr-26 | Apr-27 | Apr-28 | Apr-29 | Apr-30 | Apr-31 | |||||
| NOTE: (***) means Key Personnel | ||||||||||||
| FSD Labor Category | Personnel | Direct Labor Hours | Fully Loaded Hourly Rate | |||||||||
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | 52.217-8 Pricing (6 month pricing) | Proposed Total | Location | |||||
| *** Program Manager, Materiel Fielding - CTM | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick (Non-Travel) | ||
| *** Management Analyst-Middle, Materiel Fielding | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick | ||
| *** Logistics Analyst IV Logistics Assistance Representative, Medical Liaison Support (LNO) | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Carson | ||
| *** Logistics Analyst IV Logistics Assistance Representative, Medical Liaison Support (LNO) | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Hood | ||
| *** Logistics Analyst IV Logistics Assistance Representative, Medical Liaison Support (LNO) | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick (Non-Travel) | ||
| *** Logistics Analyst IV Logistics Assistance Representative, Medical Liaison Support (LNO) | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | JB Lewis-McChord | ||
| *** Logistics Analyst IV Logistics Assistance Representative, Medical Liaison Support (LNO) | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Bragg | ||
| *** Logistics Analyst IV Logistics Assistance Representative, Medical Liaison Support (LNO) | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Campbell | ||
| *** Logistics Analyst IV Logistics Assistance Representative, Medical Liaison Support (LNO) | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Germany | ||
| *** Logistics Analyst IV Logistics Assistance Representative, Medical Liaison Support (LNO) | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | JB Elmendorf-Richardson | ||
| *** Logistics Analyst IV Medical Liaison Support (LNO) Systems Analyst | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick | ||
| *** Logistics Analyst III, Materiel Fielding Coordinator | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick (Non-Travel) | ||
| Logistics Analyst III, Materiel Fielding/Transportation Coordinator | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick (Non-Travel) | ||
| Logistics Analyst III, Materiel Fielding Scheduler | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick (Non-Travel) | ||
| Logistics Analyst III, Materiel Fielding (Regional Manager Support) | 5 | 9,400 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick (Non-Travel) | ||
| Logistics Analyst III, Materiel Fielding | 5 | 9,400 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick | ||
| Logistics Analyst II, Materiel Fielding | 14 | 26,320 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick | ||
| Administrative Assistant-Junior, Materiel Fielding | 1 | 1,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Ft. Detrick | ||
| Total Direct Labor: | 39 | 73320 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Travel- FSD (Plug Numbers Provided) | $ 385,000.00 | $ 385,000.00 | $ 385,000.00 | $ 385,000.00 | $ 385,000.00 | $ 220,000.00 | $ 2,145,000.00 | |||||
| Other Direct Costs - Supplies (Plug Numbers Provided) | $ 20,000.00 | $ 20,000.00 | $ 20,000.00 | $ 20,000.00 | $ 20,000.00 | $ 11,000.00 | $ 111,000.00 | |||||
| Total: | $ 405,000.00 | $ 405,000.00 | $ 405,000.00 | $ 405,000.00 | $ 405,000.00 | $ 231,000.00 | $ 2,256,000.00 |
| SURGE | Jul-25 | Jul-26 | Jul-27 | Jul-28 | Jul-29 | |||||||
| FSD Labor Category | Personnel | Direct Labor Hours | Fully Loaded Hourly Rate | |||||||||
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | -8 Pricing (6 month pricing) | Proposed Total | Location | |||||
| Logistics Analyst II (Fielding) Part 1, 6 month period | 10 | 9,400 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Non-specified | ||
| Logistics Analyst III (Fielding) Part 1, 6 month period | 1 | 940 | $ - 0 | $ - 0 | $- | $- | $- | $- | $ - 0 | Non-specified | ||
| Part 1 Total Labor | 11 | 10,340 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Logistics Analyst II (Fielding) Part 2, 6 month period | 10 | 9,400 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Non-specified | ||
| Logistics Analyst III (Fielding) Part 2, 6 month period | 1 | 940 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Non-specified | ||
| Part 2 Total Labor | 11 | 10,340 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total Direct Labor: | 11 | 20,680 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Travel- FSD, Part 1 (Plug Numbers Provided) | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 150,000.00 | |||||
| Other Direct Costs - Supplies, Part 1 (Plug Numbers Provided) | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 60,000.00 | |||||
| Part 1 Total Travel and ODCs | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ 210,000.00 | |||||
| Travel- FSD, Part 2 (Plug Numbers Provided) | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 25,000.00 | $ 150,000.00 | |||||
| Other Direct Costs - Supplies, Part 2 (Plug Numbers Provided) | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 60,000.00 | |||||
| Part 2 Total Travel and ODCs | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ 210,000.00 | |||||
| Total Travel and ODCs: | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 420,000.00 | |||||
| Total Surge for Complete Year: | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 420,000.00 |
Total Evaluated Price: $ 2,676,000.00
TASK PIVOT
| Count of B OR S | Column Labels | |||||||||||||||||
| Row Labels | BSO | CM3 | DOC | FPD | FSD | ICS | IMD | M3D | OPS | PAO | PM AD | PM ILS | PM MEDVAC | PMMD MOD | PMMD MOD | PPAE | (blank) | Grand Total |
| Acquisition Analyst II | 1 | 1 | ||||||||||||||||
| Admin Specialist | 1 | 1 | ||||||||||||||||
| Administrative Assiistant | 1 | 1 | ||||||||||||||||
| Administrative Assistant I | 1 | 1 | ||||||||||||||||
| Administrative Assistant Level II Services | 1 | 1 | ||||||||||||||||
| Administrative Assistant Level III Services | 1 | 1 | ||||||||||||||||
| Biomedical Engineer | 1 | 1 | 2 | 4 | ||||||||||||||
| Biomedical Engineer | 1 | 1 | ||||||||||||||||
| Biomedical Engineer 2 | 1 | 1 | ||||||||||||||||
| Biomedical Engineer II | 1 | 1 | ||||||||||||||||
| Biomedical Engineer II (1) (Publication Svc) | 1 | 1 | ||||||||||||||||
| Biomedical Equipment Technician II | 1 | 1 | ||||||||||||||||
| Biomedical Equipment Technician III | 1 | 1 | ||||||||||||||||
| Biomedical Equipment Technician IV | 1 | 1 | ||||||||||||||||
| Configuration & Data Management Analyst I | 1 | 1 | ||||||||||||||||
| Customer Service Representative II | 2 | 2 | ||||||||||||||||
| Customer Service Representative III | 1 | 1 | ||||||||||||||||
| Cybersecurity Speicalist | 1 | 1 | ||||||||||||||||
| Cybersecurity Speicalist II | 1 | 1 | ||||||||||||||||
| Cybersecurity Speicalist III | 1 | 1 | ||||||||||||||||
| Data Analyst | 2 | 2 | ||||||||||||||||
| Database Analyst/Programmer Senior | 2 | 2 | ||||||||||||||||
| Database Developer | 2 | 2 | ||||||||||||||||
| Database Support Administrator | 1 | 1 | ||||||||||||||||
| Equipment Specialist - Biomedical | 1 | 1 | 2 | |||||||||||||||
| Financial Analyst | 1 | 1 | 2 | |||||||||||||||
| Force Integration/RESET Analyst IV | 1 | 1 | ||||||||||||||||
| Healthcare Specialist ii (1) | 2 | 2 | ||||||||||||||||
| Informatics Physician | 1 | 1 | ||||||||||||||||
| Instructional Designer and Support Analyst | 1 | 1 | ||||||||||||||||
| Item Manager (2) | 1 | 1 | ||||||||||||||||
| Item Manager and Sourcing Specialist (2) | 1 | 1 | ||||||||||||||||
| Lead Biomedical Equipment Technician III | 1 | 1 | ||||||||||||||||
| Liaison Officer (LNO) Services | 1 | 1 | ||||||||||||||||
| Logistics Analyst I x1 (DETRICK) | 1 | 1 | 2 | |||||||||||||||
| Logistics Analyst I x4 (SIERRA) | 1 | 1 | 2 | |||||||||||||||
| Logistics Analyst II (4) | 1 | 1 | ||||||||||||||||
| Logistics Analyst III | 1 | 1 | ||||||||||||||||
| Medical/Scientific Writer/Editor I | 1 | 1 | ||||||||||||||||
| Nuclear Physicist 4 | 1 | 1 | ||||||||||||||||
| Operations / Desk Officer | 2 | 2 | ||||||||||||||||
| Procurement Specialist II | 2 | 2 | ||||||||||||||||
| Program Analyst | 2 | 2 | ||||||||||||||||
| Program Analyst (Senior Flight Paramedic) | 1 | 1 | ||||||||||||||||
| Program Logistics Manager | 2 | 2 | ||||||||||||||||
| Program Management Analyst | 1 | 1 | ||||||||||||||||
| Program Manager | 1 | 1 | ||||||||||||||||
| Program Manager/Logistics Analyst III | 1 | 1 | ||||||||||||||||
| Programmer/ Analyst II | 2 | 2 | ||||||||||||||||
| Project Analyst I | 1 | 1 | ||||||||||||||||
| Project Analyst I (3) | 1 | 1 | ||||||||||||||||
| Project Analyst II | 1 | 1 | ||||||||||||||||
| Project Analyst II (2) | 1 | 1 | ||||||||||||||||
| Project Manager | 3 | 1 | 1 | 5 | ||||||||||||||
| Project Manager Services | 1 | 1 | ||||||||||||||||
| Project Manager/Manager | 1 | 1 | ||||||||||||||||
| Project Scientist - Emergency Medicine/Paramedic | 1 | 1 | ||||||||||||||||
| Project Scientist - Neuroscience | 1 | 1 | ||||||||||||||||
| Project Scientist - Physiologist | 1 | 1 | ||||||||||||||||
| Project Scientist - Radiology | 1 | 1 | ||||||||||||||||
| Project Scientist - Surgical Nurse | 1 | 1 | ||||||||||||||||
| Quality Assurance Specialist III | 1 | 1 | ||||||||||||||||
| Scientific Writer II | 1 | 1 | ||||||||||||||||
| Senior Business Analyst | 1 | 1 | ||||||||||||||||
| Senior Business Analyst IV | 2 | 2 | ||||||||||||||||
| Senior Business Analyst V | 2 | 2 | ||||||||||||||||
| Senior Logistics Analyst | 1 | 1 | ||||||||||||||||
| Senior Radiological Control Manager | 2 | 2 | ||||||||||||||||
| Senior Test Engineer | 1 | 1 | ||||||||||||||||
| SharePoint Developer | 2 | 2 | ||||||||||||||||
| Strategic Planner | 1 | 1 | ||||||||||||||||
| Subject Matter Expert (Functional-IMSPS) II | 1 | 1 | ||||||||||||||||
| Subject Matter Expert DMLSS Customer Assistance Module (DCAM) | 1 | 1 | ||||||||||||||||
| Subject Matter Expert Global Combat Support System – Army (GCSS-A) | 1 | 1 | ||||||||||||||||
| Subject Matter Expert SAP Material Management (MM) | 1 | 1 | ||||||||||||||||
| Subject Matter Expert SAP Plant Maintenance (PM) | 1 | 1 | ||||||||||||||||
| Subject Matter Expert SAP Sales and Distribution (SD) | 1 | 1 | ||||||||||||||||
| Subject Matter Expert SAP Warehouse Management (WM) | 1 | 1 | ||||||||||||||||
| Supply Management Analyst (1) (Publication Svc) | 1 | 1 | ||||||||||||||||
| System Engineer | 2 | 2 | ||||||||||||||||
| Technical Writer (1) (Publication Svc) | 1 | 1 | ||||||||||||||||
| Technical Writer (terri pull over) | 1 | 1 | ||||||||||||||||
| Test Engineer | 1 | 1 | ||||||||||||||||
| Theater Enterprise-Wide Logistics System (TEWLS)/SAP Analysis | 1 | 1 | ||||||||||||||||
| Trainer Supply Chain / SAP | 1 | 1 | ||||||||||||||||
| Transportation Specialist II | 1 | 1 | ||||||||||||||||
| Visual Information Specialist | 1 | 1 | ||||||||||||||||
| Web Applications Developer | 2 | 2 | ||||||||||||||||
| Writer-editor | 1 | 1 | ||||||||||||||||
| (blank) | ||||||||||||||||||
| Grand Total | 8 | 5 | 5 | 2 | 2 | 18 | 6 | 9 | 2 | 2 | 17 | 11 | 14 | 4 | 3 | 8 | 116 |
Total Tasks
| TASK | ORG | B OR S |
| Database Analyst/Programmer Senior | ICS | S |
| Biomedical Engineer | ICS | S |
| Cybersecurity Speicalist | ICS | S |
| Biomedical Engineer 2 | ICS | S |
| Senior Radiological Control Manager | ICS | S |
| Programmer/ Analyst II | ICS | S |
| Senior Radiological Control Manager | ICS | S |
| Nuclear Physicist 4 | ICS | S |
| Medical/Scientific Writer/Editor I | ICS | S |
| Informatics Physician | ICS | S |
| Programmer/ Analyst II | ICS | S |
| Configuration & Data Management Analyst I | ICS | S |
| Biomedical Engineer | ICS | S |
| Database Analyst/Programmer Senior | ICS | S |
| Administrative Assiistant | PM AD | S |
| Project Analyst I | PM AD | S |
| Biomedical Engineer II | PM AD | S |
| Project Analyst II | PM AD | S |
| Project Scientist - Radiology | PM AD | S |
| Project Manager/Manager | PM AD | S |
| Scientific Writer II | PM AD | S |
| Healthcare Specialist ii (1) | PM ILS | S |
| Data Analyst | PM ILS | S |
| Program Logistics Manager | PM ILS | S |
| Item Manager and Sourcing Specialist (2) | PM ILS | S |
| Project Manager | PMMD MOD | S |
| Equipment Specialist - Biomedical | PMMD MOD | S |
| Financial Analyst | PMMD MOD | S |
| Test Engineer | PMMD MOD | S |
| Instructional Designer and Support Analyst | BSO | S |
| Subject Matter Expert SAP Material Management (MM) | BSO | S |
| Subject Matter Expert SAP Sales and Distribution (SD) | BSO | S |
| Subject Matter Expert SAP Warehouse Management (WM) | BSO | S |
| Subject Matter Expert SAP Plant Maintenance (PM) | BSO | S |
| Trainer Supply Chain / SAP | BSO | S |
| Subject Matter Expert DMLSS Customer Assistance Module (DCAM) | BSO | S |
| Subject Matter Expert Global Combat Support System – Army (GCSS-A) | BSO | S |
| Procurement Specialist II | CM3 | S |
| Customer Service Representative II | CM3 | S |
| Database Support Administrator | DOC | S |
| Program Manager/Logistics Analyst III | DOC | S |
| Logistics Analyst III | DOC | S |
| Logistics Analyst II (4) | DOC | S |
| Administrative Assistant I | DOC | S |
| Logistics Analyst I x1 (DETRICK) | FPD | S |
| Logistics Analyst I x4 (SIERRA) | FPD | S |
| Logistics Analyst I x1 (DETRICK) | FSD | S |
| Logistics Analyst I x4 (SIERRA) | FSD | S |
| Web Applications Developer | IMD | S |
| Database Developer | IMD | S |
| SharePoint Developer | IMD | S |
| Biomedical Equipment Technician II | M3D | S |
| Biomedical Equipment Technician III | M3D | S |
| Lead Biomedical Equipment Technician III | M3D | S |
| Biomedical Equipment Technician IV | M3D | S |
| Administrative Assistant Level II Services | M3D | S |
| Administrative Assistant Level III Services | M3D | S |
| Project Manager Services | M3D | S |
| Theater Enterprise-Wide Logistics System (TEWLS)/SAP Analysis | M3D | S |
| Liaison Officer (LNO) Services | M3D | S |
| Operations / Desk Officer | OPS | S |
| Visual Information Specialist | PAO | S |
| System Engineer | PM MEDVAC | S |
| Biomedical Engineer | PM MEDVAC | S |
| Project Manager | PM MEDVAC | S |
| Program Analyst | PM MEDVAC | S |
| Program Analyst (Senior Flight Paramedic) | PM MEDVAC | S |
| Senior Test Engineer | PM MEDVAC | S |
| Senior Business Analyst V | PPAE | S |
| Senior Business Analyst IV | PPAE | S |
| Quality Assurance Specialist III | PPAE | S |
| Transportation Specialist II | PPAE | S |
| Strategic Planner | PPAE | S |
| Force Integration/RESET Analyst IV | PPAE | S |
| Cybersecurity Speicalist III | ICS | B |
| Cybersecurity Speicalist II | ICS | B |
| Admin Specialist | ICS | B |
| Program Management Analyst | ICS | B |
| Financial Analyst | PM AD | B |
| Biomedical Engineer | PM AD | B |
| Project Scientist - Physiologist | PM AD | B |
| Project Scientist - Neuroscience | PM AD | B |
| Project Scientist - Emergency Medicine/Paramedic | PM AD | B |
| Project Scientist - Surgical Nurse | PM AD | B |
| Subject Matter Expert (Functional-IMSPS) II | PM AD | B |
| Acquisition Analyst II | PM AD | B |
| Project Analyst I (3) | PM AD | B |
| Project Analyst II (2) | PM AD | B |
| Biomedical Engineer II (1) (Publication Svc) | PM ILS | B |
| Supply Management Analyst (1) (Publication Svc) | PM ILS | B |
| Technical Writer (1) (Publication Svc) | PM ILS | B |
| Healthcare Specialist ii (1) | PM ILS | B |
| Data Analyst | PM ILS | B |
| Program Logistics Manager | PM ILS | B |
| Item Manager (2) | PM ILS | B |
| Technical Writer (terri pull over) | PMMD MOD | B |
| Equipment Specialist - Biomedical | PMMD MOD | B |
| Project Manager | PMMD MOD | B |
| Procurement Specialist II | CM3 | B |
| Customer Service Representative II | CM3 | B |
| Customer Service Representative III | CM3 | B |
| Web Applications Developer | IMD | B |
| Database Developer | IMD | B |
| SharePoint Developer | IMD | B |
| Operations / Desk Officer | OPS | B |
| Writer-editor | PAO | B |
| Program Manager | PM MEDVAC | B |
| System Engineer | PM MEDVAC | B |
| Biomedical Engineer | PM MEDVAC | B |
| Project Manager | PM MEDVAC | B |
| Project Manager | PM MEDVAC | B |
| Program Analyst | PM MEDVAC | B |
| Senior Business Analyst | PM MEDVAC | B |
| Senior Logistics Analyst | PM MEDVAC | B |
| Senior Business Analyst V | PPAE | B |
| Senior Business Analyst IV | PPAE | B |
Sheet6
| Row Labels | DUTY LOCATION | Sum of NO | on | off | |
| BSO | FLORIDA | 1 | BSO | 3 | 1 |
| FT. DETRICK | 3 | DOC | 6 | 0 | |
| DOC | FT. DETRICK | 6 | FPD | 1 | 2 |
| FPD | FT. DETRICK | 1 | FSD | 8 | 25 |
| SIERRA | 2 | M3D | 9 | 71 | |
| FSD | FT. BRAGG | 1 | MED-DEV | 15 | |
| FT. CAMPBELL | 1 | MED-DEV HANDBOOK | 2 | ||
| FT. CARSON | 1 | PM-ICS | 8 | ||
| FT. DETRICK | 8 | medevac | 6 | ||
| FT. HOOD | 1 | 58 | 99 | ||
| JOINT BASE LEWIS MCCHORD | 1 | ||||
| MORGANTOWN, WV | 20 | ||||
| M3D | FT. DETRICK | 9 | |||
| HILL | 26 | ||||
| SIERRA | 9 | ||||
| TOBYHANNA | 10 | ||||
| TRACY | 26 | ||||
| MED-DEV | FT. DETRICK | 15 | |||
| MED-DEV HANDBOOK | FT. DETRICK | 2 | |||
| PM-ICS | FT. DETRICK | 8 | |||
| TELEMEDICINE | FT. DETRICK | 6 |
IGCE for Immediate Req
| Dec-17 | Dec-18 | Sep-19 | ||||||
| PMMD AD Labor Category | PASS Task Equivilant | Direct Labor Hours | Fully Loaded Hourly Rate | Estimated Costs | ||||
| Base Year | Year 2 [3.5%] | Year 3 [3.5%] | Estimated Total | |||||
| Analyst | 1880 | $85 | $ 159,800.00 | $ 165,393.00 | $ 171,181.76 | $ 496,374.76 | ||
| Biomedical Engineer IV - MD | 3760 | $68 | $ 261,120.00 | $ 270,259.20 | $ 279,718.27 | $ 811,097.47 | ||
| Clinical Trials Nurse | 1880 | $95 | $ 178,600.00 | $ 184,851.00 | $ 191,320.79 | $ 554,771.79 | ||
| Help Desk Specialist | 1880 | $113 | $ 212,440.00 | $ 219,875.40 | $ 227,571.04 | $ 659,886.44 | ||
| Log Analyst III | 1880 | $120 | $ 225,299.20 | $ 233,184.67 | $ 241,346.14 | $ 699,830.01 | ||
| Log Analyst IV | 5640 | $91 | $ 341,370.40 | $ 353,318.36 | $ 365,684.51 | $ 1,060,373.27 | ||
| Log Engineer | 1880 | $38 | $ 142,880.00 | $ 147,880.80 | $ 153,056.63 | $ 443,817.43 | ||
| Management Analyst Middle I | 1880 | $99 | $ 186,120.00 | $ 192,634.20 | $ 199,376.40 | $ 578,130.60 | ||
| Program Manager 1 | 1880 | $90 | $ 345,600.00 | $ 357,696.00 | $ 370,215.36 | $ 1,073,511.36 | ||
| Research Analyst | 3760 | $75 | $ 282,000.00 | $ 291,870.00 | $ 302,085.45 | $ 875,955.45 | ||
| Customer Service Representative II | See Bridge Requirements for Definition of task. | 1880 | $60 | $ 112,800.00 | $ 116,748.00 | $ 120,834.18 | $ 350,382.18 | |
| Customer Service Representative III | See Bridge Requirements for Definition of task. | 1880 | $66 | $ 124,080.00 | $ 128,422.80 | $ 132,917.60 | $ 385,420.40 | |
| Database Developer | See Bridge Requirements for Definition of task. | 1880 | $120 | $ 225,600.00 | $ 233,496.00 | $ 241,668.36 | $ 700,764.36 | |
| Procurement Specialist II | See Bridge Requirements for Definition of task. | 3760 | $87 | $ 654,240.00 | $ 677,138.40 | $ 700,838.24 | $ 2,032,216.64 | |
| SharePoint Developer | See Bridge Requirements for Definition of task. | 1880 | $100 | $ 188,000.00 | $ 194,580.00 | $ 201,390.30 | $ 583,970.30 | |
| Theater Enterprise-Wide Logistics System (TEWLS)/SAP Analysis | See Bridge Requirements for Definition of task. | 3760 | $103 | $ 387,280.00 | $ 398,898.40 | $ 410,865.35 | $ 1,197,043.75 | |
| Web Applications Developer | See Bridge Requirements for Definition of task. | 1880 | $115 | $ 216,200.00 | $ 223,767.00 | $ 231,598.85 | $ 671,565.85 | |
| Technical Editor | 1880 | $80 | $ 150,400.00 | $ 155,664.00 | $ 161,112.24 | $ 467,176.24 | ||
| Technical Writer I | 3760 | $91 | $ 171,080.00 | $ 177,067.80 | $ 183,265.17 | $ 531,412.97 | ||
| Total Direct Labor: | 26 | $ 4,564,909.60 | $ 4,722,745.04 | $ 4,886,046.62 | $ 9,608,791.66 | |||
| Travel | $ 30,000.00 | $ 31,050.00 | $ 32,136.75 | $ 63,186.75 | ||||
| Other Supplies | $ - 0 | |||||||
| Total: | $ 4,594,909.60 | $ 4,753,795.04 | $ 4,918,183.37 | $ 9,671,978.41 |
DFA
| Base Cost W/O 35% OH | Base Costs With 35% OH | ||||||||||||||
| 1-Jul-19 | 1-Jul-20 | 1-Jul-21 | 1-Jul-22 | 1-Jul-23 | 1-Jul-19 | 1-Jul-20 | 1-Jul-21 | 1-Jul-22 | 1-Jul-23 | ||||||
| Subject | Estimated Costs | ||||||||||||||
| Base Year | Year 2 [3.5%] | Year 3 [3.5%] | Year 4 [3.5%] | Year 5 [3.5%] | Estimated Total | Division | Estimated Costs | ||||||||
| Base Year | Year 2 [3.5%] | Year 3 [3.5%] | Year 4 [3.5%] | Year 5 [3.5%] | Estimated Total | ||||||||||
| PM ICS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ICS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| PM AD | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | PM AD | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| PM ILS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | PM ILS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| PM MOD | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | PM MOD | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| MEDEVAC | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | MEDEVAC | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Totals | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | Totals | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| SURGE SUPPORT W/O 35% OH | SURGE SUPPORT With 35% OH | ||||||||||||||
| 1-Jul-19 | 1-Jul-20 | 1-Jul-21 | 1-Jul-22 | 1-Jul-23 | 1-Jul-19 | 1-Jul-20 | 1-Jul-21 | 1-Jul-22 | 1-Jul-23 | ||||||
| Subject | Estimated Costs | ||||||||||||||
| Base Year | Year 2 [3.5%] | Year 3 [3.5%] | Year 4 [3.5%] | Year 5 [3.5%] | Estimated Total | Subject | Estimated Costs | ||||||||
| Base Year | Year 2 [3.5%] | Year 3 [3.5%] | Year 4 [3.5%] | Year 5 [3.5%] | Estimated Total | ||||||||||
| PM ICS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | PM ICS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| PM AD | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | PM AD | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| PM ILS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | PM ILS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| PM MOD | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | PM MOD | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| MEDEVAC | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | MEDEVAC | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| Totals | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | Totals | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Total Level of Effort for 5 Years witt 35% OH | ||||||||||||
| Subject | Estimated Costs | |||||||||||
| Base Year | Year 2 [3.5%] | Year 3 [3.5%] | Year 4 [3.5%] | Year 5 [3.5%] | Estimated Total | |||||||
| PM ICS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
image1.png image2.png
File details come from the government source that posted it. Updated .