Attachment 0002- Pricing Snow Eagle Group.xlsx
XLSX spreadsheet 52 KB Posted
- Solicitation number
- 69319522R000001
About this file
This document contains a pricing spreadsheet and award notice for an IDIQ contract. The federal contract was awarded to Snow Eagle Group by the Department of Transportation Federal Transit Administration on September 27, 2022. The purpose of the contract is for Snow Eagle Group to provide SMS Technical Support services to FTA's Transit Safety Office over a five year period from September 30, 2022 to September 29, 2027. The pricing spreadsheet outlines labor rates and quantities for six contract line item numbers including Policy Development, Safety Risk Management, Data Collection and Reporting, Technical Assistance Development and Delivery, Program Evaluation and Safety Assurance, and Other Direct Costs. The total estimated value of the contract is $15,934,159.74 to be paid over the five year base period and four optional one year periods.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| SF-26 Snow Eagle 69319522D000014_Signed.pdf | ||
| Attachment 0001 - 69391522D000014 - Snow Eagle. finaldocx.docx | DOCX document |
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
SEG Pricing File
| TSO-10 Safety Program Support | ||||||||||||||||||||||||||||||||||
| Program Area | Description | Labor Categories | Quantity | Loaded Hourly | BPA | Discount | Discount | Base Year | Quantity | Loaded Hourly | BPA | Discount | Discount | Option Year 1 | Quantity | Loaded Hourly | BPA | Discount | Discount | Option Year 2 | Quantity | Loaded Hourly | BPA | Discount | Discount | Option Year 3 | Quantity | Loaded Hourly | BPA | Discount | Discount | Option Year 4 | Total 5-Year | Total 5-Year |
| (Hours) | Labor Rate | Labor Rate | ($) | (%) | (Hours) | Labor Rate | Labor Rate | ($) | (%) | (Hours) | Labor Rate | Labor Rate | ($) | (%) | (Hours) | Labor Rate | Labor Rate | ($) | (%) | (Hours) | Labor Rate | Labor Rate | ($) | (%) | Labor Hours | Contract Value | ||||||||
| CLIN 0001 | Policy Development and Implementation | |||||||||||||||||||||||||||||||||
| Program Manager | 520 | $124.31 | $140.76 | $16.45 | 12% | $64,641.20 | 520 | $126.80 | $144.28 | $16.78 | 12% | $65,934.02 | 520 | $129.33 | $147.89 | $17.12 | 12% | $67,252.70 | 520 | $131.92 | $151.58 | $17.46 | 12% | $68,597.76 | 520 | $134.56 | $155.37 | $17.81 | 11% | $69,969.71 | 2600 | $336,395.40 | ||
| Senior Consultant/SME | 520 | $160.53 | $193.85 | $33.32 | 17% | $83,475.60 | 520 | $163.74 | $198.70 | $33.99 | 17% | $85,145.11 | 520 | $167.02 | $203.66 | $34.67 | 17% | $86,848.01 | 520 | $170.36 | $208.76 | $35.36 | 17% | $88,584.97 | 520 | $173.76 | $213.97 | $36.07 | 17% | $90,356.67 | 2600 | $434,410.37 | ||
| Senior Analyst | 2080 | $150.87 | $170.87 | $20.00 | 12% | $313,809.60 | 2080 | $153.89 | $175.14 | $20.40 | 12% | $320,085.79 | 2080 | $156.97 | $179.52 | $20.81 | 12% | $326,487.51 | 2080 | $160.10 | $184.01 | $21.23 | 12% | $333,017.26 | 2080 | $163.31 | $188.61 | $21.65 | 11% | $339,677.60 | 10400 | $1,633,077.76 | ||
| Mid-Level Analyst | 1560 | $116.42 | $134.92 | $18.50 | 14% | $181,615.20 | 1560 | $118.75 | $138.29 | $18.87 | 14% | $185,247.50 | 1560 | $121.12 | $141.75 | $19.25 | 14% | $188,952.45 | 1560 | $123.55 | $145.29 | $19.63 | 14% | $192,731.50 | 1560 | $126.02 | $148.93 | $20.03 | 13% | $196,586.13 | 7800 | $945,132.79 | ||
| Junior Analyst | 520 | $75.21 | $90.12 | $14.91 | 17% | $39,109.20 | 520 | $76.71 | $92.37 | $15.21 | 16% | $39,891.38 | 520 | $78.25 | $94.68 | $15.51 | 16% | $40,689.21 | 520 | $79.81 | $97.05 | $15.82 | 16% | $41,503.00 | 520 | $81.41 | $99.48 | $16.14 | 16% | $42,333.06 | 2600 | $203,525.85 |
Subtotals 5200 $682,650.80 5200 $696,303.82 5200 $710,229.89 5200 $724,434.49 5200 $738,923.18 26000 $3,552,542.18
| CLIN 0002 | Safety Risk Management Process Implementation | |||||||||||||||||||||||||||||||||
| Program Manager | 520 | $124.31 | $140.76 | $16.45 | 12% | $64,641.20 | 520 | $126.80 | $144.28 | $16.78 | 12% | $65,934.02 | 520 | $129.33 | $147.89 | $17.12 | 12% | $67,252.70 | 520 | $131.92 | $151.58 | $17.46 | 12% | $68,597.76 | 520 | $134.56 | $155.37 | $17.81 | 11% | $69,969.71 | 2600 | $336,395.40 | ||
| Senior Consultant/SME | 520 | $160.53 | $193.85 | $33.32 | 17% | $83,475.60 | 520 | $163.74 | $198.70 | $33.99 | 17% | $85,145.11 | 520 | $167.02 | $203.66 | $34.67 | 17% | $86,848.01 | 520 | $170.36 | $208.76 | $35.36 | 17% | $88,584.97 | 520 | $173.76 | $213.97 | $36.07 | 17% | $90,356.67 | 2600 | $434,410.37 | ||
| Senior Analyst | 2080 | $113.86 | $170.87 | $57.01 | 33% | $236,828.80 | 2080 | $116.14 | $175.14 | $58.15 | 33% | $241,565.38 | 2080 | $118.46 | $179.52 | $59.32 | 33% | $246,396.68 | 2080 | $120.83 | $184.01 | $60.50 | 33% | $251,324.62 | 2080 | $123.25 | $188.61 | $61.71 | 33% | $256,351.11 | 10400 | $1,232,466.59 | ||
| Mid-Level Analyst | 1560 | $116.42 | $134.92 | $18.50 | 14% | $181,615.20 | 1560 | $118.75 | $138.29 | $18.87 | 14% | $185,247.50 | 1560 | $121.12 | $141.75 | $19.25 | 14% | $188,952.45 | 1560 | $123.55 | $145.29 | $19.63 | 14% | $192,731.50 | 1560 | $126.02 | $148.93 | $20.03 | 13% | $196,586.13 | 7800 | $945,132.79 | ||
| Junior Analyst | 520 | $75.21 | $90.12 | $14.91 | 17% | $39,109.20 | 520 | $76.71 | $92.37 | $15.21 | 16% | $39,891.38 | 520 | $78.25 | $94.68 | $15.51 | 16% | $40,689.21 | 520 | $79.81 | $97.05 | $15.82 | 16% | $41,503.00 | 520 | $81.41 | $99.48 | $16.14 | 16% | $42,333.06 | 2600 | $203,525.85 |
Subtotals 5200 $605,670.00 5200 $617,783.40 5200 $630,139.07 5200 $642,741.85 5200 $655,596.69 26000 $3,151,931.00
| CLIN 0003 | Data Collection, Analysis & Reporting | |||||||||||||||||||||||||||||||||
| Program Manager | 520 | $124.31 | $140.76 | $16.45 | 12% | $64,641.20 | 520 | $126.80 | $144.28 | $16.78 | 12% | $65,934.02 | 520 | $129.33 | $147.89 | $17.12 | 12% | $67,252.70 | 520 | $131.92 | $151.58 | $17.46 | 12% | $68,597.76 | 520 | $134.56 | $155.37 | $17.81 | 11% | $69,969.71 | 2600 | $336,395.40 | ||
| Senior Consultant/SME | 520 | $160.53 | $193.85 | $33.32 | 17% | $83,475.60 | 520 | $163.74 | $198.70 | $33.99 | 17% | $85,145.11 | 520 | $167.02 | $203.66 | $34.67 | 17% | $86,848.01 | 520 | $170.36 | $208.76 | $35.36 | 17% | $88,584.97 | 520 | $173.76 | $213.97 | $36.07 | 17% | $90,356.67 | 2600 | $434,410.37 | ||
| Senior Analyst | 2080 | $97.36 | $170.87 | $73.51 | 43% | $202,508.80 | 2080 | $99.31 | $175.14 | $74.98 | 43% | $206,558.98 | 2080 | $101.29 | $179.52 | $76.48 | 43% | $210,690.16 | 2080 | $103.32 | $184.01 | $78.01 | 42% | $214,903.96 | 2080 | $105.39 | $188.61 | $79.57 | 42% | $219,202.04 | 10400 | $1,053,863.93 | ||
| Mid-Level Analyst | 1560 | $91.33 | $134.92 | $43.59 | 32% | $142,474.80 | 1040 | $93.16 | $138.29 | $44.46 | 32% | $96,882.86 | 1040 | $95.02 | $141.75 | $45.35 | 32% | $98,820.52 | 1040 | $96.92 | $145.29 | $46.26 | 32% | $100,796.93 | 1040 | $98.86 | $148.93 | $47.18 | 32% | $102,812.87 | 5720 | $541,787.99 | ||
| Junior Analyst | 520 | $75.21 | $90.12 | $14.91 | 17% | $39,109.20 | 1560 | $76.71 | $92.37 | $15.21 | 16% | $119,674.15 | 1560 | $78.25 | $94.68 | $15.51 | 16% | $122,067.64 | 1560 | $79.81 | $97.05 | $15.82 | 16% | $124,508.99 | 1560 | $81.41 | $99.48 | $16.14 | 16% | $126,999.17 | 6760 | $532,359.14 |
Subtotals 5200 $532,209.60 5720 $574,195.13 5720 $585,679.03 5720 $597,392.61 5720 $609,340.46 22880 $2,898,816.83
| CLIN 0004 | Technical Assistance Development & Delivery | |||||||||||||||||||||||||||||||||
| Program Manager | 1040 | $124.31 | $140.76 | $16.45 | 12% | $129,282.40 | 1040 | $126.80 | $144.28 | $16.78 | 12% | $131,868.05 | 1040 | $129.33 | $147.89 | $17.12 | 12% | $134,505.41 | 1040 | $131.92 | $151.58 | $17.46 | 12% | $137,195.52 | 1040 | $134.56 | $155.37 | $17.81 | 11% | $139,939.43 | 5200 | $672,790.80 | ||
| Senior Consultant/SME | 1040 | $160.53 | $193.85 | $33.32 | 17% | $166,951.20 | 1040 | $163.74 | $198.70 | $33.99 | 17% | $170,290.22 | 1040 | $167.02 | $203.66 | $34.67 | 17% | $173,696.03 | 1040 | $170.36 | $208.76 | $35.36 | 17% | $177,169.95 | 1040 | $173.76 | $213.97 | $36.07 | 17% | $180,713.35 | 5200 | $868,820.75 | ||
| Senior Analyst | 2080 | $150.87 | $170.87 | $20.00 | 12% | $313,809.60 | 2080 | $153.89 | $175.14 | $20.40 | 12% | $320,085.79 | 2080 | $156.97 | $179.52 | $20.81 | 12% | $326,487.51 | 2080 | $160.10 | $184.01 | $21.23 | 12% | $333,017.26 | 2080 | $163.31 | $188.61 | $21.65 | 11% | $339,677.60 | 10400 | $1,633,077.76 | ||
| Mid-Level Analyst | 1040 | $94.59 | $134.92 | $40.33 | 30% | $98,373.60 | 1040 | $96.48 | $138.29 | $41.14 | 30% | $100,341.07 | 1040 | $98.41 | $141.75 | $41.96 | 30% | $102,347.89 | 1040 | $100.38 | $145.29 | $42.80 | 29% | $104,394.85 | 1040 | $102.39 | $148.93 | $43.66 | 29% | $106,482.75 | 5200 | $511,940.17 | ||
| Junior Analyst | 520 | $71.50 | $90.12 | $18.62 | 21% | $37,180.00 | 520 | $72.93 | $92.37 | $18.99 | 21% | $37,923.60 | 520 | $74.39 | $94.68 | $19.37 | 20% | $38,682.07 | 520 | $75.88 | $97.05 | $19.76 | 20% | $39,455.71 | 520 | $77.39 | $99.48 | $20.15 | 20% | $40,244.83 | 2600 | $193,486.21 |
Subtotals 5720 $745,596.80 5720 $760,508.74 5720 $775,718.91 5720 $791,233.29 5720 $807,057.95 28600 $3,880,115.69
| CLIN 0005 | Program Evaluation & Safety Assurance | |||||||||||||||||||||||||||||||||
| Program Manager | 1040 | $124.31 | $140.76 | $16.45 | 12% | $129,282.40 | 1040 | $126.80 | $144.28 | $16.78 | 12% | $131,868.05 | 1040 | $129.33 | $147.89 | $17.12 | 12% | $134,505.41 | 1040 | $131.92 | $151.58 | $17.46 | 12% | $137,195.52 | 1040 | $134.56 | $155.37 | $17.81 | 11% | $139,939.43 | 5200 | $672,790.80 | ||
| Senior Consultant/SME | 1040 | $160.53 | $193.85 | $33.32 | 17% | $166,951.20 | 1040 | $163.74 | $198.70 | $27.14 | 14% | $170,290.22 | 1040 | $167.02 | $203.66 | $34.67 | 17% | $173,696.03 | 1040 | $170.36 | $208.76 | $35.36 | 17% | $177,169.95 | 1040 | $173.76 | $213.97 | $36.07 | 17% | $180,713.35 | 5200 | $868,820.75 | ||
| Senior Analyst | 520 | $114.44 | $170.87 | $56.43 | 33% | $59,508.80 | 520 | $116.73 | $175.14 | $58.41 | 33% | $60,698.98 | 520 | $119.06 | $179.52 | $58.71 | 33% | $61,912.96 | 520 | $121.44 | $184.01 | $59.89 | 33% | $63,151.21 | 520 | $123.87 | $188.61 | $61.08 | 32% | $64,414.24 | 2600 | $309,686.19 | ||
| Mid-Level Analyst | 520 | $94.59 | $134.92 | $40.33 | 30% | $49,186.80 | 520 | $96.48 | $138.29 | $28.33 | 20% | $50,170.54 | 520 | $98.41 | $141.75 | $41.96 | 30% | $51,173.95 | 520 | $100.38 | $145.29 | $42.80 | 29% | $52,197.43 | 520 | $102.39 | $148.93 | $43.66 | 29% | $53,241.37 | 2600 | $255,970.08 | ||
| Junior Analyst | 520 | $71.50 | $90.12 | $18.62 | 21% | $37,180.00 | 520 | $72.93 | $92.37 | $12.62 | 14% | $37,923.60 | 520 | $74.39 | $94.68 | $19.37 | 20% | $38,682.07 | 520 | $75.88 | $97.05 | $19.76 | 20% | $39,455.71 | 520 | $77.39 | $99.48 | $20.15 | 20% | $40,244.83 | 2600 | $193,486.21 |
Subtotals 3640 $442,109.20 3640 $450,951.38 3640 $459,970.41 3640 $469,169.82 3640 $478,553.22 18200 $2,300,754.03
| CLIN 0006 | Other Direct Costs | $15,784,159.74 | 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,008,236.40 | 25480 | $3,099,742.46 | 25480 | $3,161,737.31 | 25480 | $3,224,972.06 | 25480 | $3,289,471.50 | $15,784,159.74 |
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,038,236.40 25480 $3,129,742.46 25480 $3,191,737.31 25480 $3,254,972.06 25480 $3,319,471.50 $15,934,159.74
File details come from the government source that posted it. Updated .