Back to BlogMetrics & KPIs

5 Financial Metrics Every CPG Founder Should Track Weekly

Feb 8, 20266 min read

Most CPG founders check their bank balance every day but look at their financials once a month — or once a quarter. That gap between instinct and information is where bad decisions get made.

The 30-Minute Rule

You do not need a 50-metric dashboard. You need five numbers, updated weekly, that tell you whether your business is healthy or heading toward trouble. They take 30 minutes to update each week — and they will change the way you run your business.
01

Cash Runway

Cash runway is the number of weeks (or months) until your bank account hits zero, based on your current burn rate. It is the single most important number for any CPG brand that is not yet profitable.

How to Calculate Cash Runway

Current cash balance$250,000
Avg weekly net cash burn (4–8 wks)$12,500
Cash runway20 weeks

Net cash burn means total cash out minus total cash in — not just expenses, but actual cash movements including inventory purchases, collections, and debt service.

Cash Runway Benchmarks

Danger zone< 4 months
Minimum target6 months
Fundraise trigger9–12 months
Comfortable12+ months

Red Flags

  • Runway below 4 months without an active fundraise or credit line
  • Runway decreasing for 4+ consecutive weeks — your burn is accelerating
  • A large inventory purchase or co-man run that will cut runway by 6+ weeks in a single hit
02

Gross Margin by SKU

Your gross margin at the individual SKU level — revenue minus COGS for each product you sell. Not blended across your portfolio, but broken out so you can see which products are carrying the business and which are dragging it down.

SKU-Level Margin Formula

Net revenue (after discounts)$24.00
Ingredients−$4.80
Packaging−$2.40
Co-man fees−$3.60
Inbound freight−$1.20
Gross margin$12.00 (50%)

Target Gross Margins by Category

Personal care & household55–70%
Beverages50–65%
Snacks & shelf-stable food40–55%
Refrigerated & frozen35–50%

Pro Tip

If any SKU is consistently below 35% gross margin, you need to either raise the price, renegotiate your COGS, or seriously consider discontinuing it. Low-margin SKUs consume working capital and warehouse space that could be allocated to higher-performing products.

Red Flags

  • Any SKU with gross margins below 30% — almost certainly unprofitable after trade spend and fulfillment
  • Margins declining 3+ consecutive weeks without a known cause
  • A low-margin SKU representing a disproportionate share of sales volume
03

Inventory Weeks on Hand

Inventory weeks on hand tells you how many weeks your current inventory will last at your current rate of sales. It is the bridge between your supply chain and your cash flow — too many weeks and you have cash trapped in product, too few and you risk stock-outs.

How to Calculate Weeks on Hand

Total inventory value (at cost)$180,000
Avg weekly COGS (last 4 weeks)$22,500
Weeks on hand8.0 weeks

Inventory Weeks on Hand — Healthy Ranges

Lean (short lead times only)2–4 weeks
Healthy range4–8 weeks
Getting heavy8–12 weeks
Cash problem12+ weeks

Red Flags

  • Weeks on hand increasing while sales velocity is flat or declining
  • A specific SKU with 16+ weeks on hand — candidate for write-off or liquidation
  • Below 3 weeks with a 4-week production lead time — stock-out risk that could cost retailer placements
04

Customer Acquisition Cost

Customer acquisition cost measures how much you spend to acquire a new customer. In CPG this applies differently across channels — for DTC, it is a straightforward marketing spend calculation. For retail, it encompasses trade spend, slotting fees, and demos needed to establish a product in a new door.

DTC CAC Calculation

Weekly marketing & ad spend$5,000
Influencer & promo costs$1,200
New customers acquired248
CAC per customer$25.00

DTC CAC as % of First-Order Revenue

Excellent< 20%
Healthy target< 30%
Needs attention30–50%
Unsustainable> 50%

Pro Tip

For retail (per door): Track the total investment per door — slotting fees, free fills, demo costs, broker commissions — and measure it against annual gross profit per door. You should recoup your per-door investment within 6 to 9 months.

Red Flags

  • DTC CAC exceeding 50% of first-order revenue — only works with a very high repeat rate
  • CAC increasing for 4+ consecutive weeks — audience saturation or creative fatigue
  • High retail launch costs per door with low initial velocity
05

Accounts Receivable Aging

Accounts receivable aging breaks down how much money is owed to you and how long it has been outstanding. In CPG, where retailer and distributor payment terms can be long and deductions are common, AR aging is your early warning system for cash collection problems.

AR Aging — Healthy Distribution

Current (within terms)≥ 85%
1–30 days past due~10%
31–60 days past due< 5%
60+ days past due< 5%
90+ days past due~0%

Key Insight

Bucket your outstanding receivables into aging categories — current, 1–30 days past due, 31–60, 61–90, and 90+. Track both the total dollar amount and the percentage of total AR in each bucket every week.

Red Flags

  • Total AR growing faster than revenue — you are shipping more but not collecting proportionally
  • A single large customer moving into the 60+ day bucket — signals financial trouble or a dispute
  • Unexplained deductions appearing consistently — deduction recovery can represent 2–4% of gross revenue

Putting It All Together

These five metrics take 30 minutes to update once you have the systems in place. Set up a simple dashboard — a spreadsheet works fine — and update it every Monday morning. Review it with your leadership team or your fractional CFO weekly.

Why Five Metrics Together

The power is not in any single metric but in seeing them together. When cash runway is shrinking, gross margins are flat, and AR aging is getting worse all at the same time, you have a clear and urgent problem. When inventory weeks on hand are dropping while velocity is increasing, you have a supply chain risk to manage.

Your Weekly Dashboard Checklist

1. Cash runway__ weeks
2. Gross margin by top 5 SKUs__ %
3. Inventory weeks on hand__ weeks
4. Customer acquisition cost$__
5. AR aging (% current)__ %

Bottom Line

The CPG founders who track these numbers weekly make faster, better decisions. They catch problems before they become crises. And they walk into investor meetings and board conversations with the confidence that comes from actually knowing their numbers.

Need help with your CPG finances?

We help CPG brands get their numbers right — so they can make better decisions and grow profitably.

Book a Free Consultation