RoyalOakRFP-RO-2025-030_CostWorkbook_-_UPDATED.xlsx

Workbook Instructions Instructions

Proposers must complete this workbook and submit it with their proposal documents.

The Workbook must be completed and submitted as an EXCEL file. Please submit this document with this name:

RoyalOakRFP-RO-2025-030_CostWorkbook_VendorName

Each tab of this workbook has instructions specific to that tab. In all tabs, entries are to be made only in yellow-highlighted cells, and formulas may not be altered. Any alteration to this workbook that has not been approved by the Purchasing Agent may result in the entire submission being disqualified. This is to allow the City to properly compare prices.

All prices shall be in U.S. dollars. The City expects proposers to present a pricing model that provides a reasonable estimate of both monthly operational costs and one-time costs required to meet the scope of work as specified in the RFP. Furthermore, the City expects that the proposed costs in this pricing worksheet will be substantially the same as any contract resulting from this RFP, unless the City and the Contractor agree to changes to the Scope of Work.

Proposers shall also indicate the maximum amount by which prices may be raised for subsequent years of the contract. All price increases will be negotiated with the City, taking into account actual operating costs and the rate of inflation.

All Parking Locations Proposers must complete this workbook and submit it with their proposal documents. Each facility requires a breakdown of pricing for the specifications of that particular facility/designation. This tab includes all locations where the Proposer may be expected to provide its services. The loctaions include four (4) garages and ten (10) surface lots. Proposers shall provide pricing for each location and the City may utilize the Contractor for any or all facilities and/or utilize and or all of the services listed.

The "Labor Costs" tab requires a breakdown of labor costs by staff position. The pricing should be used to complete the overall labor cost pricing within the "All Parking Locations" tab. Pricing in this "Labor Costs" tab shall also be the basis for the addition of supplementary staff that may be required by City throughout the duration of the contract.

Optional Services $ - 0 $ - 0 $ - 0 $ - 0

Not-to-Exceed Yearly Price Adjustment (years 2 and 3)

Bundled Pricing Proposers must complete this workbook and submit it with their proposal documents. The "Bundled Pricing" tab shall include pricing based on overall specifications with any volume-based discount available to the City for selection of the Bundled Price.

Instructions

For each job classification that will be supporting this operation, list the Position or Job Title, the Quantity of people performing that role, the Fully Burdened Hourly Unit Rate for the role, and the Estimated Number of Hours per month (per individual). Only enter data in the yellow cells. Additional rows may be inserted (best done before the table is completed). Do not adjust any formulas on this sheet.

If a certain role will have both full- and part-time employees, enter the average number of hours per person for that role (such that Quantity x Estimated # Hours should equal the total number of hours that Proposer expects to have that position staffed).

Pricing in this "Labor Costs" tab shall also be the basis for the addition of supplementary staff that may be required by City throughout the duration of the contract.

After entering all data in the yellow cells, the total row should reflect the labor cost that will be billed to the City for the Proposer to meet the scope of work as currently written.

Instructions

For each role for which uniforms will be provided, please list the Position or Job Title, the Quantity of people performing that role who will need uniforms, and the cost per individual for their uniforms. Only enter data in the yellow cells. Additional rows may be inserted (best done before the table is completed). Do not adjust any formulas on this sheet.

After entering all data in the yellow cells, the total row should reflect the uniform cost that will be billed to the City for the Contractor to meet the scope of work as currently written.

Instructions

For each category of services expenses below, list the name of each component of the cost, the upfront or one-time purchase cost, and the estimated monthly cost. (For a recurring cost that will not be paid on a monthly basis, determine and insert the average monthly cost.) These costs should not include labor, as labor is captured separately.

It is suggested that a comment be entered for each cost to explain why it is needed and/or the benefit to the operation.

Only enter data in the yellow cells. Additional rows may be inserted (best done before the table is completed). Do not adjust any formulas on this sheet.

After entering all data in the yellow cells, each total row should reflect the total cost of services that will be billed to the City for the Proposer to meet the scope of work as currently written.

Itemize costs to operate ALL Facilities + Parking Operations as descibed in the SOW

Instructions

Enter the name of each overhead cost that will be billed to the City for Proposer's performance on this operation, and include the upfront or one-time purchase cost, and the estimated monthly cost. (For a recurring cost that will not be paid on a monthly basis, determine the average monthly cost for this sheet.)

Examples of overhead costs are insurance, permits, and licenses. Direct costs related to labor, services (including outsourced services), and supplies (collectively, "operating costs") should be identified on the appropriate sheets for those categories.

It is suggested that a comment be entered for each cost to explain why it is needed and/or the benefit to the operation.

Only enter data in the yellow cells. Additional rows may be inserted (best done before the table is completed). Do not adjust any formulas on this sheet.

After entering all data in the yellow cells, the total row should reflect the total overhead cost that will be billed to the City for the Proposer to meet the scope of work as currently written.

Itemize costs to operate ALL Facilities + Parking Operations as descibed in the SOW

Optional Services $ - 0 $ - 0 $ - 0 $ - 0

Not-to-Exceed Yearly Price Adjustment (years 2 and 3)

Optional Services Instructions

Enter a complete description of each optional service offered by Proposer. Include the upfront or one-time purchase cost, and the estimated monthly cost. For a cost that would have a basis other than a monthly fee, Proposer should estimate the cost per month and indicate, in the Comments, how the cost is determined. For example, if the cost is a transaction fee, Proposer should indicate the cost per transaction and the estimated number of transactions each month, multiply the two, and enter as an Estimated Monthly Cost.

Proposers should also include a reference to the full description of the service in the comments section of the proposals. Additionally, the Comments should explain when the optional/enhanced service would be available to the City.

Only enter data in the yellow cells. Additional rows may be inserted (best done before the table is completed). Do not adjust any formulas on this sheet.