Attachment 0002 - Pricing Cypher LLC.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- 69319522R000001
About this file
This document contains a pricing spreadsheet and award notice for a federal contract. Cypher LLC was awarded an IDIQ contract valued at $17,664,148.80 for the period of September 30, 2022 through September 29, 2027 to provide technical support services to the Federal Transit Administration's Transit Safety Office. The pricing spreadsheet outlines labor categories, hourly rates, and discounts for the base year and four option years. Services include policy development and implementation, safety risk management process implementation, data collection, analysis and reporting, technical assistance development and delivery, and program evaluation and safety assurance. The award notice identifies the solicitation and contract numbers for the IDIQ awarded to Cypher LLC on September 27, 2022.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment 0001 - 69391522D000013 - Cypher final.docx | DOCX document | |
| SF-26 Cypher 69319522D000013_Signed.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
Pricing
| TSO-10 Safety Program Support | |||||||||||||||||||||||||||||
| Program Area | Description | Labor Categories | Quantity | Loaded Hourly | Discount | Rate after Discount | Base Year | Quantity | Loaded Hourly | Discount | Rate after Discount | Option Year 1 | Quantity | Loaded Hourly | Discount | Rate after Discount | Option Year 2 | Quantity | Loaded Hourly | Discount | Rate After Discount | Option Year 3 | Quantity | Loaded Hourly | Discount | Rate after Discount | Option Year 4 | Total 5-Year | Total 5-Year |
| (Hours) | Labor Rate | (Hours) | Labor Rate | (Hours) | Labor Rate | (Hours) | Labor Rate | (Hours) | Labor Rate | Labor Hours | Contract Value | ||||||||||||||||||
| CLIN 0001 | Policy Development and Implementation | ||||||||||||||||||||||||||||
| Program Manager | 520 | $215.48 | 35% | $ 159.61 | $82,999.70 | 520 | $220.87 | 35% | $ 163.61 | $85,074.70 | 520 | $226.39 | 35% | $ 167.70 | $87,201.56 | 520 | $232.05 | 35% | $ 171.89 | $89,381.60 | 520 | $237.85 | 35% | $ 176.18 | $91,616.14 | 2600 | $436,273.71 | ||
| Senior Consultant/SME | 520 | $215.12 | 30% | $ 165.48 | $86,048.00 | 520 | $220.50 | 30% | $ 169.61 | $88,199.20 | 520 | $226.01 | 30% | $ 173.85 | $90,404.18 | 520 | $231.66 | 30% | $ 178.20 | $92,664.28 | 520 | $237.45 | 30% | $ 182.66 | $94,980.89 | 2600 | $452,296.56 | ||
| Senior Analyst | 2080 | $143.26 | 12% | $ 127.91 | $266,054.29 | 2080 | $146.84 | 12% | $ 131.11 | $272,705.64 | 2080 | $150.51 | 12% | $ 134.39 | $279,523.28 | 2080 | $154.28 | 12% | $ 137.75 | $286,511.37 | 2080 | $158.13 | 12% | $ 141.19 | $293,674.15 | 10400 | $1,398,468.73 | ||
| Mid-Level Analyst | 1560 | $117.67 | 0% | $ 117.67 | $183,565.20 | 1560 | $120.61 | 0% | $ 120.61 | $188,154.33 | 1560 | $123.63 | 0% | $ 123.63 | $192,858.19 | 1560 | $126.72 | 0% | $ 126.72 | $197,679.64 | 1560 | $129.89 | 0% | $ 129.89 | $202,621.63 | 7800 | $964,879.00 | ||
| Junior Analyst | 520 | $96.81 | 0% | $ 96.81 | $50,341.20 | 520 | $99.23 | 0% | $ 99.23 | $51,599.73 | 520 | $101.71 | 0% | $ 101.71 | $52,889.72 | 520 | $104.25 | 0% | $ 104.25 | $54,211.97 | 520 | $106.86 | 0% | $ 106.86 | $55,567.27 | 2600 | $264,609.89 |
Subtotals 5200 $669,008.39 5200 $685,733.60 5200 $702,876.94 5200 $720,448.86 5200 $738,460.08 26000 $3,516,527.87
| CLIN 0002 | Safety Risk Management Process Implementation | ||||||||||||||||||||||||||||
| Program Manager | 520 | $215.48 | 35% | $ 159.61 | $82,999.70 | 520 | $220.87 | 35% | $ 163.61 | $85,074.70 | 520 | $226.39 | 35% | $ 167.70 | $87,201.56 | 520 | $232.05 | 35% | $ 171.89 | $89,381.60 | 520 | $237.85 | 35% | $ 176.18 | $91,616.14 | 2600 | $436,273.71 | ||
| Senior Consultant/SME | 520 | $215.12 | 30% | $ 165.48 | $86,048.00 | 520 | $220.50 | 30% | $ 169.61 | $88,199.20 | 520 | $226.01 | 30% | $ 173.85 | $90,404.18 | 520 | $231.66 | 30% | $ 178.20 | $92,664.28 | 520 | $237.45 | 30% | $ 182.66 | $94,980.89 | 2600 | $452,296.56 | ||
| Senior Analyst | 2080 | $143.26 | 12% | $ 127.91 | $266,054.29 | 2080 | $146.84 | 12% | $ 131.11 | $272,705.64 | 2080 | $150.51 | 12% | $ 134.39 | $279,523.28 | 2080 | $154.28 | 12% | $ 137.75 | $286,511.37 | 2080 | $158.13 | 12% | $ 141.19 | $293,674.15 | 10400 | $1,398,468.73 | ||
| Mid-Level Analyst | 1560 | $117.67 | 0% | $ 117.67 | $183,565.20 | 1560 | $120.61 | 0% | $ 120.61 | $188,154.33 | 1560 | $123.63 | 0% | $ 123.63 | $192,858.19 | 1560 | $126.72 | 0% | $ 126.72 | $197,679.64 | 1560 | $129.89 | 0% | $ 129.89 | $202,621.63 | 7800 | $964,879.00 | ||
| Junior Analyst | 520 | $96.81 | 0% | $ 96.81 | $50,341.20 | 520 | $99.23 | 0% | $ 99.23 | $51,599.73 | 520 | $101.71 | 0% | $ 101.71 | $52,889.72 | 520 | $104.25 | 0% | $ 104.25 | $54,211.97 | 520 | $106.86 | 0% | $ 106.86 | $55,567.27 | 2600 | $264,609.89 |
Subtotals 5200 $669,008.39 5200 $685,733.60 5200 $702,876.94 5200 $720,448.86 5200 $738,460.08 26000 $3,516,527.87
| CLIN 0003 | Data Collection, Analysis & Reporting | ||||||||||||||||||||||||||||
| Program Manager | 520 | $215.48 | 35% | $ 159.61 | $82,999.70 | 520 | $220.87 | 35% | $ 163.61 | $85,074.70 | 520 | $226.39 | 35% | $ 167.70 | $87,201.56 | 520 | $232.05 | 35% | $ 171.89 | $89,381.60 | 520 | $237.85 | 35% | $ 176.18 | $91,616.14 | 2600 | $436,273.71 | ||
| Senior Consultant/SME | 520 | $215.12 | 30% | $ 165.48 | $86,048.00 | 520 | $220.50 | 30% | $ 169.61 | $88,199.20 | 520 | $226.01 | 30% | $ 173.85 | $90,404.18 | 520 | $231.66 | 30% | $ 178.20 | $92,664.28 | 520 | $237.45 | 30% | $ 182.66 | $94,980.89 | 2600 | $452,296.56 | ||
| Senior Analyst | 2080 | $143.26 | 12% | $ 127.91 | $266,054.29 | 2080 | $146.84 | 12% | $ 131.11 | $272,705.64 | 2080 | $150.51 | 12% | $ 134.39 | $279,523.28 | 2080 | $154.28 | 12% | $ 137.75 | $286,511.37 | 2080 | $158.13 | 12% | $ 141.19 | $293,674.15 | 10400 | $1,398,468.73 | ||
| Mid-Level Analyst | 1560 | $117.67 | 0% | $ 117.67 | $183,565.20 | 1040 | $120.61 | 0% | $ 120.61 | $125,436.22 | 1040 | $123.63 | 0% | $ 123.63 | $128,572.13 | 1040 | $126.72 | 0% | $ 126.72 | $131,786.43 | 1040 | $129.89 | 0% | $ 129.89 | $135,081.09 | 5720 | $704,441.06 | ||
| Junior Analyst | 520 | $96.81 | 0% | $ 96.81 | $50,341.20 | 1560 | $99.23 | 0% | $ 99.23 | $154,799.19 | 1560 | $101.71 | 0% | $ 101.71 | $158,669.17 | 1560 | $104.25 | 0% | $ 104.25 | $162,635.90 | 1560 | $106.86 | 0% | $ 106.86 | $166,701.80 | 6760 | $693,147.26 |
Subtotals 5200 $669,008.39 5720 $726,214.95 5720 $744,370.32 5720 $762,979.58 5720 $782,054.07 22880 $3,684,627.31
| CLIN 0004 | Technical Assistance Development & Delivery | ||||||||||||||||||||||||||||
| Program Manager | 1040 | $215.48 | 35% | $ 159.61 | $165,999.41 | 1040 | $220.87 | 35% | $ 163.61 | $170,149.39 | 1040 | $226.39 | 35% | $ 167.70 | $174,403.13 | 1040 | $232.05 | 35% | $ 171.89 | $178,763.21 | 1040 | $237.85 | 35% | $ 176.18 | $183,232.29 | 5200 | $872,547.42 | ||
| Senior Consultant/SME | 1040 | $215.12 | 30% | $ 165.48 | $172,096.00 | 1040 | $220.50 | 30% | $ 169.61 | $176,398.40 | 1040 | $226.01 | 30% | $ 173.85 | $180,808.36 | 1040 | $231.66 | 30% | $ 178.20 | $185,328.57 | 1040 | $237.45 | 30% | $ 182.66 | $189,961.78 | 5200 | $904,593.11 | ||
| Senior Analyst | 2080 | $143.26 | 12% | $ 127.91 | $266,054.29 | 2080 | $146.84 | 12% | $ 131.11 | $272,705.64 | 2080 | $150.51 | 12% | $ 134.39 | $279,523.28 | 2080 | $154.28 | 12% | $ 137.75 | $286,511.37 | 2080 | $158.13 | 12% | $ 141.19 | $293,674.15 | 10400 | $1,398,468.73 | ||
| Mid-Level Analyst | 1040 | $117.67 | 0% | $ 117.67 | $122,376.80 | 1040 | $120.61 | 0% | $ 120.61 | $125,436.22 | 1040 | $123.63 | 0% | $ 123.63 | $128,572.13 | 1040 | $126.72 | 0% | $ 126.72 | $131,786.43 | 1040 | $129.89 | 0% | $ 129.89 | $135,081.09 | 5200 | $643,252.66 | ||
| Junior Analyst | 520 | $96.81 | 0% | $ 96.81 | $50,341.20 | 520 | $99.23 | 0% | $ 99.23 | $51,599.73 | 520 | $101.71 | 0% | $ 101.71 | $52,889.72 | 520 | $104.25 | 0% | $ 104.25 | $54,211.97 | 520 | $106.86 | 0% | $ 106.86 | $55,567.27 | 2600 | $264,609.89 |
Subtotals 5720 $776,867.69 5720 $796,289.39 5720 $816,196.62 5720 $836,601.54 5720 $857,516.57 28600 $4,083,471.81
| CLIN 0005 | Program Evaluation & Safety Assurance | ||||||||||||||||||||||||||||
| Program Manager | 1040 | $215.48 | 35% | $ 159.61 | $165,999.41 | 1040 | $220.87 | 35% | $ 163.61 | $170,149.39 | 1040 | $226.39 | 35% | $ 167.70 | $174,403.13 | 1040 | $232.05 | 35% | $ 171.89 | $178,763.21 | 1040 | $237.85 | 35% | $ 176.18 | $183,232.29 | 5200 | $872,547.42 | ||
| Senior Consultant/SME | 1040 | $215.12 | 30% | $ 165.48 | $172,096.00 | 1040 | $220.50 | 30% | $ 169.61 | $176,398.40 | 1040 | $226.01 | 30% | $ 173.85 | $180,808.36 | 1040 | $231.66 | 30% | $ 178.20 | $185,328.57 | 1040 | $237.45 | 30% | $ 182.66 | $189,961.78 | 5200 | $904,593.11 | ||
| Senior Analyst | 520 | $143.26 | 12% | $ 127.91 | $66,513.57 | 520 | $146.84 | 12% | $ 131.11 | $68,176.41 | 520 | $150.51 | 12% | $ 134.39 | $69,880.82 | 520 | $154.28 | 12% | $ 137.75 | $71,627.84 | 520 | $158.13 | 12% | $ 141.19 | $73,418.54 | 2600 | $349,617.18 | ||
| Mid-Level Analyst | 520 | $117.67 | 0% | $ 117.67 | $61,188.40 | 520 | $120.61 | 0% | $ 120.61 | $62,718.11 | 520 | $123.63 | 0% | $ 123.63 | $64,286.06 | 520 | $126.72 | 0% | $ 126.72 | $65,893.21 | 520 | $129.89 | 0% | $ 129.89 | $67,540.54 | 2600 | $321,626.33 | ||
| Junior Analyst | 520 | $96.81 | 0% | $ 96.81 | $50,341.20 | 520 | $99.23 | 0% | $ 99.23 | $51,599.73 | 520 | $101.71 | 0% | $ 101.71 | $52,889.72 | 520 | $104.25 | 0% | $ 104.25 | $54,211.97 | 520 | $106.86 | 0% | $ 106.86 | $55,567.27 | 2600 | $264,609.89 |
Subtotals 3640 $516,138.58 3640 $529,042.04 3640 $542,268.09 3640 $555,824.80 3640 $569,720.42 18200 $2,712,993.93
| CLIN 0006 | Other Direct Costs | $17,514,148.80 | Total Labor Costs for 5-year | |||||||||||
| Other Direct Costs (Travel & Per Diem)(NTE) | $15,000.00 | $15,000.00 | $15,000.00 | $15,000.00 | $15,000.00 | $75,000.00 | ||||||||
| Printing (NTE) | $5,000.00 | $5,000.00 | $5,000.00 | $5,000.00 | $5,000.00 | $25,000.00 | ||||||||
| Workshops (NTE) | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | $10,000.00 | $50,000.00 | ||||||||
| --------------------- | --------------------- | --------------------- | --------------------- | --------------------- | --------------------- | |||||||||
| Subtotal Other | 0 | $30,000.00 | 0 | $30,000.00 | 0 | $30,000.00 | 0 | $30,000.00 | 0 | $30,000.00 | $150,000.00 |
| Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | |||||||
| Sum Total Labor Costs | 24960 | $3,300,031.44 | 25480 | $3,423,013.58 | 25480 | $3,508,588.92 | 25480 | $3,596,303.64 | 25480 | $3,686,211.23 | $17,514,148.80 |
Sum Other Direct Costs 0 $30,000.00 0 $30,000.00 0 $30,000.00 0 $30,000.00 0 $30,000.00 $150,000.00
TOTAL (per year) 24960 $3,330,031.44 25480 $3,453,013.58 25480 $3,538,588.92 25480 $3,626,303.64 25480 $3,716,211.23 $17,664,148.80
File details come from the government source that posted it. Updated .