Attachment_8_ITSS_Employee_Tenure_and_Retention_Table_A4_0004.xlsx
XLSX spreadsheet 58 KB Posted
- Attached to
- IT Support Services (ITSS) IDIQ
- Solicitation number
- 140A1624R0001
About this file
This document appears to be an attachment related to a federal contract opportunity for IT Support Services (ITSS). The attachment is an "ITSS Employee Tenure and Retention Table" that requires the offeror to provide a count of current employees aligned to positions held and the duration employed (less than one year or more than one year). The offeror must complete this table separately for the prime contractor and each teaming partner/subcontractor.
The related federal contract opportunity is for an IDIQ contract for IT Support Services with the Department of the Interior Bureau of Indian Affairs Central Office. The solicitation number is 140A1624R0001. The document also includes an IGCE (Independent Government Cost Estimate) Summary with labor category rates and a Project-Based Estimate table with labor categories, hours, and costs for small, medium, and large projects over a 5-year period. Overall, this appears to be a comprehensive set of materials related to the ITSS IDIQ contract requirements and pricing.
View the file
Other files
Show all 37
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
Tenure Table
| ITSS Employee Tenure and Retention Table |
| Employee Tenure Table |
Quoters shall provide a count of current employees aligned to current positions held and the duration employed - either less than one year or more than one year. Each employee shall be referenced once in a single position that is currently held by that individual. Please fill in the table separately for each teaming partner / subcontractor as well as for the Prime Contractor. If necessary please add additional columns for additional teaming partners.
| Prime Contractor | Teaming Partner 1 | Teaming Partner 2 | Teaming Partner 3 | Teaming Partner 4 | Teaming Partner 5 | |||||||
| Labor Category | FTE < 1 Year | FTE > 1 Year | FTE < 1 Year | FTE > 1 Year | FTE < 1 Year | FTE > 1 Year | FTE < 1 Year | FTE > 1 Year | FTE < 1 Year | FTE > 1 Year | FTE < 1 Year | FTE > 1 Year |
| Application Specialist I | ||||||||||||
| Application Specialist II | ||||||||||||
| Application Specialist III | ||||||||||||
| Application Specialist IV | ||||||||||||
| Application Specialist V | ||||||||||||
| Application Specialist VI | ||||||||||||
| Application/Database Specialist | ||||||||||||
| Business Analyst-Intermediate | ||||||||||||
| Business Analyst-Junior | ||||||||||||
| Business Analyst-Senior | ||||||||||||
| Cloud Operations Engineer | ||||||||||||
| Communications Specialist | ||||||||||||
| Configuration Management Specialist | ||||||||||||
| Customer Experience / User Experience Specialist | ||||||||||||
| Cybersecurity Administrator-Intermediate | ||||||||||||
| Cybersecurity Administrator-Senior | ||||||||||||
| Cybersecurity Analyst/Incident Response | ||||||||||||
| Cybersecurity Analyst-Senior | ||||||||||||
| Cybersecurity Engineer-Intermediate | ||||||||||||
| Cybersecurity Engineer-Junior | ||||||||||||
| Cybersecurity Engineer-Senior | ||||||||||||
| Data Center Analyst-Senior | ||||||||||||
| Data Center Network Engineer IV | ||||||||||||
| Data Center Network Engineer V | ||||||||||||
| Data Center Network Engineer VI | ||||||||||||
| Data Center Network Engineer VII | ||||||||||||
| Data Center Technician I | ||||||||||||
| Data Center Technician II | ||||||||||||
| Data Center Technician III | ||||||||||||
| Data Center Technician IV | ||||||||||||
| Database Administrator I | ||||||||||||
| Database Administrator II | ||||||||||||
| Database Administrator III | ||||||||||||
| Database Administrator IV | ||||||||||||
| Database Administrator V | ||||||||||||
| Database Administrator VI | ||||||||||||
| Desktop Technician I | ||||||||||||
| Desktop Technician II | ||||||||||||
| Desktop Technician III | ||||||||||||
| Desktop Technician IV | ||||||||||||
| Desktop Technician V | ||||||||||||
| Desktop Technician VI | ||||||||||||
| Desktop Technician VII | ||||||||||||
| Disaster Recovery Analyst | ||||||||||||
| Hybrid Cloud Network Engineer | ||||||||||||
| InfoSec Engineer III | ||||||||||||
| Linux System Administrator V | ||||||||||||
| Messaging Specialist-Intermediate | ||||||||||||
| Messaging Specialist-Junior | ||||||||||||
| Messaging Specialist-Senior | ||||||||||||
| Network Engineer II | ||||||||||||
| Network Engineer III | ||||||||||||
| Network Engineer IV | ||||||||||||
| Network Engineer V | ||||||||||||
| Network Engineer VI | ||||||||||||
| Network Engineer VII | ||||||||||||
| Network Security Engineer-Senior | ||||||||||||
| Patch Management Engineer-Senior | ||||||||||||
| Program Manager | ||||||||||||
| Project Manager-Intermediate | ||||||||||||
| Project Manager-Senior | ||||||||||||
| Radio Frequency Network Engineer | ||||||||||||
| Scrum Master | ||||||||||||
| Security Analyst-Junior | ||||||||||||
| Security Engineer-Senior | ||||||||||||
| Service Center Knowledge Base Article and Reporting Lead | ||||||||||||
| Service Center Technician I | ||||||||||||
| Service Center Technician II | ||||||||||||
| Service Center Technician III | ||||||||||||
| Service Center Technician IV Lead | ||||||||||||
| Solution Architect | ||||||||||||
| System Administrator I | ||||||||||||
| System Administrator II | ||||||||||||
| System Administrator III | ||||||||||||
| System Administrator IV | ||||||||||||
| System Administrator V | ||||||||||||
| System Administrator VI | ||||||||||||
| System Administrator VII | ||||||||||||
| IT Documentation Specialist | ||||||||||||
| Voice of Customer / Customer Insights Specialist | ||||||||||||
| VOIP Administrator | ||||||||||||
| Web Developer I | ||||||||||||
| Web Developer II |
* denotes Key Personnel
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 .