Integrated Cost-Control Simulation: Full-Week Scenario Analysis and Corrective Action

Why an Integrated Simulation Matters

Running a profitable restaurant requires more than knowing one formula. Food cost, labor cost, yield, and cost of goods sold (COGS) are interconnected. A problem in one area almost always shows up in another. This lab pulls every cost-control skill together into a single realistic week so you can practice the full management cycle: measure, compare, diagnose, and act.

The Four Core Metrics You Will Calculate

Food Cost Percentage tells you what share of food sales was spent buying the food that was sold.

> Food Cost % = (Cost of Food Sold ÷ Food Sales) × 100

Cost of Food Sold is calculated from your inventory records: Beginning Inventory + Purchases − Ending Inventory.

Labor Cost Percentage tells you what share of total sales went to paying your team.

> Labor Cost % = (Total Labor Cost ÷ Total Sales) × 100

Total labor cost includes wages, salaries, and any payroll taxes or benefits tracked on the time cards.

COGS (Cost of Goods Sold) is the dollar value of all food and beverage used to generate sales during the period. It is the numerator in the food cost percentage formula.

Yield Percentage measures how much usable product you get from a raw ingredient after trimming, cooking loss, or portioning.

> Yield % = (Usable Weight ÷ As-Purchased Weight) × 100

Yield percentage feeds directly into your standard recipe cost card. If actual yield falls below the standard, your cost per portion rises even if you paid the same invoice price.

Reading the Simulation Packet

Your packet contains one week of real-world documents. Treat each document as a primary source:

• Sales reports give you total food sales and beverage sales by day and by meal period.
• Purchase invoices show what was ordered and what was paid. Check the unit and the price against your recipe cost card.
• Inventory sheets provide beginning and ending counts in both units and dollar values.
• Time cards list each employee's hours and pay rate. Multiply hours by rate, then sum all employees to get total labor cost.
• Recipe cost card states the standard cost per portion and the standard yield for a specified item.

Work through the documents in order: sales → inventory → invoices → time cards → recipe card. This sequence lets you build each number on a confirmed foundation before moving to the next calculation.

Variance Analysis: Finding the Problems

Once every metric is calculated, compare each result to the target range provided. A variance is any metric that falls outside that range.

For each variance, your form asks for four things:

1. Actual figure — what you calculated.

2. Target figure — the standard or benchmark.

3. Dollar and percentage-point variance — how far off, expressed both ways.

4. Probable cause — a specific, evidence-based explanation drawn from the documents in front of you.

Probable causes must be grounded in the data. "Food cost is 4 points over target because the Tuesday beef invoice shows a price increase of $0.40/lb and no corresponding menu price adjustment was made" is a strong cause. "Something went wrong" is not.

Common causes to look for: invoice price spikes, over-ordering leading to spoilage, portioning errors (recipe yield lower than standard), scheduling inefficiency (overtime hours visible on time cards), and sales mix shifts toward lower-margin items.

Writing the Operations Cost Summary

The summary is a one-to-two-page document addressed to ownership. It has three parts:

1. Results table — all four metrics with actual and target side by side.

2. Variance summary — a brief narrative explaining which variances were found and what likely caused them.

3. Three prioritized corrective actions — listed from highest to lowest projected impact, each tied directly to a specific variance.

A corrective action must be specific (name the task, the person responsible, and the timeline), feasible (achievable with the resources a typical restaurant has), and logically connected to the variance it addresses. "Renegotiate the beef contract or find an alternate supplier within two weeks" ties directly to an invoice price variance. "Work harder" does not meet the standard.

For each action, estimate the projected impact in dollar terms or percentage points. You do not need a precise forecast, but you must show reasoning: "Correcting portioning to standard yield on the salmon entrée would reduce food cost by approximately X dollars per week based on the volume shown in the sales report."

Accuracy and Professional Standards

Arithmetic errors in a real operation cost money and credibility. Check every calculation twice. When using a spreadsheet, verify that each formula references the correct cell. A transposed digit or a wrong cell reference can make a healthy operation look failing — or mask a real problem.

Present your summary in clean, professional language. Ownership and investors read these documents. Spelling errors and vague language undermine confidence in your analysis even when the numbers are correct.

Safety Note

This is a paper-and-spreadsheet lab. There are no physical food-handling, equipment, or chemical hazards in this activity. However, the cost-control decisions you practice here directly fund the resources that keep a kitchen safe: adequate staffing prevents fatigue-related injuries; proper ordering prevents spoilage and the food-safety risks that come with it. Sound cost control and safe operations are not in conflict — they support each other.