Spreadsheet Cost Reporting: Building and Interpreting a Weekly Cost Report

Why Weekly Cost Reports Matter

Running a restaurant without a weekly cost report is like driving at night without headlights. Sales may look strong, but if food and labor costs are creeping above budget, profit disappears before you ever see it. A weekly spreadsheet report catches problems in days, not months, giving managers time to act before small variances become serious losses. Both the NRAEF ManageFirst and AHLEI Hospitality Supervisor credentials expect you to understand how to measure and respond to these costs.

The Two Costs You Track Every Week

Food cost measures what you spend on ingredients relative to what you sell. Labor cost measures what you spend on employee wages and hours relative to sales. Together, these two line items typically make up the largest share of a restaurant's operating expenses. Controlling them is the core skill of a cost-control manager.

Setting Up Your Spreadsheet: Column Structure

Organize your spreadsheet with one column per day of the week (Monday through Sunday) and a final column for weekly totals. Use rows for each data input and each calculated field.

Input rows (enter raw numbers from source documents):

• Daily food sales
• Daily beverage sales (if tracked separately)
• Food purchases received that day (from invoices)
• Opening inventory value (Monday only, or daily if you do daily counts)
• Closing inventory value (Sunday, or daily)
• Total labor hours worked
• Total wages paid (gross, before deductions)

Calculated rows (formulas only — never type an answer directly):

• Daily cost of food sold
• Daily food cost percentage
• Daily labor cost percentage
• Weekly totals and weekly percentages

Using formulas instead of hard-coded numbers is not just a classroom rule — it is professional practice. A report built on formulas updates instantly when data changes, reducing error and saving time.

The Core Formulas

Cost of Food Sold (for the week):

`Opening Inventory + Purchases − Closing Inventory = Cost of Food Sold`

This formula captures what actually left the kitchen as product, not just what arrived on a truck.

Food Cost Percentage:

`Cost of Food Sold ÷ Food Sales × 100 = Food Cost %`

In a spreadsheet cell, this looks like: `=B12/B5*100` where B12 is cost of food sold and B5 is food sales for that column. Format the cell as a percentage or multiply by 100 and display as a number — be consistent.

Labor Cost Percentage:

`Total Wages ÷ Total Sales × 100 = Labor Cost %`

Use total sales (food plus beverage) in the denominator unless your restaurant tracks them separately with different targets.

Reading the Variance

Once your actual percentages appear, compare each to the budget target your manager or owner set. The difference is the variance.

`Variance = Actual % − Budget %`

A positive variance means actual cost is higher than budget — unfavorable, requires action. A negative variance means actual cost is lower than budget — favorable, but investigate anyway to confirm it is real and not a data error.

Focus your corrective-action memo on the two largest unfavorable variances. Prioritize by dollar impact, not just percentage points.

Common Causes of Variance

Food cost too high:

• Receiving errors (paying for product not received)
• Spoilage or improper storage
• Over-portioning by kitchen staff
• Theft or unrecorded employee meals
• Price increases from suppliers not yet reflected in menu prices

Labor cost too high:

• Overtime not approved in advance
• Over-scheduling relative to actual sales volume
• Low sales on a shift (fixed labor with no revenue to cover it)
• Inaccurate time-card entries or clock-out errors

Writing the Corrective-Action Memo

A corrective-action memo is a brief, professional document. It is not a complaint — it is a plan. Use a standard business-memo header (To, From, Date, Subject) and organize the body in two short sections, one for each variance.

For each variance, state:

1. The specific variance in numbers (e.g., "Food cost ran 34.2 % against a 29.0 % budget, a +5.2 point unfavorable variance.")

2. One plausible cause supported by evidence you observed in the data

3. One specific corrective action with a named responsible party and a timeframe

Vague responses such as "train staff better" do not pass. Specific responses such as "conduct a portion-weight audit on all protein items by Thursday, led by the kitchen manager" demonstrate real management thinking.

Data Accuracy and Professional Integrity

Always reconcile your data before reporting. If a daily sales figure looks abnormal, check the point-of-sale report before entering it. If an invoice total seems too high, compare it against the purchase order. Reporting inaccurate numbers — even accidentally — can lead to poor business decisions. In a real operation, managers who routinely verify source documents before entering data are the ones who catch problems early.

Safety Note

While spreadsheet work is office-based, you may reference this data in a kitchen-adjacent setting. Keep beverages away from keyboards and electrical equipment. When retrieving physical invoices or inventory sheets from kitchen or storage areas, wear closed-toe shoes and follow all posted safety rules for those spaces. Data security matters too: cost reports contain confidential financial information — do not share files outside authorized users, and password-protect sensitive documents per your operation's policy.