Attachment 3 _ Price Proposal.xlsx

XLSX spreadsheet 184 KB Posted

Attached to
TRANSIT OPERATIONS AND MAINTENANCE SERVICES
Solicitation number
PE-99600-RFP-2026-000000002
Issued by
Fulton County, Atlanta City, Georgia

About this file

This document is a Price Proposal spreadsheet for transit services involving the Atlanta Regional Transit (ATL) and Ride Gwinnett (RG), covering multiple transit service types including local routes, commuter routes, paratransit, microtransit, and express services. The pricing proposal is structured with a three-tier system for each agency, representing scenarios of revenue hours at 75% reduction, current levels, and 20% increase above current levels. The contract appears to span five years, with detailed cost breakdowns for vehicle operations, vehicle maintenance, general administration, and non-vehicle maintenance across different service types.

The pricing structure includes comprehensive cost elements such as management wages, driver wages, vehicle maintenance, contract services, training, and other operational expenses. A notable feature is the cost-sharing arrangement for the North Facility, where expenses are split 30% for ATL and 70% for Ride Gwinnett. The document suggests that the original pricing scenarios were contingent on a Gwinnett County transit referendum, which did not pass, potentially impacting the final service levels and pricing. The spreadsheet provides a granular approach to cost proposal, allowing for flexible service level adjustments while maintaining a consistent methodological framework for pricing across different transit service categories.

View the file

Other files

Show all 16

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

Price Proposal Cover Sheet

Pricing Scenerios Two Pricing Scenarios tc={2A517A33-5597-49B4-A644-F03D1BD2B9EF}: [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:

@Abhiram Puppala I don’t think this sheet will be applicable since Gwinnett’s transit referendum did not pass.

1Gwinnett County Existing
20212022202320242025
Local
95,70995,709119,001119,001119,001
Commuter
30,87130,87130,87130,87130,871
Microtransit
14,33714,33714,33714,33714,338
Paratransit
23,46023,92924,40824,89625,394
ATL Express20212022202320242025
59,35759,35759,35759,35759,357
2Gwinnett County w/ Referendum
20212022202320242025
Local
95,70995,709138,686138,686179,822
Commuter
30,87130,87130,87144,77650,110
Microtransit
14,33714,33714,33714,33729,086
Paratransit
24,15024,90527,93531,33435,146
ATL Express20212022202320242025
5935759357593575935759357

@Abhiram Puppala I don’t think this sheet will be applicable since Gwinnett’s transit referendum did not pass.

Instructions

Price Proposal Assumptions
a) Interlining on trips will not be paid as revenue hours.
b) For AM commuter trips, a boarding time of 10 minutes for the County, and 5 minutes for ATL, before the departure time will be paid as revenue hours.
c) ATL and the County will pay based on scheduled revenue hours. Regular Atlanta traffic conditions should be considered when building blocks, run cuts, and reporting times for operators, and they should also be considered part of the regular revenue hour rate.
d) The Fixed fee and all shared expenses at the North Facility will be divided between ATL and the County based on the total number of vehicles residing at the North Facility for each agency, which is currently split as thirty percent (30%) ATL and seventy percent (70%) Gwinnett County.
e) Variable costs should be reflected on the County and ATL cost sheets individually. Specific requests that are unique to either agency should also be reflected on that agency's pricing sheets.
f) Start-up costs are not to be included in the yearly costs and should be included on a separate pricing form.
The Price Proposal Form is designed with a tiered costing system based on revenue hours and the requirements to meet service needs. The tier system for each agency is shown below.
a) ATL (3-Tier System):
1) Tier 1: Revenue hours reduced at or below 75% of current levels.
2) Tier 2: Revenue hours remain at current levels.
3) Tier 3: Revenue hours increase at or above 20% above current levels.
b) Gwinnett (3-Tier System):
a) Tier 1: Revenue hours reduced at or below 75% of current levels.
b) Tier 2: Revenue hours remain at current levels.
c) Tier 3: Revenue hours increase at or above 20% above current levels.
The following instructions assist in navigating the spreadsheet.
a) Cells highlighted in yellow require manual input by proposers.
b) Tier 2 (current revenue hours) have already been prepopulated and should not be adjusted.
c) The spreadsheet auto-populates the revenue hours for all other tiers (both ATL and Gwinnett) and should not be adjusted.
1) For the North Facility, the administrative and non-vehicle maintenance fixed fees splits are thirty percent (30%) for the ATL and seventy percent (70%) Gwinnett County. This proportion should be used to determine each agency’s share of those costs.
2) These fee splits are already incorporated into the formulas
d) Costs for each tier are entered in yellow-highlighted cells for different cost items.
e) Non-highlighted cells auto-populate to align cost items with the corresponding tiered revenue hours.
f) Proposers shall not adjust any formulas or override any formulas in these cells. Only inputs to highlighted cells are permitted. Any adjustments or overrides will result in a non-responsive bid, and the proposal will be considered disqualified.
g) The spreadsheet consolidates all proposer cost data, and the final cumulative costs for all tiers are calculated automatically in the Master sheets.
h) Separate Master sheets are maintained for ATL and Gwinnett, each reflecting their respective tiered costing systems.

