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

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:

1All cells in yellow require an input. Boxes in Blue will auto populate.
2Technical 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.
3If 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.
4Any 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.
5Any deviation from this format may result in disqualification of Offeror's proposal.
Total Cost of Ownership (Cost Points Determined by this amount)
CategoryTotal 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 TypeEstimated Annual Number of Transactions based on TypeEstimated Annual Transaction Amount Totals by TypeEstimated Average Transaction AmountSet Cost to City or Customer per TransactionSet Percentage Fee Cost to City or Customer per TransactionInterchange Fee (Percentage)Interchange Fee (Flat Fee)BIN Sponsor FeeOther Fees. Offeror may add additional fee columns, if needed.Anticipated Total Annual Cost to City or End User
1Cash Payments2,124$ 265,698.00$ 125.09$ - 00.00%0.00%$ - 00.00%$ - 0
2Check Payment6,863$ 82,864,609.00$ 12,074.11$ - 00.00%0.00%$ - 00.00%$ - 0
3Credit Cards - Visa, Discover47,696$ 10,400,346.77$ 218.05$ - 00.00%0.00%$ - 00.00%$ - 0
4Credit Cards - Mastercard13,778$ 3,443,122.26$ 249.90$ - 00.00%0.00%$ - 00.00%$ - 0
5Credit Cards - American Express20,695$ 6,788,385.04$ 328.02$ - 00.00%0.00%$ - 00.00%$ - 0
6Debit Cards83,264$ 7,945,423.16$ 95.42$ - 00.00%0.00%$ - 00.00%$ - 0
7Prepaid Cards3,194$ 244,369.49$ 76.51$ - 00.00%0.00%$ - 00.00%$ - 0
8ACH/EFT/E-check11,286$ 46,621,966.00$ 4,130.96$ - 00.00%0.00%$ - 00.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.
1Fees for digital payment channels, wallets, and other methods offered under IPN.
2
3
4
5
6Offeror 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
1Retrieval Fee (Flat-Rate Fee)$ - 0
2Chargeback Fee (Flat-Rate Fee)$ - 0
3Other 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 Chargebacks81
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
1Non-Sufficient Fund (NSF) or Return Item Fee. (Flat-Rate Fee)$ - 0
2Chargeback Fee (Flat-Rate Fee)$ - 0
3Other 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 Returns26
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
1Processing Fee$ - 0
2Interchange fee$ - 0
3Other 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
1Return Fee$ - 0
2Other 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.CostsPercentageRange
1$0.000%$0.00
2$0.000%$0.00
3$0.000%$0.00
4$0.000%$0.00
5$0.000%$0.00
6$0.000%$0.00
7$0.000%$0.00
8Offeror may additional lines if needed.$0.000%$0.00

Total Cost for Category #1: $ - 0

Category #2

Category #2: Equipment Costs
Category #2a: Anticipated Equipment NeededQuantityIndividual Station CostsCosts
1Cashiering Station20$ - 0$ - 0
2Kiosk Station10$ - 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
8Offeror 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
8Offeror 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
8Offeror 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 TitleSoftware Engineer
Employee Hourly Rate$ - 0$ - 0$ - 0$ - 0$ - 0Total Hours
1.1HoursHoursHoursHoursHours
1.2000000
1.3000000
1.4000000
1.5000000
1.6000000
1.7000000
1.8000000
1.9000000
1.10000000
1.11000000
1.12Offeror may add more rows for individual implementation phases and/or columns for employees as needed.000000
Total Hours000000
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
SolutionIn-House/Cloud BasedCost per Integration Point
1Azure API Management ServicesIn House$ - 0
2Automated Citation Tracking (ACT) SystemIn House$ - 0
3Parking & Civil Citation Payment WebsiteIn House$ - 0
4AccelaCloud$ - 0
5Public Utilities - CityworksIn-House currently, but should be cloud based.$ - 0
6Utah Courts Information System (CORIS)In House$ - 0
7SalesforceCloud$ - 0
8Special AssessmentsIn House$ - 0
9Just FOIACloud$ - 0
10BrytCloud$ - 0
Total Cost for Category #3b.$ - 0
Category #3c: Custom Report Costs
Custom Report Hourly RatesProjected HoursHourly Rate for Report DevelopmentTotal Reporting Costs
1Custom 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 MonthTotal Tenant Costs
1Production$ - 0
2Sandbox
3Implementation
4Additional Implementation Tenant
5Offeror 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 FeesCost per LicenseEstimated LicensesTotal License Fees
1Cost per License (Year 0)$ - 060$ - 0
2Cost per License (Year 1)$ - 060$ - 0
3Cost per License (Year 2)$ - 060$ - 0
4Cost per License (Year 3)$ - 060$ - 0
5Cost per License (Year 4)$ - 060$ - 0
6Cost per License (Year 5)$ - 060$ - 0
Total License Fees$ - 0
Category #4b: Hosting and Managed ServicesTotal Hosting and Managed Services
1Hosting Fees (Year 0)$ - 0
2Managed Services (Year 0)$ - 0
3Hosting Fees (Year 1)$ - 0
4Managed Services (Year 1)$ - 0
5Hosting Fees (Year 2)$ - 0
6Managed Services (Year 2)$ - 0
7Hosting Fees (Year 3)$ - 0
8Managed Services (Year 3)$ - 0
9Hosting Fees (Year 4)$ - 0
10Managed Services (Year 4)$ - 0
11Hosting Fees (Year 5)$ - 0
12Managed Services (Year 5)$ - 0
Total Hosting and Managed Services Fees$ - 0
Category #4c: Annual Maintenance and SupportAnnual Maintenance and Support
1Maintenance and Support (Year 0)$ - 0
2Maintenance and Support (Year 1)$ - 0
3Maintenance and Support (Year 2)$ - 0
4Maintenance and Support (Year 3)$ - 0
5Maintenance and Support (Year 4)$ - 0
6Maintenance and Support (Year 5)$ - 0
Total Annual Maintenance and Support$ - 0
Category #4d: Additional Fees, etc.Additional Fees by Contract Year.
1Annual Statement Fee (Year 0)$ - 0
2Annual Statement Fee (Year 1)$ - 0
3Annual Statement Fee (Year 2)$ - 0
4Annual Statement Fee (Year 3)$ - 0
5Annual Statement Fee (Year 4)$ - 0
6Annual Statement Fee (Year 5)$ - 0
7Offeror 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
1IVR$0.00
2$0.00
3$0.00
4$0.00
5$0.00
6$0.00
7$0.00
8Offeror may additional lines if needed.$0.00
Category #5e: Fees for Value AddAdditional Fees by Contract Year.
1Annual Statement Fee (Year 0)$ - 0
2Annual Statement Fee (Year 1)$ - 0
3Annual Statement Fee (Year 2)$ - 0
4Annual Statement Fee (Year 3)$ - 0
5Annual Statement Fee (Year 4)$ - 0
6Annual Statement Fee (Year 5)$ - 0
7Offeror 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 FeesAdditional 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
13Offeror 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 .