🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Hospitality, Food & Tourism › Restaurant Management › Purchasing for Restaurant Operations › Lesson 7
HOS-REST26-06 · Lesson 7 · 14 clock hours · lab

Inventory Control: Perpetual Systems, Physical Counts, and Turnover

Objective. Students will record transactions in a perpetual inventory log, conduct a physical inventory count, calculate inventory turnover rate and variance, and identify items requiring reorder or investigation.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a certified food-safety manager and industry professional or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Why Inventory Control Matters

Inventory control is one of the most direct levers a restaurant manager has over food cost and profitability. Every dollar sitting on a shelf is cash your operation has already spent. Knowing exactly what you have, what you used, and what you still owe suppliers is not optional — it is a core management discipline tested by NRAEF ManageFirst and expected by every employer you will work for.

Two systems work together to give you that knowledge: the perpetual inventory system, which tracks stock in real time as transactions happen, and the physical inventory count, which verifies the numbers by actually touching and counting every item.

The Perpetual Inventory System

A perpetual inventory log records three events for every item:

The core formula is:

> Beginning Balance + Received − Issued = Ending Balance

This formula must balance for every line, every day. A well-maintained perpetual log lets a manager check par levels at any moment, spot a suspicious drop in a high-value item, and generate a reorder list without waiting for the monthly count. In computerized point-of-sale or back-office systems, receiving and sales data can update the perpetual log automatically, but manual entry in a spreadsheet follows the same logic.

Accuracy disciplines to follow:

Physical Inventory Count

No perpetual system is perfectly accurate over time. Breakage, theft, mis-pulls, and data-entry errors accumulate. A physical count is the only way to verify what is truly on hand.

Count procedure:

1. Schedule the count at the close of business or before the first delivery of the day, so movement is minimized.

2. Work in teams of two — one person counts, the other records. Never let one person do both unsupervised.

3. Count systematically: shelves left to right, top to bottom, so nothing is skipped or double-counted.

4. Record the quantity, then extend it: Quantity × Unit Cost = Extended Value.

5. Total all extended values to get the total physical inventory value.

Safety note: In walk-in coolers and freezers, wear appropriate cold-weather gear and confirm the door release mechanism works before entering. Never enter a walk-in alone; inform a colleague before going in. Keep aisles clear of boxes during counting to prevent slips and trips. When moving heavy cases to count items behind them, use proper lifting technique — straight back, lift with the legs.

Calculating Variance

Once you have the physical count, compare it to the perpetual ending balance:

> Variance (units) = Perpetual Ending Balance − Physical Count

> Variance ($) = Variance (units) × Unit Cost