Ride Gwinnett (RG) Master Sheet

COST PROPOSAL SCHEDULE
Ride Gwinnett - Local, Paratransit, Microtransit and Special Event Service
Year 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Annual General Administration Fixed Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Non-Vehicle Maintenance Fixed Fee*$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Local Service Revenue Hour Rate
Vehicle Operations$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Vehicle Maintenance$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Paratransit Service Revenue Hour Rate
Vehicle Operations$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Vehicle Maintenance$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Microtransit Service Revenue Hour Rate
Vehicle Operations$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Vehicle Maintenance$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
North Facility FTEs - RG Annual Share$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
North Facility Fixed Expenses - RG Annual Share$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Annual Cost**000000000000000
Year 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Special Event Service Revenue Hour Rate***
Performance Bond Cost
* Includes Facilities (Buildings, Grounds) & Equipment Maintenance
** For calculation assume:
Tier 1Tier 2- currentTier 3
Local =95,507127,342152,810revenue hours
Paratransit =17,84720,99725,196revenue hours
Microtransit=37,62344,26253,114revenue hours
***The rate for special event service should be provided independent of the total annual cost
______________________________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG Start-Up Costs

COST PROPOSAL BREAKDOWN
Ride Gwinnett Start-Up Fixed Fee
Start Up - 6 Month
Item
Management Wages
Non-Management Wages
Management Benefits
Non-Management Benefits
Recruiting
Printing & Copying
Taxes & Fees
Rents & Leases
Legal Services
Accounting
Overhead
Allowable Travel Costs
Uniforms
Supplies
Equipment
IT Support
Other Startup Costs (List Below)

Ride Gwinnett Totals $ - 0

____________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG Annual Gen. Admin. Fixed

COST PROPOSAL BREAKDOWN
Ride Gwinnett Annual General Administration Fixed Fee
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Other General Administration Wages & Fringes
Contract Services (Specify)
Park and Ride Security (Specify)
Park and Ride Security Grounds Maintenance (Specify)
Revenue Collection/Reconciliation/Deposit
Fee or Profit (Specify Percentage: 1.9% - yr. 1)
Ride Gwinnett Totals$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
____________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG Annual Non-Veh. Maint.

COST PROPOSAL BREAKDOWN
Ride Gwinnett Annual Non-Vehicle Maintenance Fixed Fee*
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Other Facility & Equipment Maintenance Wages & Fringes
Contract Services (Specify) - janitorial
Subcontract for Grounds & Maintenance
Leasehold Improvements - RG Facility/Yard
Ride Gwinnett Totals$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
* Includes Facilities (Buildings, Grounds) & Equipment Maintenance
____________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG Vehicle Ops. Commuter

COST PROPOSAL BREAKDOWN

