Springstex

Daily Operating Dashboard

Overview
Prototype Loading...
Cash Available
--
Bank balance after clearing
Loading
Total Liquidity
--
Cash + line of credit
Loading
Feb Revenue
--
Breakeven: $569K/mo
Loading
Open Orders
--
Active lines as of 3/4
Loading
Utilization
--
February 2026 capacity
Loading
Gross Margin
--
February 2026
Loading
Yards Shipped*
473
Most recent day (3/2)
Normal: ~300/day
Off Quality
2.4%
Scrap rate (Jan)
$3,029 scrap cost
*Yards Shipped currently uses yards printed. Kevin to confirm if shipped = printed or if separate tracking exists.
Revenue & Orders

Monthly Revenue vs. Breakeven

Working Capital Trend

Daily
Cash & Liquidity

Digital Cash Position

Total Cash
--
Items to Clear
--
Cash Available
--
LOC Available
--
Total Liquidity
--
~3 weeks operating coverage at current burn rate

Debt & Working Capital

External Debt
--
Term loan, expires Jan 2027
Intercompany
--
Digital owes SCPG
AR Outstanding
--
AP Outstanding
--
Net AR-AP Position Loading...
Customer Intelligence

Top Accounts — Revenue, Margin & Risk

CustomerRevenueMarginAR BalanceBacklogRepSignal
Loading customer data...
Demand by Substrate & Order Position

Backlog by Substrate

Order Position — Ship Date Timeline

Inventory

Digital Inventory Pipeline

Enterprise Inventory by Division

Production & Capacity

Capacity Utilization

Daily Production (Most Recent)

Work CenterYardsNotes
Loading...
Profit & Loss

January 2026 P&L

Expense Structure

CategoryMonthly% Revenue
Loading...
For every $1.00 earned, Digital spent $2.07 Shared Services alone ($40,224/mo) consumes 31% of revenue. This is a one-way allocation from SCPG.
Derick's 12 Metrics — Roadmap
#
Metric
Status
Data Source
Automation
1
Yardage Shipped
Ready
Apprise → Power BI daily
Automate
2
Orders Received
Ready
Apprise OOR (6:15 AM daily)
Automate
3
Inventory Charts
Ready
SCPG Trend + Digital Metrics weekly
API Ready
4
Sales Calls
Pending
HubSpot CRM (Alison + Flint)
HubSpot
5
Customer Summaries
Ready
Sales Through + AR aging weekly
API Ready
6
Demand by Greige
Partial
Subcategory available; SKU-level needs Apprise
API Ready
7
Off Quality
Partial
Reprints tracked; full QC not captured
Expand
8
COGS
Ready
Sales Through + P&L GL detail
API Ready
9
Order Position
Ready
Apprise OOR daily (507 lines current)
Automate
10
% Capacity Utilization
Ready
Digital Metrics weekly
API Ready
11
% Budget
Partial
Inventory targets available; full budget TBD
Need Data
12
Expense Breakdown
Ready
Jan P&L received 3/3 (353 GL lines)
API Ready
+
Cash & Liquidity
Ready
Combined Metrics daily at noon (Riley)
Automate
What Automated Looks Like
SPRINGSTEX DAILY BRIEF
Wednesday, March 12, 2026 · 7:30 AM
Good morning, Derick.
Cash & Collections
Cash available: $33,820 · Liquidity: $107,759
AR collected yesterday: $18,400
AP paid: $4,200 (intercompany)
Orders & Production
New orders booked: 14 lines ($21,500)
Yards printed: 473 (Cotton 102, DyeSub 366, Latex 5)
Utilization: 22.1% (target: 60%)
Revenue
March MTD: $48,252 · Pace: $193K/mo
Watch List
3 Rowe orders shipping Friday ($14,971)
Cotton queue: 3.9 weeks at capacity
Lacefield AR: $58K, 42% past 60 days
Simulated daily briefing · Auto-populated from Apprise + Power BI + daily cash report

Automation Phases

Phase 1: Daily Feeds (This Month)
Kevin sets up automatic email delivery:
• Daily BI Report (7:00 AM) — orders, billed, late
• Daily OOR (6:15 AM) — all open orders
• Daily Cash Metrics (noon) — cash, AR, AP
AI processes and dashboard updates automatically.
Phase 2: API Connections (60 days)
Direct connections to:
• Apprise ERP (via Arow/Frank's Power BI)
• HubSpot CRM (Alison & Flint)
Eliminates manual handoff. Real-time data.
Phase 3: Intelligence Layer (90 days)
AI analysis on top of data:
• Anomaly detection & trend forecasting
• Customer health scoring
• Automated watch list generation
From dashboard to decision support.