B08_SOL_-_Attachment_B_-_Pricing_Spreadsheet_3.xlsx
XLSX spreadsheet 40 KB Posted
- Solicitation number
- 140D0424R0069
About this file
This document appears to be a pricing spreadsheet attachment related to a federal contract opportunity for the Indian Health Service (IHS) Health Information Technology (IT) Modernization Program for the Development of the Four Directions Warehouse (4DW).
The spreadsheet provides pricing details for various labor categories, travel, and other direct costs (ODCs) over a base period and four option periods. The total evaluated price for the 5-year contract is $2,442,750.50. The contract opportunity is a small business set-aside, with a solicitation number of 140D0424R0069. Key labor categories include Data Analyst, Data Engineer, Cybersecurity Specialist, and Project Manager. The pricing spreadsheet provides detailed cost estimates for each labor category by period. Travel costs are estimated at $786,709 and ODCs at $375,000 over the 5-year term.
View the file
Other files
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
Overview
| Category | Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Total | 6-month Option* | Total Evaluated Price |
| Labor | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Travel | $151,053.00 | $154,225.00 | $157,310.00 | $160,456.00 | $163,665.00 | $786,709.00 | $81,832.50 | $1,655,250.50 |
| ODCs | $75,000.00 | $75,000.00 | $75,000.00 | $75,000.00 | $75,000.00 | $375,000.00 | $37,500.00 | $787,500.00 |
| Total | $226,053.00 | $229,225.00 | $232,310.00 | $235,456.00 | $238,665.00 | $1,161,709.00 | $119,332.50 | $2,442,750.50 |
*The 6-month option is calculated by taking the highest option divided by 2.
Base Period
| Base Period (1 Year) | ||||||
| # | Labor Category | Subject to SCLS*? | Total Hours | Quoter Hours | Rate | Cost |
| 1 | Administrative Assistant | 1,920 | $0.00 | |||
| 2 | Applications Engineer, Senior | 1,920 | $0.00 | |||
| 3 | Business Systems Analyst | 1,920 | $0.00 | |||
| 4 | Clinical Analyst, Senior | 430 | $0.00 | |||
| 5 | Clinical Informaticist I | 3,880 | $0.00 | |||
| 6 | Cloud Developer | 4,280 | $0.00 | |||
| 7 | Cloud Engineer | 4,050 | $0.00 | |||
| 8 | Configuration Management Specialist | 392 | $0.00 | |||
| 9 | Cybersecurity Manager | 1,180 | $0.00 | |||
| 10 | Cybersecurity Specialist | 3,840 | $0.00 | |||
| 11 | Cybersecurity Specialist-Senior | 960 | $0.00 | |||
| 12 | Data Analyst | 13,440 | $0.00 | |||
| 13 | Data Architect | 1,706 | $0.00 | |||
| 14 | Data Engineer | 3,840 | $0.00 | |||
| 15 | Data Integration Engineer | 3,840 | $0.00 | |||
| 16 | Data Scientist | 3,840 | $0.00 | |||
| 17 | Database Management Specialist, Senior | 2,737 | $0.00 | |||
| 18 | Financial Analyst | 1,584 | $0.00 | |||
| 19 | IT Architect | 1,922 | $0.00 | |||
| 20 | IT Deployment Manager | 370 | $0.00 | |||
| 21 | IT Help Desk Manager | 0 | $0.00 | |||
| 22 | IT Help Desk Technician | 1,920 | $0.00 | |||
| 23 | Modeling & Simulation Engineer | 2,880 | $0.00 | |||
| 24 | Operations Manager | 3,142 | $0.00 | |||
| 25 | Program Manager, Senior | 1,920 | $0.00 | |||
| 26 | Project Manager | 11,520 | $0.00 | |||
| 27 | QA Engineer | 960 | $0.00 | |||
| 28 | Quality Assurance Engineer | 490 | $0.00 | |||
| 29 | Release Manager | 525 | $0.00 | |||
| 30 | Senior Business Analyst | 1,920 | $0.00 | |||
| 31 | Software Developer/ Engineer, Senior | 1,614 | $0.00 | |||
| 32 | Software Developer/Engineer, Mid-Level | 360 | $0.00 | |||
| 33 | System Administrator, Senior | 1,920 | $0.00 | |||
| 34 | System Engineer | 842 | $0.00 | |||
| 35 | Systems Architect II | 960 | $0.00 | |||
| 36 | Technical Writer | 386 | $0.00 | |||
| 37 | Technical Writer II | 513 | $0.00 | |||
| 38 | Test Engineer: Associate | 1,920 | $0.00 | |||
| 39 | Test Engineer: Senior | 1,920 | $0.00 | |||
| 40 | Training Specialist II | 480 | $0.00 | |||
| Labor Total | 94,243 | 0.00 | $0.00 | |||
| Travel | $151,053.00 | |||||
| ODCs | $75,000.00 | |||||
| Total | $226,053.00 | |||||
| *Indicate whether labor categories are subject to the Service Contract Labor Standards (SCLS). | ||||||
| Carry out decimal to second place ONLY |
Option Period 1
| Base Period (1 Year) | ||||||
| # | Labor Category | Subject to SCLS*? | Total Hours | Quoter Hours | Rate | Cost |
| 1 | Administrative Assistant | 1,920 | $0.00 | |||
| 2 | Applications Engineer, Senior | 1,920 | $0.00 | |||
| 3 | Business Systems Analyst | 1,920 | $0.00 | |||
| 4 | Clinical Informaticist I | 4,224 | $0.00 | |||
| 5 | Cloud Developer | 2,040 | $0.00 | |||
| 6 | Cloud Engineer | 1,498 | $0.00 | |||
| 7 | Configuration Management Specialist | 200 | $0.00 | |||
| 8 | Cybersecurity Manager | 1,180 | $0.00 | |||
| 9 | Cybersecurity Specialist | 3,840 | $0.00 | |||
| 10 | Cybersecurity Specialist-Senior | 960 | $0.00 | |||
| 11 | Data Analyst | 13,440 | $0.00 | |||
| 12 | Data Architect | 894 | $0.00 | |||
| 13 | Data Engineer | 3,840 | $0.00 | |||
| 14 | Data Integration Engineer | 3,840 | $0.00 | |||
| 15 | Data Scientist | 3,840 | $0.00 | |||
| 16 | Database Management Specialist, Senior | 1,308 | $0.00 | |||
| 17 | Financial Analyst | 480 | $0.00 | |||
| 18 | IT Architect | 460 | $0.00 | |||
| 19 | IT Deployment Manager | 80 | $0.00 | |||
| 20 | IT Help Desk Manager | 960 | $0.00 | |||
| 21 | IT Help Desk Technician | 8,160 | $0.00 | |||
| 22 | Modeling & Simulation Engineer | 2,880 | $0.00 | |||
| 23 | Operations Manager | 3,142 | $0.00 | |||
| 24 | Program Manager, Senior | 1,920 | $0.00 | |||
| 25 | Project Manager | 3,840 | $0.00 | |||
| 26 | QA Engineer | 960 | $0.00 | |||
| 27 | Quality Assurance Engineer | 40 | $0.00 | |||
| 28 | Release Manager | 240 | $0.00 | |||
| 29 | Senior Business Analyst | 1,920 | $0.00 | |||
| 30 | Software Developer/ Engineer, Senior | 1,104 | $0.00 | |||
| 31 | Software Developer/Engineer, Mid-Level | 360 | $0.00 | |||
| 32 | System Engineer | 100 | $0.00 | |||
| 33 | Systems Architect II | 12 | $0.00 | |||
| 34 | Technical Writer | 784 | $0.00 | |||
| 35 | Technical Writer II | 14 | $0.00 | |||
| 36 | Test Engineer: Associate | 1,920 | $0.00 | |||
| 37 | Test Engineer: Senior | 1,920 | $0.00 | |||
| 38 | Training Specialist II | 16 | $0.00 | |||
| Labor Total | 78,176 | 0.00 | $0.00 | |||
| Travel | $154,225.00 | |||||
| ODCs | $75,000.00 | |||||
| Total | $229,225.00 | |||||
| *Indicate whether labor categories are subject to the Service Contract Labor Standards (SCLS). | ||||||
| Carry out decimal to second place ONLY |
Option Period 2
| Base Period (1 Year) | ||||||
| # | Labor Category | Subject to SCLS*? | Total Hours | Quoter Hours | Rate | Cost |
| 1 | Administrative Assistant | 1,920 | $0.00 | |||
| 2 | Applications Engineer, Senior | 1,920 | $0.00 | |||
| 3 | Business Systems Analyst | 1,920 | $0.00 | |||
| 4 | Clinical Informaticist I | 4,224 | $0.00 | |||
| 5 | Cloud Developer | 2,040 | $0.00 | |||
| 6 | Cloud Engineer | 1,498 | $0.00 | |||
| 7 | Configuration Management Specialist | 200 | $0.00 | |||
| 8 | Cybersecurity Manager | 1,180 | $0.00 | |||
| 9 | Cybersecurity Specialist | 3,840 | $0.00 | |||
| 10 | Cybersecurity Specialist-Senior | 960 | $0.00 | |||
| 11 | Data Analyst | 13,440 | $0.00 | |||
| 12 | Data Architect | 894 | $0.00 | |||
| 13 | Data Engineer | 3,840 | $0.00 | |||
| 14 | Data Integration Engineer | 3,840 | $0.00 | |||
| 15 | Data Scientist | 3,840 | $0.00 | |||
| 16 | Database Management Specialist, Senior | 1,308 | $0.00 | |||
| 17 | Financial Analyst | 480 | $0.00 | |||
| 18 | IT Architect | 460 | $0.00 | |||
| 19 | IT Deployment Manager | 80 | $0.00 | |||
| 20 | IT Help Desk Manager | 960 | $0.00 | |||
| 21 | IT Help Desk Technician | 8,160 | $0.00 | |||
| 22 | Modeling & Simulation Engineer | 2,880 | $0.00 | |||
| 23 | Operations Manager | 3,142 | $0.00 | |||
| 24 | Program Manager, Senior | 1,920 | $0.00 | |||
| 25 | Project Manager | 3,840 | $0.00 | |||
| 26 | QA Engineer | 960 | $0.00 | |||
| 27 | Quality Assurance Engineer | 40 | $0.00 | |||
| 28 | Release Manager | 240 | $0.00 | |||
| 29 | Senior Business Analyst | 1,920 | $0.00 | |||
| 30 | Software Developer/ Engineer, Senior | 1,104 | $0.00 | |||
| 31 | Software Developer/Engineer, Mid-Level | 360 | $0.00 | |||
| 32 | System Engineer | 100 | $0.00 | |||
| 33 | Systems Architect II | 12 | $0.00 | |||
| 34 | Technical Writer | 784 | $0.00 | |||
| 35 | Technical Writer II | 14 | $0.00 | |||
| 36 | Test Engineer: Associate | 1,920 | $0.00 | |||
| 37 | Test Engineer: Senior | 1,920 | $0.00 | |||
| 38 | Training Specialist II | 16 | $0.00 | |||
| Labor Total | 78,176 | 0.00 | $0.00 | |||
| Travel | $157,310.00 | |||||
| ODCs | $75,000.00 | |||||
| Total | $232,310.00 | |||||
| *Indicate whether labor categories are subject to the Service Contract Labor Standards (SCLS). | ||||||
| Carry out decimal to second place ONLY |
Option Period 3
| Base Period (1 Year) | ||||||
| # | Labor Category | Subject to SCLS*? | Total Hours | Quoter Hours | Rate | Cost |
| 1 | Administrative Assistant | 1,920 | $0.00 | |||
| 2 | Applications Engineer, Senior | 1,920 | $0.00 | |||
| 3 | Business Systems Analyst | 1,920 | $0.00 | |||
| 4 | Clinical Informaticist I | 4,224 | $0.00 | |||
| 5 | Cloud Developer | 2,040 | $0.00 | |||
| 6 | Cloud Engineer | 1,498 | $0.00 | |||
| 7 | Configuration Management Specialist | 200 | $0.00 | |||
| 8 | Cybersecurity Manager | 1,180 | $0.00 | |||
| 9 | Cybersecurity Specialist | 3,840 | $0.00 | |||
| 10 | Cybersecurity Specialist-Senior | 960 | $0.00 | |||
| 11 | Data Analyst | 13,440 | $0.00 | |||
| 12 | Data Architect | 894 | $0.00 | |||
| 13 | Data Engineer | 3,840 | $0.00 | |||
| 14 | Data Integration Engineer | 3,840 | $0.00 | |||
| 15 | Data Scientist | 3,840 | $0.00 | |||
| 16 | Database Management Specialist, Senior | 1,308 | $0.00 | |||
| 17 | Financial Analyst | 480 | $0.00 | |||
| 18 | IT Architect | 460 | $0.00 | |||
| 19 | IT Deployment Manager | 80 | $0.00 | |||
| 20 | IT Help Desk Manager | 960 | $0.00 | |||
| 21 | IT Help Desk Technician | 8,160 | $0.00 | |||
| 22 | Modeling & Simulation Engineer | 2,880 | $0.00 | |||
| 23 | Operations Manager | 3,142 | $0.00 | |||
| 24 | Program Manager, Senior | 1,920 | $0.00 | |||
| 25 | Project Manager | 3,840 | $0.00 | |||
| 26 | QA Engineer | 960 | $0.00 | |||
| 27 | Quality Assurance Engineer | 40 | $0.00 | |||
| 28 | Release Manager | 240 | $0.00 | |||
| 29 | Senior Business Analyst | 1,920 | $0.00 | |||
| 30 | Software Developer/ Engineer, Senior | 1,104 | $0.00 | |||
| 31 | Software Developer/Engineer, Mid-Level | 360 | $0.00 | |||
| 32 | System Engineer | 100 | $0.00 | |||
| 33 | Systems Architect II | 12 | $0.00 | |||
| 34 | Technical Writer | 784 | $0.00 | |||
| 35 | Technical Writer II | 14 | $0.00 | |||
| 36 | Test Engineer: Associate | 1,920 | $0.00 | |||
| 37 | Test Engineer: Senior | 1,920 | $0.00 | |||
| 38 | Training Specialist II | 16 | $0.00 | |||
| Labor Total | 78,176 | 0.00 | $0.00 | |||
| Travel | $160,456.00 | |||||
| ODCs | $75,000.00 | |||||
| Total | $235,456.00 | |||||
| *Indicate whether labor categories are subject to the Service Contract Labor Standards (SCLS). | ||||||
| Carry out decimal to second place ONLY |
Option Period 4
| Base Period (1 Year) | ||||||
| # | Labor Category | Subject to SCLS*? | Total Hours | Quoter Hours | Rate | Cost |
| 1 | Administrative Assistant | 1,920 | $0.00 | |||
| 2 | Applications Engineer, Senior | 1,920 | $0.00 | |||
| 3 | Business Systems Analyst | 1,920 | $0.00 | |||
| 4 | Clinical Informaticist I | 4,224 | $0.00 | |||
| 5 | Cloud Developer | 2,040 | $0.00 | |||
| 6 | Cloud Engineer | 1,498 | $0.00 | |||
| 7 | Configuration Management Specialist | 200 | $0.00 | |||
| 8 | Cybersecurity Manager | 1,180 | $0.00 | |||
| 9 | Cybersecurity Specialist | 3,840 | $0.00 | |||
| 10 | Cybersecurity Specialist-Senior | 960 | $0.00 | |||
| 11 | Data Analyst | 13,440 | $0.00 | |||
| 12 | Data Architect | 894 | $0.00 | |||
| 13 | Data Engineer | 3,840 | $0.00 | |||
| 14 | Data Integration Engineer | 3,840 | $0.00 | |||
| 15 | Data Scientist | 3,840 | $0.00 | |||
| 16 | Database Management Specialist, Senior | 1,308 | $0.00 | |||
| 17 | Financial Analyst | 480 | $0.00 | |||
| 18 | IT Architect | 460 | $0.00 | |||
| 19 | IT Deployment Manager | 80 | $0.00 | |||
| 20 | IT Help Desk Manager | 960 | $0.00 | |||
| 21 | IT Help Desk Technician | 8,160 | $0.00 | |||
| 22 | Modeling & Simulation Engineer | 2,880 | $0.00 | |||
| 23 | Operations Manager | 3,142 | $0.00 | |||
| 24 | Program Manager, Senior | 1,920 | $0.00 | |||
| 25 | Project Manager | 3,840 | $0.00 | |||
| 26 | QA Engineer | 960 | $0.00 | |||
| 27 | Quality Assurance Engineer | 40 | $0.00 | |||
| 28 | Release Manager | 240 | $0.00 | |||
| 29 | Senior Business Analyst | 1,920 | $0.00 | |||
| 30 | Software Developer/ Engineer, Senior | 1,104 | $0.00 | |||
| 31 | Software Developer/Engineer, Mid-Level | 360 | $0.00 | |||
| 32 | System Engineer | 100 | $0.00 | |||
| 33 | Systems Architect II | 12 | $0.00 | |||
| 34 | Technical Writer | 784 | $0.00 | |||
| 35 | Technical Writer II | 14 | $0.00 | |||
| 36 | Test Engineer: Associate | 1,920 | $0.00 | |||
| 37 | Test Engineer: Senior | 1,920 | $0.00 | |||
| 38 | Training Specialist II | 16 | $0.00 | |||
| Labor Total | 78,176 | 0.00 | $0.00 | |||
| Travel | $163,665.00 | |||||
| ODCs | $75,000.00 | |||||
| Total | $238,665.00 | |||||
| *Indicate whether labor categories are subject to the Service Contract Labor Standards (SCLS). | ||||||
| Carry out decimal to second place ONLY |
Price Assumptions
File details come from the government source that posted it. Updated .