Operational Dashboard

Constraint-based inventory and cash flow modeling

Days Until Stockout

30

On-hand: 5,000 units

Cash Position

$50,000

Lowest: $25,708

Total Inventory

30,000

Across all states

Demand Scenario
Model different demand assumptions
Current Inventory & Demand

Per-Flavor Inventory & Demand

5,000 units
150 units/day

Multi-Channel Revenue Model

Shopify Channel

TikTok Channel

Blended Metrics (used in calculations):

Avg AOV:$35.60
Avg Cans/Order:2.78
Avg Net Margin/Can:$6.20

Monthly Overhead Expenses

Total Monthly Burn: $17,800

Inventory State Breakdown

Sellable

5,000

In Production

15,000

Awaiting Canning

10,000

Committed

0

Manufacturers
Tennessee, Daily Manufacturing, Ameripouch

Tennessee

Vanilla
Lead: 8wMOQ: 15,000Cost: $1/unitTerms: 50% deposit

Daily Manufacturing

Mint
Lead: 6wMOQ: 10,000Cost: $1/unitTerms: 30% deposit

Ameripouch

Cinnamon
Lead: 10wMOQ: 20,000Cost: $1/unitTerms: 40% deposit
Production Orders
Track inventory through production stages

Tennessee

in production

Units

15,000

Completion

May 11, 2026

Paid

$9,000

Owed

$9,000

Tennessee

awaiting canning

Units

10,000

Completion

Mar 23, 2026

Paid

$12,000

Owed

$0

Cash Obligations
Next 30 days: $11,000

Rent - Office

Amount: $2,000Due: Mar 21, 2026⏳ Unpaid

Tennessee - Balance Payment

Amount: $9,000Due: Mar 30, 2026⏳ Unpaid
Reorder Recommendations
Based on Base demand scenario

Daily Manufacturing

🔴 Order NOW (Mint) - Stockout in 30 days(12 days behind)

Action Required

Recommended Units

10,000

Total Cost

$13,500

Deposit Required

$4,050

Expected Delivery

Apr 27, 2026

Tennessee

🔴 Order NOW (Vanilla) - Stockout in 25 days(31 days behind)

Action Required

Recommended Units

15,000

Total Cost

$18,000

Deposit Required

$9,000

Expected Delivery

May 11, 2026

Ameripouch

🔴 Order NOW (Cinnamon) - Stockout in 13 days(57 days behind)

Action Required

Recommended Units

20,000

Total Cost

$23,000

Deposit Required

$9,200

Expected Delivery

May 25, 2026

Flavor Inventory Breakdown
Per-flavor stockout projections

Vanilla

On-hand:2,000 units
Daily demand:60 units/day
Stockout in:25 days
Apr 10, 2026

Mint

On-hand:2,000 units
Daily demand:50 units/day
Stockout in:30 days
Apr 15, 2026

Cinnamon

On-hand:1,000 units
Daily demand:40 units/day
Stockout in:12 days
Mar 28, 2026
Growth Jump Timeline
Can you afford the next deposit? And the one after that?

Without fundraising: covers 0 jumps

Short $1,227 on Jump 1

Fundraise Recommendation

To cover more jumps and extend your growth runway:

With $0:Covers 0 jumps
With $1,227:Covers 1 jump (minimum to complete Jump 1)
With $2,453:Likely covers 1 jump
With $3,680:Likely covers 1 jump

💡 Tip: Enter different fundraise amounts above to see exact coverage for each jump

Jump-by-Jump Breakdown

Jump 1: Vanilla

Tennessee • 15,000 units

$18,000

Total cost

Deposit (immediate)

$9,000

Mar 16

Cash: $50,000

✅ Covered

Balance (at completion)

$9,000

May 11

Cash: $7,773

❌ Short $1,227

Demand at order: 66 units/day

Demand at arrival: 66 units/day

Inventory arrives: May 11, 2026

🎯 Decision-Focused Fundraising Analysis

Answering three operational questions: survival, completion, and growth ceiling

Self-Sustaining Baseline
$50,000
Projected cash at next reorder
Recommended Fundraise
$79,480
To complete orders + 3mo ops
3-month cash need$118,900
Deposits (immediate):$22,250
Balances (at completion):$32,250
Overhead (3 months):$53,400
Existing obligations:$11,000

A. Do we survive until inventory is sellable?

Lowest Cash Point

$25,708

May 11, 2026

Inventory Sellable

Apr 5, 2026

✅ Survives with $25,708 buffer

How is this calculated?

Lowest Cash Point Calculation:

Starting Cash: $24,292

- Deposits (immediate): Varies by reorders

- Balance payments (at completion): Varies by dates

- Overhead burn: $8,097 per month (approx)

+ Revenue (if any): Zero until inventory sellable

= Lowest Point: $25,708

B. Can we finish what we start?

TennesseeVanilla
Deposit (immediate)
$9,000✓ Covered
Balance due May 11, 2026
$9,000✗ Short
Projected cash on balance date$7,773

⚠️ Order will stall at final payment unless additional $1,227 is raised by May 11, 2026

Daily ManufacturingMint
Deposit (immediate)
$4,050✓ Covered
Balance due Apr 27, 2026
$9,450✓ Covered
Projected cash on balance date$21,030

✅ Order can be fully completed

AmeripouchCinnamon
Deposit (immediate)
$9,200✓ Covered
Balance due May 25, 2026
$13,800✗ Short
Projected cash on balance date-$733

⚠️ Order will stall at final payment unless additional $14,533 is raised by May 25, 2026

C. What growth level breaks the system?

Current Daily Demand

150 units/day

Maximum Sustainable

89 units/day

📊 Headroom: -40%

At current cash and lead times, demand above 89 units/day creates a stockout before the next reorder completes.

Implied ad spend ceiling: $4,464/day (assuming $50 CAC)

D. When do we become self-sustaining?

⚠️ Not self-sustaining within 12 months

At current margins and growth rate, revenue does not fully cover recurring inventory costs + overhead. Additional capital may be needed.

MonthRevenueInventoryOverheadNet FlowCash Position
M1$29,295$0$17,800+$11,495$61,495
M2$30,760$20,029$17,800-$7,069$54,426
M3$32,298$0$17,800+$14,498$68,924
M4$33,913$22,082$17,800-$5,969$62,955
M5$35,608$0$17,800+$17,808$80,763
M6$37,389$24,345$17,800-$4,756$76,007

Showing first 6 months. Net Flow = Revenue - Inventory - Overhead.

Inventory Depletion Projection
90-day forecast under base demand scenario
Mar 16Mar 26Apr 5Apr 15Apr 25May 5May 15May 25Jun 401,5003,0004,5006,000
  • Inventory (units)
Cash Flow Projection
90-day cash position forecast
Mar 16Mar 26Apr 5Apr 15Apr 25May 5May 15May 25Jun 4$0k$15k$30k$45k$60k
  • Cash Balance
Revenue vs Inventory Availability
Daily revenue generation tied to inventory levels
Mar 16Mar 23Mar 30Apr 6Apr 13Apr 20Apr 27May 4May 11May 18May 25Jun 1Jun 8$0k$0k$1k$1k$1k
  • Daily Revenue
Cash Gap Timeline
Projected cash position through inventory constraints

Current Cash

$50,000

Lowest Cash Point

$25,708

May 11, 2026

Inventory Sellable

Apr 5, 2026

Revenue Resumes

Continuous