Attachment 7_EX-IT Pricing Template.xlsx

XLSX spreadsheet 111 KB Posted

Attached to
ECA EX/IT Information Technology Transformation and Operations Support Services (8a set-aside)
Solicitation number
19AQMM21R0302
Issued by

About this file

This Request for Proposal (RFP) solicits offers for Information Technology Transformation and Operations Support Services for the Department of State's Office of Acquisition Management. The RFP seeks a contractor to provide EX/IT services including program management, security, governance, customer support, platforms, solutions, data, and quality assurance. Key dates include questions due by August 24, 2021 and proposals due on an unspecified future date.

The RFP includes ten attachments providing details on required services and deliverables. Attachment 1 tracks application services, Attachment 2 covers platform technologies, and Attachment 3 defines 37 labor categories. Attachments 4-6 provide additional supporting documentation. Attachment 7 is the pricing template offerors must use in their proposals. Attachments 8-10 cover the evaluation process, with Attachment 8 outlining a potential down-select. The solicitation is set aside for 8(a) small businesses. The incumbent contractor's performance will be evaluated. Offerors are advised to submit any questions regarding the RFP by the specified date.

View the file

Other files

File Type Posted
Questions and Answers - Amendment 004.xlsx XLSX spreadsheet
19AQMM21R0302-A004.pdf PDF
Attachment 8_Instructions to Offerors_Advisory Down-Select Process_A004.pdf PDF
Attachment 3_Labor Categories_Position Descriptions_A004.pdf PDF
19AQMM21R0302-A003 (Stage 2).pdf PDF
19AQMM21R0302-A002.pdf PDF
Questions and Answers - Amendment 002.xlsx XLSX spreadsheet
Attachment 8_Instructions to Offerors_Advisory Down-Select Process_A002.pdf PDF
Attachment 7_EX-IT Pricing Template_A002.xlsx XLSX spreadsheet
Attachment 5_Past Performance Questionnaire_A002.docx DOCX document
Attachment 9_Evaluation Procedures_Evaluation Factors for Award_A002.pdf PDF
19AQMM21R0302-A0001.pdf PDF
Attachment 6_Employee Tenure and Retention Table.xlsx XLSX spreadsheet
Attachment 5_Past Performance Questionnaire.docx DOCX document
Attachment 2_Platform Technology Tracker.pdf PDF
19AQMM21R0302 - ECA IT Transformation and Operations Support Services.pdf PDF
Attachment 9_Evaluation Procedures_Evaluation Factors for Award.pdf PDF
Attachment 3_Labor Categories_Position Descriptions.pdf PDF
Attachment 8_Instructions to Offerors_Advisory Down-Select Process.pdf PDF
Attachment 10_Bidders DD-254 - 19AQMM-21-R-0302.pdf PDF
Attachment 4_ECA DIN Infrastructure Diagram.pdf PDF
Attachment 1_Applications Tracker.xlsx XLSX spreadsheet
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
-Each of the light blue tabs numbered 1-5 provides a listing of all EX-IT labor categories to be priced
-There is one tab for the Base Period and one tab for each of the 4 Option Periods
-For each labor category, offerors shall enter a base rate and additional dollar amounts for Overhead, G&A, Fringe and Profit
-The total Burdened Rate for each labor category will be calculated automatically as the sum of the component prices entered
Total Evaluated Price
-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 Offerors proposed labor rates from the 5 blue tabs to the sample LOE
Protected Workbook
-Offerors shall provide their proposed pricing using this pricing template - not alternative formats will be accepted
-The tables 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 5 numbered tabs 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

Sample LOE - Evaluation Only

