🌳

Mimir Plan 5463 · Audit

Forecast demand794,323 lbs

Orders35

Covered35

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 69″W × 65.6″OD × 20″ID multi-series rewind

Coil weight59,812 lb

PIW866.8 lb/in

Coils8

Spec OD window33.0–40.6″

Demand478,498 lb

Buy478,498 lb

Buy vs forecast100%

% Scrap1.1%

$/cwt to run$49.79

Reworksnone

Series17 multi

Cut pattern (per coil): 15.984″ + 18.980″ + 9.449″ + 15.250″ + 8.583″

Strip width	Lbs / master	Finished coils	Each	Finished OD
39.500″	34,240 lb	4×	8,560 lb	37.1″
37.495″	32,502 lb	4×	8,126 lb	37.1″
21.750″	18,854 lb	4×	4,713 lb	37.1″
18.980″	16,453 lb	4×	4,113 lb	37.1″
15.984″	13,856 lb	4×	3,464 lb	37.1″
15.590″	13,514 lb	4×	3,379 lb	37.1″
15.250″	13,219 lb	4×	3,305 lb	37.1″
14.291″	12,388 lb	4×	3,097 lb	37.1″
12.750″	11,052 lb	4×	2,763 lb	37.1″
12.441″	10,784 lb	4×	2,696 lb	37.1″
9.449″	8,191 lb	4×	2,048 lb	37.1″
8.583″	7,440 lb	4×	1,860 lb	37.1″
7.913″	6,860 lb	4×	1,715 lb	37.1″
6.929″	6,006 lb	4×	1,502 lb	37.1″
6.693″	5,802 lb	4×	1,450 lb	37.1″
6.339″	5,495 lb	4×	1,374 lb	37.1″
4.921″	4,266 lb	4×	1,066 lb	37.1″

Cluster 3 69″W × 60.0″OD × 20″ID 1 series / strip OD-floored

Coil weight49,077 lb

PIW711.3 lb/in

Coils4

Spec OD window60.0–72.0″

Demand183,468 lb

Buy196,307 lb

Buy vs forecast107%

Over-buy12,839 lb

% Scrap1.6%

$/cwt to run$49.79

Reworksnone

Series3

Cut pattern (per coil): 7.480″ + 7.480″ + 7.480″ + 9.075″ + 9.075″ + 9.075″ + 9.075″ + 9.075″

Strip width	Lbs / master	Finished coils	Each	Finished OD
9.075″	6,455 lb	1×	6,455 lb	60.0″
7.480″	5,320 lb	1×	5,320 lb	60.0″
7.283″	5,180 lb	1×	5,180 lb	60.0″

Cluster 2 69″W × 57.2″OD × 20″ID multi-series rewind

Coil weight44,119 lb

PIW639.4 lb/in

Coils3

Spec OD window—–53.5″

Demand132,357 lb

Buy132,357 lb

Buy vs forecast100%

% Scrap1.1%

$/cwt to run$49.79

Reworksnone

Series13 multi

Cut pattern (per coil): 4.724″ + 4.724″ + 4.724″ + 4.724″ + 4.724″ + 4.724″ + 1.995″ + 1.995″ + 1.995″ + 2.598″ +5 more

Strip width	Lbs / master	Finished coils	Each	Finished OD
19.120″	12,225 lb	2×	6,113 lb	42.9″
11.900″	7,609 lb	2×	3,804 lb	42.9″
10.472″	6,696 lb	2×	3,348 lb	42.9″
8.500″	5,435 lb	2×	2,717 lb	42.9″
7.992″	5,110 lb	2×	2,555 lb	42.9″
6.750″	4,316 lb	2×	2,158 lb	42.9″
6.102″	3,902 lb	2×	1,951 lb	42.9″
5.433″	3,474 lb	2×	1,737 lb	42.9″
4.724″	3,021 lb	2×	1,510 lb	42.9″
4.528″	2,895 lb	2×	1,447 lb	42.9″
4.409″	2,819 lb	2×	1,410 lb	42.9″
2.598″	1,661 lb	2×	831 lb	42.9″
1.995″	1,276 lb	2×	638 lb	42.9″

