563pricing_OTAP_563-26_RLS_Team.xlsx

XLSX spreadsheet 225 KB Posted

Attached to
Competitive Selection OH|DOT56326-1
Contract number
DOT56326-1
Issued by
Ohio

About this file

This document is a cost proposal summary for Transit Support Services, prepared by multiple consultants including RLS & Associates, Inc., Unicorn, Schweiger Consulting LLC, and AECOM for the Ohio Department of Transportation (ODOT). The proposal is version February 2021 and covers an indefinite delivery vehicle contract for various transit-related support services across multiple tasks and subtasks.

The contract encompasses six primary task areas: Section 5311 Staff Support, Drug & Alcohol Program Reviews, Subrecipient On-Site Technical Assistance, Subrecipient Reviews Support, Section 5310 Staff Support, and RTAP Training Workshops & Program. The total known tasks for RLS & Associates amount to 5,563 hours with a total cost of $685,189.57, including labor, overhead, and direct costs. The pricing structure includes varying hourly rates for different staff positions ranging from $32.92 to $185.56, with overhead rates between 84.24% and 159.98%. The contract appears to be structured with known tasks, potential unknown tasks, and future task sections, suggesting flexibility for additional work scopes. Direct costs include categories such as mileage, air travel, lodging, printing, and rental car expenses, with a net fee percentage capped at 11%.

View the file

Other files

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

RLS

RFP: Transit Support ServicesCOST PROPOSAL SUMMARYVersion:
Feb 2021RFP: Transit Support ServicesPROPOSAL COST SUMMARYVersion:
Feb 2021RFP: Transit Support ServicesDIRECT COSTSVersion:

Feb 2021

Consultant:RLS & Associates, Inc.Consultant:RLS & Asssociates, Inc.Consultant:RLS & Associates, Inc.
Agreement No.Agreement No.0State Average Overhead Rate159.98%Agreement No.0Mileage

tc={E92F1BAE-17FA-4BBC-AC43-CE0423209E15}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert direct cost category (e.g.: mileage, airfare, printing/copies, rental car, etc.)SubsistanceAir TravelLodgingSurvey MonkeyWebinarsPrinting and PostageRental CarRental Car FuelTotal
Modification No.Modification No.0Consultant Overhead Rate:84.24%

tc={5F176C5F-5E77-4D5C-8040-05720EA7F21B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rateModification No.0
PID No.Assigned Staff Positions & Associated RatesPID No.0Cost of Money:0.14%

tc={953A55F2-FC43-4D27-9524-DAD905EC8290}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rate, for example 0.08%PID No.0
Proposal Date5/14/25ExampleProposal Date5/14/25Net Fee Percentage:11%

tc={D90B5E0A-388E-47A3-B38C-07D51FC3F9BE}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage that goes no higher than 11.0%Proposal Date
Staff PositionContract Manager

tc={375C69B9-5530-4600-9629-661986A5ABA9}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)PrincipalSubject Matter ExpertSenior Associate/ PMAssociate IIIAssociate IIAssociate ISupportTotalNo. of UnitsAverage HourlyTotalLaborOverheadCost ofDirectSubconNetTotalDirect Cost Category:
Task DescriptionDirect Labor Rate$70.91