EX-IT Sample Task Order
FOR EVALUATION PURPOSES ONLYTotal 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,92023456
Labor CategorySample FTETotal Evaluated Price*
BaseOY 1OY 2OY 3OY 4TOTAL
1Program Manager1$0$0$0$0$0$0
Customer Engagement
2Requirements & Business Analysis Lead1$0$0$0$0$0$0
3Mid-Level Business Analyst6$0$0$0$0$0$0
4Senior Business Analyst1$0$0$0$0$0$0
5Training Coordinator1$0$0$0$0$0$0
6Trainer1$0$0$0$0$0$0
7Junior Customer Support Technician1$0$0$0$0$0$0
8Mid-Level Customer Support Technician1$0$0$0$0$0$0
9Senior Customer Support Technician1$0$0$0$0$0$0
Data & Analytics
10Data Team Functional Lead1$0$0$0$0$0$0
11Data Governance / MDM - Data Architect1$0$0$0$0$0$0
12Data Governance / MDM - Senior Data Analyst1$0$0$0$0$0$0
13Senior Database Administrator2$0$0$0$0$0$0
14ETL Developer1$0$0$0$0$0$0
15Business Intelligence & Visualization - Data Scientist1$0$0$0$0$0$0
16Business Intelligence & Visualization - Data Analyst5$0$0$0$0$0$0
17Business Intelligence & Visualization - Data Reports Developer5$0$0$0$0$0$0
Solutions
18Solutions Technical Lead1$0$0$0$0$0$0
19Solution Architect1$0$0$0$0$0$0
20Mid-Level Application Developer5$0$0$0$0$0$0
21Senior Application Developer8$0$0$0$0$0$0
22Scrum Master5$0$0$0$0$0$0
23Configuration Management Specialist1$0$0$0$0$0$0
24Q&A Tester3$0$0$0$0$0$0
25Q&A Tester - Application / Automation4$0$0$0$0$0$0
26Business Process Reengineering Analyst2$0$0$0$0$0$0
27SharePoint Developer1$0$0$0$0$0$0
Platforms
28Platform Technical Lead1$0$0$0$0$0$0
29Cloud Operations Engineer2$0$0$0$0$0$0
30Mid-Level Network Engineer1$0$0$0$0$0$0
31Senior Network Engineer1$0$0$0$0$0$0
32Mid-Level System Administrator1$0$0$0$0$0$0
33Senior System Administrator1$0$0$0$0$0$0
34Audio Visual Administrator1$0$0$0$0$0$0
Security
35Security & Monitoring Analyst1$0$0$0$0$0$0
Governance
36Enterprise Architect1$0$0$0$0$0$0
37Technical Writer1$0$0$0$0$0$0
Total Evaluated Price*73$0$0$0$0$0$0

1. NTE Labor Rates - BASE

ECA IT TRANSFORMATION & OPERATIONS SERVICESNote: Offeror shall fill in the Base Rate, Overhead, G&A, Fringe, and Profit amounts comprising the fully Burdened Rate
Breakdown of NTE Hourly Rates by Labor Category

BASE YEAR HOURLY RATES

Labor CategoryBase RateOverheadG&AFringeProfitBurdened Rate
1Program Manager$0.00
Customer Engagement
2Requirements & Business Analysis Lead$0.00
3Mid-Level Business Analyst$0.00
4Senior Business Analyst$0.00
5Training Coordinator$0.00
6Trainer$0.00
7Junior Customer Support Technician$0.00
8Mid-Level Customer Support Technician$0.00
9Senior Customer Support Technician$0.00
Data & Analytics
10Data Team Functional Lead$0.00
11Data Governance / MDM - Data Architect$0.00
12Data Governance / MDM - Senior Data Analyst$0.00
13Senior Database Administrator$0.00
14ETL Developer$0.00
15Business Intelligence & Visualization - Data Scientist$0.00
16Business Intelligence & Visualization - Data Analyst$0.00
17Business Intelligence & Visualization - Data Reports Developer$0.00
Solutions
18Solutions Technical Lead$0.00
19Solution Architect$0.00
20Mid-Level Application Developer$0.00
21Senior Application Developer$0.00
22Scrum Master$0.00
23Configuration Management Specialist$0.00
24Q&A Tester$0.00
25Q&A Tester - Application / Automation$0.00
26Business Process Reengineering Analyst$0.00
27SharePoint Developer$0.00
Platforms
28Platform Technical Lead$0.00
29Cloud Operations Engineer$0.00
30Mid-Level Network Engineer$0.00
31Senior Network Engineer$0.00
32Mid-Level System Administrator$0.00
33Senior System Administrator$0.00
34Audio Visual Administrator$0.00
Security
35Security & Monitoring Analyst$0.00
Governance
36Enterprise Architect$0.00
37Technical Writer$0.00`

Attachment E (to be completed by Offeror)

19AQMM18R0183

2. NTE Labor Rates - OY1

ECA IT TRANSFORMATION & OPERATIONS SERVICESNote: Offeror shall fill in the Base Rate, Overhead, G&A, Fringe, and Profit amounts comprising the fully Burdened Rate
Breakdown of NTE Hourly Rates by Labor Category

OPTION YEAR 1 HOURLY RATES

Labor CategoryBase RateOverheadG&AFringeProfitBurdened Rate
1Program Manager$0.00
Customer Engagement
2Requirements & Business Analysis Lead$0.00
3Mid-Level Business Analyst$0.00
4Senior Business Analyst$0.00
5Training Coordinator$0.00
6Trainer$0.00
7Junior Customer Support Technician$0.00
8Mid-Level Customer Support Technician$0.00
9Senior Customer Support Technician$0.00
Data & Analytics
10Data Team Functional Lead$0.00
11Data Governance / MDM - Data Architect$0.00
12Data Governance / MDM - Senior Data Analyst$0.00
13Senior Database Administrator$0.00
14ETL Developer$0.00
15Business Intelligence & Visualization - Data Scientist$0.00
16Business Intelligence & Visualization - Data Analyst$0.00
17Business Intelligence & Visualization - Data Reports Developer$0.00
Solutions
18Solutions Technical Lead$0.00
19Solution Architect$0.00
20Mid-Level Application Developer$0.00
21Senior Application Developer$0.00
22Scrum Master$0.00
23Configuration Management Specialist$0.00
24Q&A Tester$0.00
25Q&A Tester - Application / Automation$0.00
26Business Process Reengineering Analyst$0.00
27SharePoint Developer$0.00
Platforms
28Platform Technical Lead$0.00
29Cloud Operations Engineer$0.00
30Mid-Level Network Engineer$0.00
31Senior Network Engineer$0.00
32Mid-Level System Administrator$0.00
33Senior System Administrator$0.00
34Audio Visual Administrator$0.00
Security
35Security & Monitoring Analyst$0.00
Governance
36Enterprise Architect$0.00
37Technical Writer$0.00`

