🌳

Mimir Plan 664 · Audit

Forecast demand421,737 lbs

Orders27

Covered27

Short0

Buy vs forecast102%

Forecast windowAug · Sep · Oct

Each order's forecast over the next 3 months and how the recommended cut pattern serves it. In pattern = strips of this order's width in the cluster's sample cut pattern (per coil). The slitter rotates several patterns across the coils, so a width not in the sample is still cut “via rotation.” Mimir buys enough cluster tonnage; the exact per-order pounds are the slitter's post-delivery allocation — so this is fulfillment evidence, not a per-order guarantee. Buy vs forecast = the master tonnage recommended for this order's cluster, proportioned to the order, as a % of its forecast. Over 100% is the over-buy needed to hit mill-minimums, the liquidity floor, and pattern/coil rounding — capital that lands as master-form inventory, not a shortfall. Rows in red are left short.

Master coil layout map

Each cluster's real master coil from PIW geometry (OD² = ID² + 4·W ÷ (ρ·π·width), ρ = 0.283 lb/in³) — width × OD × ID, the geometry-bound coil weight, and how every strip rewinds into finished coils (“series”) at the spec OD. Buy % is whole-coil buy ÷ forecast; over 100% is real coil-rounding / OD-class over-buy (capital as master-form inventory), not a shortfall. Each card also shows the chosen cut pattern's % scrap, predicted $/cwt to run (hover for the basis), and reworks (lbs of narrow strips needing a repass).

Cluster 1 infeasible — no buyable coil

🛑 OD specs conflict — hard floor 65.0" exceeds ceiling 58.0"; check MXODFR/MXODTO data

Cluster 2 53″W × 64.6″OD × 20″ID multi-series rewind

Coil weight44,492 lb

PIW839.5 lb/in

Coils3

Spec OD window45.0–56.5″

Demand133,475 lb

Buy133,475 lb

Buy vs forecast100%

% Scrap1.9%

$/cwt to run$44.71

Reworksnone

Series9 multi

Cut pattern (per coil): 7.953″ + 3.480″ + 3.480″ + 3.480″ + 12.087″ + 9.720″ + 5.900″ + 5.900″

Strip width	Lbs / master	Finished coils	Each	Finished OD
26.575″	22,309 lb	2×	11,154 lb	47.8″
12.087″	10,146 lb	2×	5,073 lb	47.8″
9.720″	8,160 lb	2×	4,080 lb	47.8″
8.071″	6,775 lb	2×	3,388 lb	47.8″
7.953″	6,676 lb	2×	3,338 lb	47.8″
7.717″	6,478 lb	2×	3,239 lb	47.8″
6.250″	5,247 lb	2×	2,623 lb	47.8″
5.900″	4,953 lb	2×	2,476 lb	47.8″
3.480″	2,921 lb	2×	1,461 lb	47.8″

Cluster 3 53″W × 61.6″OD × 20″ID multi-series rewind OD-floored

Coil weight40,000 lb

PIW754.7 lb/in

Coils2

Spec OD window40.0–49.4″

Demand71,598 lb

Buy80,000 lb

Buy vs forecast112%

Over-buy8,402 lb

% Scrap1.9%

$/cwt to run$44.71

Reworksnone

Series7 multi

Cut pattern (per coil): 4.875″ + 8.625″ + 13.850″ + 13.850″ + 5.400″ + 5.400″

Strip width	Lbs / master	Finished coils	Each	Finished OD
13.850″	10,453 lb	2×	5,226 lb	45.8″
8.625″	6,509 lb	2×	3,255 lb	45.8″
7.748″	5,848 lb	2×	2,924 lb	45.8″
5.400″	4,075 lb	2×	2,038 lb	45.8″
4.875″	3,679 lb	2×	1,840 lb	45.8″
3.450″	2,604 lb	2×	1,302 lb	45.8″
3.155″	2,381 lb	2×	1,191 lb	45.8″

