Attachment_F_-_Cost_Proposal.xlsx
XLSX spreadsheet 49 KB Posted
- Solicitation number
- 2026-RFP-056-PR
- Issued by
- Dane County, Mattoon Village, Wisconsin
About this file
This is a cost proposal attachment for a food and beverage service operations contract with Dane County, Wisconsin for the Alliant Energy Center, identified as RFP #2026-RFP-056-PR. The document contains two mandatory and optional proposal tabs that bidders must complete to outline their financial projections and service offerings over a five-year contract term. The RFP assumes increasing event volumes across the contract period: Year 1 encompasses 275 events across 1,175 event days, escalating to Year 5 with 320 events across 1,367 event days. Bidders are required to project total revenue by category including retail food and beverage, retail alcohol, catering food and beverage, catering alcohol, service charges, and state-rate offerings, with historical revenue data provided in the main RFP document to inform realistic projections.
The cost proposal requires bidders to establish a commission structure that can be formatted as either a flat rate or tiered structure based on revenue ranges, with commissions calculated against each revenue category. Tab 1 mandates completion of a Profit and Loss statement showing revenue projections and commission returns across all five contract years with corresponding percentages of sales. Tab 2 provides an optional management fee model alternative, allowing bidders to propose a base management fee with projected profit or subsidy calculations and optional incentive fee structures tied to key performance indicators. All capital investments must be amortized on a straight-line basis over the five-year contract period. The spreadsheet includes sections for pre-opening expenses, other investments, funds, and grants, enabling bidders to present comprehensive financial proposals that demonstrate both revenue generation capacity and cost management for operating food and beverage services at the venue.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Food_and_Beverage_Service_Operations_for_the_Alliant_Energy_Center_of_Dane_County_(Addendum_#1_Revision).pdf | ||
| Exhibit_J-_Concessions_Sale_Report_2024-2026_by_Building.xlsx | XLSX spreadsheet | |
| Exhibit_I-_AEC_Concessions_Commission_Revenue_by_Building.xlsx | XLSX spreadsheet | |
| Exhibit_I-_Concessions_Revenue_by_Building.xlsx | XLSX spreadsheet | |
| Exhibit_H-_Tables-_Answer_#21_and_#28.pdf | ||
| Attachment_G-_Project_Overview.pdf | ||
| Food_and_Beverage_Service_Operations_for_the_Alliant_Energy_Center_of_Dane_County.pdf | ||
| Exhibit_E_Coca-Cola_Agreement.pdf | ||
| Exhibit_D_Event_Equipment_Inventory.xlsx | XLSX spreadsheet | |
| Exhibit_C_2026_Event_Attendance.xlsx | XLSX spreadsheet | |
| Exhibit_B_2025_Event_Attendance.xlsx | XLSX spreadsheet | |
| Exhibit_A_2024_Event_Attendance.xlsx | XLSX spreadsheet |
Show all 12
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
Tab 1- P&L- Mandatory
| Profit and Loss - Mandatory |
| Cost Proposal |
| Food and Beverage Service Operations for the Alliant Energy Center of Dane County |
| RFP #: 2026-RFP-056-PR |
| 1. All bidders MUST complete this Excel tab- P&L Mandatory. Provide total revenue projections by category as outlined below utilizing the following assumptions regarding total number of events, total number of event days, historical revenues detailed in the RFP, and your experience working at similar accounts. |
2. Complete the commission structure chart below. If using a tiered commission structure, rename Boxes C22, D22, and E22 with respective revenue ranges.
| Key Assumptions: |
| Year 1: 275 events; 1,175 event days |
Year 2: 290 events; 1,240 event days Year 3: 300 events, 1,282 event days Year 4: 310 events, 1325 event days Year 5: 320 events; 1,367 event days
| Alliant Energy Profit and Loss Model Revenue Projections | ||||||||||||
| Year 1 | % of Sales | Year 2 | % of Sales | Year 3 | % of Sales | Year 4 | % of Sales | Year 5 | % of Sales | Total | % of Sales | |
| Retail Food & N/A Beverage | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Retail Alcohol | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Catering Food & N/A Beverage | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Catering Alcohol | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Service Charges | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| State Rate Catering | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| State Rate Service Charges | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Gross Subcontractor Sales | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Revenue Split to Subcontractors | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Net Subcontractor Sales | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Total Sales | $0 | $0 | $0 | $0 | $0 | $0 |
| Alliant Energy Profit and Loss Model Commission Structure | ||||
| Flate Rate | Tier Structure #1 | Tier Structure #2 | Tier Structure #3 | |
| Retail Food & N/A Beverage | ||||
| Retail Alcohol | ||||
| Catering Food & N/A Beverage | ||||
| Catering Alcohol | ||||
| Service Charges | ||||
| State Rate Catering | ||||
| State Rate Service Charges | ||||
| Net Subcontractor Sales |
Alliant Energy Profit and LossModel Commission Return Projections
| Year 1 | % of Sales | Year 2 | % of Sales | Year 3 | % of Sales | Year 4 | % of Sales | Year 5 | % of Sales | Total | % of Sales | |
| Retail Foo & N/A Beverage | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Retail Alcohol | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Catering Food & N/A Beverage | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Catering Alcohol | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Service Charges | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| State Rate Catering | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| State Rate Service Charges | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Net Subcontractor Sales | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Total Commission Return | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! | 0 | ERROR:#DIV/0! |
| Alliant Energy Profit and Loss Model Investment Offer | Alliant Energy Profit and Loss Model Pre-Opening Expenses | Alliant Energy Profit and Loss Model Other Investments, Funds, Grants, etc. | |||||
| Item | Value | Year(s) Disbursed | Item | Value | Item | Value | Frequency |
Total Investment $0 Total Pre-Opening $0
Tab 2- MGMT Fee- Optional
| Management Fee - Optional |
| Cost Proposal |
| Food and Beverage Service Operations for the Alliant Energy Center of Dane County |
| RFP #: 2026-RFP-056-PR |
| 1. Bidders may complete this tab in addition to Tab 1-Profit and Loss, which is required. |
2. Bidders must provide their total management fee cost along with projected profit or subsidy for all five years after accounting for costs.
3. All investment must be amortized on a straight-line basis not to exceed Year 5.
| Key Assumptions: |
| Year 1: 275 events; 1,175 event days |
Year 2: 290 events; 1,240 event days Year 3: 300 events, 1,282 event days Year 4: 310 events, 1325 event days Year 5: 320 events; 1,367 event days
Alliant Energy Management Fee Model Projections
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Total Sales | |||||
| Base Management Fee | |||||
| Projected Profit/(Subsidy) |
Alliant Energy Management Fee Model Proposed Structure
| % | |
| Proposed Incentive Fee Percentage |
| Proposed KPI Structure | |
| KPI | % |
image1.png
File details come from the government source that posted it. Updated .