19-5934-R1 Embedded Price Sheet.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
Emergency Notification System (UW-MAD) [19-5934-R1]
Solicitation number
19-5934-R1
Issued by
Dane County, Madison City, Wisconsin

About this file

This is an embedded price sheet for the University of Wisconsin-Madison's Emergency Notification System (RFP 19-5934-R1) solicitation. The price sheet serves as the mandatory cost proposal template for vendors responding to this Request for Proposals. Vendors must submit pricing in the exact format provided, with only the yellow-highlighted fields requiring completion by the respondent. The contract structure includes three lots: the primary lot and two optional lots (Lot 2 and Lot 3). The pricing template is designed to capture costs across a 10-year contract term, broken down by the University of Wisconsin's fiscal year (July 1 through June 30). Vendors must categorize all costs into three distinct categories: recurring costs (annual fees for licensing, maintenance, and subscriptions), implementation costs (one-time system deployment fees), and all other costs. The template provides separate sections for each contract year, with rows for license costs, maintenance costs, subscription costs, and other miscellaneous expenses for each year.

The price sheet requires vendors to provide detailed cost breakdowns with specific rate information, including hourly rates for personnel and fixed rates for product purchases. Pricing is firm for the first three years of the contract, after which only documented cost increases are permitted. An additional services tab allows vendors to propose supplementary services at fixed hourly rates for personnel or fixed product rates. The spreadsheet contains embedded formulas that automatically calculate subtotals for each year and category, as well as grand totals across the entire contract period. Vendors are explicitly cautioned that only fees expressly called out on this spreadsheet will be paid by the University; omissions or errors in the proposal become the vendor's responsibility. The University reserves the right to disqualify bids submitted in formats other than the specified spreadsheet template.

View the file

Other files

File Type Posted
19-5934-R1 RFP AMD 2.docx DOCX document
19-5934-R1 RFP.docx DOCX document
19-5934-R1 RFP AMD 1.docx DOCX document

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

Instructions

Other Notes
1)Your response MUST be received in this format. If you provide it back in some other form or copy and special past it elsewhere, the UW reserves the right to disqualify your bid.
2)Only fees expressly called out here will be used to calculate your proposed costs. Errors and omission will be the responsibility of the vendor. The UW will not pay above and beyond the cost on your solicitation response.
3)Pricing shall be firm for the first three (3) years of the contract. After this initial period only documented cost increases will be allowed (See Section 3.5 of RFP Document)
4)You only need to enter information in the boxes highlighted in Yellow. All other calculations will be embedded in the sheet.
Definitions
Reoccuring Costs
are defined as costs that are not directly related to the implementation costs and is a cost that will need to be paid each year of the contract.
Implementation Costs
are fees and charges directly related to the cost to implement the system. Can not be Reoccuring or be a charge in multiple years of the contract.
All Other Costs
are any other fees that do not fit into the Reoccuring Costs or the implementation costs. Only fees on this spreadsheet will be paid by the UW. Make sure that you cost proposal is all encompassing, because omission on your part will not be the responsibility of the UW.
Additional Services Tab
On this tab, please add any additional services that the UW maybe interested in. You must provide your cost as a fixed hourly rate for all personnel costs and a fix rate for all product purchases.
Foot Notes
1)This form is designed to give the University of Wisconsin Madison a full budget of all costs associated with the implementaion and ongoing cost for the duration of the contract. The UW's Fiscal year runs from July 1 through June 30 of the next year. Please break out your costs per our fiscal year.
2)This field is to give a general category of the costs. This field is locked on tabs where the category is already filled in. Please us industry standard category that clearly delineate the costs by Hardware, Software, Maintanence, etc.
3)Please provide a descriptive name of the product or service that you are providing. The UW must be able to easily identify the product or service based solely on this description.
4)This field is for you to provide the estmated hours that you company will provide by person or project. While you may prefer to provide a lump sum price, the UW needs to understand the number of hours you are proposing. Deviations from this formate may cause your response to be disqualified.
5)This field is for products that do not have a hourly rate (i.e. you by a hammer for $5 or you allow us to use software for a set cost per year)
6)This field is used to calculate the total cost of hourly wages (i.e. Rate of Pay/Hr X Estimated Hours)

