Attachment to Exhibit A WCU Finanical Submittal pro froma REV #3 10526.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- WCU Dining Services
- Solicitation number
- 73-RFP-00775
- Issued by
- Jackson County, North Carolina
About this file
This is a financial pro forma submission document for Western Carolina University's comprehensive dining services contract (RFP 73-RFP-00775). The document provides detailed revenue projections and operational cost breakdowns for the 2027-2028 and 2028-2029 fiscal years across 22 dining service locations and concepts, including two residential dining halls, 16 retail venues featuring branded concepts such as Chick-fil-A, Starbucks, Panda Express, and Einstein Bros Bagels, catering services, athletic concessions, and vending operations. The pro forma includes line-item revenue categories encompassing retail food and beverage sales, alcoholic beverages, board meal revenue, meal exchanges, catering for campus events and summer conferences, and departmental catering. For 2027-2028, total projected net revenues are $29,436,604.76, representing an increase from the prior year's $27,676,939.00, with projected 2028-2029 revenues of $30,319,702.90. The bidder is required to provide itemized cost of goods calculations broken down by storeroom, meat, and groceries categories; detailed labor cost breakdowns by position and category; and comprehensive operating expense summaries.
The pro forma template mandates submission of complete cost assumptions including average check amounts and transaction counts for each concept, identification of all labor staffing models by category, itemization of operating expenses, and calculation of the total operating cost percentage relative to net revenues. The contractor must achieve an operating cost ceiling of 80.9% of estimated revenues under the Annual Guaranteed Maximum Percentage (AGMP) model, with the contractor's compensation comprising a fixed management fee, variable fees tied to key performance indicators, and potential incentive fees. The document indicates that cost of goods, labor, and expenses must be fully documented to establish the operating profit or deficit for each fiscal year, with rebates from designated distributors credited against product costs. This financial submittal represents the bidder's detailed operational assumptions and projections required to demonstrate financial viability and compliance with the University's pricing and performance parameters for the new five-year contract commencing July 1, 2027, with options for two additional five-year renewal terms.
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
2027-28
| 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2027 - 2028 | 2026 - 2027 | ||
| WCU | |||||||||||||||||||||||||
| Catering | WCU | ||||||||||||||||||||||||
| Vending | WCU | ||||||||||||||||||||||||
| Contract Athletic Concessions | WCU | ||||||||||||||||||||||||
| Café CY Residential | WCU | ||||||||||||||||||||||||
| Food Court Admin | WCU | ||||||||||||||||||||||||
| Starbucks at Courtyard | WCU | ||||||||||||||||||||||||
| Chick-fil-A | WCU | ||||||||||||||||||||||||
| Freshens | WCU |
Bellasui (Third Party Operator) WCU Moes Southwest
| Grill | WCU |
| Panda Express | WCU |
| Papa Johns | WCU |
| Which Which | WCU |
| Brown Dining Hall Residential | WCU |
| Blue Ridge Burger/1889 Bistro | WCU |
| TownHouse Restaurant | WCU |
| TownHouse Tap House | WCU |
| Einstein Bros Bagels | WCU |
| Food Truck | WCU |
| HHS | WCU |
| Noble C store | WCU |
Starbucks
| at Brown | Total Revenue | Budget | ||||||||||||||||||||||||
| Retail Sales - Alcoholic Beverages | Alcohol | $ - 0 | $ - 0 | $ 129,754 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 109,682 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 10,451 | $ - 0 | $ 249,887 | $ 182,001 | |
| Retail Sales - Food | Other | $ 38,598 | $ - 0 | $ - 0 | $ 284,281 | $ - 0 | $ 464,263 | $ 404,766 | $ 87,309 | $ 129,327 | $ 108,523 | $ 201,182 | $ 72,750 | $ 25,479 | $ 13,246 | $ 22,904 | $ 376,577 | $ - 0 | $ 91,163 | $ 9,612 | $ 61,667 | $ 197,629 | $ 64,823 | $ 2,654,098 | $ 1,930,546 | |
| Sales - Catering Food and Beverage | Concessions | $ - 0 | $ - 0 | $ 342,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 342,920 | $ 310,021 | |
| Sales-Other | Vending | $ - 0 | $ 194,354 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 194,354 | $ 176,390 | |
| Retail Sales - Food | DB | $ - 0 | $ - 0 | $ 28,590 | $ 104,888 | $ - 0 | $ 605,471 | $ 737,158 | $ 214,764 | $ 251,923 | $ 268,673 | $ 280,073 | $ 320,411 | $ 42,644 | $ 15,243 | $ 44,928 | $ 564,865 | $ - 0 | $ 153,665 | $ 5,956 | $ 52,543 | $ 672,291 | $ 194,436 | $ 4,558,522 | $ 3,775,308 | |
| Sales - Catering Food and Beverage | Campus Catering | $ 770,326 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 770,326 | $ 755,033 | |
| Sales - Catering Food and Beverage | Summer Camps Conf | $ - 0 | $ - 0 | $ - 0 | $ 558,841 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 558,841 | $ 432,834 | |
| Sales - Meals | Board Revenue | $ - 0 | $ - 0 | $ - 0 | $ 10,678,577 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 1,884,874 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 12,563,451 | $ 13,345,362 | |
| Sales - Meals | Meal Exchange | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 690,199 | $ 1,805,468 | $ 636,866 | $ - 0 | $ 560,973 | $ 707,196 | $ 210,407 | $ 170,009 | $ - 0 | $ 2,057,045 | $ - 0 | $ - 0 | $ 330,263 | $ 26,917 | $ 20,692 | $ - 0 | $ 201,129 | $ 7,417,163 | $ 6,664,299 | |
| Sales-Other | Department Catering | $ - 0 | $ - 0 | $ 974 | $ 66,526 | $ - 0 | $ 62 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 21,670 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 574 | $ 1,127 | $ - 0 | $ - 0 | $ - 0 | $ 90,933 | $ 74,573 | |
| Sales-Other | CatCash | $ - 0 | $ - 0 | $ - 0 | $ 3,750 | $ - 0 | $ 5,408 | $ 8,897 | $ 2,342 | $ 1,908 | $ 1,911 | $ 2,780 | $ 1,778 | $ 397 | $ 328 | $ 709 | $ - 0 | $ - 0 | $ 2,003 | $ 47 | $ 669 | $ 2,011 | $ 1,170 | $ 36,109 | $ 30,572 | |
| Total Net Revenues | $808,924.31 | $194,353.58 | 502,238.58 | $11,696,862.44 | $0.00 | $1,765,403.54 | $2,956,289.24 | $941,281.29 | $383,157.53 | $940,080.16 | $1,191,230.80 | $627,015.03 | $238,528.68 | $1,913,691.04 | $2,125,586.24 | $1,051,123.73 | $0.00 | $577,669.09 | $43,659.96 | $135,570.21 | $882,381.69 | $461,557.60 | $29,436,604.76 | $27,676,939.00 | ||
| Cost of Goods breakdown by Category, you may add additional Rows. | note: Tap house sales are include in Restaurant | |||||||||||||||||||||||||
| Storeroom | ||||||||||||||||||||||||||
| Meat | ||||||||||||||||||||||||||
| Groceries |
| Cost of Goods - Total |
| Rebates , this will be a negative that will credit the costs of goods total |
| Net Product Cost |
(Cost of Goods - Rebate credit) Provide in detail all of the costs that establish the total labor.
| Labor - Total |
| Breakdown by Category, you may add additional Rows. Indicate any Corporate Overhead charges |
Expenses - Total
Total Operating Costs (COG, Labor & Expenses)
Excess / Deficit (Revenues - Total Operating costs)
Operating costs percentage to Net Revenues
| 0 | 0 | 129753.9513 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 109682.309 | 0 | 0 | 0 | 0 | 10451.06849 | 0 | 249887.32879 | 182001 |
| 38598.0861 | 0 | 0 | 284280.5768 | 0 | 464262.9828 | 404766.05819 | 87309.03594 | 129326.92399 | 108523.45073 | 201182.20806 | 72750.07147 | 25478.7662 | 13246.01877 | 22903.749 | 376576.5696 | 0 | 91163.00981 | 9612.17365 | 61667.08096 | 197628.76029 | 64822.53595 | 2654098.05831 | 1930546 |
| 0 | 0 | 342920.3102 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 342920.3102 | 310021 |
| 0 | 194353.584 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 194353.584 | 176390 |
| 0 | 0 | 28589.9366 | 104887.9076 | 0 | 605471.4714 | 737158.1802 | 214764.13467 | 251922.9381 | 268673.11882 | 280072.63433 | 320410.79902 | 42644.00903 | 15243.0383 | 44928.134 | 564864.8544 | 0 | 153665.34845 | 5956.35594 | 52542.63205 | 672290.62864 | 194436.04743 | 4558522.16898 | 3775308 |
| 770326.2262 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 770326.2262 | 755033 |
| 0 | 0 | 0 | 558841.435 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 558841.435 | 432834 |
| 0 | 0 | 0 | 10678577.0047 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1884873.74415 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12563450.74885 | 13345362 |
| 0 | 0 | 0 | 0 | 0 | 690199.3023 | 1805467.61233 | 636865.92181 | 0 | 560972.94125 | 707196.02729 | 210406.55226 | 170008.69671 | 0 | 2057045.34251 | 0 | 0 | 330263.15184 | 26917.286 | 20691.94136 | 0 | 201128.51391 | 7417163.28957 | 6664299 |
| 0 | 0 | 974.38 | 66525.9284 | 0 | 61.8 | 0 | 0 | 0 | 0 | 0 | 21669.68133 | 0 | 0 | 0 | 0 | 0 | 574.16484 | 1126.829 | 0 | 0 | 0 | 90932.78357 | 74573 |
| 0 | 0 | 0 | 3749.5914 | 0 | 5407.9841 | 8897.39114 | 2342.19292 | 1907.6674 | 1910.64849 | 2779.92973 | 1777.92668 | 397.2101 | 328.24218 | 709.016 | 0 | 0 | 2003.41909 | 47.31761 | 668.55835 | 2011.23438 | 1170.49794 | 36108.82751 | 30572 |
WCU RFP #73-RFP-00775
WCU RFP #73-RFP-00775
2028-29
| 2028-2028 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2027 - 2028 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | 2028-2029 | ||
| WCU | ||||||||||||||||||||||||
| Catering | WCU | |||||||||||||||||||||||
| Vending | WCU | |||||||||||||||||||||||
| Contract Athletic Concessions | WCU | |||||||||||||||||||||||
| Café CY Residential | WCU | |||||||||||||||||||||||
| Food Court Admin | WCU | |||||||||||||||||||||||
| Starbucks at Courtyard | WCU | |||||||||||||||||||||||
| Chick-fil-A | WCU | |||||||||||||||||||||||
| Freshens | WCU |
Bellasui (Third Party Operator) WCU Moes Southwest
| Grill | WCU |
| Panda Express | WCU |
| Papa Johns | WCU |
| Which Which | WCU |
| Brown Dining Hall Residential | WCU |
| Blue Ridge Burger/1889 Bistro | WCU |
| TownHouse Restaurant | WCU |
| TownHouse Tap House | WCU |
| Einstein Bros Bagels | WCU |
| Food Truck | WCU |
| HHS | WCU |
| Noble C store | WCU |
Starbucks
| at Brown | Total Revenue | ||||||||||||||||||||||||
| Retail Sales - Alcoholic Beverages | Miscellaneous | $0 | $0 | $133,647 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $112,973 | $0 | $0 | $0 | $0 | $10,765 | $0 | $257,384 | |
| Retail Sales - Food | Other | $39,756 | $0 | $0 | $292,809 | $0 | $478,191 | $416,909 | $89,928 | $133,207 | $111,779 | $207,218 | $74,933 | $26,243 | $13,643 | $23,591 | $387,874 | $0 | $93,898 | $9,901 | $63,517 | $203,558 | $66,767 | $2,733,721 | |
| Sales - Catering Food and Beverage | Concessions | $0 | $0 | $353,208 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $353,208 | |
| Sales-Other | Vending | $0 | $200,184 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $200,184 | |
| Retail Sales - Food | DB | $0 | $0 | $29,448 | $108,035 | $0 | $623,636 | $759,273 | $221,207 | $259,481 | $276,733 | $288,475 | $330,023 | $43,923 | $15,700 | $46,276 | $581,811 | $0 | $158,275 | $6,135 | $54,119 | $692,459 | $200,269 | $4,695,278 | |
| Sales - Catering Food and Beverage | Campus Catering | $793,436 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $793,436 | |
| Sales - Catering Food and Beverage | Summer Camps Conf | $0 | $0 | $0 | $575,607 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $575,607 | |
| Sales - Meals | Board Revenue | $0 | $0 | $0 | $10,998,934 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,941,420 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $12,940,354 | |
| Sales - Meals | Meal Exchange | $0 | $0 | $0 | $0 | $0 | $710,905 | $1,859,632 | $655,972 | $0 | $577,802 | $728,412 | $216,719 | $175,109 | $0 | $2,118,757 | $0 | $0 | $340,171 | $27,725 | $21,313 | $0 | $207,162 | $7,639,678 | |
| Sales-Other | Department Catering | $0 | $0 | $1,004 | $68,522 | $0 | $64 | $0 | $0 | $0 | $0 | $0 | $22,320 | $0 | $0 | $0 | $0 | $0 | $591 | $1,161 | $0 | $0 | $0 | $93,661 | |
| Sales-Other | CatCash | $0 | $0 | $0 | $3,862 | $0 | $5,570 | $9,164 | $2,412 | $1,965 | $1,968 | $2,863 | $1,831 | $409 | $338 | $730 | $0 | $0 | $2,064 | $49 | $689 | $2,072 | $1,206 | $37,192 | |
| Total Net Revenues | $833,192.04 | $200,184.19 | $517,305.74 | $12,047,768.32 | $0.00 | $1,818,365.65 | $3,044,977.92 | $969,519.72 | $394,652.26 | $968,282.56 | $1,226,967.72 | $645,825.48 | $245,684.54 | $1,971,101.77 | $2,189,353.83 | $1,082,657.44 | $0.00 | $594,999.17 | $44,969.76 | $139,637.32 | $908,853.14 | $475,404.32 | $30,319,702.90 | ||
| Cost of Goods breakdown by Category, you may add additional Rows. | |||||||||||||||||||||||||
| Storeroom | |||||||||||||||||||||||||
| Meat | |||||||||||||||||||||||||
| Groceries |
| Cost of Goods - Total |
| Rebates , this will be a negative that will credit the costs of goods total |
| Net Product Cost |
Provide in detail all of the costs that establish the total labor.
| Labor - Total |
| Breakdown by Category, you may add additional Rows. Indicate any Corporate Overhead charges |
Expenses - Total
Total Operating Costs (COG, Labor & Expenses)
Excess / Deficit (Revenues - Total Operating costs)
Operating costs percentage to Net Revenues
WCU RFP # 73-RFP-00775
WCU RFP # 73-RFP-00775
New Concepts
| NEW CONCEPTS PRO FORMA | |
| Instructions - For each concept provide the following information below each concept | |
| 1 | Revenue Expense Assumptions (average check , transaction counts) |
| 2 | Cost of Goods |
| 3 | Labor staffing model |
| 4 | Operating Expenses |
| Name of Concept | Name of Concept | Name of Concept | |||
| Retail Sales - Alcoholic Beverages | Miscellaneous | Retail Sales - Alcoholic Beverages | Miscellaneous | Retail Sales - Alcoholic Beverages | Miscellaneous |
| Retail Sales - Food | Other | Retail Sales - Food | Other | Retail Sales - Food | Other |
| Sales - Catering Food and Beverage | Concessions | Sales - Catering Food and Beverage | Concessions | Sales - Catering Food and Beverage | Concessions |
| Sales-Other | Vending | Sales-Other | Vending | Sales-Other | Vending |
| Retail Sales - Food | DB | Retail Sales - Food | DB | Retail Sales - Food | DB |
| Sales - Catering Food and Beverage | Campus Catering | Sales - Catering Food and Beverage | Campus Catering | Sales - Catering Food and Beverage | Campus Catering |
| Sales - Catering Food and Beverage | Summer Camps Conf | Sales - Catering Food and Beverage | Summer Camps Conf | Sales - Catering Food and Beverage | Summer Camps Conf |
| Sales - Meals | Board Revenue | Sales - Meals | Board Revenue | Sales - Meals | Board Revenue |
| Sales - Meals | Meal Exchange | Sales - Meals | Meal Exchange | Sales - Meals | Meal Exchange |
| Sales-Other | Department Catering | Sales-Other | Department Catering | Sales-Other | Department Catering |
| Sales-Other | CatCash | Sales-Other | CatCash | Sales-Other | CatCash |
| Total Net Sales | Total Net Sales | Total Net Sales | |||
| Cost of Goods breakdown by Category, you may add additional Rows. | Cost of Goods breakdown by Category, you may add additional Rows. | Cost of Goods breakdown by Category, you may add additional Rows. | |||
| Storeroom | Storeroom | Storeroom | |||
| Meat | Meat | Meat | |||
| Groceries | Groceries | Groceries |
| Cost of Goods - Total | Cost of Goods - Total | Cost of Goods - Total | ||
| Rebates , this will be a negative that will credit the costs of goods total | Rebates , this will be a negative that will credit the costs of goods total | Rebates , this will be a negative that will credit the costs of goods total | ||
| Net Product Cost (Cost of Goods - | ||||
| Rebate credit) | Net Product Cost | |||
| (Cost of Goods - Rebate credit) | Net Product Cost |
Provide in detail all of the costs that establish the total labor. Provide in detail all of the costs that establish the total labor. Provide in detail all of the costs that establish the total labor.
| Labor - Total | Labor - Total | Labor - Total |
| Breakdown by Category, you may add additional Rows. Indicate any Corporate Overhead charges | Breakdown by Category, you may add additional Rows. Indicate any Corporate Overhead charges | Breakdown by Category, you may add additional Rows. Indicate any Corporate Overhead charges |
| Expenses - Total | Expenses - Total | Expenses - Total | ||
| Total Operating Costs | ||||
| (COG, Labor & Expenses) | Total Operating Costs | |||
| (COG, Labor & Expenses) | Total Operating Costs |
(COG, Labor & Expenses)
| Excess / Deficit | ||
| (Revenues - Total Operating costs) | Excess / Deficit | |
| (Revenues - Total Operating costs) | Excess / Deficit |
(Revenues - Total Operating costs) Operating costs percentage to Net Revenues Operating costs percentage to Net Revenues Operating costs percentage to Net Revenues
WCU RFP # 73-RFP-00775
WCU RFP # 73-RFP-00775
File details come from the government source that posted it. Updated .