Inventory Counts, Cost, and Turnover
Learning objectives
After this section you will be able to:
- Reconcile goods available with ending inventory.
- Compute cost of goods sold and shrinkage.
- Use average inventory to calculate turnover.
Real-life situation
Counting a neighborhood pop-up
A hypothetical Philadelphia student cooperative sells plain tote bags. Its stock sheet separates goods sold from bags still on the shelf; every bag has the same $8 cost.
| Item | Amount or quantity |
|---|---|
| Beginning inventory | 100 bags at $8 |
| Purchases | 150 bags at $8 |
| Recorded sales | 180 bags |
| Physical ending count | 65 bags |
The concept
Inventory is merchandise held for sale. A physical count tells a business what it actually has; a stock record tells it what it expects to have. Compare both in units before assigning dollar values. In the figure, 100 + 150 − 180 = 70 bags should remain, but only 65 are counted.
For this simplified model, goods available at cost equals beginning inventory plus net purchases. Net purchases means purchases after returns and discounts, including any assigned freight-in. Cost of goods sold, or COGS, is the cost assigned to merchandise sold, not the selling price charged to customers.
A shortage between expected and counted inventory is shrinkage. Here 70 − 65 = 5 bags are missing, a $40 cost. Businesses investigate counting errors, damage, and theft rather than assuming every shortage is theft. Keep shrinkage separate from recorded sales cost in this lesson; subtracting physical ending inventory from goods available would combine both.
Turnover compares a period's COGS with average inventory at cost. Using the simple mean of beginning and ending inventory gives a useful estimate, but seasonal businesses may need monthly averages. Higher turnover can mean efficient selling or dangerously low stock, so compare similar businesses over the same period. Round money to cents and turnover to two decimal places.
Inventory Counts, Cost, and Turnover: solution map
- 1
Identify the question
Use the figure to find recorded COGS, physical ending value, and shrinkage.
- 2
Calculation 1
Available units = 100 + 150 = 250; available cost = 250 × $8 = $2,000.00.
- 3
Calculation 2
Recorded COGS = 180 × $8 = $1,440.00.
- 4
Calculation 3
Expected ending units = 250 − 180 = 70; physical ending cost = 65 × $8 = $520.00.
- 5
Calculation 4
Shrinkage = (70 − 65) × $8 = $40.00.
- 6
Calculation 5
Check: $1,440 + $520 + $40 = $2,000.
- 7
Interpret and check
Recorded COGS is $1,440.00, ending inventory is $520.00, and shrinkage is $40.00.
Money Words
Plain-language words you will use in this lesson — learn them before we reach the formulas.
inventory
The stock of goods a business holds ready to sell.
overhead
Ongoing business costs such as rent, utilities, and insurance that do not change with each sale.
fixed cost
A cost that stays the same no matter how many items are sold, like rent.
Key terms
- Inventory
- Goods held for sale, measured in units or at cost.
- Net purchases
- Purchase cost after returns and discounts, plus assigned freight-in.
- Cost of goods sold
- Inventory cost assigned to goods actually sold.
- Shrinkage
- Expected inventory minus actual inventory, when positive.
- Inventory turnover
- Period COGS divided by average inventory at cost.
Formulas & rules
Goods available
Available cost = beginning inventory cost + net purchases
Recorded sales cost
COGS = units sold × cost per unit (equal-cost goods)
Shrinkage
Shrinkage cost = (expected units − counted units) × unit cost
Turnover
Turnover = COGS ÷ [(beginning inventory + ending inventory) ÷ 2]
Worked examples
Use the figure to find recorded COGS, physical ending value, and shrinkage.
Solution
- 1Available units = 100 + 150 = 250; available cost = 250 × $8 = $2,000.00.
- 2Recorded COGS = 180 × $8 = $1,440.00.
- 3Expected ending units = 250 − 180 = 70; physical ending cost = 65 × $8 = $520.00.
- 4Shrinkage = (70 − 65) × $8 = $40.00.
- 5Check: $1,440 + $520 + $40 = $2,000.
Answer: Recorded COGS is $1,440.00, ending inventory is $520.00, and shrinkage is $40.00.
A shop has $3,000 beginning inventory, $5,000 ending inventory, and $24,000 annual COGS. Find annual turnover.
Solution
- 1Average inventory = ($3,000 + $5,000) ÷ 2 = $4,000.00.
- 2Turnover = $24,000 ÷ $4,000 = 6.
- 3The annual COGS is six times the average inventory investment.
Answer: Annual inventory turnover is 6.00 times.
Practice exercises 18.1
- A booth begins with 40 hats, buys 75, and sells 90. How many should remain?
- The booth counts 22 hats instead of 25. Each cost $6. Find shrinkage.
- Beginning inventory costs $700; net purchases cost $1,100. Ending inventory costs $500, with no shrinkage. Find COGS.
- Beginning and ending inventory are $2,000 and $4,000. Annual COGS is $15,000. Find turnover.
- Ten equal-cost cases cost $240 total; three remain with no loss. Find unit cost and COGS.
Recap quiz 18.1
Section 18.1 recap
- Reconcile units first, then multiply by cost; keep shrinkage separate from sales.
- Turnover uses COGS and average inventory at cost for the same period.
Answer key with explanations: Section 18.1
Practice exercises
- Available = 40 + 75 = 115 hats; expected ending = 115 − 90 = 25 hats.
- Missing units = 25 − 22 = 3; shrinkage cost = 3 × $6 = $18.00.
- Available cost = $700 + $1,100 = $1,800; COGS = $1,800 − $500 = $1,300.00.
- Average = ($2,000 + $4,000) ÷ 2 = $3,000; turnover = $15,000 ÷ $3,000 = 5.00 times per year.
- Unit cost = $240 ÷ 10 = $24; units sold = 10 − 3 = 7; COGS = 7 × $24 = $168.00.
Recap quiz
- COGS: COGS assigns acquisition cost to the merchandise sold.
- $27: (48 − 45) × $9 = $27.00.
- 6 times: $18,000 ÷ $3,000 = 6.00 times for the stated period.