What's the best way for a Restaurant Manager to track inventory and calculate food costs?

The best system for a Restaurant Manager is a consistent inventory routine tied directly to recipes, purchasing, sales, and waste tracking. The goal is to know:

1. What you have
2. What you used
3. What you should have used
4. Where the money is being lost

A good inventory system is less about counting everything perfectly once a month and more about creating a repeatable process.

1. Build an ingredient inventory sheet

Track every item by:

Include:

• Dry storage
• Walk-in cooler
• Freezer
• Bar inventory (if applicable)
• Paper goods and disposables (optional)

Use the same count order every time so managers count the same way each week.

2. Count inventory on a schedule

A common approach:

• High-cost items: daily or several times per week
  (steak, seafood, liquor, specialty products)
• Main food inventory: weekly
• Low-cost items: weekly or biweekly

Count at the same time each period, ideally before deliveries or major prep shifts, so numbers are comparable.

3. Calculate food cost percentage

The basic formula:

Food Cost % = (Food Cost ÷ Food Sales) × 100

Example:

• Beginning inventory: $8,000
• Purchases: $12,000
• Ending inventory: $7,000

Food cost used:

$8,000 + $12,000 − $7,000 = $13,000

If food sales were $40,000:

$13,000 ÷ $40,000 × 100 = 32.5% food cost

This calculation is based on the standard COGS method: beginning inventory + purchases − ending inventory.

4. Cost every menu item (recipe costing)

Create a recipe card for every dish:

Example: Cheeseburger

Plate cost:

$2.75

Menu price:

$12.00

Menu item food cost:

$2.75 ÷ $12.00 = 22.9%

This tells you whether pricing and portions make sense.

5. Track actual vs. theoretical food cost

This is where many restaurants find problems.

Theoretical food cost:
What you should have used based on recipes and sales.

Actual food cost:
What inventory says you actually used.

Example:

• POS says you sold enough burgers to use 100 lbs of beef.
• Inventory says you used 130 lbs.

The 30 lbs difference may come from:

• Over-portioning
• Waste
• Spoilage
• Incorrect prep
• Incorrect recipes
• Theft
• Counting errors

Comparing theoretical and actual usage helps identify these variances.

6. Track waste separately

Have a waste log:

Without waste tracking, food cost problems are hard to diagnose.

7. Use par levels and ordering rules

A par system prevents overbuying.

Formula:

Order Amount = Par Level − Current Inventory + Expected Usage Until Next Delivery

Example:

• Par: 100 lbs chicken
• On hand: 35 lbs
• Expected use before next delivery: 40 lbs

Order:

100 − 35 + 40 = 105 lbs

8. Review these numbers every week

A strong manager dashboard includes:

• Food cost %
• Beverage cost %
• Waste dollars
• Inventory value
• Purchase spending
• Vendor price changes
• Top 10 highest-cost ingredients
• Menu items with poor margins

Tools to use

For a small restaurant:

• Google Sheets or Excel with recipe costing tabs

For a larger operation:

• Inventory software integrated with POS and purchasing systems

The most important part is not the software—it is having accurate counts, updated recipe costs, and managers reviewing the numbers regularly.

A practical weekly routine:

Monday: Count inventory
Tuesday: Review food cost report
Wednesday: Check waste and portion issues
Thursday: Update vendor prices
Friday: Adjust ordering and prep levels

That cycle gives a manager control over food costs instead of only discovering problems after profits disappear.

The best way for a restaurant manager to track inventory and calculate food costs is to combine consistent weekly physical counts with automated digital tools that tie your invoices and Point of Sale (POS) data directly to your recipes . Waiting until the end of the month means you discover financial leaks too late to fix them.

An efficient, modern workflow relies on a structured step-by-step approach.

Step 1: The Core Inventory & Food Cost Formulas

To know your true financial performance, you must track two distinct metrics: Actual Food Cost Percentage (what you actually spent vs. sold) and Theoretical/Ideal Food Cost Percentage (what you should have spent based on recipes).

1. Calculate Cost of Goods Sold (COGS) / Actual Usage:
   COGS=Beginning Inventory+Purchases−Ending Inventory COGS equals Beginning Inventory plus Purchases minus Ending Inventory C O G S=B e g i n n i n g I n v e n t o r y+P u r c h a s e s−E n d i n g I n v e n t o r y
