Loading...
Executive Dashboard
$847K
Revenue MTD
↑ 12% vs last mo
31.4%
Gross Margin
↑ 2.1 pts
143
Open Orders
18 past due
$2.1M
Inventory Value
847 coils on hand
$312K
AR Outstanding
$64K over 60d
📈 Revenue — Last 6 Months
$721K
Nov
$698K
Dec
$756K
Jan
$803K
Feb
$756K
Mar
$847K
Apr ↑
🏆 Top Customers (MTD)
Miami Steel Fabricators
32 orders · G90 heavy
$148K
17.5% of rev
Southeast HVAC Supply
28 orders · Aluminized
$112K
13.2%
Doral Roofing Co.
19 orders · Mix
$89K
10.5%
Hialeah Metal Works
14 orders · HRPO
$67K
⚠ Net 60 overdue
📦 Inventory by Product Line
G90 Galvanized
312 coils · Bay A–C
$841K
✓ Healthy
HRPO Hot Rolled
198 coils · Bay D–E
$614K
✓ Healthy
Cold Rolled CR4
89 coils · Bay F
$312K
⚠ Low — reorder
Aluminized AL
248 coils · Bay G
$389K
✓ Healthy
📡 Metal Market Spot Prices Updated: Today 4:00 PM EST
HRC Hot Roll Coil
$724/ton
▲ +4.2% this week — RISING
G90 Galvanized
$0.87/lb
▲ +2.1% this week — RISING
HRPO Hot Rolled
$0.91/lb
→ Stable this week
Cold Rolled CR4
$0.94/lb
▼ −1.8% this week — FALLING
Aluminized AL
$1.05/lb
▲ +0.9% this week
🚦 Buy Signals
G90 ↑ — Buy now before price climbs
CR4 ↓ — Wait, price falling
📈 G90 Price Trajectory — 6 Months
$0.82
Nov
$0.83
Dec
$0.84
Jan
$0.85
Feb
$0.86
Mar
$0.87
Apr ▲
G90 Galvanized $/lb · +6.1% over 6 months · Trend: RISING
🚨 Alerts
⚠️ Cold Rolled CR4 — 89 coils remaining. Reorder point: 100. Suggest PO to Century Metals.
🔴 Hialeah Metal Works — $43K invoice 67 days overdue. Collections call needed.
🔵 3 vendor disputes open — $12,400 in credits pending from Century Metals.
🚛 Fleet Today
Truck 1 — F-750
Driver: Mike R. · 4 of 6 stops done
On Route
ETA last stop 4:30 PM
Truck 2 — F-650
Driver: Carlos V. · 2 of 4 stops done
⚠ Idle 34min
Break flag
Truck 3 — Ram 5500
Driver: Luis M. · Completed
✓ Done
Back at yard 3:12 PM
✓
Scan
›
2
Inspect
›
3
Confirm
›
4
Summary
📷 Scan Delivery Document
📄

Tap to photograph packing slip or BOL

AI extracts line items automatically

