Food services

Eurest company restaurants, schools, daycare and municipalities: covers, spend, food cost, waste and guest feedback.

Group view shows the Eurest food data (food services sit entirely in Eurest).

FS1Covers per calendar day

3.8%

34,362

47,711 per business day (Mon-Fri) [gstCnt ?]

FS2Spend per cover [? derived]

0.1%

€8.75

[? derived; gstCnt often empty in staff restaurants]

FS3Food revenue

3.6%

€109.7M

Eurest anchor, €109,736,791

FS4Food cost %

1.0%

31.8%

Target 31.3% (assumption)

FS5Gross margin per cover

2.3%

€1.32

Anchor gross margin / covers

FS6Waste per cover

0.070 kg

waste_kg / gstCnt [? export]

FS7Waste % of purchases

9.3%

waste value / purchases (food cost as proxy)

FS8Participation rate

62.3%

Covers per day / site population (assumption)

FS9Happy index

77.6%

Share very happy + happy [? formula]

FS10Covers per day by segment

Weekly average of covers per day

School holidays in range (approx., assumption):All Saints break 25 Oct - 2 NovChristmas break 20 Dec - 4 JanCarnival break 14 Feb - 22 FebEaster break 28 Mar - 12 AprWhitsun break 16 May - 24 MaySummer break 16 Jul - 14 Sep

Source: Oracle MICROS Simphony · BI API getOperationsDailyTotals · locRef, busDt, gstCnt [?] (often empty or 1 per check at company restaurants)

FS11Food cost % by segment

Actual vs recipe cost vs target

Source: Apicbase · Recipes financial data (cost per portion ?), Stock periods, Deliveries · Simphony netSlsTtl

FS12Revenue per site

Net sales per site (locRef) with revenue center split; select a site for the drilldown


LU-EU-002	Corporate restaurants	€13,683,043	12.5%	1,234,932	€11.08	1,192,069
LU-EU-003	Corporate restaurants	€7,211,616	6.6%	630,386	€11.44	587,125
LU-EU-021	Corporate restaurants	€6,532,018	6.0%	601,475	€10.86	571,858
LU-EU-005	Corporate restaurants	€6,107,683	5.6%	511,103	€11.95	486,197
LU-EU-029	Schools	€5,765,775	5.3%	1,013,317	€5.69	1,013,317
LU-EU-019	Municipalities	€4,160,255	3.8%	539,592	€7.71	539,592
LU-EU-034	Daycare	€3,336,012	3.0%	739,692	€4.51	739,692
LU-EU-010	Corporate restaurants	€3,171,827	2.9%	292,874	€10.83	272,437
LU-EU-022	Corporate restaurants	€3,150,151	2.9%	300,014	€10.50	290,854
LU-EU-026	Schools	€3,145,548	2.9%	506,529	€6.21	506,529

40 sites, total €109,736,791

Source: Oracle MICROS Simphony · BI API getOperationsDailyTotals · locRef, rvcNum, netSlsTtl, gstCnt [?], chkCnt (rvcNum to name via EMC config [?])

FS13Food cost % per site vs target

Actual purchases vs Apicbase recipe cost; the gap is waste, over-portioning and price variance

23 on target10 watch (up to 1.5 pt over)7 over target

					Status
Restaurant DiekirchCorporate restaurants	35.2%	31.6%	32.0%	+3.2 pt	Over target
Kantine WasserbilligCorporate restaurants	34.8%	31.7%	32.0%	+2.8 pt	Over target
Restaurant SandweilerCorporate restaurants	34.1%	32.8%	32.0%	+2.1 pt	Over target
Restaurant GasperichCorporate restaurants	33.9%	30.5%	32.0%	+1.9 pt	Over target
Mess AcademyCorporate restaurants	33.8%	30.6%	32.0%	+1.8 pt	Over target
Restaurant Seniors DudelangeMunicipalities	32.8%	29.0%	31.0%	+1.8 pt	Over target
Restaurant MunsbachCorporate restaurants	33.7%	30.5%	32.0%	+1.7 pt	Over target
Cafe MuseeCorporate restaurants	33.4%	31.2%	32.0%	+1.4 pt	Watch
Restaurant HowaldCorporate restaurants	33.3%	30.6%	32.0%	+1.3 pt	Watch
Cantine Luxembourg-VilleSchools	31.1%	27.5%	30.0%	+1.1 pt	Watch

Source: Apicbase · Recipes financial data (cost per portion ?), Stock periods, Deliveries · Simphony getOperationsDailyTotals netSlsTtl, prepCostTtl (fill ?) · targets are assumptions

FS14Menu mix and margin per item

Top items by sales with margin (price minus recipe cost)