2. Calculate Actual Food Cost Percentage:
   Food Cost%=(COGS Total Food Sales)×100 Food Cost % equals open paren the fraction with numerator COGS and denominator Total Food Sales end-fraction close paren cross 100 F o o d C o s t%=C O G S T o t a l F o o d S a l e s×1 0 0
3. Calculate Variance (Theoretical vs. Actual):
   Subtract your Ideal Food Cost from your Actual Food Cost. A high variance flags waste, over-portioning, unrecorded staff meals, or theft.

Step 2: Establish a Weekly Routine

• Pick a consistent day and time: Count inventory at the exact same time every week (e.g., Monday morning before opening).
• Organize sheets by station: Walk through the walk-in, freezer, dry storage, and line in a logical, physical path so items aren’t double-counted or missed.
• Enforce FIFO (First-In, First-Out): Ensure older stock is used first so that counts are accurate and spoilage is minimized.

Step 3: Leverage Modern Tech and Automations

Manual clipboards and sprawling Excel sheets lead to burnout and calculation errors. Modern operators use back-of-house platforms that integrate natively with their POS and invoice workflows:

• For all-in-one operations & deep analytics: Platforms like MarketMan or Restaurant365 track ingredient-level usage, vendor pricing, and recipe-level variance.
• For fast financial visibility & invoice OCR: Tools like MarginEdge let you snap photos of invoices to automatically update prices and build daily P&Ls without a tedious setup.
• For POS-native tracking: If you use a system like Toast POS , utilizing native extensions or bundled inventory add-ons ensures your sales data immediately depletes ingredient levels in real time.

Would you like me to help you build a customizable template in a spreadsheet format, or would you prefer a deeper dive into how to price specific menu items using a target food cost percentage?

Tracking inventory and calculating food costs efficiently is key to protecting your restaurant's margins. Here is a streamlined, step-by-step approach to mastering the process:

• Phase 1: Establish the Setup
  • Standardized Recipes: Create precise, gram- or ounce-accurate recipes for every menu item, including exact portion sizes and garnish breakdowns.
  • Categorized Inventory List: Organize your inventory sheets in the exact physical order your stockroom and walk-ins are laid out (e.g., dry goods, produce, meat, dairy, bar) to make counting faster.
  • Unit of Measure (UOM) Alignment: Ensure your purchasing unit (e.g., a case of 24 24 2 4 cans) matches your recipe usage unit (e.g., 1 1 1 can or ounces), or use software that auto-converts units.
• Phase 2: Conduct Consistent Counts
  • Regular Scheduling: Perform full physical inventory counts weekly or monthly, and perform high-value or high-variance items (like proteins and liquor) in daily or bi-weekly mini-counts ("p-mix" or key item tracking).
  • The Closing Routine: Always count at the same time—ideally when the restaurant is closed and deliveries for the day are fully unpacked and logged.
  • Two-Person Team: Use a two-person system where one person calls out the count and quantity while the other records it to drastically cut down on human error.
• Phase 3: Calculate Food Cost Accurately
  • Basic Formula: Use the standard formula to find your Food Cost Percentage: F o o d C o s t P e r c e n t a g e=B e g i n n i n g I n v e n t o r y+P u r c h a s e s−E n d i n g I n v e n t o r y T o t a l F o o d S a l e s×1 0 0%
  • Cost of Goods Sold (COGS): The numerator (B e g i n n i n g I n v e n t o r y+P u r c h a s e s−E n d i n g I n v e n t o r y ) represents your actual COGS for that period.
  • Target Benchmarks: Compare your calculated percentage against your target (typically 2 5% to 3 3% depending on the concept). If it is higher, you have an issue with waste, over-portioning, theft, or unrecorded comps/spoilage.
• Phase 4: Modernize with Technology
  • POS Integration: Pair your Point of Sale system with inventory management tools so that every time a dish is sold, inventory depletes in real-time (theoretical vs. actual usage).
  • Digital Platforms: Transition away from paper clipboards by implementing restaurant-specific inventory tools like Toast POS Inventory or specialized apps like MarketMan or Orderly to automate calculations and invoice scanning.

