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.1512027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282027 - 20282026 - 2027
WCU
CateringWCU
VendingWCU
Contract Athletic ConcessionsWCU
Café CY ResidentialWCU
Food Court AdminWCU
Starbucks at CourtyardWCU
Chick-fil-AWCU
FreshensWCU

Bellasui (Third Party Operator) WCU Moes Southwest

GrillWCU
Panda ExpressWCU
Papa JohnsWCU
Which WhichWCU
Brown Dining Hall ResidentialWCU
Blue Ridge Burger/1889 BistroWCU
TownHouse RestaurantWCU
TownHouse Tap HouseWCU
Einstein Bros BagelsWCU
Food TruckWCU
HHSWCU
Noble C storeWCU

Starbucks

at BrownTotal RevenueBudget
Retail Sales - Alcoholic BeveragesAlcohol$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 - FoodOther$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 BeverageConcessions$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-OtherVending$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 - FoodDB$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 BeverageCampus 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 BeverageSummer 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 - MealsBoard 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 - MealsMeal 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-OtherDepartment 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-OtherCatCash$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.58502,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 Restaurant28,507,247.17
Storeroom3% 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-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292027 - 20282028-20292028-20292028-20292028-20292028-20292028-20292028-2029
WCU
CateringWCU
VendingWCU
Contract Athletic ConcessionsWCU
Café CY ResidentialWCU
Food Court AdminWCU
Starbucks at CourtyardWCU
Chick-fil-AWCU
FreshensWCU

Bellasui (Third Party Operator) WCU Moes Southwest

GrillWCU
Panda ExpressWCU
Papa JohnsWCU
Which WhichWCU
Brown Dining Hall ResidentialWCU
Blue Ridge Burger/1889 BistroWCU
TownHouse RestaurantWCU
TownHouse Tap HouseWCU
Einstein Bros BagelsWCU
Food TruckWCU
HHSWCU
Noble C storeWCU

Starbucks

at BrownTotal Revenue0
Retail Sales - Alcoholic BeveragesMiscellaneous$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 - FoodOther$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 BeverageConcessions$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-OtherVending$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 - FoodDB$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 BeverageCampus 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 BeverageSummer 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 - MealsBoard 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 - MealsMeal 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-OtherDepartment 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-OtherCatCash$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
1Revenue Expense Assumptions (average check , transaction counts)
2Cost of Goods
3Labor staffing model
4Operating Expenses
Name of ConceptName of ConceptName of Concept
Retail Sales - Alcoholic BeveragesMiscellaneousRetail Sales - Alcoholic BeveragesMiscellaneousRetail Sales - Alcoholic BeveragesMiscellaneous
Retail Sales - FoodOtherRetail Sales - FoodOtherRetail Sales - FoodOther
Sales - Catering Food and BeverageConcessionsSales - Catering Food and BeverageConcessionsSales - Catering Food and BeverageConcessions
Sales-OtherVendingSales-OtherVendingSales-OtherVending
Retail Sales - FoodDBRetail Sales - FoodDBRetail Sales - FoodDB
Sales - Catering Food and BeverageCampus CateringSales - Catering Food and BeverageCampus CateringSales - Catering Food and BeverageCampus Catering
Sales - Catering Food and BeverageSummer Camps ConfSales - Catering Food and BeverageSummer Camps ConfSales - Catering Food and BeverageSummer Camps Conf
Sales - MealsBoard RevenueSales - MealsBoard RevenueSales - MealsBoard Revenue
Sales - MealsMeal ExchangeSales - MealsMeal ExchangeSales - MealsMeal Exchange
Sales-OtherDepartment CateringSales-OtherDepartment CateringSales-OtherDepartment Catering
Sales-OtherCatCashSales-OtherCatCashSales-OtherCatCash
Total Net SalesTotal Net SalesTotal 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.
StoreroomStoreroomStoreroom
MeatMeatMeat
GroceriesGroceriesGroceries
Cost of Goods - TotalCost of Goods - TotalCost of Goods - Total
Rebates , this will be a negative that will credit the costs of goods totalRebates , this will be a negative that will credit the costs of goods totalRebates , 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 - TotalLabor - TotalLabor - Total
Breakdown by Category, you may add additional Rows. Indicate any Corporate Overhead chargesBreakdown by Category, you may add additional Rows. Indicate any Corporate Overhead chargesBreakdown by Category, you may add additional Rows. Indicate any Corporate Overhead charges
Expenses - TotalExpenses - TotalExpenses - 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 .