Order	Width	Forecast (Aug · Sep · Oct)	Total	Served by	In pattern	Buy vs Forecast	Cover
422356083	9.900″	30.3k · 23.0k · 26.5k	79,776 lbs	Cluster 1 · 53.00″	1 strip/coil	100% 79,776 lbs buy	✓ covered
423235060	15.600″	15.0k · 15.0k · 15.0k	45,000 lbs	Cluster 1 · 53.00″	via rotation	100% 45,000 lbs buy	✓ covered
420286020	9.375″	40.0k · 0.0k · 0.0k	40,000 lbs	Cluster 1 · 53.00″	via rotation	100% 40,000 lbs buy	✓ covered
413219041	13.850″	11.2k · 5.6k · 11.2k	27,998 lbs	Cluster 3 · 53.00″	2 strips/coil	112% 31,284 lbs buy	✓ covered
423110011	7.953″	7.6k · 11.4k · 7.6k	26,600 lbs	Cluster 2 · 53.00″	1 strip/coil	100% 26,600 lbs buy	✓ covered
422160005	6.000″	0.0k · 0.0k · 20.0k	20,000 lbs	Cluster 1 · 53.00″	2 strips/coil	100% 20,000 lbs buy	✓ covered
413092018	5.400″	6.2k · 6.2k · 6.2k	18,612 lbs	Cluster 3 · 53.00″	2 strips/coil	112% 20,796 lbs buy	✓ covered
424029070	8.071″	4.5k · 6.8k · 6.8k	18,000 lbs	Cluster 2 · 53.00″	via rotation	100% 18,000 lbs buy	✓ covered
424008010	26.575″	17.7k · 0.0k · 0.0k	17,700 lbs	Cluster 2 · 53.00″	via rotation	100% 17,700 lbs buy	✓ covered
419212024	3.480″	7.4k · 0.0k · 7.4k	14,800 lbs	Cluster 2 · 53.00″	3 strips/coil	100% 14,800 lbs buy	✓ covered
417250030	9.720″	0.0k · 0.0k · 14.0k	14,000 lbs	Cluster 2 · 53.00″	1 strip/coil	100% 14,000 lbs buy	✓ covered
418298020	7.717″	7.0k · 0.0k · 7.0k	14,000 lbs	Cluster 2 · 53.00″	via rotation	100% 14,000 lbs buy	✓ covered
419206025	8.500″	0.0k · 13.3k · 0.0k	13,270 lbs	Cluster 1 · 53.00″	1 strip/coil	100% 13,270 lbs buy	✓ covered
425322101	6.250″	0.0k · 7.0k · 4.0k	11,000 lbs	Cluster 2 · 53.00″	via rotation	100% 11,000 lbs buy	✓ covered
425262054	5.400″	5.0k · 0.0k · 5.0k	10,000 lbs	Cluster 1 · 53.00″	4 strips/coil	100% 10,000 lbs buy	✓ covered
413350029	5.900″	4.7k · 2.3k · 2.3k	9,375 lbs	Cluster 2 · 53.00″	2 strips/coil	100% 9,375 lbs buy	✓ covered
422217028	12.087″	4.0k · 0.0k · 4.0k	8,000 lbs	Cluster 2 · 53.00″	1 strip/coil	100% 8,000 lbs buy	✓ covered
420311014	7.748″	2.5k · 2.7k · 2.8k	7,988 lbs	Cluster 3 · 53.00″	via rotation	112% 8,925 lbs buy	✓ covered
413092017	3.450″	1.5k · 1.5k · 3.0k	6,000 lbs	Cluster 3 · 53.00″	via rotation	112% 6,704 lbs buy	✓ covered
413092028	8.625″	4.0k · 0.0k · 2.0k	6,000 lbs	Cluster 3 · 53.00″	1 strip/coil	112% 6,704 lbs buy	✓ covered
421074125	8.000″	3.2k · 0.0k · 0.0k	3,169 lbs	Cluster 1 · 53.00″	via rotation	100% 3,169 lbs buy	✓ covered
413092022	4.875″	1.0k · 1.0k · 1.0k	3,000 lbs	Cluster 3 · 53.00″	1 strip/coil	112% 3,352 lbs buy	✓ covered
417296003	4.500″	2.0k · 0.0k · 0.0k	2,000 lbs	Cluster 1 · 53.00″	via rotation	100% 2,000 lbs buy	✓ covered
413092019	3.155″	1.0k · 0.0k · 1.0k	2,000 lbs	Cluster 3 · 53.00″	via rotation	112% 2,235 lbs buy	✓ covered
421074126	7.437″	1.1k · 0.6k · 0.0k	1,704 lbs	Cluster 1 · 53.00″	via rotation	100% 1,704 lbs buy	✓ covered
413343024	8.188″	0.0k · 0.0k · 1.7k	1,687 lbs	Cluster 1 · 53.00″	via rotation	100% 1,687 lbs buy	✓ covered
423039016	8.000″	0.0k · 0.1k · 0.0k	58 lbs	Cluster 1 · 53.00″	via rotation	100% 58 lbs buy	✓ covered