tc={ADC08D57-F31B-447B-91CD-2E0A0644D19B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee's labor rate excluding overhead rate $185.56 $108.46 $70.91 $62.00 $46.35 $38.70 $32.92 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $0.58 tc={4D6A823F-DE15-4A68-80CC-679AC9DC9756}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert unit cost related to the direct cost category tc={375C69B9-5530-4600-9629-661986A5ABA9}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)

tc={5F176C5F-5E77-4D5C-8040-05720EA7F21B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rate tc={ADC08D57-F31B-447B-91CD-2E0A0644D19B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee's labor rate excluding overhead rate tc={953A55F2-FC43-4D27-9524-DAD905EC8290}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rate, for example 0.08% tc={D90B5E0A-388E-47A3-B38C-07D51FC3F9BE}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage that goes no higher than 11.0%$68.00$620.00$110.00$110.00$100.00$32.00$76.00$35.00
AUTHORIZED TASKS:AUTHORIZED TASKS:AUTHORIZED TASKS:
Known TasksKnown TasksKnown Tasks
Staff HoursUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnits$
Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)
Subtask 1:85617001791$85,936Subtask 1:0$47.981791$85,935.71$72,392.24$120.31$2,314.00$0.00$24,575.72$185,337.98Subtask 1:10006666$2,314.00
Subtask 2:0$0Subtask 2:0ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:0ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 1856000170000001791$85,936TOTAL Task 1$47.981791$85,936$72,392$120$2,314$0$24,576$185,337.98TOTAL Task 1100060600066$2,314.00
Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)
Subtask 1:1760271447$22,968Subtask 1:$51.38447$22,967.86$19,348.13$32.16$3,591.20$0.00$6,568.30$52,507.64Subtask 1:1440881212$3,591.20
Subtask 2:0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 200017600271000447$22,968TOTAL Task 2$51.38447$22,967.86$19,348.13$32.16$3,591.20$0.00$6,568.30$52,507.64TOTAL Task 214408080001212$3,591.20
Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)
Subtask 1:428034318$22,705Subtask 1:$71.40318$22,705.04$19,126.73$31.79$4,502.00$0.00$6,493.14$52,858.69Subtask 1:140012121414$4,502.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 30402803400000318$22,705TOTAL Task 3$71.40318$22,705.04$19,126.73$31.79$4,502.00$0.00$6,493.14$52,858.69TOTAL Task 31400120120001414$4,502.00
Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)
Subtask 1:8680400520251039$71,929Subtask 1:$69.231039$71,928.94$60,592.94$100.70$3,442.00$0.00$20,570.09$156,634.67Subtask 1:800222422$3,442.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 486804005200250001039$71,929TOTAL Task 4$69.231039$71,928.94$60,592.94$100.70$3,442.00$0.00$20,570.09$156,634.67TOTAL Task 4800202024022$3,442.00
Task 5: Section 5310 Staff Support (average 684 hours per year)Task 5: Section 5310 Staff Support (average 684 hours per year)Task 5: Section 5310 Staff Support (average 684 hours per year)
Subtask 1:80200264544$30,309Subtask 1:$55.72544$30,309.20$25,532.47$42.43$1,160.00$0.00$8,667.76$65,711.87Subtask 1:2000$1,160.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:000000000$0.00
TOTAL Task 5000802002640000544$30,309TOTAL Task 5$55.72544$30,309.20$25,532.47$42.43$1,160.00$0.00$8,667.76$65,711.87TOTAL Task 5200000000000$1,160.00
Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)
Subtask 1:0888240280483404201424$74,617Subtask 1:$52.401424$74,616.56$62,856.99$104.46$13,222.00$0.00$21,338.69$172,138.71Subtask 1:32002421614824$13,222.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 6088824028048340420001424$74,617TOTAL Task 6$52.401424$74,616.56$62,856.99$104.46$13,222.00$0.00$21,338.69$172,138.71TOTAL Task 63200242161480240$13,222.00

TOTAL Known Tasks 93 24 168 1176 1034 2012 636 420 0 0 5563 $308,463.31 TOTAL Known Tasks $55.45 5563 $308,463.31 $259,849.49 $431.85 $28,231.20 $0.00 $88,213.72 $685,189.57 TOTAL Known Tasks 9840 52 2 44 1 72 0 58 34 $28,231.20

Unknown TasksUnknown TasksUnknown Tasks
Task 1:Task 1:Task 1:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 100000000000$0TOTAL Task 1ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 1000000000$0.00
Task 2:Task 2:Task 2:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 200000000000$0TOTAL Task 2ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 2000000000$0.00
Task 3:Task 3:Task 3:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 300000000000$0TOTAL Task 3ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 3000000000$0.00
Task 4:Task 4:Task 4:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 400000000000$0TOTAL Task 4ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 4000000000$0.00
Task 5:Task 5:Task 5:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 50000000000TOTAL Task 5ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 5000000000$0.00

Total - Unknown Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Unknown Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Unknown Tasks 0 0 0 0 0 0 0 0 0 $0.00

Future Tasks SectionFuture Tasks SectionFuture Tasks Section
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00

Total - Future Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Future Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Future Tasks 0 0 0 0 0 0 0 0 0 $0.00

Future Tasks SectionFuture Tasks SectionFuture Tasks Section
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00

Total - Future Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Future Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Future Tasks 0 0 0 0 0 0 0 0 0 $0.00

TOTAL AUTHORIZED PARTS TOTAL AUTHORIZED PARTS $55.45 5563 $308,463.31 $259,849.49 $431.85 $28,231.20 $0.00 $88,213.72 $685,189.57

IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS:

TOTAL IF-AUTHORIZED PARTS TOTAL IF-AUTHORIZED PARTS

GRAND TOTAL GRAND TOTAL

&9&P of &N

UNICORN

RFP: Transit Support ServicesCOST PROPOSAL SUMMARYVersion:
Feb 2021RFP: Transit Support ServicesPROPOSAL COST SUMMARYVersion:
Feb 2021RFP: Transit Support ServicesDIRECT COSTSVersion:

Feb 2021

Consultant:UnicornConsultant:UnicornConsultant:Unicorn
Agreement No.Agreement No.0State Average Overhead Rate159.98%Agreement No.0Mileage

tc={E92F1BAE-17FA-4BBD-AC43-CE0423209E15}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert direct cost category (e.g.: mileage, airfare, printing/copies, rental car, etc.)SubsistanceAir TravelLodgingSurvey MonkeyWebinarsPrinting and PostageRental CarRental Car FuelTotal
Modification No.Modification No.0Consultant Overhead Rate:163.11%

tc={5F176C5F-5E77-4D5D-8040-05720EA7F21B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rateModification No.0
PID No.Assigned Staff Positions & Associated RatesPID No.0Cost of Money:0.00%

tc={953A55F2-FC43-4D28-9524-DAD905EC8290}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rate, for example 0.08%PID No.0
Proposal Date5/14/25ExampleProposal Date5/14/25Net Fee Percentage:8%

tc={D90B5E0A-388E-47A4-B38C-07D51FC3F9BE}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage that goes no higher than 11.0%Proposal Date
Staff PositionProject Manager

tc={375C69B9-5530-4601-9629-661986A5ABA9}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)TotalNo. of UnitsAverage HourlyTotalLaborOverheadCost ofDirectSubconNetTotalDirect Cost Category:
Task DescriptionDirect Labor Rate$77.00