Attachment E (to be completed by Offeror)

19AQMM18R0183

3. NTE Labor Rates - OY2

ECA IT TRANSFORMATION & OPERATIONS SERVICESNote: Offeror shall fill in the Base Rate, Overhead, G&A, Fringe, and Profit amounts comprising the fully Burdened Rate
Breakdown of NTE Hourly Rates by Labor Category

OPTION YEAR 2 HOURLY RATES

Labor CategoryBase RateOverheadG&AFringeProfitBurdened Rate
1Program Manager$0.00
Customer Engagement
2Requirements & Business Analysis Lead$0.00
3Mid-Level Business Analyst$0.00
4Senior Business Analyst$0.00
5Training Coordinator$0.00
6Trainer$0.00
7Junior Customer Support Technician$0.00
8Mid-Level Customer Support Technician$0.00
9Senior Customer Support Technician$0.00
Data & Analytics
10Data Team Functional Lead$0.00
11Data Governance / MDM - Data Architect$0.00
12Data Governance / MDM - Senior Data Analyst$0.00
13Senior Database Administrator$0.00
14ETL Developer$0.00
15Business Intelligence & Visualization - Data Scientist$0.00
16Business Intelligence & Visualization - Data Analyst$0.00
17Business Intelligence & Visualization - Data Reports Developer$0.00
Solutions
18Solutions Technical Lead$0.00
19Solution Architect$0.00
20Mid-Level Application Developer$0.00
21Senior Application Developer$0.00
22Scrum Master$0.00
23Configuration Management Specialist$0.00
24Q&A Tester$0.00
25Q&A Tester - Application / Automation$0.00
26Business Process Reengineering Analyst$0.00
27SharePoint Developer$0.00
Platforms
28Platform Technical Lead$0.00
29Cloud Operations Engineer$0.00
30Mid-Level Network Engineer$0.00
31Senior Network Engineer$0.00
32Mid-Level System Administrator$0.00
33Senior System Administrator$0.00
34Audio Visual Administrator$0.00
Security
35Security & Monitoring Analyst$0.00
Governance
36Enterprise Architect$0.00
37Technical Writer$0.00`

Attachment E (to be completed by Offeror)

19AQMM18R0183

4. NTE Labor Rates - OY3

ECA IT TRANSFORMATION & OPERATIONS SERVICESNote: Offeror shall fill in the Base Rate, Overhead, G&A, Fringe, and Profit amounts comprising the fully Burdened Rate
Breakdown of NTE Hourly Rates by Labor Category

OPTION YEAR 3 HOURLY RATES

Labor CategoryBase RateOverheadG&AFringeProfitBurdened Rate
1Program Manager$0.00
Customer Engagement
2Requirements & Business Analysis Lead$0.00
3Mid-Level Business Analyst$0.00
4Senior Business Analyst$0.00
5Training Coordinator$0.00
6Trainer$0.00
7Junior Customer Support Technician$0.00
8Mid-Level Customer Support Technician$0.00
9Senior Customer Support Technician$0.00
Data & Analytics
10Data Team Functional Lead$0.00
11Data Governance / MDM - Data Architect$0.00
12Data Governance / MDM - Senior Data Analyst$0.00
13Senior Database Administrator$0.00
14ETL Developer$0.00
15Business Intelligence & Visualization - Data Scientist$0.00
16Business Intelligence & Visualization - Data Analyst$0.00
17Business Intelligence & Visualization - Data Reports Developer$0.00
Solutions
18Solutions Technical Lead$0.00
19Solution Architect$0.00
20Mid-Level Application Developer$0.00
21Senior Application Developer$0.00
22Scrum Master$0.00
23Configuration Management Specialist$0.00
24Q&A Tester$0.00
25Q&A Tester - Application / Automation$0.00
26Business Process Reengineering Analyst$0.00
27SharePoint Developer$0.00
Platforms
28Platform Technical Lead$0.00
29Cloud Operations Engineer$0.00
30Mid-Level Network Engineer$0.00
31Senior Network Engineer$0.00
32Mid-Level System Administrator$0.00
33Senior System Administrator$0.00
34Audio Visual Administrator$0.00
Security
35Security & Monitoring Analyst$0.00
Governance
36Enterprise Architect$0.00
37Technical Writer$0.00`

