Proforma_Instruction_Guide_3.2.26.docx
DOCX document 29 KB Posted
- Attached to
- Food & Beverage Concessions
- Solicitation number
- 26-021-RFP Conc
- Issued by
- Kenton County, Kentucky
About this file
This is a Proforma Instruction and Reference Guide for Food & Beverage Concessions proposals submitted to the Kenton County Airport Board (KCAB) for operations at Cincinnati/Northern Kentucky International Airport (CVG). The guide outlines a standardized financial modeling template that all bidders must use to project their business performance. A pre-proposal site visit is scheduled for Tuesday, April 21, 2026 at 9:00 am at CVG Main Terminal's Ticketing Level, with RSVP required by March 25, 2026. Written questions regarding the opportunity are due by 11:59 pm on Thursday, May 14, 2026, with answers to be posted by 11:59 pm on Thursday, May 21, 2026. Proposals must be submitted by Thursday, June 25, 2026 at 11:59 pm through KCAB's online bidding system at https://procurement.opengov.com/portal/cvgairport, with no late submissions accepted unless extended by addendum.
The proforma template requires bidders to submit financial projections based on pre-filled airport enplanement data (total projected annual passengers) and an assumed 2% year-over-year growth rate. Bidders must input user-defined values including capture rate percentage, average check amount, cost of goods sold, wage projections (management/salaried and hourly employee), benefits, payroll taxes, utilities, royalties and advertising fees, insurance, repairs and maintenance, rent, general administrative expenses, and interest or depreciation and amortization. The template automatically calculates gross sales, gross profit, total wages, total expenses, EBITDA, and net profit. A mandatory 0.5% marketing fund is automatically calculated from gross sales to support joint promotional and branding initiatives benefiting all CVG concessionaires. This standardized approach ensures consistency across all submissions and facilitates clear performance comparison among bidders.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Food_&_Beverage_Concessions.pdf | ||
| Proposed_Agreement_-_Food_&_Beverage_Concession.pdf | ||
| 2026.03.24_RFP_Release_Technical_Design_Criteria_Manual.docx | DOCX document | |
| PROTECTED_CVG_ProForma_Template_BLANK_3.2.26.xlsx | XLSX spreadsheet | |
| 2025_Airline_Rankings.xlsx | XLSX spreadsheet | |
| 2025_Monthly_Enplanements.xlsx | XLSX spreadsheet | |
| Condition_Assessment_Summary.pdf | ||
| Condition_Assessment_-_A-004.pdf | ||
| Condition_Assessment_-_A-031.pdf | ||
| KCAB_-_RSVP_Instructional_Guide_for_OpenGov.pdf | ||
| Condition_Assessment_-_A-015.pdf | ||
| LOD_A-015.pdf | ||
| LOD_A-004.pdf | ||
| LOD_A-031.pdf | ||
| CVG_Flight_Schedule_Summary_2025_06.30_-_07.06.pdf | ||
| XX-XXRFP_Food_&_Beverage_Multi_Unit_Concessions_4.24.25_DRAFT.docx | DOCX document | |
| 2024_Monthly_Enplanements.xlsx | XLSX spreadsheet | |
| 2024_Airline_Rankings.xlsx | XLSX spreadsheet |
Show all 18
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
Proforma Instruction & Reference Guide REMINDER: Only input values in yellow-highlighted cells. All other cells calculate automatically. This ensures consistency across submissions and allows for clear performance comparison.
1. Airport Overall Enplanements
· Pre-filled: Total projected annual passengers departing from the airport. This is based on airport forecasts and should not be changed.
2. YOY Increase
· Pre-filled: Assumed annual percentage growth in enplanements, set at 2% per year.
3. Capture Rate (%):
· User Input: Enter the percentage of total enplanements you expect to capture as customers (e.g., 3%). The capture rate should be entered as a whole number, not a decimal. For example, enter 33% instead of 0.33%.
4. Capture Enplanements:
· Auto-calculated: Airport Overall Enplanements × Capture Rate
5. Average Check:
· User Input: Enter your projected average transaction amount per customer (e.g., $8.50).
6. Sales per Enplanement:
· Auto-calculated: Gross Sales / Enplanements
7. Gross Sales:
· Auto-calculated: Capture Enplanements × Average Check
8. Cost of Goods Sold (COGS)
· User Input: Enter total annual cost of goods sold for your business (e.g., food/beverage/retail costs).
9. Gross Profit:
· Auto-calculated: Gross Sales – COGS
10. Management/Admin Wages:
· User Input: Enter projected annual wages for salaried staff.
11. Employee Wages:
· User Input: Enter projected annual wages for hourly staff.
12. Benefits:
· User Input: Annual cost of healthcare, PTO, etc.
13. Taxes:
· User Input: Payroll tax estimate.
14. Total Wages:
· Auto-calculated: Sum of all wage-related line items
15. Utilities
· User Input:
16. Royalties/Advertising (e.g., brand fees, marketing fund)
· User Input:
17. Insurance
· User Input:
18. Repairs/Maintenance
· User Input:
19. Rent
· User Input:
20. General Administrative (office supplies, tech systems, etc.)
· User Input:
21. Other Direct Expenses
· User Input:
22. Sub-Total:
· Auto-calculated: Sum of all other operating expenses
23. Total Expenses:
· Auto-calculated: Total Wages + Sub-Total
24. EBITDA:
· Auto-calculated: Gross Profit – Total Wages
25. Interest, Depreciation & Amortization:
· User Input: If applicable (e.g., for loan or asset depreciation).
26. Marketing Fund:
· Auto-calculated: The Marketing Fund is calculated as 0.5% of Gross Sales and is designed to support joint promotional, advertising, and branding initiatives that benefit all concessionaires at CVG.
27. Net Profit:
· Auto-calculated: EBITDA – Interest/Depreciation/Amortization – Airport Contingency Fund – Marketing Fund
File details come from the government source that posted it. Updated .