Attachment to Exhibit A WCU Finanical Submittal pro froma.xlsx
XLSX spreadsheet 40 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 submittal document prepared for Western Carolina University's dining services request for proposal (RFP #73-RFP-00775), detailing projected revenues and operating costs for the 2027-2028 and 2028-2029 fiscal years. The pro forma covers twenty-two dining and food service locations across WCU's campus in Cullowhee, North Carolina, including residential dining halls, quick-service restaurants, catering operations, vending services, and specialty concepts such as Starbucks, Chick-fil-A, Panda Express, and Einstein Bros Bagels. The document presents revenue projections organized by sales category, including retail food and beverage sales, catering revenue, meal plan board revenue, meal exchange transactions, and miscellaneous sales. For fiscal year 2027-2028, total net revenues are projected at $29,436,604.76, with an expected increase to $30,914,702.07 for 2028-2029.
The pro forma requires bidders to provide detailed cost of goods breakdowns by category (storeroom, meat, and groceries), comprehensive labor cost structures with staffing models for each concept, corporate overhead charges, and total operating expenses. The document includes line items for rebates that will credit against cost of goods totals and requests calculation of net product costs, total operating costs (combining cost of goods, labor, and expenses), and operating cost percentages relative to net revenues. The pro forma also establishes an excess or deficit analysis showing profitability projections for each fiscal year, with comparative data from the 2026-2027 baseline year provided for reference.
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
| 1.151 | 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 | 28,507,247.17 | ||||||||||||||||||||||||
| Storeroom | 3% increase from budget | |||||||||||||||||||||||||
| 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
WCU RFP #73-RFP-00775
WCU RFP #73-RFP-00775
2028-29
| ERROR:#REF! | 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 | 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 | 0 | ||||||||||||||||||||||||
| 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 | $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 | $93,898 | $9,901 | $63,517 | $203,558 | $66,767 | $2,827,619 | |
| 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 | $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 | $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 | $158,275 | $6,135 | $54,119 | $692,459 | $200,269 | $4,853,553 | |
| 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 | $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 | $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 | $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 | $340,171 | $27,725 | $21,313 | $0 | $207,162 | $7,979,849 | |
| 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 | $591 | $1,161 | $0 | $0 | $0 | $94,252 | |
| 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 | $2,064 | $49 | $689 | $2,072 | $1,206 | $39,256 | |
| 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 | $594,999.17 | $44,969.76 | $139,637.32 | $908,853.14 | $475,404.32 | $30,914,702.07 | ||
| 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
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 |
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 .