🌳

Mimir Plan 2242 · Audit

Forecast demand450,488 lbs

Orders22

Covered22

Short0

Buy vs forecast118%

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 67″W × 56.4″OD × 20″ID 1 series / strip

Coil weight41,371 lb

PIW617.5 lb/in

Coils7

Spec OD window49.0–60.0″

Demand289,600 lb

Buy289,600 lb

Buy vs forecast100%

% Scrap1.1%

$/cwt to run$49.79

Reworksnone

Series13

Cut pattern (per coil): 6.772″ + 6.772″ + 6.772″ + 6.772″ + 10.236″ + 7.205″ + 7.240″ + 7.240″ + 7.240″

Strip width	Lbs / master	Finished coils	Each	Finished OD
25.240″	15,585 lb	1×	15,585 lb	56.4″
22.992″	14,197 lb	1×	14,197 lb	56.4″
22.953″	14,173 lb	1×	14,173 lb	56.4″
19.700″	12,164 lb	1×	12,164 lb	56.4″
13.500″	8,336 lb	1×	8,336 lb	56.4″
10.236″	6,321 lb	1×	6,321 lb	56.4″
9.252″	5,713 lb	1×	5,713 lb	56.4″
9.250″	5,712 lb	1×	5,712 lb	56.4″
7.240″	4,471 lb	1×	4,471 lb	56.4″
7.205″	4,449 lb	1×	4,449 lb	56.4″
6.772″	4,181 lb	1×	4,181 lb	56.4″
5.906″	3,647 lb	1×	3,647 lb	56.4″
4.106″	2,535 lb	1×	2,535 lb	56.4″

Cluster 2 67″W × 55.5″OD × 20″ID multi-series rewind OD-floored

Coil weight40,000 lb

PIW597.0 lb/in

Coils4

Spec OD window41.0–45.0″

Demand155,888 lb

Buy160,000 lb

Buy vs forecast103%

Over-buy4,112 lb

% Scrap1.2%

$/cwt to run$49.79

Reworksnone

Series8 multi

Cut pattern (per coil): 13.900″ + 13.900″ + 13.900″ + 8.300″ + 8.300″ + 7.900″

Strip width	Lbs / master	Finished coils	Each	Finished OD
25.000″	14,925 lb	2×	7,463 lb	41.8″
18.750″	11,194 lb	2×	5,597 lb	41.8″
17.900″	10,687 lb	2×	5,343 lb	41.8″
14.200″	8,478 lb	2×	4,239 lb	41.8″
13.900″	8,299 lb	2×	4,149 lb	41.8″
10.000″	5,970 lb	2×	2,985 lb	41.8″
8.300″	4,955 lb	2×	2,478 lb	41.8″
7.900″	4,716 lb	2×	2,358 lb	41.8″

Cluster 3 67″W × 57.1″OD × 24″ID 1 series / strip OD-floored

Coil weight40,000 lb

PIW597.0 lb/in

Coils2

Spec OD window—–58.0″

Demand5,000 lb

Buy80,000 lb

Buy vs forecast1600%

Over-buy75,000 lb

% Scrap7.0%

$/cwt to run$49.79

Reworksnone

Series1

Cut pattern (per coil): 31.142″ + 31.142″

Strip width	Lbs / master	Finished coils	Each	Finished OD
31.142″	18,592 lb	1×	18,592 lb	57.1″

Order	Width	Forecast (Aug · Sep · Oct)	Total	Served by	In pattern	Buy vs Forecast	Cover
418026019	13.500″	44.2k · 26.9k · 25.0k	95,985 lbs	Cluster 1 · 67.00″	via rotation	100% 95,985 lbs buy	✓ covered
424065033	10.236″	23.1k · 9.9k · 23.1k	56,217 lbs	Cluster 1 · 67.00″	1 strip/coil	100% 56,217 lbs buy	✓ covered
420276049	13.900″	22.0k · 16.0k · 14.0k	52,000 lbs	Cluster 2 · 67.00″	3 strips/coil	103% 53,372 lbs buy	✓ covered
424065029	6.772″	15.9k · 15.9k · 7.9k	39,682 lbs	Cluster 1 · 67.00″	4 strips/coil	100% 39,682 lbs buy	✓ covered
419298106	14.200″	15.0k · 9.9k · 14.1k	38,960 lbs	Cluster 2 · 67.00″	via rotation	103% 39,988 lbs buy	✓ covered
422354036	7.900″	10.3k · 8.0k · 9.1k	27,399 lbs	Cluster 2 · 67.00″	1 strip/coil	103% 28,122 lbs buy	✓ covered
415299015	19.700″	8.9k · 10.8k · 4.5k	24,137 lbs	Cluster 1 · 67.00″	via rotation	100% 24,137 lbs buy	✓ covered
422297029	25.240″	10.0k · 0.0k · 10.0k	20,000 lbs	Cluster 1 · 67.00″	via rotation	100% 20,000 lbs buy	✓ covered
423198070	22.953″	6.8k · 0.0k · 8.3k	15,079 lbs	Cluster 1 · 67.00″	via rotation	100% 15,079 lbs buy	✓ covered
425322090	7.205″	6.0k · 3.0k · 6.0k	15,000 lbs	Cluster 1 · 67.00″	1 strip/coil	100% 15,000 lbs buy	✓ covered
422361068	8.300″	5.3k · 2.2k · 3.5k	10,952 lbs	Cluster 2 · 67.00″	2 strips/coil	103% 11,241 lbs buy	✓ covered
421004010	18.750″	0.0k · 0.0k · 10.0k	10,000 lbs	Cluster 2 · 67.00″	via rotation	103% 10,264 lbs buy	✓ covered
421006013	10.000″	0.0k · 0.0k · 10.0k	10,000 lbs	Cluster 2 · 67.00″	via rotation	103% 10,264 lbs buy	✓ covered
425322086	9.252″	0.0k · 0.0k · 6.0k	6,000 lbs	Cluster 1 · 67.00″	via rotation	100% 6,000 lbs buy	✓ covered
425322099	7.240″	0.0k · 2.0k · 4.0k	6,000 lbs	Cluster 1 · 67.00″	3 strips/coil	100% 6,000 lbs buy	✓ covered
421006010	25.000″	0.0k · 0.0k · 5.0k	5,000 lbs	Cluster 2 · 67.00″	via rotation	103% 5,132 lbs buy	✓ covered
422356055	31.142″	0.0k · 2.0k · 3.0k	5,000 lbs	Cluster 3 · 67.00″	2 strips/coil	1600% 80,000 lbs buy	✓ covered
422356034	22.992″	0.0k · 1.0k · 3.0k	4,000 lbs	Cluster 1 · 67.00″	via rotation	100% 4,000 lbs buy	✓ covered
425322100	5.906″	0.0k · 3.0k · 1.0k	4,000 lbs	Cluster 1 · 67.00″	via rotation	100% 4,000 lbs buy	✓ covered
421004009	4.106″	0.0k · 0.0k · 2.5k	2,500 lbs	Cluster 1 · 67.00″	via rotation	100% 2,500 lbs buy	✓ covered
423313054	17.900″	1.6k · 0.0k · 0.0k	1,577 lbs	Cluster 2 · 67.00″	via rotation	103% 1,619 lbs buy	✓ covered
425322096	9.250″	0.0k · 0.0k · 1.0k	1,000 lbs	Cluster 1 · 67.00″	via rotation	100% 1,000 lbs buy	✓ covered