🌳

Mimir Plan 2243

🔍 Audit ← New plan ChartGBT

Master Coil Buy Recommendation — Plan 2243

PPG1 1 · Forecast demand 756,356 lbs · Prepared by Mimir (ChartGBT) ·
PPG1 1
Edge Trim (derived) 0.375″
Forecast Demand 756,356 lbs
Distinct Orders 25
Compatibility Clusters 5
✓ All 25 orders covered
756,356 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 756,356 · 100%
Buy 901,296 lbs = 756,356 covered demand + 144,940 master-form / scrap (capital tied up, not a shortfall).

Buy list — 2 master widths to order

Master Width Coils Tonnage Avg Scrap $/CWT · Est. Total Serves
61.000″ 🔥 Sweet 18 821,296 lbs 2.3% $49.79/cwtⓘ
~$408,923
 4 clusters
55.000″ 🔥 Sweet 2 80,000 lbs 1.9% $49.08/cwtⓘ
~$39,264
 1 cluster
Total 20 901,296 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 30.00″–34.00″, ID 24.00″–24.00″
1 orders · widths 26.968″–26.968″ · 7,060 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
55.00″ 2×
80,000 lbs
 $49.08/cwtⓘ 🔥 Sweet
~$39,264
 1.9% 65.7/70
scrap 98 · cost 81 · cov 100
26.968″, 26.968″
Cluster 2 — OD 41.00″–42.00″, ID 20.00″–20.00″
6 orders · widths 4.750″–26.126″ · 159,780 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
61.00″ 3×
159,780 lbs
 $49.79/cwtⓘ 🔥 Sweet
~$79,554
 1.4% 63.4/70
scrap 99 · cost 80 · cov 91
4.750″, 4.750″, 4.750″, 4.750″, 8.250″, 8.250″, 8.250″, 8.250″ +1 more
Cluster 3 — OD 60.00″–60.00″, ID 20.00″–24.00″
16 orders · widths 5.700″–26.968″ · 443,113 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
61.00″ 10×
443,113 lbs
 $49.79/cwtⓘ 🔥 Sweet
~$220,626
 1.2% 59.8/70
scrap 99 · cost 80 · cov 76
18.618″, 18.618″, 13.583″, 9.420″
Cluster 4 — OD 45.00″–52.67″, ID 20.00″–20.00″
1 orders · widths 28.543″–28.543″ · 8,000 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
61.00″ 2×
80,000 lbs
 $49.79/cwtⓘ 🔥 Sweet
~$39,832
 6.4% 64.4/70
scrap 94 · cost 80 · cov 100
28.543″, 28.543″
Cluster 5 — OD 62.00″–72.00″, ID 24.00″–24.00″
1 orders · widths 14.600″–14.600″ · 138,403 lbs
Master Width Buy $/CWT · Total Scrap Composite Strip Pattern
61.00″ 3×
138,403 lbs
 $49.79/cwtⓘ 🔥 Sweet
~$68,911
 4.3% 65.0/70
scrap 96 · cost 80 · cov 100
14.600″, 14.600″, 14.600″, 14.600″