🌳

Mimir Plan 1886

🔍 Audit ← New plan ChartGBT

Master Coil Buy Recommendation — Plan 1886

PPG1 5 · Forecast demand 396,417 lbs · Prepared by Mimir (ChartGBT) ·
PPG1 5
Edge Trim (derived) 0.375″
Forecast Demand 396,417 lbs
Distinct Orders 9
Compatibility Clusters 3
✓ All 9 orders covered
396,417 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 396,417 · 100%
Buy 453,856 lbs = 396,417 covered demand + 57,439 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
71.000″ 🔥 Sweet 10 453,856 lbs 2.0% $50.80/cwtⓘ
~$230,559
 3 clusters
Total 10 453,856 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 31.50″–40.00″, ID 20.00″–20.00″
2 orders · widths 4.252″–10.158″ · 127,535 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
71.00″ 3×
127,535 lbs
 $50.80/cwtⓘ 🔥 Sweet
~$64,788
 2.2% 65.3/70
scrap 98 · cost 79 · cov 100
10.158″, 10.158″, 10.158″, 10.158″, 10.158″, 10.158″, 4.252″, 4.252″
Cluster 2 — OD 50.00″–53.71″, ID 20.00″–20.00″
5 orders · widths 6.890″–20.472″ · 211,443 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
71.00″ 5×
211,443 lbs
 $50.80/cwtⓘ 🔥 Sweet
~$107,413
 1.3% 65.5/70
scrap 99 · cost 79 · cov 100
10.520″, 10.520″, 8.125″, 20.472″, 20.472″
Cluster 3 — OD 60.00″–69.25″, ID 20.00″–20.00″
2 orders · widths 7.250″–20.551″ · 57,439 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
71.00″ 2×
114,878 lbs
 $50.80/cwtⓘ 🔥 Sweet
~$58,358
 2.9% 65.1/70
scrap 97 · cost 79 · cov 100
20.551″, 20.551″, 20.551″, 7.250″