Lot 2

Lot 3

Recurring Costs

Re Occuring Costs
Item2Year1Description3Cost5
Example (Year 1 Subscription Costs)Example (1)$1,000.00 per month for 12 Months, includes all subscription, licensing and Maintenance costs. No other reoccuring monthly costs.$ 12,000.00
Year 1 License Costs1
Year 1 Maintanence Costs1
Year 1 Subscription Costs1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
$ - 0
Sub Total Year 1
Item2Year1Description3Cost5
Year 2 License Costs2
Year 2 Maintanence Costs2
Year 2 Subscription Costs2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Sub Total Year 2$ - 0
Item2Year1Description3Cost5
Year 3 License Costs3
Year 3 Maintanence Costs3
Year 3 Subscription Costs3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Sub Total Year 3$ - 0
Item2Year1Description3Cost5
Year 4 License Costs4
Year 4 Maintanence Costs4
Year 4 Subscription Costs4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Sub Total Year 4$ - 0
Item2Year1Description3Cost5
Year 5 License Costs5
Year 5 Maintanence Costs5
Year 5 Subscription Costs5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
$ - 0
Sub Total Year 5
Item2Year1Description3Cost5
Year 6 License Costs6
Year 6 Maintanence Costs6
Year 6 Subscription Costs6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Sub Total Year 6$ - 0
Item2Year1Description3Cost5
Year 7 License Costs7
Year 7 Maintanence Costs7
Year 7 Subscription Costs7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Sub Total Year 7$ - 0
Item2Year1Description3Cost5
Year 8 License Costs8
Year 8 Maintanence Costs8
Year 8 Subscription Costs8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Sub Total Year 8$ - 0
Item2Year1Description3Cost5
Year 9 License Costs9
Year 9 Maintanence Costs9
Year 9 Subscription Costs9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Sub Total Year 9$ - 0
Item2Year1Description3Cost5
Year 10 License Costs10
Year 10 Maintanence Costs10
Year 10 Subscription Costs10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Sub Total Year 10$ - 0

Implementation Cost

Implementation Costs
Item2Description3Estimated Hours4Rate of Pay/HR5Total Cost6

$ - 0

All other Costs

All Other Costs Not Shown Elsewhere
Year1Item2Description3Estimated Hours4Rate of Pay/HR5Total Cost6
Total All other Costs All years$ - 0
Year 1 Total All Other Costs$ - 0
Year 2 Total All Other Costs$ - 0
Year 3 Total All Other Costs$ - 0
Year 4 Total All Other Costs$ - 0
Year 5 Total All Other Costs$ - 0
Year 6 Total All Other Costs$ - 0
Year 7 Total All Other Costs$ - 0
Year 8 Total All Other Costs$ - 0
Year 9 Total All Other Costs$ - 0
Year 10 Total All Other Costs$ - 0

Additional Services

Other Services
Year1Item2Description3Rate of Pay/HR5

Total All other Costs All years

Lot 2

