RFP-25-0704_Time_and_Labor_Pricing_Proposal.xlsx

1. Instructions

Project: Time and Labor Management System Solution Attachment

Offeror must complete the Cost Proposal with the expected cost rate based on the anticipated contract start date as stated in the RFP. However, should the contract start date shift for any reason, the City expects the Offeror to honor the costs as stated in their Cost Proposal. The total bid cost is a firm fixed price proposal, and the determination of the contract start date will not affect the total bid price. The Offeror should prepare a cost proposal to reflect the best available pricing to meet the requested scope of services. The City and the Offeror will establish a payment schedule.

This workbook contains cost information required for submission of a proposal for the services in this RFP. The worksheets within this response template are listed below.

All worksheets must be completed. Any proposals that do not provide complete cost information may be excluded from the competitive field.

All costs to deliver the Offeror's full proposal must be included in this workbook. This includes all associated travel expenses

- Cells requiring Offeror data entry are highlighted in light blue to indicate which cells are available for data entry

- Cells that contain titles and formulas are marked in dark gray highlight

- Cells that are not applicable are marked in black highlight

- Do NOT add, edit, or adjust cells unless specifically requested to do so

- It is the Offeror's responsibility to validate the integrity of the Cost Workbook formulas and links

Key Assumptions:

- Offerors must abide by the deadlines detailed in the RFP

- All figures should be in USD and whole dollars

- Implementation is expected to occur up to year 2, with support and maintenance costs occurring after each implementation phase

- Proposals to include costs for a total of 5 years

DO NOTHING ON THIS SHEET.

2. Total Cost Summary Total Cost Summary

The costs recorded on this Total Cost Summary worksheet are automatically calculated using the information entered into worksheets 3. Implementation, 4. Support, and 5. Software. It is Offeror's responsibility to ensure that the costs reflect the full proposal cost for the services outlined in this RFP. Components such as data warehouse, document management, etc. should be included in the Cost Proposal.

Instructions: do NOT edit this sheet. Prior to submission, confirm all costs reflect the proposal cost total.

Total Cost Summary

&"Arial Black,Regular"&9Phoenix Municipal Court Request for Proposal Attachment F - Cost Workbook

3. Implementation

Implementation Costs

All tasks associated with the implementation services and deliverables described in response to RFP Scope of Work Section 3.9 - Implementation Services and proposed by Offeror shall be included per year (12-month period) for that service, based on Offeror's implementation plan described in response to RFP Scope of Work Section ----.

Note: the information displayed in the cells of this worksheet may be altered. It is the responsibility of Offeror to ensure the spreadsheet calculations are correct. All costs must be fully inclusive.

Instructions: enter costs for existing services in the light-blue cells. If a service will be provided by a third party, notate that as such in the Cost Assumptions tab and cost out that service as its own separate line item. Adjust labels in the white cells as needed. Insert additional rows as necessary where noted to record additional services.

The worksheet allows for one implementation phase. Offerors may add additional rows to correspond with their anticipated implementation plan. All figures should be in USD and whole dollars.

Solution Implementation

&"Arial Black,Regular"&9Phoenix Municipal Court

Attachment F - Cost Workbook

3. Implementation

Implementation Costs

All tasks associated with the implementation services and deliverables described in response to RFP Scope of Work Section 4.8 - Implementation Services and proposed by Offeror shall be included per year (12-month period) for that service, based on Offeror's implementation plan described in response to RFP Scope of Work Section.

Note: the information displayed in the cells of this worksheet may be altered. It is the responsibility of Offeror to ensure the spreadsheet calculations are correct. All costs must be fully inclusive.

Instructions: enter costs for existing services in the light-blue cells. If a service will be provided by a third party, notate that as such in the Cost Assumptions tab and cost out that service as its own separate line item. Adjust labels in the white cells as needed. Insert additional rows as necessary where noted to record additional services.

The worksheet allows for one implementation phase. Offerors may add additional rows to correspond with their anticipated implementation plan. All figures should be in USD and whole dollars.

Phase I - Solution Implementation

$ - 0

Total Implementation Costs Phase I ERROR:#DIV/0! $ - 0

&"Arial Black,Regular"&9Phoenix Municipal Court

