🌳

Mimir Plan 887

🔍 Audit ← New plan ChartGBT

Master Coil Buy Recommendation — Plan 887

PPG1 5 · Forecast demand 676,188 lbs · Prepared by Mimir (ChartGBT) ·
PPG1 5
Edge Trim (derived) 0.375″
Forecast Demand 676,188 lbs
Distinct Orders 17
Compatibility Clusters 3
✓ All 17 orders covered
676,188 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 676,188 · 100%
Buy 718,188 lbs = 676,188 covered demand + 42,000 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
61.000″ 🔥 Sweet 14 718,188 lbs 1.6% $50.80/cwtⓘ
~$364,840
 3 clusters
Total 14 718,188 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 33.00″–38.05″, ID 20.00″–20.00″
3 orders · widths 11.880″–21.550″ · 42,000 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
61.00″ 2×
84,000 lbs
 $50.80/cwtⓘ 🔥 Sweet
~$42,672
 3.5% 65.0/70
scrap 96 · cost 79 · cov 100
18.110″, 18.110″, 11.880″, 11.880″
Cluster 2 — OD 50.00″–52.84″, ID 20.00″–20.00″
9 orders · widths 2.820″–30.197″ · 428,419 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
61.00″ 8×
428,419 lbs
 $50.80/cwtⓘ 🔥 Sweet
~$217,637
 1.3% 65.5/70
scrap 99 · cost 79 · cov 100
15.000″, 15.000″, 30.197″
Cluster 3 — OD 60.00″–70.00″, ID 24.00″–24.00″
5 orders · widths 7.598″–16.496″ · 205,769 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
61.00″ 4×
205,769 lbs
 $50.80/cwtⓘ 🔥 Sweet
~$104,531
 1.6% 65.4/70
scrap 98 · cost 79 · cov 100
16.000″, 16.000″, 7.598″, 10.236″, 10.236″