If you'd like, let me know:

• What type of restaurant you manage (casual, fine dining, quick-service)
• Whether you are currently using pen-and-paper or a software system

I can give you a customized workflow or a breakdown of the best tools for your setup.

The most effective approach is to combine consistent inventory procedures, standardized recipes, and food cost tracking. Restaurants that treat inventory as a daily or weekly management process—not just a month-end task—typically have better control over waste, theft, and profitability.

Here's a practical system that works well for most restaurants:

1. Create a Master Inventory List

Organize inventory by storage location:

• Walk-in cooler
• Freezer
• Dry storage
• Bar
• Prep stations

Each item should include:

• Item name
• Vendor
• Purchase unit (case, pound, gallon)
• Unit cost
• Counted quantity
• Total value

This makes counting faster and more consistent.

2. Standardize Recipes

Every menu item should have:

• Exact ingredient quantities
• Portion sizes
• Yield
• Current ingredient costs

Example:

Total Plate Cost = $3.42

Without standardized recipes, food cost calculations become unreliable.

3. Calculate Cost of Goods Sold (COGS)

Use this formula:

Beginning Inventory + Purchases − Ending Inventory = COGS

Example:

• Beginning Inventory = $18,000
• Purchases = $7,500
• Ending Inventory = $16,200

COGS = $9,300

This tells you how much inventory was actually used during the period.

4. Calculate Food Cost Percentage

Formula:

Food Cost % = (COGS ÷ Food Sales) × 100

Example:

• COGS = $9,300
• Food Sales = $31,000

Food Cost = 30%

Many full-service restaurants target roughly 28–35%, though the ideal range depends on the concept and menu.

5. Compare Theoretical vs. Actual Food Cost

Your POS and recipes tell you what food should have been used (theoretical). Inventory counts tell you what actually was used.

Large variances can indicate:

• Over-portioning
• Waste
• Spoilage
• Incorrect recipes
• Theft
• Counting errors

This comparison is one of the most valuable management reports.

6. Set Par Levels

Determine the minimum quantity of each ingredient you need before reordering.

Example:

This reduces both stockouts and excess inventory.

7. Use FIFO

"First In, First Out" means older inventory is used before newer deliveries. This reduces spoilage and helps maintain food quality.

8. Track Waste

Maintain a waste log with:

• Date
• Item
• Quantity
• Reason (burned, expired, overproduction, customer return, etc.)

Over time, you'll identify patterns that help reduce unnecessary costs.

Spreadsheet vs. Software

For a single-location restaurant, a spreadsheet can be enough if it includes:

• Inventory counts
• Purchase tracking
• Recipe costing
• Automatic COGS calculations
• Food cost %
• Waste log
• Vendor price history

For larger or multi-unit operations, inventory software integrated with your POS can automatically deduct ingredients as menu items are sold, making inventory and food cost reporting more accurate and less time-consuming.

Key Performance Indicators (KPIs)

Review these weekly:

• Food Cost %
• Beverage Cost %
• Prime Cost (Food + Labor)
• Inventory Turnover
• Waste %
• Sales Mix
• Recipe Variance
• Gross Profit by Menu Item

A weekly management routine around these metrics helps identify problems early, when they're easier to correct.

If you're looking for a ready-to-use solution, I can also help you build an Excel or Google Sheets inventory workbook that automatically calculates COGS, food cost percentage, inventory valuation, reorder quantities, and menu profitability from your inventory counts and purchase data.

The best way for a restaurant manager to track inventory and calculate food costs is by using a combination of consistent weekly manual counts, digital management software (e.g., MarginEdge, Restaurant365, Xtrachef ), and strict adherence to the FIFO (First-In, First-Out) inventory system.

Here is a comprehensive guide to tracking inventory and calculating food costs:

1. The Best Method for Tracking Inventory