✓ Document Scanned
Vendor: Century Metals
BOL: CM-2024-8821 · PO Match: PO-2024-0381
Items detected: 5 coils
Worker
Jesse R. — Slitting Line
4 Jobs Today
Today's Progress1 of 4 complete
WO-2024-0441 · IN PROGRESS
Slit G90 18ga × 48" → 24" strips
📍 Bay A · Section 3-4 · Floor position
Tag: ECM-G90-18-0041 · 19,200 lbs · 3 coils · Order: SO-2024-0881
Active
Cut Instructions: Slit to 24" width. Yield target: 98%. Scrap to bin 3.
WO-2024-0442 · QUEUED
Cut HRPO 11ga × 60" → 120" lengths
📍 Bay D · Section 1-2 · Mid position
Tag: ECM-HRPO-11-0043 · 17,200 lbs · 1 coil · Order: SO-2024-0882
Queued
WO-2024-0443 · QUEUED
Slit Cold Rolled 16ga × 48" → 12" strips
📍 Bay F · Section 2-1 · Top position
Tag: ECM-CR4-16-0044 · 22,000 lbs · 2 coils · Order: SO-2024-0884
Queued
WO-2024-0440 · COMPLETED 10:22 AM
Slit Aluminized 22ga × 36" → 18" strips
✓ Complete — pushed to shipping
Done
Driver
Mike R. — Truck 1
On Route
Route Progress2 of 4 stops delivered
✓
Miami Steel Fabricators
1234 NW 36th St, Miami FL
✓ Delivered 10:18 AM · Signed by: R. Gomez
✓
Southeast HVAC Supply
5678 W 16th Ave, Hialeah FL
✓ Delivered 11:44 AM · Signed by: M. Torres
3
Doral Roofing Co.
910 NW 87th Ave, Doral FL
2 coils G90 18ga + 1 coil HRPO · 48,400 lbs total
Order Items
📦 ECM-G90-18-0041 · G90 18ga × 48" · 19,200 lbs
📦 ECM-G90-18-0042 · G90 18ga × 48" · 11,800 lbs
📦 ECM-HRPO-11-0043 · HRPO 11ga × 60" · 17,400 lbs
Customer Signature
Tap here for customer to sign
4
Hialeah Metal Works
321 E 4th Ave, Hialeah FL
1 coil Cold Rolled 16ga · 22,000 lbs
🚛 T1
⚠ T2
🏁 T3
ECM Yard
🚛 Fleet Status
Truck 1 — Ford F-750
Mike R. · 4 of 6 stops · 89 mi driven
On Route
ETA yard: 5:30 PM
Truck 2 — Ford F-650
Carlos V. · 2 of 4 stops · 44 mi driven
⚠ Idle 34min
Break flag — alert sent
Truck 3 — Ram 5500
Luis M. · All stops done · 67 mi driven
✓ At Yard
Returned 3:12 PM
📊 Route Efficiency — Today
Mike R.
6 stops · 89 mi · 0 idle flags
94%
Efficiency
Carlos V.
4 stops · 44 mi · 1 idle flag (34min)
71%
Below avg
Luis M.
5 stops · 67 mi · 0 idle flags
91%
Efficiency
📦 Deliveries Completed Today
Miami Steel Fabricators
Truck 1 · 10:18 AM
✓ POD
Southeast HVAC Supply
Truck 1 · 11:44 AM
✓ POD
Beacon Roofing Hialeah
Truck 3 · 1:05 PM
✓ POD
Allied Sheet Metal
Truck 2 · 2:22 PM
✓ POD
$214K
Open Quotes
12 pending response
$847K
Closed MTD
↑ 12% vs last mo
🔍 Inventory Availability Check
✓ IN STOCK — 312 coils available
G90 Galv 18ga × 48" · Bay A · Sections 1–4
Nearest coil: ECM-G90-18-0041 · Bay A-3 · 19,200 lbs
Price: $0.84/lb · Min order: 1 coil
📋 Active Quotes
Doral Roofing Co.
Q-2024-0091 · G90 18ga · 5 coils · Sent 2d ago
$42,000
Awaiting response
Florida Panel Systems
Q-2024-0092 · HRPO 11ga · 8 coils · Sent today
$68,400
Awaiting response
SE HVAC Supply
Q-2024-0089 · Aluminized · 3 coils · Sent 4d ago
$24,800
Follow up needed
Allied Sheet Metal
Q-2024-0090 · CR4 16ga · 4 coils · Sent 1d ago
$31,200
✓ Accepted → Order
📦 Active Sales Orders
SO-2024-0881 · Miami Steel Fab
G90 18ga · In production · WO assigned
In Prod
SO-2024-0882 · Doral Roofing
HRPO 11ga · Ready to ship
Ship Ready
SO-2024-0880 · SE HVAC
Aluminized 22ga · Delivered ✓
Delivered
SO-2024-0884 · Allied Sheet Metal
CR4 16ga · New — pending WO
New
💵 My Commission MTD
$4,235
On $847K closed · 0.5% rate
+ $1,060 pending on open orders
$312K
AR Outstanding
$64K over 60 days
$187K
AP Due This Week
4 vendor invoices
$48K
Collected Today
3
Disputes Pending
$12.4K
Credits Due
📬 Accounts Receivable — Aging
Miami Steel Fabricators
INV-2024-0441 · Due Apr 30
$48,200
Current
Doral Roofing Co.
INV-2024-0438 · Due Apr 15
$31,400
15 days overdue
Overdue
SE HVAC Supply
INV-2024-0421 · Due Mar 31
$22,800
30 days overdue
Overdue
Hialeah Metal Works
INV-2024-0398 · Due Feb 28
$43,000
⚠ 67 days
67d
Allied Sheet Metal
INV-2024-0444 · Due May 15
$31,200
Not yet due
🏭 Accounts Payable — Due This Week
Century Metals
PO-2024-0381 · 3-way match ✓
$84,200
Ready to pay
Steel Technologies
PO-2024-0379 · Receiving match ✓
$52,800
Ready to pay
Metals USA
PO-2024-0382 · ⚠ Dispute pending
$38,400
Hold — dispute open
Olympic Steel
PO-2024-0376 · 3-way match ✓
$11,600
Ready to pay
🔗 3-Way Match Status
PO + Receiving Record + Vendor Invoice must all match before payment releases.
Century Metals — PO-0381
PO ✓ · Receiving ✓ · Invoice ✓
✓ Matched
Metals USA — PO-0382
PO ✓ · Receiving ⚠ weight var · Invoice ✓
⚠ Dispute
Steel Tech — PO-0379
PO ✓ · Receiving ✓ · Invoice ✓
✓ Matched
🏷 Vendor Dispute Credits
Century Metals — DSP-0003
Short weight 1,200 lbs · HRPO 11ga
$4,800
Pending credit
Metals USA — DSP-0002
Damaged coil · Cold Rolled 16ga
$7,600
Pending credit
6
Ship Today
4
Dispatched
2
Still Loading
📋 Today's Shipments
SO-2024-0880 · SE HVAC Supply
✓ Dispatched
Truck 1 · Mike R. · 2 coils Aluminized · 21,400 lbs
Dispatched 9:45 AM · POD received 11:44 AM
SO-2024-0878 · Beacon Roofing
✓ Dispatched
Truck 3 · Luis M. · 3 coils G90 · 44,200 lbs
Dispatched 10:15 AM · POD received 1:05 PM
SO-2024-0881 · Doral Roofing
Loading
Truck 1 · Mike R. · 3 coils HRPO + G90 · 48,400 lbs
Scheduled 2:00 PM departure
SO-2024-0884 · Allied Sheet Metal
Loading
Truck 2 · Carlos V. · 2 coils CR4 · 22,000 lbs
Scheduled 3:00 PM departure
📥 Inbound Today (Expected)
Century Metals — PO-2024-0381
5 coils · ETA 2:00 PM · BOL: CM-2024-8821
Expected
Steel Technologies — PO-2024-0382
3 coils · ETA 4:30 PM · Driver: TBD
Expected
🚛 Driver Assignment
Truck 1
Mike R. · 4 stops today
On Route
Truck 2
Carlos V. · 2 stops remain
⚠ Idle
Truck 3
Luis M. · All stops complete
At Yard
847
Total Coils
4 product lines
$2.1M
Total Value
↑ from $1.9M last mo
🔍 Search Inventory
Showing 6 of 6 coils
MaterialLocationWeightStatus
ECM-G90-18-0041
G90 18ga x 48"
Bay A-3
19,200 lbs
Available
ECM-G90-18-0042
G90 18ga x 48"
Bay A-3
11,800 lbs
Allocated
ECM-G90-20-0042
G90 20ga x 36"
Bay A-4
14,800 lbs
Available
ECM-HRPO-11-0043
HRPO 11ga x 60"
Bay D-1
17,200 lbs
Dispute
ECM-CR4-16-0044
CR4 16ga x 48"
Bay F-2
22,000 lbs
Available
ECM-AL-22-0045
Aluminized 22ga x 36"
Bay G-1
9,600 lbs
Available
🗺 Yard Map — Bay Overview
Bay A
G90 Galv
312 coils
Bay D–E
HRPO HR
198 coils
Bay F
Cold Rolled
89 coils ⚠
Bay G
Aluminized
248 coils
⚠️ Reorder Alerts
⚠️ Cold Rolled CR4 — 89 coils (Bay F). Reorder point: 100. Suggest PO to Century Metals for 50 coils.
📊 Inventory by Status
Available
Ready to sell / allocate
698 coils
Allocated
Reserved for open orders
112 coils
Dispute / Hold
Pending vendor resolution
14 coils
In Production
On slitting / cut-to-length line
23 coils
WORKORDERS TAB IS WORKING
LIFECYCLE TAB IS WORKING
REMNANTS TAB IS WORKING
PRICING TAB IS WORKING
CALC TAB IS WORKING