Attachment 7_EX-IT Pricing Template_A002.xlsx
XLSX spreadsheet 70 KB Posted
- Attached to
- ECA EX/IT Information Technology Transformation and Operations Support Services (8a set-aside)
- Solicitation number
- 19AQMM21R0302
About this file
This solicitation requests proposals for information technology transformation and operations support services. Offerors must submit pricing using the attached template by August 24, 2021. The Department of State seeks to award an 8(a) set-aside contract to provide program management, customer support, data analytics, application development and maintenance support. The incumbent contractor will support platforms, networks and systems across 70 global locations. Offerors should track applications and platforms using the attached forms and provide details on labor categories, past performance and security clearance in their submissions. The agency will evaluate proposals based on price and past performance using the criteria in the solicitation.
View the file
Other files
Show all 22
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
Instructions
| Pricing Template Instructions | |
| Not To Exceed (NTE) Labor Rates (Blue Tab) | |
| - | Offerors shall enter the fully-burdened not-to-exceed (NTE) hourly rate for each labor category listed |
| - | Separate columns are provided for the Base Year and each option year - all columns must be completed |
| - | Hourly rates will be automatically incorporated into the Total Evaluated Price calculation (Yellow Tab) |
| Total Evaluated Price (Yellow Tab) | |
| - | The yellow tab provides a sample Level of Effort (LOE) to be used for evaluation purposes only |
| - | NOTE: The labor mix and FTE counts for this sample task are for evaluation purposes only and do not represent any current or future planned task orders. |
| - | The total evaluated price is calculated automatically by applying the Offeror's proposed labor rates from the blue tab to the sample LOE |
| Protected Workbook | |
| - | Offerors shall provide their proposed pricing using this pricing template - no alternative formats will be accepted |
| - | The "Instructions" and "Total Evaluated Price" tabs in this pricing workbook have been protected to prevent editing or changing the structure and format of the pricing tables |
| - | Offerors shall enter their pricing information where requested on the blue tab and shall not modify or edit the format or structure of the pricing workbook |
| - | Offerors submitting modified files with different formats/structures will have their pricing proposal deemed non-responsive and will be removed from further consideration for award |
Total Evaluated Price
| EX-IT Sample Task Order | |
| FOR EVALUATION PURPOSES ONLY | Total Evaluated Price |
| * The labor mix and FTE counts for this sample task are for evaluation purposes only and do not represent any current or future planned task orders. | |
| $0 |
| 1,920 | 2 | 3 | 4 | 5 | 6 | |||
| Labor Category | Sample FTE | Total Evaluated Price* | ||||||
| Base | OY 1 | OY 2 | OY 3 | OY 4 | TOTAL | |||
| 1 | Program Manager | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| Customer Engagement | ||||||||
| 2 | Requirements & Business Analysis Lead | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 3 | Mid-Level Business Analyst | 6 | $0 | $0 | $0 | $0 | $0 | $0 |
| 4 | Senior Business Analyst | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 5 | Training Coordinator | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 6 | Trainer | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 7 | Junior Customer Support Technician | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 8 | Mid-Level Customer Support Technician | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 9 | Senior Customer Support Technician | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| Data & Analytics | ||||||||
| 10 | Data Team Functional Lead | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 11 | Data Governance / MDM - Data Architect | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 12 | Data Governance / MDM - Senior Data Analyst | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 13 | Senior Database Administrator | 2 | $0 | $0 | $0 | $0 | $0 | $0 |
| 14 | ETL Developer | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 15 | Business Intelligence & Visualization - Data Scientist | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 16 | Business Intelligence & Visualization - Data Analyst | 5 | $0 | $0 | $0 | $0 | $0 | $0 |
| 17 | Business Intelligence & Visualization - Data Reports Developer | 5 | $0 | $0 | $0 | $0 | $0 | $0 |
| Solutions | ||||||||
| 18 | Solutions Technical Lead | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 19 | Solution Architect | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 20 | Mid-Level Application Developer | 5 | $0 | $0 | $0 | $0 | $0 | $0 |
| 21 | Senior Application Developer | 8 | $0 | $0 | $0 | $0 | $0 | $0 |
| 22 | Scrum Master | 5 | $0 | $0 | $0 | $0 | $0 | $0 |
| 23 | Configuration Management Specialist | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 24 | Q&A Tester | 3 | $0 | $0 | $0 | $0 | $0 | $0 |
| 25 | Q&A Tester - Application / Automation | 4 | $0 | $0 | $0 | $0 | $0 | $0 |
| 26 | Business Process Reengineering Analyst | 2 | $0 | $0 | $0 | $0 | $0 | $0 |
| 27 | SharePoint Developer | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| Platforms | ||||||||
| 28 | Platform Technical Lead | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 29 | Cloud Operations Engineer | 2 | $0 | $0 | $0 | $0 | $0 | $0 |
| 30 | Mid-Level Network Engineer | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 31 | Senior Network Engineer | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 32 | Mid-Level System Administrator | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 33 | Senior System Administrator | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 34 | Audio Visual Administrator | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| Security | ||||||||
| 35 | Security & Monitoring Analyst | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| Governance | ||||||||
| 36 | Enterprise Architect | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| 37 | Technical Writer | 1 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Evaluated Price* | 73 | $0 | $0 | $0 | $0 | $0 | $0 |
NTE Labor Rates
| ECA IT TRANSFORMATION & OPERATIONS SERVICES |
| NTE Hourly Rates by Labor Category |
BASE AND OPTION YEAR FULLY BURDENED HOURLY RATES
| Labor Category | Base Year | OY 1 | OY 2 | OY 3 | OY 4 | ||
| 1 | Program Manager | ||||||
| Customer Engagement | |||||||
| 2 | Requirements & Business Analysis Lead | ||||||
| 3 | Mid-Level Business Analyst | ||||||
| 4 | Senior Business Analyst | ||||||
| 5 | Training Coordinator | ||||||
| 6 | Trainer | ||||||
| 7 | Junior Customer Support Technician | ||||||
| 8 | Mid-Level Customer Support Technician | ||||||
| 9 | Senior Customer Support Technician | ||||||
| Data & Analytics | |||||||
| 10 | Data Team Functional Lead | ||||||
| 11 | Data Governance / MDM - Data Architect | ||||||
| 12 | Data Governance / MDM - Senior Data Analyst | ||||||
| 13 | Senior Database Administrator | ||||||
| 14 | ETL Developer | ||||||
| 15 | Business Intelligence & Visualization - Data Scientist | ||||||
| 16 | Business Intelligence & Visualization - Data Analyst | ||||||
| 17 | Business Intelligence & Visualization - Data Reports Developer | ||||||
| Solutions | |||||||
| 18 | Solutions Technical Lead | ||||||
| 19 | Solution Architect | ||||||
| 20 | Mid-Level Application Developer | ||||||
| 21 | Senior Application Developer | ||||||
| 22 | Scrum Master | ||||||
| 23 | Configuration Management Specialist | ||||||
| 24 | Q&A Tester | ||||||
| 25 | Q&A Tester - Application / Automation | ||||||
| 26 | Business Process Reengineering Analyst | ||||||
| 27 | SharePoint Developer | ||||||
| Platforms | |||||||
| 28 | Platform Technical Lead | ||||||
| 29 | Cloud Operations Engineer | ||||||
| 30 | Mid-Level Network Engineer | ||||||
| 31 | Senior Network Engineer | ||||||
| 32 | Mid-Level System Administrator | ||||||
| 33 | Senior System Administrator | ||||||
| 34 | Audio Visual Administrator | ||||||
| Security | |||||||
| 35 | Security & Monitoring Analyst | ||||||
| Governance | |||||||
| 36 | Enterprise Architect | ||||||
| 37 | Technical Writer | ` |
Attachment E (to be completed by Offeror)
19AQMM18R0183
OT Labor Rates (If Applicable)
| ECA PROFESSIONAL STAFFING SERVICES |
| 19AQMM18R0183 |
| Overtime Rates / By Performance Year |
| (IF APPLICABLE - NOT EXEMPT BY SCA) |
| Labor Category | 1,920 | Annual Cost (1920 Hours Per Year) | ||||||||||
| FTE | Base | FTE | OY 1 | FTE | OY 2 | FTE | OY 3 | FTE | OY 4 | FTE | Total | |
| Program Manager | 1 | $347,386 | 1 | $353,986 | 1 | $360,712 | 1 | $367,565 | 1 | $374,549 | 1 | $1,804,197 |
| Security Analyst | 1 | $233,683 | 1 | $238,123 | 1 | $242,648 | 1 | $247,258 | 1 | $251,956 | 1 | $1,213,671 |
| Enterprise Architect | 1 | $284,198 | 1 | $289,598 | 1 | $295,101 | 1 | $300,707 | 1 | $306,421 | 1 | $1,476,029 |
| Technical Writer | 1 | $158,074 | 1 | $161,077 | 1 | $164,137 | 1 | $167,256 | 1 | $170,434 | 1 | $820,982 |
| Customer Support Technician | 3 | $367,085 | 3 | $374,059 | 3 | $381,167 | 3 | $388,409 | 3 | $395,788 | 3 | $1,906,520 |
| Requirements & BA Lead | 1 | $265,978 | 1 | $271,031 | 1 | $276,181 | 1 | $281,428 | 1 | $286,775 | 1 | $1,381,397 |
| Sr Business Analyst | 2 | $531,955 | 2 | $542,062 | 2 | $552,362 | 2 | $562,856 | 2 | $573,551 | 2 | $2,762,794 |
| Jr Business Analyst | 1 | $227,270 | 1 | $231,589 | 1 | $235,989 | 1 | $240,473 | 1 | $245,041 | 1 | $1,180,366 |
| Training Coordinator | 1 | $175,814 | 1 | $179,155 | 1 | $182,559 | 1 | $186,027 | 1 | $189,562 | 1 | $913,121 |
| Trainer | 1 | $134,477 | 1 | $137,032 | 1 | $139,635 | 1 | $142,289 | 1 | $144,992 | 1 | $698,429 |
| Audio Visual Administrator | 1 | $231,226 | 1 | $235,619 | 1 | $240,096 | 1 | $244,657 | 1 | $249,306 | 1 | $1,200,908 |
| Platform Technical Lead | 1 | $312,269 | 1 | $318,202 | 1 | $324,248 | 1 | $330,408 | 1 | $336,686 | 1 | $1,621,817 |
| Cloud Operations Engineer | 2 | $462,451 | 2 | $471,238 | 2 | $480,191 | 2 | $489,315 | 2 | $498,612 | 2 | $2,401,815 |
| Network Infrastructure Engineer | 2 | $388,339 | 2 | $395,718 | 2 | $403,236 | 2 | $410,898 | 2 | $418,705 | 2 | $2,016,904 |
| Systems Administrator | 2 | $358,272 | 2 | $365,079 | 2 | $372,016 | 2 | $379,084 | 2 | $386,287 | 2 | $1,860,745 |
| Solutions Technical Lead | 1 | $324,653 | 1 | $330,821 | 1 | $337,107 | 1 | $343,512 | 1 | $350,039 | 1 | $1,686,135 |
| Solution Architect | 1 | $234,336 | 1 | $238,788 | 1 | $243,325 | 1 | $247,949 | 1 | $252,660 | 1 | $1,217,062 |
| Sr Application Developer | 3 | $870,278 | 3 | $886,814 | 3 | $903,663 | 3 | $920,833 | 3 | $938,329 | 3 | $4,519,929 |
| Jr Application Developer | 2 | $502,925 | 2 | $512,480 | 2 | $522,217 | 2 | $532,140 | 2 | $542,250 | 2 | $2,612,021 |
| SharePoint Developer | 1 | $234,816 | 1 | $239,278 | 1 | $243,824 | 1 | $248,456 | 1 | $253,177 | 1 | $1,219,555 |
| Scrum Master | 2 | $453,120 | 2 | $461,729 | 2 | $470,502 | 2 | $479,442 | 2 | $488,551 | 2 | $2,353,352 |
| Configuration Manager | 1 | $249,600 | 1 | $254,342 | 1 | $259,175 | 1 | $264,099 | 1 | $269,117 | 1 | $1,296,338 |
| Application/Automation Tester | 2 | $245,760 | 2 | $250,429 | 2 | $255,188 | 2 | $260,036 | 2 | $264,977 | 2 | $1,276,398 |
| Q&A Tester | 1 | $163,200 | 1 | $166,301 | 1 | $169,461 | 1 | $172,680 | 1 | $175,961 | 1 | $847,607 |
| BPR Analyst | 2 | $531,955 | 2 | $542,062 | 2 | $552,362 | 2 | $562,856 | 2 | $573,551 | 2 | $2,762,794 |
| Data Team Technical Lead | 1 | $324,653 | 1 | $330,821 | 1 | $337,107 | 1 | $343,512 | 1 | $350,039 | 1 | $1,686,135 |
| Database Management Analyst | 2 | $433,958 | 2 | $442,204 | 2 | $450,605 | 2 | $459,167 | 2 | $467,891 | 2 | $2,253,834 |
| Master Data Management Analyst | 1 | $230,458 | 1 | $234,836 | 1 | $239,298 | 1 | $243,845 | 1 | $248,478 | 1 | $1,196,919 |
| Data Reports Developer | 1 | $238,080 | 1 | $242,604 | 1 | $247,213 | 1 | $251,910 | 1 | $256,696 | 1 | $1,236,507 |
| BI Data Analyst | 1 | $265,978 | 1 | $271,031 | 1 | $276,181 | 1 | $281,428 | 1 | $286,775 | 1 | $1,381,397 |
| BI Data Scientist | 1 | $252,902 | 1 | $257,708 | 1 | $262,604 | 1 | $267,593 | 1 | $272,678 | 1 | $1,313,489 |
| Data Governance Data Architect | 1 | $239,117 | 1 | $243,660 | 1 | $248,290 | 1 | $253,007 | 1 | $257,814 | 1 | $1,241,892 |
| Data Governance Senior Data Analyst | 1 | $201,619 | 1 | $205,450 | 1 | $209,354 | 1 | $213,331 | 1 | $217,385 | 1 | $1,047,142 |
| ETL Developer | 1 | $170,803 | 1 | $174,048 | 1 | $177,355 | 1 | $180,725 | 1 | $184,159 | 1 | $887,095 |
| 47 | $10,646,688 | 47 | $10,848,975 | 47 | $11,055,106 | 47 | $11,265,153 | 47 | $11,479,191 | 47 | $55,295,300 |
&"Times New Roman,Bold"&12Attachment 6 - Base Year
&"Times New Roman,Bold"19AQMM18R0041
IGCE Summary
| EX/IT IGCE Cost Summary | ||||||||
| 2 | 3 | 4 | 5 | 6 | 6 | |||
| TOTAL 5-YEAR ESTIMATED COST | Annual | |||||||
| Cost Component | Base | OY 1 | OY 2 | OY 3 | OY 4 | Total | FTE | |
| 1 | Total O&M Cost | $10,646,688 | $10,848,975 | $11,055,106 | $11,265,153 | $11,479,191 | $55,295,112 | 47 |
| 2 | Total Project-Based Cost - Low | $4,995,840 | $5,090,761 | $5,187,485 | $5,286,048 | $5,386,483 | $25,946,617 | 21.50 |
| 3 | Total Project-Based Cost - High | $7,277,194 | $7,415,460 | $7,556,354 | $7,699,925 | $7,846,223 | $37,795,156 | 31.25 |
| 4 | TOTAL ESTIMATED COST - LOW | $15,642,528 | $15,939,736 | $16,242,591 | $16,551,200 | $16,865,673 | $81,241,728 | 68.50 |
| 5 | TOTAL ESTIMATED COST - HIGH | $17,923,882 | $18,264,435 | $18,611,460 | $18,965,077 | $19,325,414 | $93,090,268 | 78.25 |
O&M Estimate
| Labor Category Rate Table | 2 | 3 | 4 | 5 | 6 | 6 | |||||
| Hours Per Year = | 1,920 | Annual Cost (1920 Hours Per Year) | |||||||||
| Branch | Functional Area | Task Area | Labor Category | FTE | Base | OY 1 | OY 2 | OY 3 | OY 4 | Total | |
| 1 | All | All | Program Management | Program Manager | 1 | $347,386 | $353,986 | $360,712 | $367,565 | $374,549 | $1,804,197 |
| 2 | Security & Governance | Security | Security Monitoring | Security Analyst | 1 | $233,683 | $238,123 | $242,648 | $247,258 | $251,956 | $1,213,667 |
| 3 | Security & Governance | Governance | Enterprise Architecture | Enterprise Architect | 1 | $284,198 | $289,598 | $295,101 | $300,707 | $306,421 | $1,476,025 |
| 4 | Security & Governance | Governance | Technical Writing | Technical Writer | 1 | $158,074 | $161,077 | $164,137 | $167,256 | $170,434 | $820,978 |
| 5 | Customer Outreach & Platforms | Customer Engagement | Service Desk | Customer Support Technician | 3 | $367,085 | $374,059 | $381,167 | $388,409 | $395,788 | $1,906,508 |
| 6 | Customer Outreach & Platforms | Customer Engagement | Requirements & Business Analysis | Requirements & BA Lead | 1 | $265,978 | $271,031 | $276,181 | $281,428 | $286,775 | $1,381,393 |
| 7 | Customer Outreach & Platforms | Customer Engagement | Requirements & Business Analysis | Sr Business Analyst | 2 | $531,955 | $542,062 | $552,362 | $562,856 | $573,551 | $2,762,786 |
| 8 | Customer Outreach & Platforms | Customer Engagement | Requirements & Business Analysis | Jr Business Analyst | 1 | $227,270 | $231,589 | $235,989 | $240,473 | $245,041 | $1,180,362 |
| 9 | Customer Outreach & Platforms | Customer Engagement | Training | Training Coordinator | 1 | $175,814 | $179,155 | $182,559 | $186,027 | $189,562 | $913,117 |
| 10 | Customer Outreach & Platforms | Customer Engagement | Training | Trainer | 1 | $134,477 | $137,032 | $139,635 | $142,289 | $144,992 | $698,425 |
| 11 | Customer Outreach & Platforms | Customer Engagement | Audio Visual Support | Audio Visual Administrator | 1 | $231,226 | $235,619 | $240,096 | $244,657 | $249,306 | $1,200,904 |
| 12 | Customer Outreach & Platforms | Platforms | All | Platform Technical Lead | 1 | $312,269 | $318,202 | $324,248 | $330,408 | $336,686 | $1,621,813 |
| 13 | Customer Outreach & Platforms | Platforms | Cloud Operations | Cloud Operations Engineer | 2 | $462,451 | $471,238 | $480,191 | $489,315 | $498,612 | $2,401,807 |
| 14 | Customer Outreach & Platforms | Platforms | Network Infrastructure | Network Infrastructure Engineer | 2 | $388,339 | $395,718 | $403,236 | $410,898 | $418,705 | $2,016,896 |
| 15 | Customer Outreach & Platforms | Platforms | Systems Administration & Integration | Systems Administrator | 2 | $358,272 | $365,079 | $372,016 | $379,084 | $386,287 | $1,860,737 |
| 16 | Solutions & Data | Solutions | All | Solutions Technical Lead | 1 | $324,653 | $330,821 | $337,107 | $343,512 | $350,039 | $1,686,131 |
| 17 | Solutions & Data | Solutions | Technology Innovation | Solution Architect | 1 | $234,336 | $238,788 | $243,325 | $247,949 | $252,660 | $1,217,058 |
| 18 | Solutions & Data | Solutions | Solutions & Applications Development | Sr Application Developer | 3 | $870,278 | $886,814 | $903,663 | $920,833 | $938,329 | $4,519,917 |
| 19 | Solutions & Data | Solutions | Solutions & Applications Development | Jr Application Developer | 2 | $502,925 | $512,480 | $522,217 | $532,140 | $542,250 | $2,612,013 |
| 20 | Solutions & Data | Solutions | Solutions & Applications Development | SharePoint Developer | 1 | $234,816 | $239,278 | $243,824 | $248,456 | $253,177 | $1,219,551 |
| 21 | Solutions & Data | Solutions | Solutions & Applications Development | Scrum Master | 2 | $453,120 | $461,729 | $470,502 | $479,442 | $488,551 | $2,353,344 |
| 22 | Solutions & Data | Solutions | Solutions & Applications Development | Configuration Manager | 1 | $249,600 | $254,342 | $259,175 | $264,099 | $269,117 | $1,296,334 |
| 23 | Solutions & Data | Solutions | Quality Assurance & Testing | Application/Automation Tester | 2 | $245,760 | $250,429 | $255,188 | $260,036 | $264,977 | $1,276,390 |
| 24 | Solutions & Data | Solutions | Quality Assurance & Testing | Q&A Tester | 1 | $163,200 | $166,301 | $169,461 | $172,680 | $175,961 | $847,603 |
| 25 | Solutions & Data | Solutions | Business Process Reengineering | BPR Analyst | 2 | $531,955 | $542,062 | $552,362 | $562,856 | $573,551 | $2,762,786 |
| 26 | Solutions & Data | Data | All | Data Team Technical Lead | 1 | $324,653 | $330,821 | $337,107 | $343,512 | $350,039 | $1,686,131 |
| 27 | Solutions & Data | Data | Database Management (DBAs) | Database Management Analyst | 2 | $433,958 | $442,204 | $450,605 | $459,167 | $467,891 | $2,253,826 |
| 28 | Solutions & Data | Data | Master Data Management | Master Data Management Analyst | 1 | $230,458 | $234,836 | $239,298 | $243,845 | $248,478 | $1,196,915 |
| 29 | Solutions & Data | Data | Data Reporting | Data Reports Developer | 1 | $238,080 | $242,604 | $247,213 | $251,910 | $256,696 | $1,236,503 |
| 30 | Solutions & Data | Data | Business Intelligence & Visualization | BI Data Analyst | 1 | $265,978 | $271,031 | $276,181 | $281,428 | $286,775 | $1,381,393 |
| 31 | Solutions & Data | Data | Business Intelligence & Visualization | BI Data Scientist | 1 | $252,902 | $257,708 | $262,604 | $267,593 | $272,678 | $1,313,485 |
| 32 | Solutions & Data | Data | Data Governance | Data Governance Data Architect | 1 | $239,117 | $243,660 | $248,290 | $253,007 | $257,814 | $1,241,888 |
| 33 | Solutions & Data | Data | Data Governance | Data Governance Senior Data Analyst | 1 | $201,619 | $205,450 | $209,354 | $213,331 | $217,385 | $1,047,138 |
| 34 | Solutions & Data | Data | Data Governance | ETL Developer | 1 | $170,803 | $174,048 | $177,355 | $180,725 | $184,159 | $887,091 |
| Total O&M | 47 | $10,646,688 | $10,848,975 | $11,055,106 | $11,265,153 | $11,479,191 | $55,295,112 |
Project-Based Estimate
| 2 | 3 | 4 | 5 | 6 | 6 | ||||
| Hours Per Year = | 1,920 | Annual Cost (1920 Hours Per Year) | Total | ||||||
| Labor Category | FTE | Base | OY 1 | OY 2 | OY 3 | OY 4 | $ | FTE | |
| 1 | SMALL PROJECT (3-6 Months) | ||||||||
| 2 | Jr Business Analyst | 0.5 | $113,635 | $115,794 | $117,994 | $120,236 | $122,521 | $590,181 | |
| 3 | Sr Application Developer | 0.5 | $145,046 | $147,802 | $150,611 | $153,472 | $156,388 | $753,319 | |
| 4 | Scrum Master | 0.25 | $56,640 | $57,716 | $58,813 | $59,930 | $61,069 | $294,168 | |
| 5 | Application/Automation Tester | 0.25 | $30,720 | $31,304 | $31,898 | $32,505 | $33,122 | $159,549 | |
| 6 | Q&A Tester | 0.25 | $40,800 | $41,575 | $42,365 | $43,170 | $43,990 | $211,901 | |
| 7 | Data Reports Developer | 0.5 | $119,040 | $121,302 | $123,606 | $125,955 | $128,348 | $618,251 | |
| 8 | BI Data Analyst | 0.5 | $132,989 | $135,516 | $138,090 | $140,714 | $143,388 | $690,697 | |
| 9 | TOTAL PER PROJECT | 2.75 | $638,870 | $651,009 | $663,378 | $675,982 | $688,826 | $3,318,066 | |
| 10 | TOTAL SMALL PROJECT COST - LOW | 2 | $1,277,741 | $1,302,018 | $1,326,756 | $1,351,965 | $1,377,652 | $6,636,131 | 5.50 |
| 11 | TOTAL SMALL PROJECT COST - HIGH | 3 | $1,916,611 | $1,953,027 | $1,990,134 | $2,027,947 | $2,066,478 | $9,954,197 | 8.25 |
| 12 | MEDIUM PROJECT (6-12 Months) | ||||||||
| 13 | Jr Business Analyst | 1 | $227,270 | $231,589 | $235,989 | $240,473 | $245,041 | $1,180,362 | |
| 14 | Jr Application Developer | 1 | $251,462 | $256,240 | $261,109 | $266,070 | $271,125 | $1,306,006 | |
| 15 | Sr Application Developer | 1 | $290,093 | $295,605 | $301,221 | $306,944 | $312,776 | $1,506,639 | |
| 16 | Scrum Master | 1 | $226,560 | $230,865 | $235,251 | $239,721 | $244,276 | $1,176,672 | |
| 17 | Application/Automation Tester | 0.5 | $61,440 | $62,607 | $63,797 | $65,009 | $66,244 | $319,098 | |
| 18 | Q&A Tester | 0.5 | $81,600 | $83,150 | $84,730 | $86,340 | $87,981 | $423,801 | |
| 19 | Data Reports Developer | 1 | $238,080 | $242,604 | $247,213 | $251,910 | $256,696 | $1,236,503 | |
| 20 | BI Data Analyst | 1 | $265,978 | $271,031 | $276,181 | $281,428 | $286,775 | $1,381,393 | |
| 21 | TOTAL PER PROJECT | 7 | $1,642,483 | $1,673,690 | $1,705,490 | $1,737,895 | $1,770,915 | $8,530,474 | |
| 22 | TOTAL MEDIUM PROJECT COST - LOW | 1 | $1,642,483 | $1,673,690 | $1,705,490 | $1,737,895 | $1,770,915 | $8,530,474 | 7.0 |
| 23 | TOTAL MEDIUM PROJECT COST - HIGH | 2 | $3,284,966 | $3,347,381 | $3,410,981 | $3,475,790 | $3,541,830 | $17,060,947 | 14.0 |
| 24 | LARGE PROJECT (12+ Months) | ||||||||
| 25 | Jr Business Analyst | 1 | $227,270 | $231,589 | $235,989 | $240,473 | $245,041 | $1,180,362 | |
| 26 | Jr Application Developer | 1 | $251,462 | $256,240 | $261,109 | $266,070 | $271,125 | $1,306,006 | |
| 27 | Sr Application Developer | 2 | $580,186 | $591,209 | $602,442 | $613,888 | $625,552 | $3,013,278 | |
| 28 | Scrum Master | 1 | $226,560 | $230,865 | $235,251 | $239,721 | $244,276 | $1,176,672 | |
| 29 | Application/Automation Tester | 1 | $122,880 | $125,215 | $127,594 | $130,018 | $132,488 | $638,195 | |
| 30 | Q&A Tester | 1 | $163,200 | $166,301 | $169,461 | $172,680 | $175,961 | $847,603 | |
| 31 | Data Reports Developer | 1 | $238,080 | $242,604 | $247,213 | $251,910 | $256,696 | $1,236,503 | |
| 32 | BI Data Analyst | 1 | $265,978 | $271,031 | $276,181 | $281,428 | $286,775 | $1,381,393 | |
| 33 | TOTAL PER PROJECT | 9 | $2,075,616 | $2,115,053 | $2,155,239 | $2,196,188 | $2,237,916 | $10,780,011 | |
| 34 | TOTAL LARGE PROJECT COST - LOW | 1 | $2,075,616 | $2,115,053 | $2,155,239 | $2,196,188 | $2,237,916 | $10,780,011 | 9.0 |
| 35 | TOTAL LARGE PROJECT COST - HIGH | 1 | $2,075,616 | $2,115,053 | $2,155,239 | $2,196,188 | $2,237,916 | $10,780,011 | 9.0 |
| 36 | TOTAL PROJECT-BASED - LOW | $4,995,840 | $5,090,761 | $5,187,485 | $5,286,048 | $5,386,483 | $25,946,617 | 21.50 |
| 37 | TOTAL PROJECT-BASED - HIGH | $7,277,194 | $7,415,460 | $7,556,354 | $7,699,925 | $7,846,223 | $37,795,156 | 31.25 |
Rate Table
| Labor Category Rate Table | Rate Escalation Assumption = | 2% | |||||||
| Hourly Rates (1920 Hours per Year) | |||||||||
| Branch | Functional Area | Task Area | Labor Category | Base | OY 1 | OY 2 | OY 3 | OY 4 | |
| 1 | All | All | Program Management | Program Manager | $180.93 | 184.36767 | $187.87 | $191.44 | $195.08 |
| 2 | Security & Governance | Security | Security Monitoring | Security Analyst | $121.71 | $124.02 | $126.38 | $128.78 | $131.23 |
| 3 | Security & Governance | Governance | Enterprise Architecture | Enterprise Architect | $148.02 | $150.83 | $153.70 | $156.62 | $159.59 |
| 4 | Security & Governance | Governance | Technical Writing | Technical Writer | $82.33 | $83.89 | $85.49 | $87.11 | $88.77 |
| 5 | Customer Outreach & Platforms | Customer Engagement | Service Desk | Customer Support Technician | $63.73 | $64.94 | $66.17 | $67.43 | $68.71 |
| 6 | Customer Outreach & Platforms | Customer Engagement | Requirements & Business Analysis | Requirements & BA Lead | $138.53 | $141.16 | $143.84 | $146.58 | $149.36 |
| 7 | Customer Outreach & Platforms | Customer Engagement | Requirements & Business Analysis | Sr Business Analyst | $138.53 | $141.16 | $143.84 | $146.58 | $149.36 |
| 8 | Customer Outreach & Platforms | Customer Engagement | Requirements & Business Analysis | Jr Business Analyst | $118.37 | $120.62 | $122.91 | $125.25 | $127.63 |
| 9 | Customer Outreach & Platforms | Customer Engagement | Training | Training Coordinator | $91.57 | $93.31 | $95.08 | $96.89 | $98.73 |
| 10 | Customer Outreach & Platforms | Customer Engagement | Training | Trainer | $70.04 | $71.37 | $72.73 | $74.11 | $75.52 |
| 11 | Customer Outreach & Platforms | Customer Engagement | Audio Visual Support | Audio Visual Administrator | $120.43 | $122.72 | $125.05 | $127.43 | $129.85 |
| 12 | Customer Outreach & Platforms | Platforms | All | Platform Technical Lead | $162.64 | $165.73 | $168.88 | $172.09 | $175.36 |
| 13 | Customer Outreach & Platforms | Platforms | Cloud Operations | Cloud Operations Engineer | $120.43 | $122.72 | $125.05 | $127.43 | $129.85 |
| 14 | Customer Outreach & Platforms | Platforms | Network Infrastructure | Network Infrastructure Engineer | $101.13 | $103.05 | $105.01 | $107.00 | $109.04 |
| 15 | Customer Outreach & Platforms | Platforms | Systems Administration & Integration | Systems Administrator | $93.30 | $95.07 | $96.88 | $98.72 | $100.60 |
| 16 | Solutions & Data | Solutions | All | Solutions Technical Lead | $169.09 | $172.30 | $175.58 | $178.91 | $182.31 |
| 17 | Solutions & Data | Solutions | Technology Innovation | Solution Architect | $122.05 | $124.37 | $126.73 | $129.14 | $131.59 |
| 18 | Solutions & Data | Solutions | Solutions & Applications Development | Sr Application Developer | $151.09 | $153.96 | $156.89 | $159.87 | $162.90 |
| 19 | Solutions & Data | Solutions | Solutions & Applications Development | Jr Application Developer | $130.97 | $133.46 | $135.99 | $138.58 | $141.21 |
| 20 | Solutions & Data | Solutions | Solutions & Applications Development | SharePoint Developer | $122.30 | $124.62 | $126.99 | $129.40 | $131.86 |
| 21 | Solutions & Data | Solutions | Solutions & Applications Development | Scrum Master | $118.00 | $120.24 | $122.53 | $124.85 | $127.23 |
| 22 | Solutions & Data | Solutions | Solutions & Applications Development | Configuration Manager | $130.00 |
Brian Fischbeck: Brian Fischbeck:
| Rate provided by Nirun. This person needs to be a more senior person | $132.47 | $134.99 | $137.55 | $140.17 | ||||||
| 23 | Solutions & Data | Solutions | Quality Assurance & Testing | Application/Automation Tester | $64.00 | $65.22 | $66.46 | $67.72 | $69.00 | |
| 24 | Solutions & Data | Solutions | Quality Assurance & Testing | Q&A Tester | $85.00 | $86.62 | $88.26 | $89.94 | $91.65 | |
| 25 | Solutions & Data | Solutions | Business Process Reengineering | BPR Analyst | $138.53 | $141.16 | $143.84 | $146.58 | $149.36 | |
| 26 | Solutions & Data | Data | All | Data Team Technical Lead | $169.09 | $172.30 | $175.58 | $178.91 | $182.31 | |
| 27 | Solutions & Data | Data | Database Management (DBAs) | Database Management Analyst | $113.01 | $115.16 | $117.35 | $119.57 | $121.85 | |
| 28 | Solutions & Data | Data | Master Data Management | Master Data Management Analyst | $120.03 | $122.31 | $124.63 | $127.00 | $129.42 | |
| 29 | Solutions & Data | Data | Data Reporting | Data Reports Developer | $124.00 | $126.36 | $128.76 | $131.20 | $133.70 | |
| 30 | Solutions & Data | Data | Business Intelligence & Visualization | BI Data Analyst | $138.53 | $141.16 | $143.84 | $146.58 | $149.36 | |
| 31 | Solutions & Data | Data | Business Intelligence & Visualization | BI Data Scientist | $131.72 | $134.22 | $136.77 | $139.37 | $142.02 | |
| 32 | Solutions & Data | Data | Data Governance | Data Governance Data Architect | $124.54 | $126.91 | $129.32 | $131.77 | $134.28 | |
| 33 | Solutions & Data | Data | Data Governance | Data Governance Senior Data Analyst | $105.01 | $107.01 | $109.04 | $111.11 | $113.22 | |
| 34 | Solutions & Data | Data | Data Governance | ETL Developer | $88.96 | $90.65 | $92.37 | $94.13 | $95.92 |
Newly adjusted positions
File details come from the government source that posted it. Updated .