🌳

Mimir Plan 5490

🔍 Audit ← New plan ChartGBT

Master Coil Buy Recommendation — Plan 5490

PPG1 2 · Forecast demand 471,937 lbs · Prepared by Mimir (ChartGBT) ·
PPG1 2
Edge Trim (derived) 0.500″
Forecast Demand 471,937 lbs
Distinct Orders 10
Compatibility Clusters 3
✓ All 10 orders covered
471,937 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 471,937 · 100%
Buy 547,837 lbs = 471,937 covered demand + 75,900 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
70.000″ 🔥 Sweet 13 547,837 lbs 2.3% $43.50/cwtⓘ
~$238,309
 3 clusters
Total 13 547,837 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 45.00″–49.00″, ID 20.00″–20.00″
6 orders · widths 5.512″–21.098″ · 304,793 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
70.00″ 7×
304,793 lbs
 $43.50/cwtⓘ 🔥 Sweet
~$132,585
 1.7% 66.9/70
scrap 98 · cost 86 · cov 100
21.098″, 21.098″, 21.098″, 5.512″
Cluster 2 — OD 35.00″–39.76″, ID 20.00″–20.00″
3 orders · widths 15.264″–19.125″ · 163,044 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
70.00″ 4×
163,044 lbs
 $43.50/cwtⓘ 🔥 Sweet
~$70,924
 1.9% 66.8/70
scrap 98 · cost 86 · cov 100
17.125″, 17.125″, 15.264″, 19.125″
Cluster 3 — OD 54.00″–60.70″, ID 20.00″–20.00″
1 orders · widths 11.000″–11.000″ · 4,100 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
70.00″ 2×
80,000 lbs
 $43.50/cwtⓘ 🔥 Sweet
~$34,800
 5.7% 65.9/70
scrap 94 · cost 86 · cov 100
11.000″, 11.000″, 11.000″, 11.000″, 11.000″, 11.000″