9-Attachment 5 - Cost Sheet - Amended 3.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Salt Lake City Request for Proposals SLCI26082 Citywide Cashiering and Point of Sale Solution
- Solicitation number
- SLCI26082
- Issued by
- Salt Lake County, Salt Lake City, Utah
About this file
This is a cost sheet template for Salt Lake City Corporation's Request for Proposals SLCI26082, which seeks a citywide cashiering and point of sale solution excluding the Department of Airports and Department of Public Utilities. The document establishes the framework for offerors to submit detailed pricing proposals organized into five primary cost categories: Transaction Costs, Equipment Costs, Implementation Costs, Licensing/Hosting/Managed Services/Maintenance and Support, and Value Add features. The cost sheet requires offerors to specify transaction fees across eight payment types (cash, check, credit cards including Visa/Discover/Mastercard/American Express, debit cards, prepaid cards, and ACH/EFT/E-check), with estimated annual transaction volumes provided by the City. Equipment costs require pricing for 20 cashiering stations and 10 kiosk stations with itemized component breakdowns. Implementation costs demand detailed labor hour projections by employee title and hourly rate across project phases, travel expenses, integration point costs for nine specified systems, custom report development hours, and tenant requirements. The template also provides estimated quantities of 60 licenses across six contract years and requires separate pricing for hosting, managed services, and annual maintenance and support.
The cost sheet mandates that all cells in yellow be populated with offeror pricing, while blue cells auto-populate totals, and specifies that any costs not provided will not be allowed into the resulting contract. Offerors are instructed that technical requirements and cost proposals must be reflective of one another, with all costs necessary to perform services included on the designated tabs. The document emphasizes strict compliance with the format provided, noting that any deviation may result in disqualification. Offerors may identify zero costs or leave cells blank only if services are provided at no cost or built into another cost item, with N/A acceptable only for non-applicable cost categories. The template accommodates flexibility for offerors to add additional fee columns, rows, and categories as needed to capture all relevant costs, and includes sections for non-scored Value Add features and a three-year option fee structure covering Years 0 through 5 of the contract period.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 8-SLCI26082 - Amended 2.docx | DOCX document | |
| 1-Confidential+and+Proprietary+Info+Declaration+Form.pdf | ||
| 6-Attachment 6 - Score Sheet.xls | XLS spreadsheet | |
| 2-Attachment 1 - Sample Agreement.docx | DOCX document | |
| 3-Attachment 3 - Scope of Work.docx | DOCX document | |
| 5-Attachment 7 - System Diagram.pdf | ||
| 4-Attachment 2 - Introduction and Background.docx | DOCX document | |
| 7-Attachment 4 - Technical Architecture and IMS Requirements - Amended.xlsx | XLSX spreadsheet |
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
Total Cost of Ownership
ATTACHMENT 5 - COST SHEET
Offeror Name:
| 1 | All cells in yellow require an input. Boxes in Blue will auto populate. |
| 2 | Technical Requirements and Cost Proposals must be reflective of one another. All costs necessary to perform the services under this contract must be included on this form. Populate costs on the individual tabs. Do not add costs to this tab. |
| 3 | If zero is entered for any cell or if any cell is left blank, the City will assume that the related services are either provided at no cost or built into another cost item. If a cost category is not applicable, enter N/A. |
| 4 | Any cost not provided on this Cost Proposal, will not be allowed into the resulting contract. If you identify a cost that cannot be properly captured in this Cost Proposal, then provide suggestions for modifying this Cost Proposal during the question and answer period for this solicitation. |
| 5 | Any deviation from this format may result in disqualification of Offeror's proposal. |
| Total Cost of Ownership (Cost Points Determined by this amount) | |
| Category | Total Cost of Ownership |
| Category #1: Transaction Costs | $ - 0 |
| Category #2: Equipment Costs | $ - 0 |
| Category #3: Implementation Costs | $ - 0 |
| Category #4: Licensing, Hosting and Managed Services, and Maintenance and Support | $ - 0 |
| Total Cost of Ownership (Cost Points Determined by this amount) | $ - 0 |
Category #1
| Category #1: Transaction Costs | |||||||||||
| Cost Category #1a: Cost to City and/or Customer Based on Payment Type. | Offeror's Proposed Fees by Type. | ||||||||||
| # | Payment Type | Estimated Annual Number of Transactions based on Type | Estimated Annual Transaction Amount Totals by Type | Estimated Average Transaction Amount | Set Cost to City or Customer per Transaction | Set Percentage Fee Cost to City or Customer per Transaction | Interchange Fee (Percentage) | Interchange Fee (Flat Fee) | BIN Sponsor Fee | Other Fees. Offeror may add additional fee columns, if needed. | Anticipated Total Annual Cost to City or End User |
| 1 | Cash Payments | 2,124 | $ 265,698.00 | $ 125.09 | $ - 0 | 0.00% | 0.00% | $ - 0 | 0.00% | $ - 0 | |
| 2 | Check Payment | 6,863 | $ 82,864,609.00 | $ 12,074.11 | $ - 0 | 0.00% | 0.00% | $ - 0 | 0.00% | $ - 0 | |
| 3 | Credit Cards - Visa, Discover | 47,696 | $ 10,400,346.77 | $ 218.05 | $ - 0 | 0.00% | 0.00% | $ - 0 | 0.00% | $ - 0 | |
| 4 | Credit Cards - Mastercard | 13,778 | $ 3,443,122.26 | $ 249.90 | $ - 0 | 0.00% | 0.00% | $ - 0 | 0.00% | $ - 0 | |
| 5 | Credit Cards - American Express | 20,695 | $ 6,788,385.04 | $ 328.02 | $ - 0 | 0.00% | 0.00% | $ - 0 | 0.00% | $ - 0 | |
| 6 | Debit Cards | 83,264 | $ 7,945,423.16 | $ 95.42 | $ - 0 | 0.00% | 0.00% | $ - 0 | 0.00% | $ - 0 | |
| 7 | Prepaid Cards | 3,194 | $ 244,369.49 | $ 76.51 | $ - 0 | 0.00% | 0.00% | $ - 0 | 0.00% | $ - 0 | |
| 8 | ACH/EFT/E-check | 11,286 | $ 46,621,966.00 | $ 4,130.96 | $ - 0 | 0.00% | 0.00% | $ - 0 | 0.00% | $ - 0 | |
| $ - 0 |
| Cost Category #1a.1 - Fee Description/Detail (Not Scored) | ||||
| # | Name of Fee. | Provide purpose and description of what fee includes/does not include. | ||
| 1 | Fees for digital payment channels, wallets, and other methods offered under IPN. | |||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | Offeror may add additional rows if needed. | |||
| Category 1b: A City customer disputes a transaction with their card issuer to reverse a charge and successfully disputes the charge. The card is a visa credit card. | ||||
| Original Transaction Amount | $612.17 | |||
| 1 | Retrieval Fee (Flat-Rate Fee) | $ - 0 | ||
| 2 | Chargeback Fee (Flat-Rate Fee) | $ - 0 | ||
| 3 | Other Fees (Please list type of fee. Offeror may add additional lines, if needed) | $ - 0 | ||
| Total Fees Assessed to City (Enter Total Fee Amount here) | $ - 0 | |||
| Estimated Annual Average Chargebacks | 81 | |||
| Total Fees Assessed to City | $ - 0 | |||
| Category 1c: A City customer check is declined because there is not enough money in their account. | ||||
| Original Transaction Amount | $8,026.23 | |||
| 1 | Non-Sufficient Fund (NSF) or Return Item Fee. (Flat-Rate Fee) | $ - 0 | ||
| 2 | Chargeback Fee (Flat-Rate Fee) | $ - 0 | ||
| 3 | Other Fees (Please list type of fee. Offeror may add additional lines, if needed) | $ - 0 | ||
| Total Fees Assessed to City (Enter Total Fee Amount here) | $ - 0 | |||
| Estimated Annual Average Check Returns | 26 | |||
| Total Fees Assessed to City | $ - 0 | |||
| Category 1d: A City customer requests a refund through a credit card payment that is approved by the City. | ||||
| Average Refund Transaction Amount | $316.58 | |||
| 1 | Processing Fee | $ - 0 | ||
| 2 | Interchange fee | $ - 0 | ||
| 3 | Other Fees (Please list type of fee. Offeror may add additional lines, if needed) | $ - 0 | ||
| Total Fees Assessed to City and Customer (Enter Total Fee Amount here) | $ - 0 | |||
| Estimated Annual Average Number of Refunds. | 268 | |||
| Total Fees Assessed to City | $ - 0 | |||
| Category 1e: A City customer attempts to pay with through ACH and the ACH cannot be processed or completed (ACH Return) | ||||
| Average ACH Return Amount | $263.41 | |||
| 1 | Return Fee | $ - 0 | ||
| 2 | Other Fees (Please list type of fee. Offeror may add additional lines, if needed) | $ - 0 | ||
| Total Fees Assessed to City and Customer (Enter Total Fee Amount here) | $ - 0 | |||
| Estimated Annual Average Number of Returns. | 97 | |||
| Total Fees Assessed to City | $ - 0 | |||
| Cost Category #1f - Fee Breakdown (Not Scored). Please provide a list of all additional fees that could apply to transactions not listed above. If fees vary based on a transaction range, please add multiple lines for the same fee and add the appropriate range to the range column. | Costs | Percentage | Range | |
| 1 | $0.00 | 0% | $0.00 | |
| 2 | $0.00 | 0% | $0.00 | |
| 3 | $0.00 | 0% | $0.00 | |
| 4 | $0.00 | 0% | $0.00 | |
| 5 | $0.00 | 0% | $0.00 | |
| 6 | $0.00 | 0% | $0.00 | |
| 7 | $0.00 | 0% | $0.00 | |
| 8 | Offeror may additional lines if needed. | $0.00 | 0% | $0.00 |
Total Cost for Category #1: $ - 0
Category #2
| Category #2: Equipment Costs | ||||
| Category #2a: Anticipated Equipment Needed | Quantity | Individual Station Costs | Costs | |
| 1 | Cashiering Station | 20 | $ - 0 | $ - 0 |
| 2 | Kiosk Station | 10 | $ - 0 | $ - 0 |
| Total Cost for Category 2 | $ - 0 | |||
| Category #2b: Provide a breakdown of what is included in a cashiering station. | Cost Per Item | |||
| 1 | $ - 0 | |||
| 2 | $ - 0 | |||
| 3 | $ - 0 | |||
| 4 | $ - 0 | |||
| 5 | $ - 0 | |||
| 6 | $ - 0 | |||
| 7 | $ - 0 | |||
| 8 | Offeror may add additional lines as needed. | $ - 0 | ||
| Total cost for an individual cashiering station. This total should match the cost for one station as listed in E4. | $ - 0 | |||
| Category #2c: Provide a breakdown of what is included in a kiosk station. | Cost Per Item | |||
| 1 | $ - 0 | |||
| 2 | $ - 0 | |||
| 3 | $ - 0 | |||
| 4 | $ - 0 | |||
| 5 | $ - 0 | |||
| 6 | $ - 0 | |||
| 7 | $ - 0 | |||
| 8 | Offeror may add additional lines as needed. | $ - 0 | ||
| Total cost for an individual cashiering station. This total should match the cost for one station as listed in E5. | $ - 0 |
| Category #2d: Additional Equipment Costs not included in a cashiering or kiosk station (Not Scored) | Cost Per Item | |
| 1 | $ - 0 | |
| 2 | $ - 0 | |
| 3 | $ - 0 | |
| 4 | $ - 0 | |
| 5 | $ - 0 | |
| 6 | $ - 0 | |
| 7 | $ - 0 | |
| 8 | Offeror may add additional lines as needed. | $ - 0 |
Category #3
| Category #3: Implementation Costs | ||||||||
| Cost Category #3a: Implementation Cost | ||||||||
| Provide a breakdown of Offeror's proposed timeline and the project hours, fees, and expenses. | Employee Title | Software Engineer | ||||||
| Employee Hourly Rate | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | Total Hours | ||
| 1.1 | Hours | Hours | Hours | Hours | Hours | |||
| 1.2 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 1.3 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 1.4 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 1.6 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 1.7 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 1.8 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 1.9 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 1.10 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 1.11 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 1.12 | Offeror may add more rows for individual implementation phases and/or columns for employees as needed. | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Hours | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Total Fees | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Travel Expenses (i.e., airfare, rental car, hotel, mileage, food, transportation, etc.), please attach supplemental spreadsheet or explanation of how total is calculated. | $ - 0 | |||||||
| Implementation Cost | $ - 0 | |||||||
| Total Cost for Category #3a. | $ - 0 |
| Category #3b: Cost per Integration Point | |||
| Solution | In-House/Cloud Based | Cost per Integration Point | |
| 1 | Azure API Management Services | In House | $ - 0 |
| 2 | Automated Citation Tracking (ACT) System | In House | $ - 0 |
| 3 | Parking & Civil Citation Payment Website | In House | $ - 0 |
| 4 | Accela | Cloud | $ - 0 |
| 5 | Public Utilities - Cityworks | In-House currently, but should be cloud based. | $ - 0 |
| 6 | Utah Courts Information System (CORIS) | In House | $ - 0 |
| 7 | Salesforce | Cloud | $ - 0 |
| 8 | Special Assessments | In House | $ - 0 |
| 9 | Just FOIA | Cloud | $ - 0 |
| 10 | Bryt | Cloud | $ - 0 |
| Total Cost for Category #3b. | $ - 0 |
| Category #3c: Custom Report Costs | ||||
| Custom Report Hourly Rates | Projected Hours | Hourly Rate for Report Development | Total Reporting Costs | |
| 1 | Custom Report Costs | $ - 0 | ||
| Total Cost for Category #3c. |
| Category #3d: Tenant Costs | |||||
| Cost per Tenant. In addition to the implementation phase, City anticipates needing a test tenant from Go-Live through termination of the agreement. | Phase (Input Phase of Project) | Duration Needed (Months) | Cost per Month | Total Tenant Costs | |
| 1 | Production | $ - 0 | |||
| 2 | Sandbox | ||||
| 3 | Implementation | ||||
| 4 | Additional Implementation Tenant | ||||
| 5 | Offeror may update names above and may add additional rows, if needed. | ||||
| Total Cost for Category #3d. | $ - 0 |
Total Cost for Category #3: $ - 0
Category #4 Category #4: Licensing, Hosting and Managed Services, and Maintenance and Support
| Category #4a: License Fees | Cost per License | Estimated Licenses | Total License Fees | |
| 1 | Cost per License (Year 0) | $ - 0 | 60 | $ - 0 |
| 2 | Cost per License (Year 1) | $ - 0 | 60 | $ - 0 |
| 3 | Cost per License (Year 2) | $ - 0 | 60 | $ - 0 |
| 4 | Cost per License (Year 3) | $ - 0 | 60 | $ - 0 |
| 5 | Cost per License (Year 4) | $ - 0 | 60 | $ - 0 |
| 6 | Cost per License (Year 5) | $ - 0 | 60 | $ - 0 |
| Total License Fees | $ - 0 | |||
| Category #4b: Hosting and Managed Services | Total Hosting and Managed Services | |||
| 1 | Hosting Fees (Year 0) | $ - 0 | ||
| 2 | Managed Services (Year 0) | $ - 0 | ||
| 3 | Hosting Fees (Year 1) | $ - 0 | ||
| 4 | Managed Services (Year 1) | $ - 0 | ||
| 5 | Hosting Fees (Year 2) | $ - 0 | ||
| 6 | Managed Services (Year 2) | $ - 0 | ||
| 7 | Hosting Fees (Year 3) | $ - 0 | ||
| 8 | Managed Services (Year 3) | $ - 0 | ||
| 9 | Hosting Fees (Year 4) | $ - 0 | ||
| 10 | Managed Services (Year 4) | $ - 0 | ||
| 11 | Hosting Fees (Year 5) | $ - 0 | ||
| 12 | Managed Services (Year 5) | $ - 0 | ||
| Total Hosting and Managed Services Fees | $ - 0 | |||
| Category #4c: Annual Maintenance and Support | Annual Maintenance and Support | |||
| 1 | Maintenance and Support (Year 0) | $ - 0 | ||
| 2 | Maintenance and Support (Year 1) | $ - 0 | ||
| 3 | Maintenance and Support (Year 2) | $ - 0 | ||
| 4 | Maintenance and Support (Year 3) | $ - 0 | ||
| 5 | Maintenance and Support (Year 4) | $ - 0 | ||
| 6 | Maintenance and Support (Year 5) | $ - 0 | ||
| Total Annual Maintenance and Support | $ - 0 | |||
| Category #4d: Additional Fees, etc. | Additional Fees by Contract Year. | |||
| 1 | Annual Statement Fee (Year 0) | $ - 0 | ||
| 2 | Annual Statement Fee (Year 1) | $ - 0 | ||
| 3 | Annual Statement Fee (Year 2) | $ - 0 | ||
| 4 | Annual Statement Fee (Year 3) | $ - 0 | ||
| 5 | Annual Statement Fee (Year 4) | $ - 0 | ||
| 6 | Annual Statement Fee (Year 5) | $ - 0 | ||
| 7 | Offeror may additional fees/lines, as needed. | $ - 0 | ||
| 8 | $ - 0 | |||
| 9 | $ - 0 | |||
| 10 | $ - 0 | |||
| 11 | $ - 0 | |||
| 12 | $ - 0 | |||
| 13 | $ - 0 | |||
| Total Additional Fees, etc. | $ - 0 |
Total Cost for Category #4: Licensing, Hosting and Managed Services, and Maintenance and Support, and Additonal Fees $ - 0
Value Add
| Value Add | ||
| Value Add (Not Scored) | Costs | |
| 1 | IVR | $0.00 |
| 2 | $0.00 | |
| 3 | $0.00 | |
| 4 | $0.00 | |
| 5 | $0.00 | |
| 6 | $0.00 | |
| 7 | $0.00 | |
| 8 | Offeror may additional lines if needed. | $0.00 |
| Category #5e: Fees for Value Add | Additional Fees by Contract Year. | |
| 1 | Annual Statement Fee (Year 0) | $ - 0 |
| 2 | Annual Statement Fee (Year 1) | $ - 0 |
| 3 | Annual Statement Fee (Year 2) | $ - 0 |
| 4 | Annual Statement Fee (Year 3) | $ - 0 |
| 5 | Annual Statement Fee (Year 4) | $ - 0 |
| 6 | Annual Statement Fee (Year 5) | $ - 0 |
| 7 | Offeror may additional fees/lines, as needed. | $ - 0 |
| 8 | $ - 0 | |
| 9 | $ - 0 | |
| 10 | $ - 0 | |
| 11 | $ - 0 | |
| 12 | $ - 0 | |
| 13 | $ - 0 | |
| Total Additional Fees, etc. | $ - 0 | |
| Category #5e: Three Year Option Fees | Additional Fees by Contract Year. | |
| 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 | Offeror may additional fees/lines, as needed. | $ - 0 |
| Costs for Three Year Option Fee | $ - 0 |
File details come from the government source that posted it. Updated .