Food-Cost Leakage Audit of an All-Day-Dining Outlet: Standard vs Actual Cost with POS Sales Mix

This industrial-training project audits why the food-cost percentage of an all-day-dining (ADD) restaurant runs higher than its target, using the records every hotel already keeps. The study is done during the Semester 4 industrial training at a fictional 180-room city hotel, Hotel Saffron Crest, whose 110-cover ADD outlet serves breakfast buffet, à la carte lunch and dinner and 24-hour in-room dining.

The trainee compares the standard (potential) food cost — what the food should have cost if every plate followed its standard recipe card — with the actual food cost worked out from opening stock, purchases, stores issues and closing stock. The gap between the two is the leakage, and the project breaks it down into four sources: portioning and recipe deviation, wastage (preparation, spoilage, plate and buffet leftovers), unrecorded consumption (staff meals, complimentary items, transfers between outlets) and stock and pricing errors.

Data come from the outlet's POS sales-mix reports (item-wise covers sold), stores requisitions and issue slips, a four-week wastage log kept with the chef de partie, and recipe costing in Excel at current purchase prices. A menu-engineering matrix (Kasavana & Smith) classifies dishes as Stars, Plowhorses, Puzzles and Dogs, showing which high-selling dishes carry the most cost risk.

The output is a clear project report for BHA402: variance tables, a Pareto of leakage sources and practical recommendations — portion scoops, buffet batch cooking, a daily wastage sheet and re-pricing of two dishes.

Abstract

Food cost is the largest controllable cost of a hotel restaurant, and most outlets set a target food-cost percentage between roughly 28 and 35 percent of food revenue. When the actual percentage exceeds the target, managers often know the number but not the cause. This industrial-training project measures the gap between standard and actual food cost in an all-day-dining outlet over four weeks and attributes it to recipe deviation, wastage, unrecorded consumption and stock errors. POS sales-mix data, recipe costing, stores issues and a wastage log are combined in Excel. A menu-engineering analysis identifies dishes where popularity and cost risk overlap. The report ends with specific control measures.

Introduction

In an all-day-dining outlet, food flows through many hands: the storekeeper issues it, the commis prepares it, the buffet absorbs it and the steward clears what is left. Each step can leak cost. Food & beverage control theory separates potential food cost (sales × standard cost) from actual food cost (opening stock + purchases + transfers in − transfers out − staff meals − closing stock). The difference is the controllable variance.

Existing system at the outlet

• Monthly food-cost percentage is reported by the cost controller, but only as one number.
• Standard recipe cards exist for à la carte items, but several are out of date and none exist for buffet counters.
• Wastage is thrown away without recording; staff-meal transfers are estimated.
• Menu prices were last revised more than a year earlier despite rises in dairy and vegetable prices.

Proposed study

• Update recipe cards for the top 25 dishes and cost them at current purchase prices.
• Record wastage by category every shift for four weeks.
• Compute weekly potential vs actual food cost and the variance.
• Run menu engineering on POS sales-mix data.
• Recommend controls with an estimated monthly saving.

Feasibility

• Access: F&B manager and executive chef permit use of non-guest operational data for training reports.
• Time: four weeks of data collection fits within the 17–22-week industrial-training period.
• Tools: Excel only; POS and stores reports are standard outputs.

The all-day-dining outlet of Hotel Saffron Crest has reported a food-cost percentage several points above its budgeted target for three consecutive months, and the monthly cost report does not show where the difference arises. Recipe cards are partly outdated, buffet production is based on estimates, wastage is not recorded and staff-meal and inter-outlet transfers are approximate. Management therefore cannot tell whether the excess comes from over-portioning, wastage, pricing, unrecorded consumption or stock errors, and corrective actions are generic ("reduce wastage").

This project aims to quantify the gap between standard and actual food cost over four weeks, attribute it to specific leakage sources, identify which dishes contribute most through a menu-engineering analysis, and recommend practical, low-cost controls with an estimate of their monthly effect on the food-cost percentage.

In scope

• One all-day-dining outlet: breakfast buffet, à la carte lunch and dinner, and in-room dining food orders.
• Four consecutive weeks of POS sales-mix, stores issue, transfer and wastage data.
• Food cost only; beverage cost is excluded.
• Recipe costing, variance analysis, menu engineering and recommendations.

Out of scope

• Banquets and specialty restaurants (they use separate kitchens and stores).
• Purchasing negotiations and vendor selection.
• Labour cost and overheads.
• Any guest-identifiable information — only item-level sales counts are used.

Research design

A descriptive, record-based case study of one outlet, combining secondary operational records with primary observation and a wastage log.

Data sources

Calculations

• Potential food cost = Σ (quantity sold × standard cost per portion)
• Actual food cost = opening stock + issues + transfers in − transfers out − staff meals − closing stock
• Variance = actual − potential; food-cost % = cost ÷ food revenue × 100
• Menu engineering: contribution margin = selling price − food cost; popularity threshold = 70% of the average menu-mix share (Kasavana & Smith)

Timeline (6 weeks within industrial training)