tc={ADC08D57-F31B-447C-91CD-2E0A0644D19B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee's labor rate excluding overhead rate Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $0.58 tc={4D6A823F-DE15-4A69-80CC-679AC9DC9756}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert unit cost related to the direct cost category tc={375C69B9-5530-4601-9629-661986A5ABA9}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)

tc={5F176C5F-5E77-4D5D-8040-05720EA7F21B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rate tc={ADC08D57-F31B-447C-91CD-2E0A0644D19B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee's labor rate excluding overhead rate tc={953A55F2-FC43-4D28-9524-DAD905EC8290}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rate, for example 0.08% tc={D90B5E0A-388E-47A4-B38C-07D51FC3F9BE}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage that goes no higher than 11.0%$68.00$620.00$110.00$110.00$100.00$32.00$76.00$35.00
AUTHORIZED TASKS:AUTHORIZED TASKS:AUTHORIZED TASKS:
Known TasksKnown TasksKnown Tasks
Staff HoursUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnits$
Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)
Subtask 1:0$0Subtask 1:0ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:120120$9,240Subtask 2:0$77.00120$9,240.00$15,071.36$0.00$0.00$0.00$1,921.77$26,233.14Subtask 2:$0.00
Subtask 3:0$0Subtask 3:0ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 1120000000000120$9,240TOTAL Task 1$77.00120$9,240$15,071$0$0$0$1,922$26,233.14TOTAL Task 1000000000$0.00
Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 200000000000$0TOTAL Task 2ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 2000000000$0.00
Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 300000000000$0TOTAL Task 3ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 3000000000$0.00
Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 400000000000$0TOTAL Task 4ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 4000000000$0.00
Task 5: Section 5310 Staff Support (average 684 hours per year)Task 5: Section 5310 Staff Support (average 684 hours per year)Task 5: Section 5310 Staff Support (average 684 hours per year)
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:000000000$0.00
TOTAL Task 500000000000$0TOTAL Task 5ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 5000000000$0.00
Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)
Subtask 1:420420$0Subtask 1:$0.00420$0.00$0.00$0.00$13,222.00$0.00$0.00$13,222.00Subtask 1:32002421614824$13,222.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 6000000042000420$0TOTAL Task 6$0.00420$0.00$0.00$0.00$13,222.00$0.00$0.00$13,222.00TOTAL Task 63200242161480240$13,222.00

TOTAL Known Tasks 120 0 0 0 0 0 0 420 0 0 540 $9,240.00 TOTAL Known Tasks $17.11 540 $9,240.00 $15,071.36 $0.00 $13,222.00 $0.00 $1,921.77 $39,455.14 TOTAL Known Tasks 3200 24 2 16 1 48 0 24 0 $13,222.00

Unknown TasksUnknown TasksUnknown Tasks
Task 1:Task 1:Task 1:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 100000000000$0TOTAL Task 1ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 1000000000$0.00
Task 2:Task 2:Task 2:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 200000000000$0TOTAL Task 2ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 2000000000$0.00
Task 3:Task 3:Task 3:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 300000000000$0TOTAL Task 3ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 3000000000$0.00
Task 4:Task 4:Task 4:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 400000000000$0TOTAL Task 4ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 4000000000$0.00
Task 5:Task 5:Task 5:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 50000000000TOTAL Task 5ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 5000000000$0.00

Total - Unknown Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Unknown Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Unknown Tasks 0 0 0 0 0 0 0 0 0 $0.00

Future Tasks SectionFuture Tasks SectionFuture Tasks Section
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00

Total - Future Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Future Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Future Tasks 0 0 0 0 0 0 0 0 0 $0.00

Future Tasks SectionFuture Tasks SectionFuture Tasks Section
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00

Total - Future Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Future Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Future Tasks 0 0 0 0 0 0 0 0 0 $0.00

TOTAL AUTHORIZED PARTS TOTAL AUTHORIZED PARTS $17.11 540 $9,240.00 $15,071.36 $0.00 $13,222.00 $0.00 $1,921.77 $39,455.14

IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS:

TOTAL IF-AUTHORIZED PARTS TOTAL IF-AUTHORIZED PARTS

GRAND TOTAL GRAND TOTAL

SCHWEIGER

RFP: Transit Support ServicesCOST PROPOSAL SUMMARYVersion:
Feb 2021RFP: Transit Support ServicesPROPOSAL COST SUMMARYVersion:
Feb 2021RFP: Transit Support ServicesDIRECT COSTSVersion:

Feb 2021

Consultant:Schweiger Consulting LLCConsultant:Schweiger Consulting LLCConsultant:Schweiger Consulting LLC
Agreement No.Agreement No.0State Average Overhead Rate159.98%Agreement No.0Mileage

tc={E92F1BAE-17FA-4BBE-AC43-CE0423209E15}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert direct cost category (e.g.: mileage, airfare, printing/copies, rental car, etc.)SubsistanceAir TravelLodgingSurvey MonkeyWebinarsPrinting and PostageRental CarRental Car FuelTotal
Modification No.Modification No.0Consultant Overhead Rate:100.00%

tc={5F176C5F-5E77-4D5E-8040-05720EA7F21B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rateModification No.0
PID No.Assigned Staff Positions & Associated RatesPID No.0Cost of Money:0.00%

tc={953A55F2-FC43-4D29-9524-DAD905EC8290}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rate, for example 0.08%PID No.0
Proposal Date5/14/25ExampleProposal Date5/14/25Net Fee Percentage:10%

tc={D90B5E0A-388E-47A5-B38C-07D51FC3F9BE}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage that goes no higher than 11.0%Proposal Date
Staff PositionContract Manager

tc={375C69B9-5530-4602-9629-661986A5ABA9}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)PrincipalSubject Matter ExpertSenior Associate/ PMAssociate IIIAssociate IIAssociate ISupportTotalNo. of UnitsAverage HourlyTotalLaborOverheadCost ofDirectSubconNetTotalDirect Cost Category:
Task DescriptionDirect Labor Rate

tc={ADC08D57-F31B-447D-91CD-2E0A0644D19B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee's labor rate excluding overhead rate $100.32 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $0.58 tc={4D6A823F-DE15-4A6A-80CC-679AC9DC9756}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert unit cost related to the direct cost category tc={375C69B9-5530-4602-9629-661986A5ABA9}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)

tc={5F176C5F-5E77-4D5E-8040-05720EA7F21B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rate tc={ADC08D57-F31B-447D-91CD-2E0A0644D19B}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Insert employee's labor rate excluding overhead rate tc={953A55F2-FC43-4D29-9524-DAD905EC8290}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage rate, for example 0.08% tc={D90B5E0A-388E-47A5-B38C-07D51FC3F9BE}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Complete as a percentage that goes no higher than 11.0%$68.00$620.00$110.00$110.00$100.00$32.00$76.00$35.00
AUTHORIZED TASKS:AUTHORIZED TASKS:AUTHORIZED TASKS:
Known TasksKnown TasksKnown Tasks
Staff HoursUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnits$
Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year)
Subtask 1:00800000080ERROR:#VALUE!Subtask 1:0ERROR:#VALUE!80ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 1:$0.00
Subtask 2:0ERROR:#VALUE!Subtask 2:0ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 2:$0.00
Subtask 3:0ERROR:#VALUE!Subtask 3:0ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 3:$0.00
TOTAL Task 10080000000080ERROR:#VALUE!TOTAL Task 1ERROR:#VALUE!80ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0$0ERROR:#VALUE!ERROR:#VALUE!TOTAL Task 1000000000$0.00
Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year)
Subtask 1:00ERROR:#VALUE!Subtask 1:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 1:$0.00
Subtask 2:0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0ERROR:#VALUE!Subtask 3:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 3:$0.00
TOTAL Task 200000000000ERROR:#VALUE!TOTAL Task 2ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!TOTAL Task 2000000000$0.00
Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year)
Subtask 1:0ERROR:#VALUE!Subtask 1:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 1:$0.00
Subtask 2:0ERROR:#VALUE!Subtask 2:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 2:$0.00
Subtask 3:0ERROR:#VALUE!Subtask 3:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 3:$0.00
TOTAL Task 300000000000ERROR:#VALUE!TOTAL Task 3ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!TOTAL Task 3000000000$0.00
Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year)
Subtask 1:0ERROR:#VALUE!Subtask 1:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 1:$0.00
Subtask 2:0ERROR:#VALUE!Subtask 2:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 2:$0.00
Subtask 3:0ERROR:#VALUE!Subtask 3:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 3:$0.00
TOTAL Task 400000000000ERROR:#VALUE!TOTAL Task 4ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!TOTAL Task 4000000000$0.00
Task 5: Section 5310 Staff Support (average 684 hours per year)Task 5: Section 5310 Staff Support (average 684 hours per year)Task 5: Section 5310 Staff Support (average 684 hours per year)
Subtask 1:0ERROR:#VALUE!Subtask 1:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 1:$0.00
Subtask 2:0ERROR:#VALUE!Subtask 2:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 2:$0.00
Subtask 3:0ERROR:#VALUE!Subtask 3:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 3:000000000$0.00
TOTAL Task 500000000000ERROR:#VALUE!TOTAL Task 5ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!TOTAL Task 5000000000$0.00
Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)Task 6: RTAP Training Workshops & Program (average 1,424 hours per year)
Subtask 1:00ERROR:#VALUE!Subtask 1:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$13,222.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 1:32002421614824$13,222.00
Subtask 2:0ERROR:#VALUE!Subtask 2:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 2:$0.00
Subtask 3:0ERROR:#VALUE!Subtask 3:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 3:$0.00
TOTAL Task 600000000000ERROR:#VALUE!TOTAL Task 6ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$13,222.00$0.00ERROR:#VALUE!ERROR:#VALUE!TOTAL Task 63200242161480240$13,222.00