Order	Width	Forecast (Aug · Sep · Oct)	Total	Served by	In pattern	Buy vs Forecast	Cover
419098030	39.500″	40.0k · 20.0k · 60.0k	120,000 lbs	Cluster 1 · 69.00″	via rotation	100% 120,000 lbs buy	✓ covered
424197025	9.075″	38.3k · 38.3k · 38.3k	115,008 lbs	Cluster 3 · 69.00″	5 strips/coil	107% 123,056 lbs buy	✓ covered
421277024	21.750″	46.0k · 14.0k · 42.0k	102,000 lbs	Cluster 1 · 69.00″	via rotation	100% 102,000 lbs buy	✓ covered
419098031	37.495″	20.0k · 20.0k · 40.0k	80,000 lbs	Cluster 1 · 69.00″	via rotation	100% 80,000 lbs buy	✓ covered
426190025	18.980″	31.0k · 39.0k · 0.0k	70,000 lbs	Cluster 1 · 69.00″	1 strip/coil	100% 70,000 lbs buy	✓ covered
420311016	7.480″	19.0k · 24.0k · 24.0k	67,000 lbs	Cluster 3 · 69.00″	3 strips/coil	107% 71,689 lbs buy	✓ covered
424214013	19.120″	20.0k · 20.0k · 20.0k	60,000 lbs	Cluster 2 · 69.00″	1 strip/coil	100% 60,000 lbs buy	✓ covered
425230020	15.590″	7.2k · 9.0k · 7.2k	23,428 lbs	Cluster 1 · 69.00″	via rotation	100% 23,428 lbs buy	✓ covered
423187032	14.291″	7.7k · 7.5k · 7.7k	22,942 lbs	Cluster 1 · 69.00″	via rotation	100% 22,942 lbs buy	✓ covered
426011006	4.724″	4.5k · 4.5k · 10.8k	19,800 lbs	Cluster 2 · 69.00″	6 strips/coil	100% 19,800 lbs buy	✓ covered
421076035	6.750″	3.4k · 8.6k · 4.0k	16,000 lbs	Cluster 2 · 69.00″	via rotation	100% 16,000 lbs buy	✓ covered
416222021	15.984″	2.2k · 4.8k · 4.6k	11,685 lbs	Cluster 1 · 69.00″	1 strip/coil	100% 11,685 lbs buy	✓ covered
417066034	8.583″	2.4k · 3.3k · 3.1k	8,818 lbs	Cluster 1 · 69.00″	1 strip/coil	100% 8,818 lbs buy	✓ covered
415023024	1.995″	2.2k · 2.9k · 2.9k	7,981 lbs	Cluster 2 · 69.00″	3 strips/coil	100% 7,981 lbs buy	✓ covered
416223057	6.693″	2.2k · 2.4k · 2.4k	7,055 lbs	Cluster 1 · 69.00″	via rotation	100% 7,055 lbs buy	✓ covered
416237036	9.449″	2.2k · 2.4k · 2.4k	7,055 lbs	Cluster 1 · 69.00″	1 strip/coil	100% 7,055 lbs buy	✓ covered
419092051	12.750″	1.6k · 2.5k · 1.6k	5,624 lbs	Cluster 1 · 69.00″	via rotation	100% 5,624 lbs buy	✓ covered
426011043	6.102″	1.6k · 1.6k · 1.9k	5,070 lbs	Cluster 2 · 69.00″	via rotation	100% 5,070 lbs buy	✓ covered
416270010	11.900″	0.0k · 5.0k · 0.0k	5,000 lbs	Cluster 2 · 69.00″	via rotation	100% 5,000 lbs buy	✓ covered
424288063	15.250″	4.9k · 0.0k · 0.0k	4,896 lbs	Cluster 1 · 69.00″	1 strip/coil	100% 4,896 lbs buy	✓ covered
426011016	10.472″	2.3k · 2.3k · 0.0k	4,632 lbs	Cluster 2 · 69.00″	via rotation	100% 4,632 lbs buy	✓ covered
422354060	7.913″	0.0k · 2.2k · 2.4k	4,630 lbs	Cluster 1 · 69.00″	via rotation	100% 4,630 lbs buy	✓ covered
423003032	14.291″	2.3k · 0.0k · 2.3k	4,588 lbs	Cluster 1 · 69.00″	via rotation	100% 4,588 lbs buy	✓ covered
426011025	5.433″	2.1k · 2.1k · 0.0k	4,186 lbs	Cluster 2 · 69.00″	via rotation	100% 4,186 lbs buy	✓ covered
415020020	7.992″	2.0k · 1.2k · 0.8k	4,000 lbs	Cluster 2 · 69.00″	via rotation	100% 4,000 lbs buy	✓ covered
422343011	8.500″	0.0k · 2.0k · 2.0k	4,000 lbs	Cluster 2 · 69.00″	via rotation	100% 4,000 lbs buy	✓ covered
416222032	4.921″	1.1k · 0.7k · 0.7k	2,463 lbs	Cluster 1 · 69.00″	via rotation	100% 2,463 lbs buy	✓ covered
416222014	6.929″	0.0k · 1.1k · 0.9k	1,984 lbs	Cluster 1 · 69.00″	via rotation	100% 1,984 lbs buy	✓ covered
424288067	7.283″	0.0k · 0.0k · 1.5k	1,460 lbs	Cluster 3 · 69.00″	via rotation	107% 1,562 lbs buy	✓ covered
426011052	12.441″	0.0k · 0.9k · 0.0k	889 lbs	Cluster 1 · 69.00″	via rotation	100% 889 lbs buy	✓ covered
424318061	6.750″	0.0k · 0.8k · 0.0k	850 lbs	Cluster 2 · 69.00″	via rotation	100% 850 lbs buy	✓ covered
426011042	4.528″	0.3k · 0.3k · 0.0k	632 lbs	Cluster 2 · 69.00″	via rotation	100% 632 lbs buy	✓ covered
418178083	6.339″	0.0k · 0.0k · 0.4k	441 lbs	Cluster 1 · 69.00″	via rotation	100% 441 lbs buy	✓ covered
426011033	2.598″	0.1k · 0.1k · 0.0k	184 lbs	Cluster 2 · 69.00″	4 strips/coil	100% 184 lbs buy	✓ covered
426011010	4.409″	0.0k · 0.0k · 0.0k	22 lbs	Cluster 2 · 69.00″	1 strip/coil	100% 22 lbs buy	✓ covered