tc={8057EDDD-A1A8-42E6-82DE-A4A6C39CC927}: [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:

@Abhiram Puppala this sheet is not applicable Ride Gwinnett Vehicle Operations Costs - Commuter Route Service

Cost ElementsYear 1Year 2Year 3Year 4Year 5
Management/Supervisory Wages & Fringes
Driver Wages & Fringes
Dispatcher Wages & Fringes
Other Vehicle Operations Wages & Fringes
Contract Services (Specify)
System Security Expenses
Operator Training
Revenue Vehicle Lubricants
Revenue Vehicle Tires & Tubes
Other Revenue Vehicle Materials & Supplies

Other Costs (Specify) - uniforms

Ride Gwinnett Commuter Vehicle Operations Revenue Hour Rate$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Vehicle Revenue HoursERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Ride Gwinnett Commuter Vehicle Operations Total CostsERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
____________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

@Abhiram Puppala this sheet is not applicable

RG Vehicle Ops. Local

COST PROPOSAL BREAKDOWN
Ride Gwinnett Vehicle Operations Costs - Local Route Service
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Driver Wages & Fringes
Dispatcher Wages & Fringes
Other Vehicle Operations Wages & Fringes
Contract Services (Specify)
System Security Expenses
Operator Training
Revenue Vehicle Lubricants
Revenue Vehicle Tires & Tubes
Other Revenue Vehicle Materials & Supplies
Other Costs (Specify) - uniforms
Ride Gwinnett Local Vehicle Operations Revenue Hour Rate000000000000000
Annual Vehicle Revenue Hours95,507127,342152,81095,507127,342152,81095,507127,342152,81095,507127,342152,81095,507127,342152,810
Ride Gwinnett Local Vehicle Operations Total Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG Vehicle Ops. Para.

COST PROPOSAL BREAKDOWN
Ride Gwinnett Vehicle Operations Costs - Paratransit Service
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Driver Wages & Fringes
Dispatcher Wages & Fringes
Other Vehicle Operations Wages & Fringes
Contract Services (Specify)
System Security Expenses
Operator Training
Revenue Vehicle Lubricants
Revenue Vehicle Tires & Tubes
Other Revenue Vehicle Materials & Supplies
Other Costs (Specify) - uniforms
Ride Gwinnett Paratransit Vehicle Operations Revenue Hour Rate$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Vehicle Revenue Hours17,84720,99725,19617,84720,99725,19617,84720,99725,19617,84720,99725,19617,84720,99725,196
Ride Gwinnett Paratransit Vehicle Operations Total Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG Vehicle Ops. Micro

COST PROPOSAL BREAKDOWN
Ride Gwinnett Vehicle Operations Costs - Microtransit Service
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Driver Wages & Fringes
Dispatcher Wages & Fringes
Other Vehicle Operations Wages & Fringes
Contract Services (Specify)
System Security Expenses
Operator Training
Revenue Vehicle Lubricants
Revenue Vehicle Tires & Tubes
Other Revenue Vehicle Materials & Supplies
Other Costs (Specify) - uniforms
Ride Gwinnett Paratransit Vehicle Operations Revenue Hour Rate$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Vehicle Revenue Hours37,62344,26253,11437,62344,26253,11437,62344,26253,11437,62344,26253,11437,62344,26253,114
Ride Gwinnett Paratransit Vehicle Operations Total Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG Veh. Maint. Commuter

COST PROPOSAL BREAKDOWN
Ride Gwinnett Vehicle Maintenance Costs - Commuter Route Service
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Management/Supervisory Wages & Fringes
Mechanic Wages & Fringes
Other Vehicle Maintenance Wages & Fringes
Contract Services (Specify) - towing, bus cleaning, enviromental
Mechanic Training
Service Vehicle Materials & Supplies
Other Materials & Supplies
Other Costs (Specify)
Ride Gwinnett Commuter Vehicle Maintenance Revenue Hour Rate$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Vehicle Revenue HoursERROR:#REF!

tc={36C136D8-64C5-479B-A77C-383619638C06}: [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:

Not applicableERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Ride Gwinnett Commuter Vehicle Maintenance Total CostsERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

Not applicable

RG Vehicle Maint. Local

COST PROPOSAL BREAKDOWN
Ride Gwinnett Vehicle Maintenance Costs - Local Route Service
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Mechanic Wages & Fringes
Other Vehicle Maintenance Wages & Fringes
Contract Services (Specify) - towing, bus cleaning, environmental
Mechanic Training
Service Vehicle Materials & Supplies
Other Materials & Supplies
Other Costs (Specify)
Ride Gwinnett Local Vehicle Maintenance Revenue Hour Rate$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Vehicle Revenue Hours95,507127,342152,81095,507127,342152,81095,507127,342152,81095,507127,342152,81095,507127,342152,810
Ride Gwinnett Local Vehicle Maintenance Total Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG Vehicle Maint. Para.

COST PROPOSAL BREAKDOWN
Ride Gwinnett Vehicle Maintenance Costs - Paratransit Service
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Mechanic Wages & Fringes
Other Vehicle Maintenance Wages & Fringes
Contract Services (Specify) - towing, bus cleaning, environmental
Mechanic Training
Service Vehicle Materials & Supplies
Other Materials & Supplies
Other Costs (Specify)
Ride Gwinnett Paratransit Vehicle Maintenance Revenue Hour Rate$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Vehicle Revenue Hours17,84720,99725,19617,84720,99725,19617,84720,99725,19617,84720,99725,19617,84720,99725,196
Ride Gwinnett Paratransit Vehicle Maintenance Total Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG Vehicle Maint. Micro

COST PROPOSAL BREAKDOWN
Ride Gwinnett Vehicle Maintenance Costs - Microtransit Service
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Mechanic Wages & Fringes
Other Vehicle Maintenance Wages & Fringes
Contract Services (Specify) - towing, bus cleaning, environmental
Mechanic Training
Service Vehicle Materials & Supplies
Other Materials & Supplies
Other Costs (Specify)
Ride Gwinnett Paratransit Vehicle Maintenance Revenue Hour Rate$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Vehicle Revenue Hours37,62344,26253,11437,62344,26253,11437,62344,26253,11437,62344,26253,11437,62344,26253,114
Ride Gwinnett Paratransit Vehicle Maintenance Total Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG Task Order Options

OPTIONAL TASK COST PROPOSAL BREAKDOWN
Ride Gwinnett Service
Cost ElementsYear 1 Hourly RateYear 2 Hourly RateYear 3 Hourly RateYear 4 Hourly RateYear 5 Hourly Rate
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Transportation Planning Services
Service Planning
Scheduling
________________________________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

RG FTEs

STAFFING BREAKDOWN
Ride Gwinnett Local, Paratransit, Microtransit and Special Event Service
Staffing PlanYear 1Year 2Year 3Year 4Year 5
Ride Gwinnett General Administration
Management/Supervisory FTEs
Customer Service FTEs
Other Staff FTEs (Specify) HR & Admin Mgrs, IT Tech
Ride Gwinnett Non-Vehicle Maintenance
Management/Supervisory FTEs
Other Facility & Equipment Maintenance FTEs
Other Staff FTEs (Specify)
Ride Gwinnett Vehicle Operations - Local Route Service
Management/Supervisory FTEs
Driver FTEs
Dispatcher FTEs
Other Vehicle Operations FTEs
Other Staff FTEs (Specify)
Ride Gwinnett Vehicle Operations - Paratransit Service
Management/Supervisory FTEs
Driver FTEs
Dispatcher FTEs
Other Vehicle Operations FTEs
Other Staff FTEs (Specify)
Ride Gwinnett Vehicle Maintenance - Local Route Service
Management/Supervisory FTEs
"A" Mechanic/Technician FTEs
"B" Mechanic/Technician FTEs
"C" Mechanic/Technician FTEs
Other Vehicle Maintenance FTEs
Other Staff FTEs (Specify) - Utility & Parts Mgmt
Ride Gwinnett Vehicle Maintenance - Paratransit Service
Management/Supervisory FTEs
"A" Mechanic/Technician FTEs
"B" Mechanic/Technician FTEs
"C" Mechanic/Technician FTEs
Other Vehicle Maintenance FTEs
Other Staff FTEs (Specify) - Utility & Parts Mgmt

Ride Gwinnett FTE Total - 0 - 0 - 0 - 0 tc={6BADFCEC-AB46-4ACB-BD7A-15E9830D5781}: [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:

My understanding is we don’t need this sheet this time around, as micro transit is already in place - 0

Name of Firm Submitting ProposalSignature of Authorized Representative
FTE = Full Time Equivalent staff
On an annual basis, an FTE is considered to be 2,080 hours, which is calculated as: 8 hours per day x 5 work days per week x 52 weeks per year = 2,080 hours per year

My understanding is we don’t need this sheet this time around, as micro transit is already in place

&P

ATL Xpress Master

COST PROPOSAL SCHEDULE
ATL Xpress Service
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Annual General Administration Fixed Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Non-Vehicle Maintenance Fixed Fee*$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Xpress Service Revenue Hour Rate
Vehicle Operations$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Vehicle Maintenance$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
North Facility FTEs - ATL Annual Share$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
South Facility FTEs - Annual Expense$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
North Facility Fixed Expenses - ATL Annual Share$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Annual Cost**000000000000000
* Includes Facilities (Buildings, Grounds) & Equipment Maintenance (cost for year 1 will be paid by ATL)
Tier 1 - 75% of CurrentTier 2 - CurrentTier 3 - 20% Above Current
** For calculation assume:25,08833,45040,140
Performance Bond Cost
Year 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Special Event Service Revenue Hour Rate***

***The rate for special event service should be provided independent of the total annual cost

______________________________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

ATL Start-Up Costs

COST PROPOSAL BREAKDOWN
ATL Start-Up Fixed Fee
Start Up - 6 Month
Item
Management Wages
Non-Management Wages
Management Benefits
Non0Managment Benefits
Recruiting
Printing & Copying
Taxes & Fees
Rents & Leases
Legal Services
Accounting
Overhead
Allowable Travel Costs
Uniforms
Supplies
Equipment
IT Support
Other Startup Costs (List Below)

ATL Totals $ - 0

____________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

ATL Xpress Gen. Admin. Fixed

COST PROPOSAL BREAKDOWN
ATL Annual General Administration Fixed Fee
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Other General Administration Wages & Fringes
Contract Services (Specify)
Support Vehicles
Computer Hardware & Software
Casualty & Liability Costs
Corporate Support
Safety Expenses
Office Materials & Supplies
Other Costs (Specify) - travel, utilities
Transition Costs (Specify)
Operating Facility Security (South Ops only)

Fee or Profit (Specify Percentage: 1.8% yr. 1) tc={E528BDC3-96CC-40D8-9AC7-A1EEF190EE46}: [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:

How does ATL want to incorporate this fee? Right now the formula indicates they enter a dollar value, but the description requests a %, in which case, the formula for line 26 needs to be updated.

ATL Totals$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

How does ATL want to incorporate this fee? Right now the formula indicates they enter a dollar value, but the description requests a %, in which case, the formula for line 26 needs to be updated.

ATL Xpress Non-Vehicle Maint.

COST PROPOSAL BREAKDOWN
ATL Annual Non-Vehicle Maintenance Fixed Fee
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Other Facility & Equipment Maintenance Wages & Fringes
Contract Services (Specify) - janitorial
Casualty & Liability Costs
Property Taxes
Cleaning Materials & Supplies
Facility & Equipment Maintenance Parts & Supplies
Other Costs (Specify)
Subcontract for Grounds & Maintenance (O&M Facilities only)
Shop Equipment
ATL Totals$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
* Includes Facilities (Buildings, Grounds) & Equipment Maintenance
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

ATL Xpress Ops. Cost ATL Vehicle Operations Costs - Xpress Route Service

Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Driver Wages & Fringes
Dispatcher Wages & Fringes
Other Vehicle Operations Wages & Fringes
Contract Services (Specify)
System Security Expenses
Operator Training
Revenue Vehicle Lubricants
Revenue Vehicle Tires & Tubes
Other Revenue Vehicle Materials & Supplies
Other Costs (Specify) - uniforms
Revenue Collection/Reconciliation/Deposit
Cash handling (as a subset of Revenue Collection/Reconciliation/Deposit*
ATL Xpress Vehicle Operations Revenue Hour Rate$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Vehicle Revenue Hours25,08833,45040,14025,08833,45040,14025,08833,45040,14025,08833,45040,14025,08833,45040,140
ATL Xpress Vehicle Operations Total Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
* Note: ATL will transition to a cashless system. Offerors are asked to cost out the handling of cash separately in case this service is removed during the contract.
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

ATL Xpress Maint. Cost

COST PROPOSAL BREAKDOWN
ATL Vehicle Maintenance Costs - Xpress Route Service
Cost ElementsYear 1Year 2Year 3Year 4Year 5
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Management/Supervisory Wages & Fringes
Mechanic Wages & Fringes
Other Vehicle Maintenance Wages & Fringes
Contract Services (Specify) - towing, bus cleaning, environmental
Mechanic Training
Service Vehicle Materials & Supplies
Other Materials & Supplies
Other Costs (Specify)
ATL Xpress Vehicle Maintenance Revenue Hour Rate000000000000000
Annual Vehicle Revenue Hours25,08833,45040,14025,08833,45040,14025,08833,45040,14025,08833,45040,14025,08833,45040,140
ATL Xpress Vehicle Maintenance Total Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
___________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

ATL Task Order Options

OPTIONAL TASK COST PROPOSAL BREAKDOWN
ATL Xpress Service
Cost ElementsYear 1 Hourly RateYear 2 Hourly RateYear 3 Hourly RateYear 4 Hourly RateYear 5 Hourly Rate
Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3Tier 1Tier 2Tier 3
Transportation Planning
Service Planning
Scheduling
Pandemic Cleaning
________________________________________________________
Name of Firm Submitting ProposalSignature of Authorized Representative

ATL Xpress FTEs South Facility

ATL South Facility Staffing Breakdown
ATL South Facility Xpress Service
ATL South Facility Staffing PlanNumber of PersonnelAnnual Total Costs
Year 1Year 2Year 3Year 4Year 5
Operations
General Manager1
Operations Manager
Commuter Fixed Route1
Safety & Training Manager1
Other Non-Key Personnel
Road Supervisor(s)3
Dispatcher(s)1
Safety & Training Supervisor(s)2
Maintenance
Maintenance Manager1
Supervisors1
Quality Assurance Coordinator1
Transit Parts Specialist1
Master Mechanic1
A-Maintenance Mechanics1
B-Maintenance Mechanics2
C-Maintenance Mechanics2
Electronic Technicians1
Utility Workers5
EV Technician1
Total Annual Expense00000
ATL Xpress Vehicles at South Facility
#Vehicles40
VOMS26
Revenue Vehicles38
Name of Firm Submitting Proposal
FTE = Full Time Equivalent staff
On an annual basis, an FTE is considered to be 2,080 hours, which is calculated as: 8 hours per day x 5 work days per week x 52 weeks per year = 2,080 hours per year

ATL RG FTEs North Facility

ATL North Facility Staffing Breakdown
ATL North Facility Xpress Service
ATL North Facility Staffing PlanNumber of PersonnelAnnual Total Costs
ATLRGSharedYear 1Year 2Year 3Year 4Year 5
Operations
General Manager1
Operations Manager
Commuter Fixed Route1
Local Fixed Route1
On-Demand (Paratransit/Microtransit)1
Safety & Training Manager1
Quality Assurance Manager1
Other Non-Key Personnel
Road Supervisor(s)27
Dispatcher(s)13
Safety & Training Supervisor(s)13
Maintenance
Maintenance Manager1
Supervisors1
Transit Parts Specialist1
Master Mechanic3
A-Maintenance Mechanics3
B-Maintenance Mechanics5
C-Maintenance Mechanics5
Technology Coordinator1
Electronic Technicians3
Utility Workers13
ATL XpressYear 1Year 2Year 3Year 4Year 5
Annual Expense$ - 0$ - 0$ - 0$ - 0$ - 0
Ride GwinnetYear 1Year 2Year 3Year 4Year 5
Annual Expense$ - 0$ - 0$ - 0$ - 0$ - 0
Total Vehicles at North FacilityATLRGTotal (ATL + RG)
#Vehicles3273105
VOMS195271
Revenue Vehicles3273105
Name of Firm Submitting Proposal
FTE = Full Time Equivalent staff
On an annual basis, an FTE is considered to be 2,080 hours, which is calculated as: 8 hours per day x 5 work days per week x 52 weeks per year = 2,080 hours per year

North Facility Fixed Shared Noth Facility Fixed Fee - Shared

Cost ElementsAnnual Total Costs
Year 1Year 2Year 3Year 4Year 5
Casualty & Liability Costs
Property Taxes
Cleaning Materials & Supplies
Facility & Equipment Maintenance Parts & Supplies
Facility Leases
Support Vehicles
Communication Systems (except for revenue vehicles)
Computer Hardware & Software
Casualty & Liability Costs
Corporate Support
Safety Expenses
Office Materials & Supplies
Other Costs (Specify) - travel, utilities, mystery rider

Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Fixed Fee Split at North Facility
ATL30
RG70
Total100
Total Annual ExpensesYear 1Year 2Year 3Year 4Year 5
ATL00000
RG00000

image1.png

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