Attachment F - Cost Workbook

4. Support

Production Support Costs

Offeror will provide costs for all post-implementation and production services inclusive of all tasks and deliverables required for maintenance and operation of the new applications as described in RFP Scope of Work Section 4.9. Post Go-Live Support & Operations and Maintenance.

For the purposes of this pricing worksheet, the scope of 'Support' should be assumed to include:

• Incident and defect triage;

• Defect and incident analysis and reporting;

• Provision of ‘break fix’ service for software, configuration, interface and data issues;

• Patch and Upgrades;

• Enhancements;

• Support for required changes to implement T&L operational functionality;

• A pool of hours (approx. three (3) FTEs) to support ongoing system enhancement and implementation of City IT initiatives

Note: The information displayed in the cells of this worksheet may be altered. It is the responsibility of the Offeror to ensure the spreadsheet calculations are correct. All costs must be fully inclusive.

Instructions: Enter annual costs for all support services in the light-blue cells. Insert additional rows as necessary, where noted in the Offeror's implementation plan. Ensure the calculations in the Total column (gray cells) carry through to the Total column for rows added. You may not delete rows once added. All figures should be in USD and whole dollars.

Post Implementation and Production Support Services

&"Arial Black,Regular"&9Phoenix Municipal Court

Attachment F - Cost Workbook

5. Software

Software Costs

Offeror will provide any and all costs for software which Offeror's solution will leverage to meet the requirements of this RFP. Costs shall include any licensing necessary to cover all environments (e.g., development, test, training, production, etc.). All costs associated with the purchase, delivery, installation, inspection, licenses, and production of the Software components shall be loaded into the Software Cost.

In the Software Specification table below, Offeror shall list the proposed software manufacturer, brand name, module name, and version number for the items being proposed.

It is the responsibility of Offeror to ensure spreadsheet calculations are correct.

Instructions: Enter all one-time and ongoing software costs for each fiscal year by item. Insert additional rows as necessary where noted. Ensure the calculations in the Total column (gray cells) carry through to the Total column for rows added. You may not delete rows once added. All figures should be in USD and whole dollars.

Software Costs

Software Specifications

&"Arial Black,Regular"&9Phoenix Municipal Court

Attachment F - Cost Workbook

6. Cost Assumptions

Cost Assumptions

Offeror must state all assumptions upon which its pricing is determined. Assumptions shall not conflict with the terms and conditions or mandatory requirements of this RFP, and shall not change the requested scope of the RFP as described in the proposal. Offeror must provide a clear understanding to the City of the cost impact to the City if any assumption is determined to be invalid; The City may use these values in consideration of the Cost Proposal.

Instructions: Complete the table below using as many rows as needed. Offeror shall provide a list of all business, economic, legal, programmatic, or practical assumptions that underlie Offeror's response to this RFP along with the associated rationale. Clearly describe the location of the references to the RFP and/or proposal, description of the assumption, rationale for the need of the assumption, and the cost impact to the City should the assumption be invalid. Insert additional rows as needed.

Cost Assumptions

&"Arial Black,Regular"&9Phoenix Municipal Court

Attachment F - Cost Workbook

7. Value-Added Services

Value-Added Services and Features

Offeror is invited to propose value-added services and/or features that may be deemed beneficial to the ongoing improvement of citywide Time and Labor system, both near-term and long-term. Examples may include, hardware clocking devices, GPS-Based Systems, Phone Systems, etc.

Offeror will provide costs for any proposed value-added services and/or features, but these costs will not be included in the Total Cost Summary. Costs for value-added services and/or optional features will not be scored, but are informational for citywide departments.

It is the responsibility of Offeror to ensure spreadsheet calculations are correct. All costs must be fully inclusive.

Instructions: Enter original and annual costs for all value-added services and/or features proposed. Insert additional rows as necessary where noted if Offeror suggests more than five services and/or features. Ensure the calculations in the Total column (gray cells) carry through to the Total column for rows added. You may not delete rows once added. All figures should be in USD and whole dollars.

Value-Added Services

&"Arial Black,Regular"&9Phoenix Municipal Court

Attachment F - Cost Workbook

Data Validation

image1.png