Attachment 0001 - Pricing.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
National Transit Database (NTD) Program Support
Solicitation number
69319522R000002
Issued by

About this file

This document contains a pricing matrix and statement of work for a federal contract to provide National Transit Database Program Support services to the Federal Transit Administration. Boyd Caton Group, Inc. will provide services including NTD assistance, annual and monthly modules, safety and security modules, apportionment and non-Excel data products, annual reviews, reporting, program performance metrics, travel, transition, staffing, special projects, training, user acceptance testing, and written documents. The base period of performance is one year from November 1, 2022 to October 31, 2023 with two optional one-year extensions. The total contract value is $11,910,359.25 over three years to be paid through both firm-fixed-price and labor-hour CLINs.

View the file

Other files

File Type Posted
69319522C000004 award signed.pdf PDF

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

Sheet1

Price Matrix
Firm Fixed Price CLINBase YearOption Year 1Option Year 2
CLIN DescriptionCLINReimbursement TypeNot To Exceed AmountNot To Exceed AmountNot To Exceed Amount
NTD Assistance0001, 0101, 0201Firm Fixed Price$ 234,738.00$ 232,928.29$ 236,422.21
Annual Module0002, 0102, 0202Firm Fixed Price$ 2,182,178.00$ 2,160,171.72$ 2,179,717.09
Monthly Module0003, 0103, 0203Firm Fixed Price$ 158,484.00$ 160,861.26$ 163,274.18
Safety and Security Module0004, 0104, 0204Firm Fixed Price$ 508,996.00$ 508,502.82$ 516,130.36
Apportionment and Certain Non-Excel Data Products0005, 0105, 0205Firm Fixed Price$ 142,720.00$ 144,860.80$ 147,033.71
Annual Review0006, 0106, 0206Firm Fixed Price$ 31,168.00$ 31,635.52$ 32,110.05
Reporting Manuals, Training Materials and Website Content0007, 0107, 0207Firm Fixed Price$ 100,200.00$ 101,703.00$ 103,228.54
Program Performance Metrics Reporting0008, 0108, 0208Firm Fixed Price$ 46,800.00$ 47,502.00$ 48,214.53
Travel*0009, 0109, 0209Cost Reimbursable$ 42,013.90$ 42,644.10$ 43,283.76
Transition0013, 0213Firm Fixed Price$ 15,659.42
Staffing Plan0015, 0115, 0215Firm Fixed Price$ 63,428.00$ 64,379.42$ 65,345.11
Labor Hour CLINBase YearOption Year 1Option Year 2
CLIN DescriptionCLINReimbursement TypeTotal Cost Not To Exceed (Contractor Recommended)Total Cost Not To Exceed (Contractor Recommended)Total Cost Not To Exceed (Contractor Recommended)
Special Projects0010, 0110, 0210Labor Hours (detail in table below)$ 140,871.20$ 131,818.46$ 133,796.22
Training Provision0011, 0111, 0211Labor Hours (detail in table below)$ 20,067.78$ 18,862.55$ 19,145.12
User Accpetance Testing and System Requirements Documentation0012, 0112, 0212Labor Hours (detail in table below)$ 234,428.74$ 219,660.76$ 222,957.52
Written Documents014, 014, 024Labor Hours (detail in table below)$ 73,470.82$ 68,955.57$ 69,990.72
Total Contract Cost (All CLINs)Base YearOption Year 1Option Year 2
$ 3,979,564.44$ 3,934,486.26$ 3,996,308.55$ 11,910,359.25
Base Year Labor Hour CLIN Detail
0010: Special Projects
YearBase Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *204204$ 158.40$ 32,313.60$ 32,313.60
Subject Matter Expert **204204$ 192.06$ 39,180.24$ 39,180.24
Data Analyst (Sr)204204$ 72.00$ 14,688.00$ 14,688.00
Data Analyst (Jr)407407$ 52.00$ 21,164.00$ 21,164.00
Database Architect I *204204$ 164.34$ 33,525.36$ 33,525.36
Total12231223$ 140,871.20$ 140,871.20
* Rate includes a 1% discount
* Rate includes a 3% discount
0011: Training Provision
YearBase Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *1313$ 158.40$ 2,059.20$ 2,059.20
Subject Matter Expert **4343$ 192.06$ 8,258.58$ 8,258.58
Trainer130130$ 75.00$ 9,750.00$ 9,750.00
Total186186$ 20,067.78$ 20,067.78
* Rate includes a 1% discount
* Rate includes a 3% discount
0012: User Accpetance Testing and System Requirements Documentation
YearBase Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *130130$ 158.40$ 20,592.00$ 20,592.00
Database Architect I *611611$ 164.34$ 100,411.74$ 100,411.74
Senior Database Developer611611$ 99.00$ 60,489.00$ 60,489.00
Data Analyst (Jr)10181018$ 52.00$ 52,936.00$ 52,936.00
Total23702370$ 234,428.74$ 234,428.74
* Rate includes a 1% discount
0014: Written Documents
YearBase Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *6767$ 158.40$ 10,612.80$ 10,612.80
Subject Matter Expert **6767$ 192.06$ 12,868.02$ 12,868.02
Data Analyst (Sr)134134$ 72.00$ 9,648.00$ 9,648.00
Data Analyst (Jr)134134$ 52.00$ 6,968.00$ 6,968.00
Editor407407$ 82.00$ 33,374.00$ 33,374.00
Total809809$ 73,470.82$ 73,470.82
* Rate includes a 1% discount
* Rate includes a 3% discount
Option Year 1 Labor Hour CLIN Detail
0110: Special Projects
YearOption Year 1
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *188188$ 160.78$ 30,225.89$ 30,225.89
Subject Matter Expert **188188$ 194.94$ 36,648.89$ 36,648.89
Data Analyst (Sr)188188$ 73.08$ 13,739.04$ 13,739.04
Data Analyst (Jr)376376$ 52.78$ 19,845.28$ 19,845.28
Database Architect I *188188$ 166.81$ 31,359.36$ 31,359.36
Total11281128$ 131,818.46$ 131,818.46
* Rate includes a 1% discount
* Rate includes a 3% discount
0111: Training Provision
YearOption Year 1
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *1212$ 160.78$ 1,929.31$ 1,929.31
Subject Matter Expert **4040$ 194.94$ 7,797.64$ 7,797.64
Trainer120120$ 76.13$ 9,135.60$ 9,135.60
Total172172$ 18,862.55$ 18,862.55
* Rate includes a 1% discount
** Rate includes a 3% discount
0112: User Accpetance Testing and System Requirements Documentation
YearOption Year 1
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *120120$ 160.78$ 19,293.12$ 19,293.12
Database Architect I *564564$ 166.81$ 94,078.08$ 94,078.08
Senior Database Developer564564$ 100.49$ 56,676.36$ 56,676.36
Data Analyst (Jr)940940$ 52.78$ 49,613.20$ 49,613.20
Total21882188$ 219,660.76$ 219,660.76
* Rate includes a 1% discount
0114: Written Documents
Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *6262$ 160.78$ 9,968.11$ 9,968.11
Subject Matter Expert **6262$ 194.94$ 12,086.34$ 12,086.34
Data Analyst (Sr)124124$ 73.08$ 9,061.92$ 9,061.92
Data Analyst (Jr)124124$ 52.78$ 6,544.72$ 6,544.72
Editor376376$ 83.23$ 31,294.48$ 31,294.48
Total748748$ 68,955.57$ 68,955.57
* Rate includes a 1% discount
** Rate includes a 3% discount
Option Year 2 Labor Hour CLIN Detail
0210: Special Projects
YearOption Year 2
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *188188$ 163.19$ 30,680.02$ 30,680.02
Subject Matter Expert **188188$ 197.86$ 37,197.79$ 37,197.79
Data Analyst (Sr)188188$ 74.18$ 13,945.84$ 13,945.84
Data Analyst (Jr)376376$ 53.57$ 20,142.32$ 20,142.32
Database Architect I *188188$ 169.31$ 31,830.24$ 31,830.24
Total11281128$ 133,796.22$ 133,796.22
* Rate includes a 1% discount
** Rate includes a 3% discount
0211: Training Provision
YearOption Year 2
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *1212$ 163.19$ 1,958.30$ 1,958.30
Subject Matter Expert **4040$ 197.86$ 7,914.42$ 7,914.42
Trainer120120$ 77.27$ 9,272.40$ 9,272.40
Total172172$ 19,145.12$ 19,145.12
* Rate includes a 1% discount
** Rate includes a 3% discount
0212: User Accpetance Testing and System Requirements Documentation
YearOption Year 2
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *120120$ 163.19$ 19,582.99$ 19,582.99
Database Architect I *564564$ 169.31$ 95,490.73$ 95,490.73
Senior Database Developer564564$ 102.00$ 57,528.00$ 57,528.00
Data Analyst (Jr)940940$ 53.57$ 50,355.80$ 50,355.80
Total21882188$ 222,957.52$ 222,957.52
* Rate includes a 1% discount
0214: Written Documents
Year
Labor CategoryGovt Estimated HoursContractor Recommended HoursHourly RateTotal Cost (Govt Hrs)Total Cost (Contractor Recommended Hrs)
Project Manager *6262$ 163.19$ 10,117.88$ 10,117.88
Subject Matter Expert **6262$ 197.86$ 12,267.36$ 12,267.36
Data Analyst (Sr)124124$ 74.18$ 9,198.32$ 9,198.32
Data Analyst (Jr)124124$ 53.57$ 6,642.68$ 6,642.68
Editor376376$ 84.48$ 31,764.48$ 31,764.48
Total748748$ 69,990.72$ 69,990.72
* Rate includes a 1% discount
** Rate includes a 3% discount

File details come from the government source that posted it. Updated .