TOTAL Known Tasks 0 0 80 0 0 0 0 0 0 0 80 ERROR:#VALUE! TOTAL Known Tasks ERROR:#VALUE! 80 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! $13,222.00 $0.00 ERROR:#VALUE! ERROR:#VALUE! TOTAL Known Tasks 3200 24 2 16 1 48 0 24 0 $13,222.00

Unknown TasksUnknown TasksUnknown Tasks
Task 1:Task 1:Task 1:
Subtask 1:0ERROR:#VALUE!Subtask 1:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 1:$0.00
Subtask 2:0ERROR:#VALUE!Subtask 2:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 2:$0.00
Subtask 3:0ERROR:#VALUE!Subtask 3:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 3:$0.00
TOTAL Task 100000000000ERROR:#VALUE!TOTAL Task 1ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!TOTAL Task 1000000000$0.00
Task 2:Task 2:Task 2:
Subtask 1:0ERROR:#VALUE!Subtask 1:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 1:$0.00
Subtask 2:0ERROR:#VALUE!Subtask 2:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 2:$0.00
Subtask 3:0ERROR:#VALUE!Subtask 3:ERROR:#VALUE!0ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00$0.00ERROR:#VALUE!ERROR:#VALUE!Subtask 3:$0.00

This is the start of the file's text. The full file is on GovTribe.

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