A positive variance means the perpetual log shows more than you physically have — product is missing. A negative variance usually means a receiving or entry error. Your operation will set a threshold (for example, more than 5% of an item's unit cost) above which a variance must be flagged for investigation. Items above the threshold may indicate theft, spoilage, or documentation failure — all of which require follow-up.

Inventory Turnover Rate

Inventory turnover measures how many times your inventory is sold and replaced in a given period. A higher turnover generally means fresher product, less spoilage, and better cash flow. The formula is:

> Inventory Turnover Rate = Cost of Food Sold ÷ Average Inventory

Where:

Turnover benchmarks vary by concept and menu type; your ManageFirst textbook discusses typical ranges for different restaurant segments. A very low turnover may signal over-purchasing or slow-moving items that should be removed from the order guide.

Identifying Reorder Needs

After reconciling the count, compare each item's physical quantity to its par level — the minimum quantity needed to cover demand until the next delivery. Any item at or below par must be added to the purchase order. High-variance items should be investigated before reordering to avoid ordering into a theft or spoilage problem.

Lab Safety Reminders

Key terms8

Perpetual Inventory SystemA running record that updates stock balances continuously each time goods are received or issued, using the formula: Beginning + Received − Issued = Ending.
Physical Inventory CountAn actual hands-on count of every item on hand, conducted periodically to verify the accuracy of the perpetual record.
VarianceThe difference between the balance shown in the perpetual ledger and the quantity found during a physical count, expressed in units and in dollars.
ExtensionThe dollar value of a counted item calculated by multiplying the counted quantity by the unit cost (Quantity × Unit Cost = Extended Value).
Inventory Turnover RateA ratio showing how many times inventory is sold and replaced in a period; calculated as Cost of Food Sold ÷ Average Inventory.
Par LevelThe minimum quantity of an item that must be on hand to meet demand until the next scheduled delivery without running out.
RequisitionA formal written or electronic request to issue goods from the storeroom to a production area; the source document for recording issues in the perpetual log.
Average InventoryThe mean value of inventory over a period, calculated as (Beginning Inventory + Ending Inventory) ÷ 2; used as the denominator in the turnover formula.

Worked examples4

1. Perpetual Balance — Canned Diced Tomatoes (6/#10 case): Beginning balance = 12 cases. Received Monday = 6 cases. Issued Tuesday = 4 cases, issued Thursday = 3 cases. What is the ending balance?
  1. Identify beginning balance: 12 cases.
  2. Add all receiving: 12 + 6 = 18 cases.
  3. Subtract all issues: 18 − 4 − 3 = 11 cases.
  4. Apply formula: Beginning (12) + Received (6) − Issued (7) = Ending (11).
Answer: Ending balance = 11 cases.
2. Variance Calculation — Olive Oil (1-gallon jugs, unit cost $14.00 each): Perpetual ending balance = 9 jugs. Physical count = 7 jugs. Variance threshold is 5% of unit cost. Is this item flagged?
  1. Calculate variance in units: 9 − 7 = 2 jugs short.
  2. Calculate variance in dollars: 2 × $14.00 = $28.00.
  3. Calculate threshold in dollars: 5% × $14.00 = $0.70 per unit. The dollar variance of $28.00 far exceeds $0.70.
  4. Alternatively, check percentage of total perpetual value: $28.00 ÷ (9 × $14.00) = $28.00 ÷ $126.00 ≈ 22.2%, well above 5%.
  5. Flag the item for investigation.
Answer: Variance = 2 units / $28.00. Item is flagged — variance far exceeds the 5% threshold.
3. Inventory Turnover Rate: For the month, Cost of Food Sold = $18,400. Beginning inventory value = $4,200. Ending inventory value = $3,800. Calculate the turnover rate.
  1. Calculate Average Inventory: ($4,200 + $3,800) ÷ 2 = $8,000 ÷ 2 = $4,000.
  2. Apply the turnover formula: Turnover Rate = Cost of Food Sold ÷ Average Inventory.
  3. Turnover Rate = $18,400 ÷ $4,000 = 4.6.
Answer: Inventory Turnover Rate = 4.6 times for the month.
4. Physical Count Extension — Shredded Mozzarella (5-lb bags, unit cost $8.75 each): Count sheet shows 14 bags. What is the extended value?
  1. Identify quantity: 14 bags.
  2. Identify unit cost: $8.75 per bag.
  3. Multiply: 14 × $8.75 = $122.50.
Answer: Extended value = $122.50.

The math in this lesson1

Learners apply beginning plus received minus issued to find an 11-case perpetual inventory balance.
A-SSE.1
Brush up in the math halls at newSchoolWorks.com:
In class: Using a provided perpetual inventory spreadsheet pre-loaded with beginning balances, enter a week's worth of receiving and requisition transactions for a 15-item storeroom; verify ending balance for each item using the formula: Beginning + Received − Issued = Ending. · Conduct a physical count of a stocked mock storeroom (15–20 labeled containers with actual or simulated quantities), record counts on count sheets, extend each item at its unit cost, and total the physical inventory value. · Compare physical count results to the perpetual ledger ending balances, calculate variance in units and dollars for each item, flag items with variance above an instructor-set threshold (e.g., more than 5% of unit cost), and calculate inventory turnover rate using the formula: Cost of Food Sold ÷ Average Inventory.
Materials: Perpetual inventory spreadsheet (Excel or printed), stocked mock storeroom with labeled containers, physical count sheets, calculators, NRAEF ManageFirst Purchasing textbook (inventory chapter)
Check: Spreadsheet graded: all 15 perpetual balances accurate (zero arithmetic errors); physical count extensions accurate within ±$0.05 per line; turnover rate calculated correctly; all items above variance threshold flagged. 95% line-item accuracy required to pass.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Inventory and Cost Control
1. A storeroom shows a beginning balance of 8 cases of pasta, receives 10 cases on Monday, and issues 6 cases on Wednesday and 3 cases on Friday. What is the correct perpetual ending balance?
Purchasing and Inventory Management
2. The primary purpose of conducting a physical inventory count is to:
Financial Management and Cost Control
3. The inventory turnover rate is calculated using which formula?
Inventory and Cost Control
4. A perpetual record shows 20 pounds of ground beef on hand. The physical count finds 15 pounds. Unit cost is $4.80 per pound. What is the dollar variance?
Workplace Safety and Regulatory Compliance
5. During a physical count in a walk-in freezer, a team member wants to count alone to finish faster. The best response from the manager is to:
Financial Management and Cost Control
6. A restaurant's beginning inventory is $5,500, ending inventory is $4,500, and cost of food sold for the period is $30,000. What is the inventory turnover rate?
Purchasing and Inventory Management
7. An item's physical count is higher than the perpetual ending balance. This negative variance most likely indicates:
Purchasing and Inventory Management
8. Which of the following best describes an item's par level in a restaurant storeroom?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.