Daily menu meat1101 · Mains	2,366,673	€27,926,740	€11.80	€3.65	€19,284,737	69.1%
Vegetarian menu1103 · Mains	1,536,461	€15,671,898	€10.20	€2.72	€11,500,026	73.4%
Daily menu fish1102 · Mains	1,057,694	€13,115,408	€12.40	€4.21	€8,659,008	66.0%
Pasta of the day1104 · Mains	1,214,378	€11,536,590	€9.50	€2.06	€9,035,161	78.3%
Grill station1105 · Mains	645,275	€8,775,734	€13.60	€4.96	€5,573,656	63.5%
Burger and fries1106 · Mains	622,685	€8,032,634	€12.90	€3.84	€5,642,272	70.2%
Kids menu1301 · Mains	826,858	€5,126,521	€6.20	€1.78	€3,655,577	71.3%
Salad bar (per 100 g)1201 · Salad and soup	978,763	€4,795,937	€4.90	€1.40	€3,421,325	71.3%
Sandwich and wrap1401 · Grab and go	676,454	€4,329,308	€6.40	€1.97	€2,999,254	69.3%
Dessert1501 · Dessert and fruit	685,475	€2,604,807	€3.80	€0.94	€1,963,001	75.4%
Soup of the day1202 · Salad and soup	644,138	€2,318,896	€3.60	€0.66	€1,896,725	81.8%
Meal on wheels1302 · Mains	189,563	€1,781,892	€9.40	€2.90	€1,231,684	69.1%
Coffee and tea1601 · Beverages	789,055	€1,657,015	€2.10	€0.33	€1,398,440	84.4%
Fruit and yoghurt1502 · Dessert and fruit	437,755	€1,050,611	€2.40	€0.84	€681,731	64.9%
Soft drink and water1602 · Beverages	389,539	€1,012,800	€2.60	€0.70	€739,259	73.0%

Total €109,736,791 sales, margin before labour €77,681,857 (70.8%). Item split is an assumption.

Source: Simphony · BI API getMenuItemDailyTotals · miNum, slsCnt, slsTtl, dscTtl, prepCost · Apicbase recipe cost per portion (mapping miNum to recipe ?)

FS15Waste by stage

Pre-consumer vs plate waste

Preparation trimmings (Pre-consumer)14.2%
Overproduction (prepared, not served) (Pre-consumer)24.3%
Spoilage and expired (Pre-consumer)8.1%
Plate waste (Plate)53.3%

Source: Winnow / Leanpath · export, no public API [?] · site, weight_kg, waste_stage [?], date

FS16Waste by category

878,813 kg, €3,254,245 in the period

Vegetables

Starch (rice, pasta, potato)

Meat

Salad

Other

Bread and bakery

Dairy and dessert

Fish

193,339 kg

166,974 kg

123,034 kg

96,669 kg

79,093 kg

70,305 kg

52,729 kg

Source: Winnow / Leanpath export [?] · category / food_type [?], weight_kg, value (cost) [?]

FS17Waste per cover trend

Grams per cover, pre-consumer vs plate

Source: Winnow / Leanpath export [?] · weight_kg, waste_stage [?] / Simphony gstCnt [?]

FS18Daypart and hour profile

Average weekday covers per hour, peak at 12:00 (about 17,293 covers)

Covers per weekday by daypart

Lunch (10:00-14:00)

Afternoon (14:00-18:00)

Breakfast (before 10:00)

Evening (18:00+)

39,142

5,159

3,293

116

Source: Simphony · BI API getGuestChecks · opnUTC, clsdUTC (UTC to local time), gstCnt [?], chkTtl · hour split is an assumption

FS19HappyOrNot feedback per site

244,634 responses, happy index 77.6%

Very happy: 99,565 (40.7%)Happy: 90,350 (36.9%)Unhappy: 34,841 (14.2%)Very unhappy: 19,878 (8.1%)

		VH / H / U / VU		Flag
Cantine Wiltz	3,474	1094 / 1393 / 566 / 421	71.6%	Low
Cantine Luxembourg-Ville	12,918	4293 / 4960 / 2344 / 1321	71.6%	Low
University restaurant Belval	36,770	13509 / 13003 / 6610 / 3648	72.1%	Watch
Cantine Esch	8,138	2759 / 3129 / 1370 / 880	72.4%	Watch
Cantine Ettelbruck	9,761	3337 / 3759 / 1553 / 1112	72.7%	Watch
Cantine Mamer	4,089	1446 / 1569 / 602 / 472	73.7%	Watch
Kantine Grevenmacher	4,277	1639 / 1550 / 646 / 442	74.6%	Watch
Canteen Walferdange	11,026	4139 / 4140 / 1737 / 1010	75.1%	Watch
Restaurant Gasperich	6,623	2885 / 2262 / 936 / 540	77.7%	Watch
Kantine Differdange	3,958	1612 / 1489 / 582 / 275	78.3%	Watch

Source: HappyOrNot API v2 · /smileys (id, label, value 1-4), feedback (timestamp, smiley_id, experience_point_id) [? paths] · happy index formula is client specific [?]

Demo with sample data. Not company figures.