Appendix 2 - Cost Proposal.xlsx
XLSX spreadsheet 40 KB Posted
- Attached to
- APD Scheduling Software State and local contract opportunity
- Solicitation number
- R-2476
- Issued by
- Arapahoe County, Colorado
About this file
This document is a Cost Proposal Appendix for the Aurora Police Department (APD) Scheduling Solution, prepared by an unnamed vendor. The file is a comprehensive Excel workbook detailing the pricing structure for a cloud-based scheduling software solution over a 5-year contract period. The proposal includes detailed worksheets for solution and hosting costs, professional services, city software and hardware requirements, payment schedules, pricing assumptions, and optional costs.
The cost proposal is structured to provide a total cost of ownership analysis, with zero-dollar placeholders in the current document. The worksheets are designed to break down costs by category, including software licensing, implementation services, and potential on-premises hardware requirements. The vendor is instructed to provide granular pricing details, including line-item breakdowns for software modules, hosting services, implementation activities, and any additional city-required hardware or software. The payment schedule is meant to be performance-based, with invoicing tied to specific project milestones and deliverables over the contract term.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Appendix 1 - Functional and Technical Requirements.xlsx | XLSX spreadsheet | |
| R-2476 APD Scheduling Software.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Cover Page
APPENDIX 2 City of Aurora
APD Scheduling Solution
Cost Proposal
Prepared by: VENDOR NAME [Company Name]
&F &P
Total Evaluated Price
| TABLE 1 - TOTAL EVALUATED PRICE | ||
| TAB | 5 Year Cost of Ownership | TOTALS |
| 1. | Solution and Hosting Cost | $0 |
| 2. | Professional Services Cost | $0 |
| VENDOR PAYMENT TOTAL | $ - 0 | |
| 3. | City Software and Hardware Cost | $0 |
| TOTAL EVALUATED PRICE | $ - 0 |
| TAB | Worksheet | |
| 4. | Payment Schedule (must match Vendor Payment Total) | $0 |
| 6. | Optional Costs | $0 |
&"-,Bold"&9&F &"-,Bold"&9&P
1. Solution and Hosting Cost
INSTRUCTIONS:
In this section, the vendor will provide line item detail on the components that make up your hosted solution. This section must fully represent total cost of ownership including one-time acquisition cost plus ongoing annual maintenance or service cost, per year, for the duration of the maintenance and support period. If you license your solution on a subscription basis, provide the subscription details. If your solution is licenseable by module or environment (pre-production vs. production) please itemize this by module or environment. If your presented a phased implementation approach, please reconcile the listing of line items in this worksheet to your proposed implementation schedule. If you separate software cost from hosting cost, provide separate line items for software vs. hosting.
List all application specific software and hosting services that will be provided. Please based the quantities off of the metrics provided in the RFP.
Provide the vendor/product name and description, license type, quantity and pricing detail for all software proposed. For "License Type", specify the type of license using P=Product, E=Enterprise, N=Named Seat, C=Concurrent Users, O= Other. Provide supporting explanation as needed in the "Pricing Assumptions" worksheet.
| Table 1 - Solution and Hosting Cost | ||||||||||||||
| Line # | Product Name / Module Name / Service Name | Description (including model/ version number) | License Type | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | 5 YR TCO |
| 1. | $ - 0 | |||||||||||||
| 2. | $ - 0 | |||||||||||||
| 3. | $ - 0 | |||||||||||||
| 4. | $ - 0 | |||||||||||||
| 5. | $ - 0 | |||||||||||||
| 6. | $ - 0 | |||||||||||||
| 7. | $ - 0 | |||||||||||||
| 8. | $ - 0 | |||||||||||||
| 9. | $ - 0 | |||||||||||||
| 10. | $ - 0 | |||||||||||||
| 11. | $ - 0 | |||||||||||||
| 12. | $ - 0 | |||||||||||||
| If you insert additional lines above ensure the row and column total formulas are correct. | ||||||||||||||
| Total Solution and Hosting Cost: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
&"-,Bold"&9&F &"-,Bold"&9&P
2. Professional Services Cost
INSTRUCTIONS:
In this section, the vendor will provide line item detail for all professional services related to the initial implementation, plus any on-going support services that will be provided for the 5 year period of the contract. It is recommended that the Implementation Services be broken out to the level of detail needed to create the Payment Schedule on the separate worksheet. If travel and other expenses are required to perform the professional services, create one estimated annual amount for this expenditure.
| Table 2 - Professional Services Cost | |||||||
| Line # | Implementation Service / Activity / Deliverable | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | 5 YR TCO |
| 1. | $ - 0 | ||||||
| 2. | $ - 0 | ||||||
| 3. | $ - 0 | ||||||
| 4. | $ - 0 | ||||||
| 5. | $ - 0 | ||||||
| 6. | $ - 0 | ||||||
| 7. | $ - 0 | ||||||
| 8. | $ - 0 | ||||||
| 9. | $ - 0 | ||||||
| 10. | $ - 0 | ||||||
| 11. | $ - 0 | ||||||
| 12. | $ - 0 | ||||||
| If you insert additional lines above ensure the row and column total formulas are correct. | |||||||
| Total Professional Services Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
&"-,Bold"&9&F &"-,Bold"&9Page &P
3. City SW and HW Cost
INSTRUCTIONS:
The City is requiring a cloud-based solution. However there may be on-prem components of the system or minimum system requirements for the City devices to use and administer the system. The City assumes that these on-prem software or hardware components will fall outside the PaaS/SaaS subscription and must be itemized separately in this worksheet. The City has provided specifications for the standard device specifications for end users and system administrators. If additional software or hardware needs to be purchased by the city to use and administer your solution please include the additional requirements in this worksheet.
In this worksheet, the vendor will provide line item detail for all software and hardware items required to be purchased and maintained by the City to support any on-prem components of the solution. If a hardware refresh of any City provided components is recommended during a 5 year ownership period, please specify the cost of the hardware refresh and subsequent maintenance. This section should fully represent the total cost of ownership (TCO) including one-time acquisition cost plus annual maintenance, for the duration of the maintenance and support period. This information will be used in the Cost Evaluation, but the City reserves the right to purchase the specified software and hardware if the City can obtain more favorable pricing.
Vendors should ensure that all listed line items are represented in any solution architecture diagrams in the vendor response. Do not include specifications required to operate your hosted solution in this worksheet. Provide supporting explanation as needed in the "Pricing Assumptions" worksheet.
| Table 3 - City Software and Hardware Cost | |||||||||
| Line # | Component Purpose / Description | Make / Model / Configuration | Unit Price | Quantity | Initial Purchase Cost | Initial Purchase Maintenance | Hardware Refresh Cost | Hardware Refresh Maintenance | 5 YR TCO |
| 1. | $ - 0 | $ - 0 | |||||||
| 2. | $ - 0 | $ - 0 | |||||||
| 3. | $ - 0 | $ - 0 | |||||||
| 4. | $ - 0 | $ - 0 | |||||||
| 5. | $ - 0 | $ - 0 | |||||||
| 6. | $ - 0 | $ - 0 | |||||||
| 7. | $ - 0 | $ - 0 | |||||||
| 8. | $ - 0 | $ - 0 | |||||||
| 9. | $ - 0 | $ - 0 | |||||||
| 10. | $ - 0 | $ - 0 | |||||||
| 11. | $ - 0 | $ - 0 | |||||||
| 12. | $ - 0 | $ - 0 | |||||||
| 13. | $ - 0 | $ - 0 | |||||||
| 14. | $ - 0 | $ - 0 | |||||||
| 15. | $ - 0 | $ - 0 | |||||||
| 16. | $ - 0 | $ - 0 | |||||||
| 17. | $ - 0 | $ - 0 | |||||||
| 18. | $ - 0 | $ - 0 | |||||||
| 19. | $ - 0 | $ - 0 | |||||||
| 20. | $ - 0 | $ - 0 | |||||||
| If you insert additional lines above ensure the row and column total formulas are correct. | |||||||||
| Total Software and Hardware Cost (On Prem Components): | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
&"-,Bold"&9&F &"-,Bold"&9&P
4. Payment Schedule
INSTRUCTIONS:
In this section, the vendor will provide a proposed payment schedule. Vendors are encouraged to offer a payment schedule that is based on performance and incentives. For the Month Completed column, indicate the date you intend to submit the invoice for payment of the deliverable expressed as the number of months after Project Start Date. If you intend to produce a deliverable or work product that is zero cost to the City, please include these in the table as well.
The Invoiced Amount should total the total Vendor Payment total from the Total Evaluated Price tab. Do not include information from the Hardware or Optional Costs tab in the Payment Schedule.
| Table 4 - Payment Schedule | ||||||
| Payment # | Deliverable | Month Invoiced (After Start Date) | Year (1-5) | Deliverable Amount | Discount ($) | Invoiced Amount |
| 1. | $ - 0 | |||||
| 2. | $ - 0 | |||||
| 3. | $ - 0 | |||||
| 4. | $ - 0 | |||||
| 5. | $ - 0 | |||||
| 6. | $ - 0 | |||||
| 7. | $ - 0 | |||||
| 8. | $ - 0 | |||||
| 9. | $ - 0 | |||||
| 10. | $ - 0 | |||||
| 11. | $ - 0 | |||||
| 12. | $ - 0 | |||||
| 13. | $ - 0 | |||||
| 14. | $ - 0 | |||||
| 15. | $ - 0 | |||||
| 16. | $ - 0 | |||||
| 17. | $ - 0 | |||||
| 18. | $ - 0 | |||||
| 19. | $ - 0 | |||||
| 20. | $ - 0 | |||||
| 21. | $ - 0 | |||||
| If you insert additional lines above ensure the row and column total formulas are correct. | ||||||
| Total Vendor Payments: | $ - 0 | $ - 0 | $ - 0 |
&"-,Bold"&9&F &"-,Bold"&9&P
5. Pricing Assumptions
INSTRUCTIONS:
Vendor should use this worksheet to list all assumptions upon which its pricing is determined. Insert as many additional lines as necessary to ensure all concerns are accurately expressed. Reference the item to the back to the applicable worksheet and line item.
| Table 5 - Pricing Assumptions | |
| Item # | Assumption Details / Description |
| 1. | |
| 2. | |
| 3. | |
| 4. | |
| 5. | |
| 6. | |
| 7. | |
| 8. | |
| 9. | |
| 10. | |
| 11. | |
| 12. | |
| 13. | |
| 14. | |
| 15. | |
| 16. | |
| 17. | |
| 18. | |
| Insert Additional Lines Above |
&"-,Bold"&9&F &"-,Bold"&9&P
6. Optional Costs
INSTRUCTIONS:
In this section, the vendor may provide a list of optional costs. Vendor is required to provide sufficient details so that the costs can be easily associated with where the option is described in the vendor's response. Optional costs will not be included in the Total Evaluated Price and therefore not considered as part of the Cost scoring.
| Table 6 - Optional Costs | ||
| Line # | Item/Service/Activity | Cost |
| 1. | ||
| 2. | ||
| 3. | ||
| 4. | ||
| 5. | ||
| 6. | ||
| 7. | ||
| 8. | ||
| 9. | ||
| 10. | ||
| 11. | ||
| 12. | ||
| 13. | ||
| 14. | ||
| Insert Additional Lines Above | ||
| $ - 0 |
&"-,Bold"&9&F &"-,Bold"&9&P
File details come from the government source that posted it. Updated .