• Weekly Counts: Conduct physical inventory counts weekly (preferably on the same day/night) to get a clear picture of inventory dynamics.
• Digital Tools: Use inventory apps or handheld devices to scan items. This reduces errors compared to pen-and-paper methods and allows for simultaneous counting by different team members.
• Implement FIFO: Ensure the oldest stock is used first by dating deliveries and organizing shelves, which minimizes spoilage.
• Set PAR Levels: Define Periodic Automatic Replenishment (PAR) levels for ingredients to prevent over-ordering and under-ordering (Formula: Average Daily Usage×cross× Delivery Lead Time + Safety Stock).

2. How to Calculate Food Costs

The industry standard for determining food cost is to measure the Cost of Goods Sold (COGS) and then divide it by total sales.

The Core Formulas:

1. Cost of Goods Sold (COGS): B e g i n n i n g I n v e n t o r y+P u r c h a s e s−E n d i n g I n v e n t o r y=C O G S.
2. Food Cost Percentage:(C O G S T o t a l F o o d S a l e s)×1 0 0=F o o d C o s t P e r c e n t a g e.

Steps to Take:

• Measure Weekly: Do not wait for month-end to find a problem. Weekly reporting allows you to catch waste before it impacts the entire month's margin.
• Separate Food from Non-Food: Only include food in your food cost calculation. Exclude paper goods, cleaning supplies, and guest supplies (like soaps).
• Track Waste, Comps, and Voids: Log all food that leaves the building without being paid for to identify discrepancies.
• Compare Actual vs. Theoretical: Calculate the "ideal" food cost (based on recipes and sales) and compare it to the "actual" food cost (from inventory counts) to find the variance.

3. Best Practices for Profitability

• Standardize Recipes: Create detailed recipe cards (portions, ingredients in grams/ml) to ensure consistency.
• Review Supplier Pricing: Regularly check supplier prices against market rates to manage inventory costs.
• Menu Engineering: Regularly analyze "dog" (low-profit) and "plowhorse" (high-volume) items to adjust pricing.

By following these procedures, managers can maintain a standard 28%–35% food cost percentage.

Would you like me to create a sample inventory spreadsheet in Excel/Google Sheets, or are you more interested in comparing popular software options like Restaurant365 vs. MarginEdge?

The most effective approach is to build a repeatable inventory system that connects four things:

1. Inventory counts
2. Purchases
3. Sales
4. Recipes

When those four pieces work together, you can accurately calculate food cost, identify waste, and make better purchasing decisions. Restaurants with disciplined inventory processes typically reduce waste, avoid stockouts, and improve profitability.

1. Count inventory on a schedule

Consistency matters more than frequency.

• Daily: High-value items (steaks, seafood, liquor)
• Weekly: Most food inventory
• Monthly: Smallwares and supplies

Always:

• Count before receiving deliveries.
• Count at the same time each period.
• Use the same units every time (lbs, ounces, gallons, each).

2. Create a master inventory sheet

Organize inventory by storage location:

• Walk-in cooler
• Freezer
• Dry storage
• Bar
• Prep stations

Track:

• Item name
• Unit (lb, case, bottle)
• Quantity
• Unit cost
• Total value

Example:

3. Calculate Cost of Goods Sold (COGS)

The standard formula is:

Beginning Inventory + Purchases − Ending Inventory = COGS

Example:

• Beginning Inventory: $14,500
• Purchases: $8,700
• Ending Inventory: $12,800

COGS = $10,400

4. Calculate Food Cost %

Use:

Food Cost % = (COGS ÷ Food Sales) × 100

Example:

• Food Sales = $36,000
• COGS = $10,400

Food Cost % = 28.9%

Many restaurants target approximately 28–35%, though the ideal range varies by concept, menu, and pricing strategy.

5. Cost every recipe

Build recipe cards with:

• Ingredient
• Quantity used
• Unit cost
• Portion cost

Example:

Burger

• Bun: $0.42
• Patty: $2.15
• Cheese: $0.31
• Lettuce: $0.18
• Tomato: $0.24
• Sauce: $0.20

Total plate cost = $3.50

If sold for $14.00:

Food Cost = 25%

6. Track waste every day

Record:

• Burned food
• Spoilage
• Overproduction
• Employee meals
• Returned food

Waste should be treated as inventory usage so managers can see where margins are being lost.

7. Set par levels

A par level is the minimum quantity you want on hand before reordering.

Example:

• Average daily chicken use: 35 lb
• Delivery every 3 days

