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 - 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 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

00129753.9513000000000000109682.309000010451.068490249887.32879182001
38598.086100284280.57680464262.9828404766.0581987309.03594129326.92399108523.45073201182.2080672750.0714725478.766213246.0187722903.749376576.5696091163.009819612.1736561667.08096197628.7602964822.535952654098.058311930546
00342920.31020000000000000000000342920.3102310021
0194353.58400000000000000000000194353.584176390
0028589.9366104887.90760605471.4714737158.1802214764.13467251922.9381268673.11882280072.63433320410.7990242644.0090315243.038344928.134564864.85440153665.348455956.3559452542.63205672290.62864194436.047434558522.168983775308
770326.2262000000000000000000000770326.2262755033
000558841.435000000000000000000558841.435432834
00010678577.00470000000001884873.744150000000012563450.7488513345362
00000690199.30231805467.61233636865.921810560972.94125707196.02729210406.55226170008.6967102057045.3425100330263.1518426917.28620691.941360201128.513917417163.289576664299
00974.3866525.9284061.80000021669.6813300000574.164841126.82900090932.7835774573
0003749.591405407.98418897.391142342.192921907.66741910.648492779.929731777.92668397.2101328.24218709.016002003.4190947.31761668.558352011.234381170.4979436108.8275130572

WCU RFP #73-RFP-00775

WCU RFP #73-RFP-00775

2028-29

2028-20282028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292028-20292027 - 20282028-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 Revenue
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$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$9,901$63,517$203,558$66,767$2,733,721
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$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$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$6,135$54,119$692,459$200,269$4,695,278
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$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$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$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$27,725$21,313$0$207,162$7,639,678
Sales-OtherDepartment 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-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$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
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

(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 .