Attachment 0008 - Pricing Sheet (Rev.2).xlsx
XLSX spreadsheet 151 KB Posted
- Solicitation number
- Reposting_RFP_W911QY26RA007_MaterielFielding_MedicalLiaisonSupportServices
About this file
This is a Pricing Sheet for federal contract W911QY26RA007, which covers Materiel Fielding and Medical Liaison Support Services for the Department of the Army. The pricing sheet provides a six-month baseline support structure with labor, travel, and other direct costs (ODCs) broken down across a base year and four option years (September 2026 through September 2031). The baseline staffing includes 39 direct labor personnel totaling 73,320 hours across multiple locations including Fort Detrick, Fort Carson, Fort Hood, Fort Bragg, Fort Campbell, JB Lewis-McChord, JB Elmendorf-Richardson, and Germany. Key positions include a Program Manager for Materiel Fielding, Management Analyst, multiple Logistics Analysts at various levels, and supporting administrative staff. The baseline labor costs show $0 in the pricing columns, while travel is budgeted at $385,000 per six-month period (reduced to $220,000 in the final option year) and supplies at $20,000 per period ($11,000 in the final period), totaling $2,256,000 across all periods.
The surge support section provides additional capacity with 11 total direct labor personnel (10 Logistics Analysts II and 1 Logistics Analyst III) split between two parts, each budgeted at $35,000 for travel and ODCs per six-month period. The total evaluated price for the complete contract period is $2,641,000. Additional supporting documentation includes a comprehensive task pivot table identifying over 100 distinct labor categories mapped across various program offices (PM ICS, PM AD, PM ILS, PMMD MOD, PM MEDVAC, PPAE, and others), and an IGCE (Independent Government Cost Estimate) section showing labor categories with hourly rates ranging from $38 to $120 per hour across multiple fiscal years with 3.5% annual escalation factors, though some cost calculation cells contain reference errors in the spreadsheet.
View the file
Other files
Show all 23
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. | Sep-26 | Sep-27 | Sep-28 | Sep-29 | Sep-30 | Sep-31 | |||||
| NOTE: (***) means Key Personnel | Pricing per year/12 months | Pricing for 6 months | ||||||||||
| 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 | Non-Specified | ||
| *** 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 | Sep-26 | Sep-27 | Sep-28 | Sep-29 | Sep-30 | Sep-31 | ||||||
| Surge Pricing for 6 months | ||||||||||||
| 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 | $ - 0 | $ - 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 | Non-specified | |||
| Logistics Analyst III (Fielding) Part 2, 6 month period | 1 | 940 | $ - 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 | $ 125,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 | $ 50,000.00 | ||||||
| Part 2 Total Travel and ODCs | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ 35,000.00 | $ - 0 | $ 175,000.00 | |||||
| Total Travel and ODCs: | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 35,000.00 | $ 385,000.00 | |||||
| Total Surge for Complete Year: | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 70,000.00 | $ 35,000.00 | $ 385,000.00 |
Total Evaluated Price: $ 2,641,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 .