Attachment E (to be completed by Offeror)

19AQMM18R0183

5. NTE Labor Rates - OY4

ECA IT TRANSFORMATION & OPERATIONS SERVICESNote: Offeror shall fill in the Base Rate, Overhead, G&A, Fringe, and Profit amounts comprising the fully Burdened Rate
Breakdown of NTE Hourly Rates by Labor Category

OPTION YEAR 4 HOURLY RATES

Labor CategoryBase RateOverheadG&AFringeProfitBurdened Rate
1Program Manager$0.00
Customer Engagement
2Requirements & Business Analysis Lead$0.00
3Mid-Level Business Analyst$0.00
4Senior Business Analyst$0.00
5Training Coordinator$0.00
6Trainer$0.00
7Junior Customer Support Technician$0.00
8Mid-Level Customer Support Technician$0.00
9Senior Customer Support Technician$0.00
Data & Analytics
10Data Team Functional Lead$0.00
11Data Governance / MDM - Data Architect$0.00
12Data Governance / MDM - Senior Data Analyst$0.00
13Senior Database Administrator$0.00
14ETL Developer$0.00
15Business Intelligence & Visualization - Data Scientist$0.00
16Business Intelligence & Visualization - Data Analyst$0.00
17Business Intelligence & Visualization - Data Reports Developer$0.00
Solutions
18Solutions Technical Lead$0.00
19Solution Architect$0.00
20Mid-Level Application Developer$0.00
21Senior Application Developer$0.00
22Scrum Master$0.00
23Configuration Management Specialist$0.00
24Q&A Tester$0.00
25Q&A Tester - Application / Automation$0.00
26Business Process Reengineering Analyst$0.00
27SharePoint Developer$0.00
Platforms
28Platform Technical Lead$0.00
29Cloud Operations Engineer$0.00
30Mid-Level Network Engineer$0.00
31Senior Network Engineer$0.00
32Mid-Level System Administrator$0.00
33Senior System Administrator$0.00
34Audio Visual Administrator$0.00
Security
35Security & Monitoring Analyst$0.00
Governance
36Enterprise Architect$0.00
37Technical Writer$0.00`

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 Category1,920Annual Cost (1920 Hours Per Year)
FTEBaseFTEOY 1FTEOY 2FTEOY 3FTEOY 4FTETotal
Program Manager1$347,3861$353,9861$360,7121$367,5651$374,5491$1,804,197
Security Analyst1$233,6831$238,1231$242,6481$247,2581$251,9561$1,213,671
Enterprise Architect1$284,1981$289,5981$295,1011$300,7071$306,4211$1,476,029
Technical Writer1$158,0741$161,0771$164,1371$167,2561$170,4341$820,982
Customer Support Technician3$367,0853$374,0593$381,1673$388,4093$395,7883$1,906,520
Requirements & BA Lead1$265,9781$271,0311$276,1811$281,4281$286,7751$1,381,397
Sr Business Analyst2$531,9552$542,0622$552,3622$562,8562$573,5512$2,762,794
Jr Business Analyst1$227,2701$231,5891$235,9891$240,4731$245,0411$1,180,366
Training Coordinator1$175,8141$179,1551$182,5591$186,0271$189,5621$913,121
Trainer1$134,4771$137,0321$139,6351$142,2891$144,9921$698,429
Audio Visual Administrator1$231,2261$235,6191$240,0961$244,6571$249,3061$1,200,908
Platform Technical Lead1$312,2691$318,2021$324,2481$330,4081$336,6861$1,621,817
Cloud Operations Engineer2$462,4512$471,2382$480,1912$489,3152$498,6122$2,401,815
Network Infrastructure Engineer2$388,3392$395,7182$403,2362$410,8982$418,7052$2,016,904
Systems Administrator2$358,2722$365,0792$372,0162$379,0842$386,2872$1,860,745
Solutions Technical Lead1$324,6531$330,8211$337,1071$343,5121$350,0391$1,686,135
Solution Architect1$234,3361$238,7881$243,3251$247,9491$252,6601$1,217,062
Sr Application Developer3$870,2783$886,8143$903,6633$920,8333$938,3293$4,519,929
Jr Application Developer2$502,9252$512,4802$522,2172$532,1402$542,2502$2,612,021
SharePoint Developer1$234,8161$239,2781$243,8241$248,4561$253,1771$1,219,555
Scrum Master2$453,1202$461,7292$470,5022$479,4422$488,5512$2,353,352
Configuration Manager1$249,6001$254,3421$259,1751$264,0991$269,1171$1,296,338
Application/Automation Tester2$245,7602$250,4292$255,1882$260,0362$264,9772$1,276,398
Q&A Tester1$163,2001$166,3011$169,4611$172,6801$175,9611$847,607
BPR Analyst2$531,9552$542,0622$552,3622$562,8562$573,5512$2,762,794
Data Team Technical Lead1$324,6531$330,8211$337,1071$343,5121$350,0391$1,686,135
Database Management Analyst2$433,9582$442,2042$450,6052$459,1672$467,8912$2,253,834
Master Data Management Analyst1$230,4581$234,8361$239,2981$243,8451$248,4781$1,196,919
Data Reports Developer1$238,0801$242,6041$247,2131$251,9101$256,6961$1,236,507
BI Data Analyst1$265,9781$271,0311$276,1811$281,4281$286,7751$1,381,397
BI Data Scientist1$252,9021$257,7081$262,6041$267,5931$272,6781$1,313,489
Data Governance Data Architect1$239,1171$243,6601$248,2901$253,0071$257,8141$1,241,892
Data Governance Senior Data Analyst1$201,6191$205,4501$209,3541$213,3311$217,3851$1,047,142
ETL Developer1$170,8031$174,0481$177,3551$180,7251$184,1591$887,095
47$10,646,68847$10,848,97547$11,055,10647$11,265,15347$11,479,19147$55,295,300

&"Times New Roman,Bold"&12Attachment 6 - Base Year

&"Times New Roman,Bold"19AQMM18R0041

IGCE Summary

EX/IT IGCE Cost Summary
234566
TOTAL 5-YEAR ESTIMATED COSTAnnual
Cost ComponentBaseOY 1OY 2OY 3OY 4TotalFTE
1Total O&M Cost$10,646,688$10,848,975$11,055,106$11,265,153$11,479,191$55,295,11247
2Total Project-Based Cost - Low$4,995,840$5,090,761$5,187,485$5,286,048$5,386,483$25,946,61721.50
3Total Project-Based Cost - High$7,277,194$7,415,460$7,556,354$7,699,925$7,846,223$37,795,15631.25
4TOTAL ESTIMATED COST - LOW$15,642,528$15,939,736$16,242,591$16,551,200$16,865,673$81,241,72868.50
5TOTAL ESTIMATED COST - HIGH$17,923,882$18,264,435$18,611,460$18,965,077$19,325,414$93,090,26878.25

O&M Estimate

Labor Category Rate Table234566
Hours Per Year =1,920Annual Cost (1920 Hours Per Year)
BranchFunctional AreaTask AreaLabor CategoryFTEBaseOY 1OY 2OY 3OY 4Total
1AllAllProgram ManagementProgram Manager1$347,386$353,986$360,712$367,565$374,549$1,804,197
2Security & GovernanceSecuritySecurity MonitoringSecurity Analyst1$233,683$238,123$242,648$247,258$251,956$1,213,667
3Security & GovernanceGovernanceEnterprise ArchitectureEnterprise Architect1$284,198$289,598$295,101$300,707$306,421$1,476,025
4Security & GovernanceGovernanceTechnical WritingTechnical Writer1$158,074$161,077$164,137$167,256$170,434$820,978
5Customer Outreach & PlatformsCustomer EngagementService DeskCustomer Support Technician3$367,085$374,059$381,167$388,409$395,788$1,906,508
6Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisRequirements & BA Lead1$265,978$271,031$276,181$281,428$286,775$1,381,393
7Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisSr Business Analyst2$531,955$542,062$552,362$562,856$573,551$2,762,786
8Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisJr Business Analyst1$227,270$231,589$235,989$240,473$245,041$1,180,362
9Customer Outreach & PlatformsCustomer EngagementTrainingTraining Coordinator1$175,814$179,155$182,559$186,027$189,562$913,117
10Customer Outreach & PlatformsCustomer EngagementTrainingTrainer1$134,477$137,032$139,635$142,289$144,992$698,425
11Customer Outreach & PlatformsCustomer EngagementAudio Visual SupportAudio Visual Administrator1$231,226$235,619$240,096$244,657$249,306$1,200,904
12Customer Outreach & PlatformsPlatformsAllPlatform Technical Lead1$312,269$318,202$324,248$330,408$336,686$1,621,813
13Customer Outreach & PlatformsPlatformsCloud OperationsCloud Operations Engineer2$462,451$471,238$480,191$489,315$498,612$2,401,807
14Customer Outreach & PlatformsPlatformsNetwork InfrastructureNetwork Infrastructure Engineer2$388,339$395,718$403,236$410,898$418,705$2,016,896
15Customer Outreach & PlatformsPlatformsSystems Administration & IntegrationSystems Administrator2$358,272$365,079$372,016$379,084$386,287$1,860,737
16Solutions & DataSolutionsAllSolutions Technical Lead1$324,653$330,821$337,107$343,512$350,039$1,686,131
17Solutions & DataSolutionsTechnology InnovationSolution Architect1$234,336$238,788$243,325$247,949$252,660$1,217,058
18Solutions & DataSolutionsSolutions & Applications DevelopmentSr Application Developer3$870,278$886,814$903,663$920,833$938,329$4,519,917
19Solutions & DataSolutionsSolutions & Applications DevelopmentJr Application Developer2$502,925$512,480$522,217$532,140$542,250$2,612,013
20Solutions & DataSolutionsSolutions & Applications DevelopmentSharePoint Developer1$234,816$239,278$243,824$248,456$253,177$1,219,551
21Solutions & DataSolutionsSolutions & Applications DevelopmentScrum Master2$453,120$461,729$470,502$479,442$488,551$2,353,344
22Solutions & DataSolutionsSolutions & Applications DevelopmentConfiguration Manager1$249,600$254,342$259,175$264,099$269,117$1,296,334
23Solutions & DataSolutionsQuality Assurance & TestingApplication/Automation Tester2$245,760$250,429$255,188$260,036$264,977$1,276,390
24Solutions & DataSolutionsQuality Assurance & TestingQ&A Tester1$163,200$166,301$169,461$172,680$175,961$847,603
25Solutions & DataSolutionsBusiness Process ReengineeringBPR Analyst2$531,955$542,062$552,362$562,856$573,551$2,762,786
26Solutions & DataDataAllData Team Technical Lead1$324,653$330,821$337,107$343,512$350,039$1,686,131
27Solutions & DataDataDatabase Management (DBAs)Database Management Analyst2$433,958$442,204$450,605$459,167$467,891$2,253,826
28Solutions & DataDataMaster Data ManagementMaster Data Management Analyst1$230,458$234,836$239,298$243,845$248,478$1,196,915
29Solutions & DataDataData ReportingData Reports Developer1$238,080$242,604$247,213$251,910$256,696$1,236,503
30Solutions & DataDataBusiness Intelligence & VisualizationBI Data Analyst1$265,978$271,031$276,181$281,428$286,775$1,381,393
31Solutions & DataDataBusiness Intelligence & VisualizationBI Data Scientist1$252,902$257,708$262,604$267,593$272,678$1,313,485
32Solutions & DataDataData GovernanceData Governance Data Architect1$239,117$243,660$248,290$253,007$257,814$1,241,888
33Solutions & DataDataData GovernanceData Governance Senior Data Analyst1$201,619$205,450$209,354$213,331$217,385$1,047,138
34Solutions & DataDataData GovernanceETL Developer1$170,803$174,048$177,355$180,725$184,159$887,091
Total O&M47$10,646,688$10,848,975$11,055,106$11,265,153$11,479,191$55,295,112

Project-Based Estimate

234566
Hours Per Year =1,920Annual Cost (1920 Hours Per Year)Total
Labor CategoryFTEBaseOY 1OY 2OY 3OY 4$FTE
1SMALL PROJECT (3-6 Months)
2Jr Business Analyst0.5$113,635$115,794$117,994$120,236$122,521$590,181
3Sr Application Developer0.5$145,046$147,802$150,611$153,472$156,388$753,319
4Scrum Master0.25$56,640$57,716$58,813$59,930$61,069$294,168
5Application/Automation Tester0.25$30,720$31,304$31,898$32,505$33,122$159,549
6Q&A Tester0.25$40,800$41,575$42,365$43,170$43,990$211,901
7Data Reports Developer0.5$119,040$121,302$123,606$125,955$128,348$618,251
8BI Data Analyst0.5$132,989$135,516$138,090$140,714$143,388$690,697
9TOTAL PER PROJECT2.75$638,870$651,009$663,378$675,982$688,826$3,318,066
10TOTAL SMALL PROJECT COST - LOW2$1,277,741$1,302,018$1,326,756$1,351,965$1,377,652$6,636,1315.50
11TOTAL SMALL PROJECT COST - HIGH3$1,916,611$1,953,027$1,990,134$2,027,947$2,066,478$9,954,1978.25
12MEDIUM PROJECT (6-12 Months)
13Jr Business Analyst1$227,270$231,589$235,989$240,473$245,041$1,180,362
14Jr Application Developer1$251,462$256,240$261,109$266,070$271,125$1,306,006
15Sr Application Developer1$290,093$295,605$301,221$306,944$312,776$1,506,639
16Scrum Master1$226,560$230,865$235,251$239,721$244,276$1,176,672
17Application/Automation Tester0.5$61,440$62,607$63,797$65,009$66,244$319,098
18Q&A Tester0.5$81,600$83,150$84,730$86,340$87,981$423,801
19Data Reports Developer1$238,080$242,604$247,213$251,910$256,696$1,236,503
20BI Data Analyst1$265,978$271,031$276,181$281,428$286,775$1,381,393
21TOTAL PER PROJECT7$1,642,483$1,673,690$1,705,490$1,737,895$1,770,915$8,530,474
22TOTAL MEDIUM PROJECT COST - LOW1$1,642,483$1,673,690$1,705,490$1,737,895$1,770,915$8,530,4747.0
23TOTAL MEDIUM PROJECT COST - HIGH2$3,284,966$3,347,381$3,410,981$3,475,790$3,541,830$17,060,94714.0
24LARGE PROJECT (12+ Months)
25Jr Business Analyst1$227,270$231,589$235,989$240,473$245,041$1,180,362
26Jr Application Developer1$251,462$256,240$261,109$266,070$271,125$1,306,006
27Sr Application Developer2$580,186$591,209$602,442$613,888$625,552$3,013,278
28Scrum Master1$226,560$230,865$235,251$239,721$244,276$1,176,672
29Application/Automation Tester1$122,880$125,215$127,594$130,018$132,488$638,195
30Q&A Tester1$163,200$166,301$169,461$172,680$175,961$847,603
31Data Reports Developer1$238,080$242,604$247,213$251,910$256,696$1,236,503
32BI Data Analyst1$265,978$271,031$276,181$281,428$286,775$1,381,393
33TOTAL PER PROJECT9$2,075,616$2,115,053$2,155,239$2,196,188$2,237,916$10,780,011
34TOTAL LARGE PROJECT COST - LOW1$2,075,616$2,115,053$2,155,239$2,196,188$2,237,916$10,780,0119.0
35TOTAL LARGE PROJECT COST - HIGH1$2,075,616$2,115,053$2,155,239$2,196,188$2,237,916$10,780,0119.0
36TOTAL PROJECT-BASED - LOW$4,995,840$5,090,761$5,187,485$5,286,048$5,386,483$25,946,61721.50
37TOTAL PROJECT-BASED - HIGH$7,277,194$7,415,460$7,556,354$7,699,925$7,846,223$37,795,15631.25

Rate Table

Labor Category Rate TableRate Escalation Assumption =2%
Hourly Rates (1920 Hours per Year)
BranchFunctional AreaTask AreaLabor CategoryBaseOY 1OY 2OY 3OY 4
1AllAllProgram ManagementProgram Manager$180.93184.36767$187.87$191.44$195.08
2Security & GovernanceSecuritySecurity MonitoringSecurity Analyst$121.71$124.02$126.38$128.78$131.23
3Security & GovernanceGovernanceEnterprise ArchitectureEnterprise Architect$148.02$150.83$153.70$156.62$159.59
4Security & GovernanceGovernanceTechnical WritingTechnical Writer$82.33$83.89$85.49$87.11$88.77
5Customer Outreach & PlatformsCustomer EngagementService DeskCustomer Support Technician$63.73$64.94$66.17$67.43$68.71
6Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisRequirements & BA Lead$138.53$141.16$143.84$146.58$149.36
7Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisSr Business Analyst$138.53$141.16$143.84$146.58$149.36
8Customer Outreach & PlatformsCustomer EngagementRequirements & Business AnalysisJr Business Analyst$118.37$120.62$122.91$125.25$127.63
9Customer Outreach & PlatformsCustomer EngagementTrainingTraining Coordinator$91.57$93.31$95.08$96.89$98.73
10Customer Outreach & PlatformsCustomer EngagementTrainingTrainer$70.04$71.37$72.73$74.11$75.52
11Customer Outreach & PlatformsCustomer EngagementAudio Visual SupportAudio Visual Administrator$120.43$122.72$125.05$127.43$129.85
12Customer Outreach & PlatformsPlatformsAllPlatform Technical Lead$162.64$165.73$168.88$172.09$175.36
13Customer Outreach & PlatformsPlatformsCloud OperationsCloud Operations Engineer$120.43$122.72$125.05$127.43$129.85
14Customer Outreach & PlatformsPlatformsNetwork InfrastructureNetwork Infrastructure Engineer$101.13$103.05$105.01$107.00$109.04
15Customer Outreach & PlatformsPlatformsSystems Administration & IntegrationSystems Administrator$93.30$95.07$96.88$98.72$100.60
16Solutions & DataSolutionsAllSolutions Technical Lead$169.09$172.30$175.58$178.91$182.31
17Solutions & DataSolutionsTechnology InnovationSolution Architect$122.05$124.37$126.73$129.14$131.59
18Solutions & DataSolutionsSolutions & Applications DevelopmentSr Application Developer$151.09$153.96$156.89$159.87$162.90
19Solutions & DataSolutionsSolutions & Applications DevelopmentJr Application Developer$130.97$133.46$135.99$138.58$141.21
20Solutions & DataSolutionsSolutions & Applications DevelopmentSharePoint Developer$122.30$124.62$126.99$129.40$131.86
21Solutions & DataSolutionsSolutions & Applications DevelopmentScrum Master$118.00$120.24$122.53$124.85$127.23
22Solutions & DataSolutionsSolutions & Applications DevelopmentConfiguration 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
23Solutions & DataSolutionsQuality Assurance & TestingApplication/Automation Tester$64.00$65.22$66.46$67.72$69.00
24Solutions & DataSolutionsQuality Assurance & TestingQ&A Tester$85.00$86.62$88.26$89.94$91.65
25Solutions & DataSolutionsBusiness Process ReengineeringBPR Analyst$138.53$141.16$143.84$146.58$149.36
26Solutions & DataDataAllData Team Technical Lead$169.09$172.30$175.58$178.91$182.31
27Solutions & DataDataDatabase Management (DBAs)Database Management Analyst$113.01$115.16$117.35$119.57$121.85
28Solutions & DataDataMaster Data ManagementMaster Data Management Analyst$120.03$122.31$124.63$127.00$129.42
29Solutions & DataDataData ReportingData Reports Developer$124.00$126.36$128.76$131.20$133.70
30Solutions & DataDataBusiness Intelligence & VisualizationBI Data Analyst$138.53$141.16$143.84$146.58$149.36
31Solutions & DataDataBusiness Intelligence & VisualizationBI Data Scientist$131.72$134.22$136.77$139.37$142.02
32Solutions & DataDataData GovernanceData Governance Data Architect$124.54$126.91$129.32$131.77$134.28
33Solutions & DataDataData GovernanceData Governance Senior Data Analyst$105.01$107.01$109.04$111.11$113.22
34Solutions & DataDataData GovernanceETL 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 .