July 8, 2026
Calculate COGS Weekly: Formula & Real Example for Small Business
How to Calculate Cost of Goods Sold (COGS) Weekly: The Math Behind Your Margins
COGS is the direct cost of inventory sold each week. Calculating it weekly instead of monthly or yearly shows you your true margins in real time and lets you spot pricing problems, supplier cost increases, or shrinkage immediately.
Why Weekly COGS Matters
Most businesses calculate COGS monthly or at year-end. By then, pricing mistakes or supplier cost creep have already cost weeks of margin. Calculate COGS weekly and you can adjust pricing, renegotiate supplier costs, or investigate shrinkage within days instead of months.
Example: your supplier raises prices 5% on Wednesday. Monthly COGS means you do not discover the margin hit until month-end, that is 3-4 weeks of discounted profit. Weekly COGS catches it by Friday.
The COGS Formula (Weekly)
Weekly COGS = (Beginning Inventory + Purchases This Week) - Ending Inventory
- Beginning Inventory: value of inventory on your count day.
- Purchases This Week: new inventory bought this week, at cost.
- Ending Inventory: value of inventory on the following count day.
Stop Doing This Manually.
14-day free trial. No credit card. No POS needed.
Track My First Week Free →Step-by-Step: Calculate Weekly COGS
- Do a physical inventory count on your count day.
- Record all purchases this week at cost, not selling price.
- Calculate this weeks ending inventory value.
- Apply the formula: Beginning Inventory ($1,000) + Purchases ($500) - Ending Inventory ($1,100) = COGS ($400).
- Calculate COGS Percentage: Divide COGS by Revenue. Ideal range is typically 25-35% for most small businesses, but varies by industry.
Stop Doing This Manually.
14-day free trial. No credit card. No POS needed.
Track My First Week Free →Real Example: A Cafes Weekly COGS
| Item | Value |
|---|---|
| Beginning Inventory (Mon 7/1) | $800 |
| Purchases (Tue-Fri) | $450 |
| Ending Inventory (Mon 7/8) | $600 |
| COGS ($800+$450-$600) | $650 |
| Revenue this week | $2,600 |
| COGS % | 25% |
This cafes COGS is 25%, which is healthy. If it were 35%, that would signal overspending or shrinkage.
What Weekly COGS Tells You
High COGS % (over target): supplier costs too high, overbuying, or shrinkage. Action: renegotiate, reduce order quantities, or investigate shrinkage.
Low COGS % (under target): could mean inventory is aging or you are under-counting. Verify count accuracy.
Trending up week-over-week: something changed, investigate immediately.
Stop Doing This Manually.
14-day free trial. No credit card. No POS needed.
Track My First Week Free →Common COGS Calculation Mistakes
Mistake 1: Using selling price instead of cost. Always value inventory at what you paid, not what you sell it for.
Mistake 2: Forgetting to include shrinkage in ending inventory. Ending inventory should reflect what you actually have that is sellable.
Mistake 3: Not including all purchases in the week. Log every supplier purchase the day it arrives.
Mistake 4: Calculating COGS monthly when you count weekly. Calculate on the same cadence as your counts for real-time insight.
FAQ
Whats a healthy COGS percentage for my business?
Varies by industry. Cafes: 25-35%. Retail: 40-50%. Food trucks: 30-40%. Salons: 20-30%.
If my COGS % is too high, what do I fix first?
Check for shrinkage and waste first, then renegotiate supplier costs, reduce order quantities, or raise prices if needed.
Should I calculate COGS for each location separately or company-wide?
Each location. Blending them hides which locations need attention.
Does COGS include labor?
No. COGS is direct material costs only. Labor is a separate operating expense.
Think you know your inventory vocabulary? Prove it.
Six free games built for operators. No signup.