Lot 2 Re Occuring Costs
Item2Year1Description3Cost5
Example (Year 1 Subscription Costs)Example (1)$1,000.00 per month for 12 Months, includes all subscription, licensing and Maintenance costs. No other reoccuring monthly costs.$ 12,000.00
Year 1 License Costs1
Year 1 Maintanence Costs1
Year 1 Subscription Costs1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
$ - 0
Sub Total Year 1
Item2Year1Description3Cost5
Year 2 License Costs2
Year 2 Maintanence Costs2
Year 2 Subscription Costs2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Sub Total Year 2$ - 0
Item2Year1Description3Cost5
Year 3 License Costs3
Year 3 Maintanence Costs3
Year 3 Subscription Costs3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Sub Total Year 3$ - 0
Item2Year1Description3Cost5
Year 4 License Costs4
Year 4 Maintanence Costs4
Year 4 Subscription Costs4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Sub Total Year 4$ - 0
Item2Year1Description3Cost5
Year 5 License Costs5
Year 5 Maintanence Costs5
Year 5 Subscription Costs5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
$ - 0
Sub Total Year 5
Item2Year1Description3Cost5
Year 6 License Costs6
Year 6 Maintanence Costs6
Year 6 Subscription Costs6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Sub Total Year 6$ - 0
Item2Year1Description3Cost5
Year 7 License Costs7
Year 7 Maintanence Costs7
Year 7 Subscription Costs7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Sub Total Year 7$ - 0
Item2Year1Description3Cost5
Year 8 License Costs8
Year 8 Maintanence Costs8
Year 8 Subscription Costs8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Sub Total Year 8$ - 0
Item2Year1Description3Cost5
Year 9 License Costs9
Year 9 Maintanence Costs9
Year 9 Subscription Costs9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Sub Total Year 9$ - 0
Item2Year1Description3Cost5
Year 10 License Costs10
Year 10 Maintanence Costs10
Year 10 Subscription Costs10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Sub Total Year 10$ - 0

Lot 3

Lot 3 Re Occuring Costs
Item2Year1Description3Cost5
Example (Year 1 Subscription Costs)Example (1)$1,000.00 per month for 12 Months, includes all subscription, licensing and Maintenance costs. No other reoccuring monthly costs.$ 12,000.00
Year 1 License Costs1
Year 1 Maintanence Costs1
Year 1 Subscription Costs1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
Other1
$ - 0
Sub Total Year 1
Item2Year1Description3Cost5
Year 2 License Costs2
Year 2 Maintanence Costs2
Year 2 Subscription Costs2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Other2
Sub Total Year 2$ - 0
Item2Year1Description3Cost5
Year 3 License Costs3
Year 3 Maintanence Costs3
Year 3 Subscription Costs3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Other3
Sub Total Year 3$ - 0
Item2Year1Description3Cost5
Year 4 License Costs4
Year 4 Maintanence Costs4
Year 4 Subscription Costs4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Other4
Sub Total Year 4$ - 0
Item2Year1Description3Cost5
Year 5 License Costs5
Year 5 Maintanence Costs5
Year 5 Subscription Costs5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
Other5
$ - 0
Sub Total Year 5
Item2Year1Description3Cost5
Year 6 License Costs6
Year 6 Maintanence Costs6
Year 6 Subscription Costs6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Other6
Sub Total Year 6$ - 0
Item2Year1Description3Cost5
Year 7 License Costs7
Year 7 Maintanence Costs7
Year 7 Subscription Costs7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Other7
Sub Total Year 7$ - 0
Item2Year1Description3Cost5
Year 8 License Costs8
Year 8 Maintanence Costs8
Year 8 Subscription Costs8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Other8
Sub Total Year 8$ - 0
Item2Year1Description3Cost5
Year 9 License Costs9
Year 9 Maintanence Costs9
Year 9 Subscription Costs9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Other9
Sub Total Year 9$ - 0
Item2Year1Description3Cost5
Year 10 License Costs10
Year 10 Maintanence Costs10
Year 10 Subscription Costs10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Other10
Sub Total Year 10$ - 0

Summary

CostAll YearsFiscal Year 1Fiscal Year 2Fiscal Year 3Fiscal Year 4Fiscal Year 5Fiscal Year 6Fiscal Year 7Fiscal Year 8Fiscal Year 9Fiscal Year 10Total
Reocurring costsN/A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Implementation Costs$ - 0N/AN/AN/AN/AN/AN/AN/AN/AN/AN/A$ - 0
All other CostsN/A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total by Year$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Optional LotsAll YearsFiscal Year 1Fiscal Year 2Fiscal Year 3Fiscal Year 4Fiscal Year 5Fiscal Year 6Fiscal Year 7Fiscal Year 8Fiscal Year 9Fiscal Year 10Total
Lot 2N/A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
lot 3N/A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

File details come from the government source that posted it. Updated .