Food Perpetual Inventory System (Daily & Weekly Versions)

Struggling With High Food Cost? This System Fixes It.

Are your food costs out of control? Is your bottom line in the red? Are you losing sleep trying to figure out where the money is going — and who might be responsible?

Workplace Wizards created the Food Perpetual Inventory System, available in both Daily and Weekly versions. This is a powerful, proactive tool designed to help restaurant owners and managers identify shortages, reduce waste, prevent theft, and regain control of food cost.

This is not a traditional weekly or monthly inventory. It is a real‑time tracking system that gives you visibility into your most expensive and most vulnerable food items — every day or every shift.

How Traditional Food Inventory Works (and Why It Isn’t Enough)

A standard inventory requires physically counting every food and beverage item, then calculating your food cost percentage:

Food Cost Formula: (Beginning Inventory + Purchases) – Ending Inventory = COGS COGS ÷ Food Revenue = Food Cost Percentage

This formula is essential — but it only tells you what happened after the damage is done.

Your inventory is your wallet. If you don’t protect it, you lose money.

What Is a Food Perpetual Inventory?

A perpetual inventory tracks selected food items daily or per shift, giving you immediate insight into:

• Waste
• Over‑portioning
• Voids and comps
• Training issues
• Theft
• Shrinkage
• Operational breakdowns

You choose the top 5, 10, or more items to track — typically your highest‑cost products or items most likely to be stolen or mishandled.

The system comes in two versions:

• Daily Food Perpetual Inventory
• Weekly Food Perpetual Inventory

Both versions function the same way; the only difference is how often you record the data.

Food Perpetual Inventory Home Page

The system includes five weeks, allowing for months that overlap into a fifth week. Each week is structured for consistent tracking and accurate reporting.

How the Food Perpetual Inventory System Works

Step 1: Select the Items You Want to Track

Choose your most expensive or most frequently missing items. If your POS shows shortages, add those items to your list.

Step 2: Enter Product Details

To generate accurate numbers, enter the following on the Product Page:

• Product Name
• Unit of Measure
• Serving Size
• Servings Per Unit
• Retail Price Per Unit
• Cost Per Case, Each, or Portion

This setup is done once. The system automatically populates these details across all sheets.

Step 3: Complete the Beginning Inventory

On the Week One Beginning Inventory Sheet, the first six shaded columns are protected and auto‑filled from the Product Page. You enter your beginning counts in the white cells. The final column calculates automatically and feeds into the Week One Final Input Sheet.

Step 4: Complete the Ending Inventory

The Week One Ending Inventory Sheet mirrors the beginning sheet. You enter your ending counts, and the system calculates usage and pushes totals to the Final Input Sheet.

Step 5: Enter Weekly Activity on the Final Input Sheet

White cells are for your entries; all colored cells are protected.

You will enter:

• Purchases (total dollar amount for the week)
• Vendor free products (cases, eaches, and dollar value)
• Transfers in/out
• Waste (comps, breakage, spoilage, etc.)
• POS sold (from your POS itemized readout)

The system then calculates:

• Total servings used
• POS servings sold
• Shortages or overages
• Dollar value of loss or gain

If you perform a beginning and ending inventory within the same shift, any shortage immediately identifies when the loss occurred — and who was working.

Why You May Be Short on Product

Common causes include:

• Food waste
• Customer voids
• Customer comps
• Server or cook errors
• Training issues
• Theft

Approximately 70% of restaurant inventory shortages are employee‑related — not always theft, but a combination of preventable issues.

Over the course of a year, these shortages can cost your restaurant thousands of dollars in lost inventory and lost profit.

Take Control of Your Food Cost Today

The Food Perpetual Inventory System gives you the visibility and accountability your restaurant needs to:

• Reduce food cost
• Prevent loss
• Improve profitability
• Strengthen training
• Hold staff accountable
• Protect your bottom line