Par = approximately 105 lb plus a reasonable safety buffer.

This helps avoid both stockouts and excess inventory.

8. Compare actual vs. theoretical usage

This is one of the most valuable management reports.

Example:

POS indicates you should have used:

• 220 lb of chicken

Inventory shows you actually used:

• 245 lb

Difference:

• 25 lb

Possible causes:

• Over-portioning
• Waste
• Theft
• Incorrect recipes
• Inventory counting errors

This comparison helps identify operational issues quickly.

9. Use software when practical

For a single-location restaurant, a well-designed Excel or Google Sheets workbook can work effectively.

As operations grow, many managers benefit from software that integrates:

• POS sales
• Purchasing
• Inventory counts
• Recipe costing
• Vendor pricing

These systems can automatically deduct ingredient inventory based on sales and highlight variances.

Key performance indicators to review weekly

A practical workflow

Every week:

1. Count inventory.
2. Enter vendor invoices.
3. Calculate COGS.
4. Review food cost percentage.
5. Compare actual vs. theoretical usage.
6. Investigate major variances.
7. Adjust purchasing and par levels based on sales trends.

This routine usually takes 1–2 hours per week for a small to medium-sized restaurant but provides managers with a clear picture of food costs, waste, and profitability.

The best way for a restaurant manager to track inventory and calculate food costs is to use a consistent weekly process , ideally aided by digital management software for efficiency and accuracy. A high-level system involves taking regular physical counts, calculating Cost of Goods Sold (COGS) , and analyzing food cost percentage.

Key Components of Inventory & Cost Management:

• Establish Regular Cycles: Perform weekly physical inventory counts on the same day/time (e.g., Sunday night) to compare against weekly sales figures.
• Organize and Standardize: Organize inventory sheets by storage area (cooler, freezer, dry storage) and ensure consistent units of measurement (pounds, cases, cases, gallons).
• Utilize Technology: Use restaurant inventory software to scan barcodes, track, and calculate COGS, which saves time compared to manual spreadsheets.
• Implement a Key Item Report: Track 5–10 high-cost items daily to prevent theft and monitor for over-ordering.
• Use a Waste Sheet: Actively log all wasted, spoiled, or stolen food to understand the causes of high food costs.

Food Cost Calculation Formulas:

1. Cost of Goods Sold (COGS):
   B e g i n n i n g I n v e n t o r y+P u r c h a s e s−E n d i n g I n v e n t o r y=C O G S
2. Food Cost Percentage:
   C O G S T o t a l F o o d S a l e s×1 0 0=F o o d C o s t%
3. Plate Cost (Dish Cost):
   C o s t o f I n g r e d i e n t s×P o r t i o n S i z e=D i s h C o s t

Best Practices for Efficiency:

• 13-Period Calendar: Divide the year into 13, 4-week periods for more consistent financial tracking, reducing the impact of holiday fluctuations.
• FIFO Method: Use the First In, First Out (FIFO) method to reduce spoilage.
• Invoice Logging: Use an invoice log to differentiate food costs from paper, janitorial, or smallwares expenses.

If you want to make this process easier, I can tell you about:

• The most popular restaurant inventory software (like Restaurant365)
• A template for a waste log sheet
• How to structure a "Key Item" daily report

Let me know which you would like to explore.

The most effective inventory system for a restaurant is one that combines consistent inventory counts, standardized recipes, purchasing records, and POS sales data. When these work together, you can accurately calculate food costs, identify waste, and improve profitability.

Here's a practical system that many successful restaurant managers use:

1. Count Inventory on a Schedule

• Perform a full inventory once a week, ideally before receiving deliveries.
• Count high-value items (steaks, seafood, liquor) daily.
• Count items in the same order every time (walk-in → freezer → dry storage).
• Use consistent units (lbs, oz, cases, each).

2. Track Every Purchase

Keep every vendor invoice and record:

• Item
• Quantity
• Unit cost
• Vendor
• Date

Updating inventory costs with each delivery helps ensure your food cost calculations stay accurate.

3. Standardize Recipes

Every menu item should have:

• Exact ingredient quantities
• Portion sizes
• Yield percentages
• Current ingredient costs

For example:

