🌳

Mimir Plan 52

🔍 Audit ← New plan ChartGBT

Master Coil Buy Recommendation — Plan 52

PPG1 1 · Forecast demand 460,783 lbs · Prepared by Mimir (ChartGBT) ·
PPG1 1
Edge Trim (derived) 0.375″
Forecast Demand 460,783 lbs
Distinct Orders 9
Compatibility Clusters 3
✓ All 9 orders covered
460,783 forecast lbs — all within the 71.25″ usable master width and sized into a tonnage-sufficient buy. The slitter allocates strips across the coils post-delivery.
COVERED 460,783 · 100%
Buy 538,733 lbs = 460,783 covered demand + 77,950 master-form / scrap (capital tied up, not a shortfall).

Buy list — 1 master width to order

Master Width Coils Tonnage Avg Scrap $/CWT · Est. Total Serves
54.000″ 🔥 Sweet 10 538,733 lbs 2.9% $49.08/cwtⓘ
~$264,410
 3 clusters
Total 10 538,733 lbs

Trade-off Weights (ChartGBT-aligned, max composite = 70)

0.25
0.2
0.25
💰 Save money ⚖ Balanced 🎯 Cover demand ♻ Yield-priority
Cluster 1 — OD 50.00″–58.22″, ID 20.00″–20.00″
6 orders · widths 1.700″–12.125″ · 351,733 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
54.00″ 6×
351,733 lbs
 $49.08/cwtⓘ 🔥 Sweet
~$172,631
 1.4% 65.8/70
scrap 99 · cost 81 · cov 100
3.500″, 3.500″, 3.500″, 12.125″, 6.800″, 6.800″, 6.800″, 6.800″ +2 more
Cluster 2 — OD 62.00″–72.00″, ID 20.00″–24.00″
1 orders · widths 8.250″–8.250″ · 2,050 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
54.00″ 2×
80,000 lbs
 $49.08/cwtⓘ 🔥 Sweet
~$39,264
 8.3% 64.1/70
scrap 92 · cost 81 · cov 100
8.250″, 8.250″, 8.250″, 8.250″, 8.250″, 8.250″
Cluster 3 — OD 30.00″–40.16″, ID 20.00″–20.00″
2 orders · widths 25.984″–26.063″ · 107,000 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
54.00″ 2×
107,000 lbs
 $49.08/cwtⓘ 🔥 Sweet
~$52,516
 3.5% 56.8/70
scrap 96 · cost 81 · cov 66
26.063″, 26.063″