🌳

Mimir Plan 1232

🔍 Audit ← New plan ChartGBT

Master Coil Buy Recommendation — Plan 1232

PPG1 2 · Forecast demand 1,105,692 lbs · Prepared by Mimir (ChartGBT) ·
PPG1 2
Edge Trim (derived) 0.500″
Forecast Demand 1,105,692 lbs
Distinct Orders 12
Compatibility Clusters 3
✓ All 12 orders covered
1,105,692 forecast lbs — all within the 71.00″ usable master width and sized into a tonnage-sufficient buy. The slitter allocates strips across the coils post-delivery.
COVERED 1,105,692 · 100%
Buy 1,168,141 lbs = 1,105,692 covered demand + 62,449 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
72.000″ 25 1,168,141 lbs 1.5% $41.45/cwtⓘ
~$484,194
 3 clusters
Total 25 1,168,141 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 62.00″–65.29″, ID 20.00″–20.00″
5 orders · widths 2.362″–17.716″ · 652,164 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
72.00″ 14×
652,164 lbs
 $41.45/cwtⓘ
~$270,322
 1.4% 67.4/70
scrap 99 · cost 88 · cov 100
9.579″, 9.579″, 9.579″, 9.579″, 9.579″, 2.362″, 2.362″, 6.125″ +2 more
Cluster 2 — OD 50.00″–50.50″, ID 20.00″–20.00″
4 orders · widths 5.500″–14.803″ · 435,977 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
72.00″ 9×
435,977 lbs
 $41.45/cwtⓘ
~$180,712
 1.5% 67.3/70
scrap 98 · cost 88 · cov 100
14.803″, 14.040″, 14.040″, 14.040″, 14.040″
Cluster 3 — OD 39.00″–40.34″, ID 20.00″–20.00″
3 orders · widths 5.500″–16.188″ · 17,551 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
72.00″ 2×
80,000 lbs
 $41.45/cwtⓘ
~$33,160
 2.0% 67.2/70
scrap 98 · cost 88 · cov 100
16.188″, 16.188″, 5.500″, 5.500″, 5.500″, 5.500″, 5.500″, 5.500″ +1 more