Without standardized recipes, it's difficult to know whether higher costs come from pricing changes or inconsistent portioning.

4. Calculate Cost of Goods Sold (COGS)

Use this formula:

Beginning Inventory + Purchases − Ending Inventory = COGS

Example:

• Beginning Inventory: $18,000
• Purchases: $9,500
• Ending Inventory: $16,500

COGS = $11,000

5. Calculate Food Cost %

Food Cost % = (COGS ÷ Food Sales) × 100

Example:

• COGS = $11,000
• Food Sales = $35,000

Food Cost = 31.4%

Many full-service restaurants target food costs in the low-30% range, though the right target varies by concept and menu.

6. Monitor Variances

Compare:

• Actual inventory usage
• Recipe (theoretical) usage
• POS sales

Large differences often point to:

• Over-portioning
• Waste
• Spoilage
• Theft
• Incorrect inventory counts

7. Track Key Performance Indicators (KPIs)

Review these weekly:

• Food Cost %
• Beverage Cost %
• Inventory Value
• Inventory Turnover
• Waste %
• Vendor Price Changes
• Top 10 Most Expensive Ingredients
• Gross Profit by Menu Item

8. Use the Right Tool

Depending on your operation:

Small restaurants (1 location)

• Microsoft Excel or Google Sheets
• Weekly inventory spreadsheet
• Recipe costing sheet

Growing restaurants

• POS-integrated inventory software that automatically deducts ingredients from inventory as items are sold
• Features like vendor invoice imports, recipe costing, purchase orders, and variance reporting can save significant time and improve accuracy.

A Simple Weekly Workflow

1. Count ending inventory (Sunday night).
2. Enter all vendor purchases.
3. Import POS sales.
4. Calculate COGS.
5. Review food cost percentage.
6. Investigate any large variances.
7. Adjust ordering and prep levels for the coming week.

This routine typically takes 1–2 hours per week once the process is established, and it gives managers timely information to control costs before small issues become expensive problems.

If you're managing a single restaurant, I can also provide a free Excel or Google Sheets inventory and food cost template that automatically calculates COGS, food cost percentage, inventory value, and reorder quantities.

The most effective way for a restaurant manager to track inventory and calculate food costs is to use a digital inventory management system or integrated POS software, conduct weekly physical counts, and utilize a consistent food cost formula to calculate costs . This approach allows for real-time tracking, accurate cost analysis, and immediate identification of waste or theft.

Key Strategies for Inventory and Food Costs:

• Implement Digital Tools: Use restaurant management software or inventory apps for efficiency and accuracy.
• Weekly Physical Counts: Perform consistent weekly counts at the same time and day, ideally before deliveries or prep.
• Establish PAR Levels: Set minimum stock levels for ingredients to prevent overordering and shortages.
• Use FIFO: Implement First-In, First-Out (FIFO) for inventory rotation, especially for perishable items.
• Track Waste and Comps: Record spoiled, wasted, or comped items to explain discrepancies in actual vs. theoretical food costs.
• Standardize Recipes: Ensure every item has a recipe card with precise portions and ingredient costs.

Food Cost Formula:

• Food Cost: Beginning Inventory + Purchases – Ending Inventory = Food Cost
• Food Cost Percentage: (Food Cost / Food Sales)×cross× 100 = Food Cost Percentage

Key Steps for Success:

• Train Staff: Educate staff on the importance of accurate inventory management and the financial impact of waste and portion control.
• Calculate Weekly: Do not wait for month-end; check your numbers weekly to catch any issues early.
• Compare Actual vs. Theoretical: Use POS analytics to compare your actual inventory usage against what should have been used based on sales.
• Analyze High-Cost Items: Focus on the highest-priced items, such as meat and liquor, for more frequent, smaller-scale counts (e.g., daily or weekly).

Would you like to explore specific software recommendations for inventory management, or perhaps tools for creating a digital inventory template in Excel/Google Sheets?

The best inventory system is one that's simple, consistent, and tied directly to sales. Most restaurants don't lose money because they lack data—they lose money because they aren't measuring the right things often enough.

Here's a proven workflow used by successful restaurant managers.

1. Organize inventory by storage location

