🌳

Mimir Plan 5975

🔍 Audit ← New plan ChartGBT

Master Coil Buy Recommendation — Plan 5975

PPG1 2 · Forecast demand 1,285,843 lbs · Prepared by Mimir (ChartGBT) ·
PPG1 2
Edge Trim (derived) 0.500″
Forecast Demand 1,285,843 lbs
Distinct Orders 16
Compatibility Clusters 3
✓ All 16 orders covered
1,285,843 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,285,843 · 100%
Buy 1,340,771 lbs = 1,285,843 covered demand + 54,928 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
65.000″ 🔥 Sweet 29 1,340,771 lbs 1.7% $43.50/cwtⓘ
~$583,235
 3 clusters
Total 29 1,340,771 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″–63.00″, ID 20.00″–20.00″
10 orders · widths 5.450″–24.495″ · 845,631 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
65.00″ 18×
845,631 lbs
 $43.50/cwtⓘ 🔥 Sweet
~$367,849
 1.6% 66.3/70
scrap 98 · cost 86 · cov 98
11.695″, 11.695″, 11.695″, 8.395″, 20.501″
Cluster 2 — OD 51.00″–60.00″, ID 20.00″–24.00″
4 orders · widths 2.250″–23.100″ · 385,284 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
65.00″ 9×
385,284 lbs
 $43.50/cwtⓘ 🔥 Sweet
~$167,599
 1.8% 64.6/70
scrap 98 · cost 86 · cov 91
2.250″, 2.250″, 2.250″, 2.250″, 13.745″, 13.745″, 13.745″, 13.745″
Cluster 3 — OD 36.00″–47.93″, ID 20.00″–20.00″
2 orders · widths 7.025″–8.095″ · 54,928 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
65.00″ 2×
109,856 lbs
 $43.50/cwtⓘ 🔥 Sweet
~$47,787
 2.0% 66.8/70
scrap 98 · cost 86 · cov 100
8.095″, 8.095″, 8.095″, 8.095″, 8.095″, 8.095″, 8.095″, 7.025″