Attachment_F_-_Cost_Proposal.xlsx

XLSX spreadsheet 49 KB Posted

Attached to
Food and Beverage Service Operations for the Alliant Energy Center of Dane County
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

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 SalesYear 2% of SalesYear 3% of SalesYear 4% of SalesYear 5% of SalesTotal% of Sales
Retail Food & N/A BeverageERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Retail AlcoholERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Catering Food & N/A BeverageERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Catering AlcoholERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Service ChargesERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
State Rate CateringERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
State Rate Service ChargesERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Gross Subcontractor SalesERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Revenue Split to SubcontractorsERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Net Subcontractor SalesERROR:#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 RateTier Structure #1Tier Structure #2Tier 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 SalesYear 2% of SalesYear 3% of SalesYear 4% of SalesYear 5% of SalesTotal% of Sales
Retail Foo & N/A BeverageERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Retail AlcoholERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Catering Food & N/A BeverageERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Catering AlcoholERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Service ChargesERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
State Rate CateringERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
State Rate Service ChargesERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Net Subcontractor SalesERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Total Commission Return0ERROR:#DIV/0!0ERROR:#DIV/0!0ERROR:#DIV/0!0ERROR:#DIV/0!0ERROR:#DIV/0!0ERROR:#DIV/0!
Alliant Energy Profit and Loss Model Investment OfferAlliant Energy Profit and Loss Model Pre-Opening ExpensesAlliant Energy Profit and Loss Model Other Investments, Funds, Grants, etc.
ItemValueYear(s) DisbursedItemValueItemValueFrequency

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 1Year 2Year 3Year 4Year 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 .