🌳

Mimir Plan 5274

🔍 Audit ← New plan ChartGBT

Master Coil Buy Recommendation — Plan 5274

PPG1 2 · Forecast demand 716,978 lbs · Prepared by Mimir (ChartGBT) ·
PPG1 2
Edge Trim (derived) 0.500″
Forecast Demand 716,978 lbs
Distinct Orders 13
Compatibility Clusters 3
✓ All 13 orders covered
716,978 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 716,978 · 100%
Buy 735,686 lbs = 716,978 covered demand + 18,708 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″ 15 735,686 lbs 1.6% $41.45/cwtⓘ
~$304,942
 3 clusters
Total 15 735,686 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 58.00″–58.00″, ID 20.00″–24.00″
6 orders · widths 5.095″–19.375″ · 286,110 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
72.00″ 7×
286,110 lbs
 $41.45/cwtⓘ
~$118,593
 1.4% 67.0/70
scrap 99 · cost 88 · cov 99
8.250″, 8.250″, 8.250″, 8.250″, 9.500″, 9.500″, 9.500″, 9.500″
Cluster 2 — OD 45.00″–50.68″, ID 20.00″–20.00″
3 orders · widths 1.250″–12.500″ · 85,959 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
72.00″ 2×
104,667 lbs
 $41.45/cwtⓘ
~$43,384
 1.6% 67.3/70
scrap 98 · cost 88 · cov 100
1.250″, 1.250″, 1.250″, 1.500″, 1.500″, 1.500″, 12.500″, 12.500″ +3 more
Cluster 3 — OD 60.00″–70.25″, ID 20.00″–20.00″
4 orders · widths 4.000″–18.945″ · 344,909 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
72.00″ 6×
344,909 lbs
 $41.45/cwtⓘ
~$142,965
 1.8% 67.3/70
scrap 98 · cost 88 · cov 100
9.961″, 4.000″, 4.000″, 4.000″, 4.000″, 4.000″, 4.000″, 4.000″ +2 more