Instead of listing items alphabetically, organize count sheets exactly how employees walk through the restaurant:

• Walk-in cooler
• Reach-in coolers
• Freezers
• Dry storage
• Bar (if applicable)

This reduces missed items and speeds up counts. Standardized count sheets and consistent counting methods improve accuracy.

2. Count inventory on a schedule

A good routine is:

• Daily: High-value proteins, seafood, alcohol
• Weekly: Full food inventory
• Monthly: Complete inventory with supplies and disposables

Always count:

• Before deliveries
• At the same time of day
• Using the same units (lbs, ounces, cases, each, etc.)

3. Record all purchases

Save every invoice.

Track:

• Vendor
• Date
• Product
• Quantity
• Cost

Updating ingredient prices weekly or monthly keeps recipe costs accurate when suppliers change pricing.

4. Build recipe costing

Every menu item should have:

• Every ingredient
• Exact portion size
• Current ingredient cost

Example:

Burger:

• Bun = $0.48
• Patty = $2.05
• Cheese = $0.32
• Lettuce = $0.10
• Sauce = $0.14

Food cost = $3.09

If the burger sells for $12.99:

Food Cost % = 3.09 ÷ 12.99 × 100 = 23.8%

5. Calculate Cost of Goods Sold (COGS)

This is the most important restaurant formula.

COGS = Beginning Inventory + Purchases − Ending Inventory

Example:

Beginning Inventory: $18,000

Purchases: $12,500

Ending Inventory: $15,000

COGS = $15,500

This tells you how much food you actually used during the period.

6. Calculate Food Cost %

Once you know COGS:

Food Cost % = COGS ÷ Food Sales × 100

Example:

Food Sales = $52,000

COGS = $15,500

Food Cost = 29.8%

Many full-service restaurants target roughly 28–35%, though the ideal number depends on concept, menu, and pricing.

7. Compare theoretical vs. actual usage

This is where many managers uncover the biggest opportunities.

Your POS and recipes tell you what inventory should have been used (theoretical usage).

Your inventory counts tell you what actually disappeared.

The difference points to:

• Over-portioning
• Waste
• Theft
• Prep errors
• Recipe inconsistencies

Focusing on the highest-cost ingredients first (such as beef, chicken, seafood, and cooking oil) often provides the fastest return.

8. Track key metrics every week

Keep a dashboard with:

9. Use technology if possible

If your POS integrates with inventory, it can automatically deduct ingredients as menu items are sold. Many systems also support recipe costing, purchase orders, and variance reporting, reducing manual work and improving visibility.

A practical weekly routine

• Monday: Full inventory count
• Tuesday: Enter invoices and update prices
• Wednesday: Review food cost report
• Thursday: Check variance on top 10 expensive ingredients
• Friday: Adjust ordering and prep levels
• Daily: Log waste, comps, and employee meals

This cadence helps catch problems before they grow into major losses.

If you're managing a single restaurant or a small group of locations, a well-designed Excel or Google Sheets workbook is often enough. If you'd like, I can also create a restaurant inventory and food cost spreadsheet that automatically calculates COGS, food cost percentages, recipe costs, and variance reports.

If your POS integrates with inventory, it can automatically deduct ingredients as menu items are sold. Many systems also support recipe costing, purchase orders, and variance reporting, reducing manual work and improving visibility.

A practical weekly routine

Ending Inventory: $15,000

COGS = $15,500

This tells you how much food you actually used during the period.

6. Calculate Food Cost %

Once you know COGS:

Food Cost % = COGS ÷ Food Sales × 100

Example:

Food Sales = $52,000

COGS = $15,500

Food Cost = 29.8%

Many full-service restaurants target roughly 28–35%, though the ideal number depends on concept, menu, and pricing.

7. Compare theoretical vs. actual usage

This is where many managers uncover the biggest opportunities.

Your POS and recipes tell you what inventory should have been used (theoretical usage).

Your inventory counts tell you what actually disappeared.

The difference points to:

• Over-portioning
• Waste
• Theft
• Prep errors
• Recipe inconsistencies

Focusing on the highest-cost ingredients first (such as beef, chicken, seafood, and cooking oil) often provides the fastest return.

8. Track key metrics every week

Keep a dashboard with: