🌳

Mimir Plan 3153 · Audit

Forecast demand1,437,966 lbs

Orders33

Covered33

Short0

Buy vs forecast100%

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 2 51″W × 71.6″OD × 20″ID multi-series rewind

Coil weight53,641 lb

PIW1051.8 lb/in

Coils15

Spec OD window48.0–53.0″

Demand804,620 lb

Buy804,620 lb

Buy vs forecast100%

% Scrap2.0%

$/cwt to run$45.92

Reworksnone

Series16 multi

Cut pattern (per coil): 8.070″ + 9.488″ + 9.488″ + 11.299″ + 5.827″ + 5.827″

Strip width	Lbs / master	Finished coils	Each	Finished OD
18.701″	19,669 lb	2×	9,835 lb	52.6″
11.890″	12,506 lb	2×	6,253 lb	52.6″
11.299″	11,884 lb	2×	5,942 lb	52.6″
9.921″	10,435 lb	2×	5,218 lb	52.6″
9.488″	9,980 lb	2×	4,990 lb	52.6″
9.370″	9,855 lb	2×	4,928 lb	52.6″
8.070″	8,488 lb	2×	4,244 lb	52.6″
6.300″	6,626 lb	2×	3,313 lb	52.6″
6.181″	6,501 lb	2×	3,251 lb	52.6″
6.053″	6,366 lb	2×	3,183 lb	52.6″
5.827″	6,129 lb	2×	3,064 lb	52.6″
5.669″	5,963 lb	2×	2,981 lb	52.6″
5.197″	5,466 lb	2×	2,733 lb	52.6″
4.961″	5,218 lb	2×	2,609 lb	52.6″
3.730″	3,923 lb	2×	1,962 lb	52.6″
2.638″	2,774 lb	2×	1,387 lb	52.6″

Cluster 3 51″W × 70.5″OD × 20″ID 1 series / strip

Coil weight51,777 lb

PIW1015.2 lb/in

Coils7

Spec OD window60.0–72.0″

Demand362,436 lb

Buy362,436 lb

Buy vs forecast100%

% Scrap2.8%

$/cwt to run$45.92

Reworksnone

Series3

Cut pattern (per coil): 5.719″ + 5.719″ + 6.693″ + 6.693″ + 6.693″ + 8.898″ + 8.898″

Strip width	Lbs / master	Finished coils	Each	Finished OD
8.898″	9,033 lb	1×	9,033 lb	70.5″
6.693″	6,795 lb	1×	6,795 lb	70.5″
5.719″	5,806 lb	1×	5,806 lb	70.5″

Cluster 1 51″W × 66.2″OD × 20″ID multi-series rewind

Coil weight45,152 lb

PIW885.3 lb/in

Coils6

Spec OD window40.0–42.9″

Demand270,910 lb

Buy270,910 lb

Buy vs forecast100%

% Scrap2.0%

$/cwt to run$45.92

Reworksnone

Series14 multi

Cut pattern (per coil): 4.400″ + 7.323″ + 7.323″ + 4.500″ + 4.500″ + 4.500″ + 4.500″ + 4.017″ + 8.937″

Strip width	Lbs / master	Finished coils	Each	Finished OD
21.500″	19,035 lb	4×	4,759 lb	37.4″
14.488″	12,827 lb	3×	4,276 lb	41.6″
13.071″	11,572 lb	3×	3,857 lb	41.6″
11.250″	9,960 lb	3×	3,320 lb	41.6″
8.937″	7,912 lb	3×	2,637 lb	41.6″
8.819″	7,808 lb	3×	2,603 lb	41.6″
8.386″	7,424 lb	3×	2,475 lb	41.6″
7.677″	6,797 lb	3×	2,266 lb	41.6″
7.323″	6,483 lb	3×	2,161 lb	41.6″
5.079″	4,496 lb	3×	1,499 lb	41.6″
4.500″	3,984 lb	3×	1,328 lb	41.6″
4.400″	3,895 lb	3×	1,298 lb	41.6″
4.017″	3,556 lb	3×	1,185 lb	41.6″
2.625″	2,324 lb	3×	775 lb	41.6″

Order	Width	Forecast (Aug · Sep · Oct)	Total	Served by	In pattern	Buy vs Forecast	Cover
419051028	8.898″	114.5k · 116.8k · 110.0k	341,211 lbs	Cluster 3 · 51.00″	2 strips/coil	100% 341,211 lbs buy	✓ covered
419051037	9.488″	80.5k · 76.5k · 85.8k	242,734 lbs	Cluster 2 · 51.00″	2 strips/coil	100% 242,734 lbs buy	✓ covered
419051042	11.890″	46.4k · 53.2k · 50.8k	150,446 lbs	Cluster 2 · 51.00″	via rotation	100% 150,446 lbs buy	✓ covered
419051041	11.299″	43.0k · 53.0k · 51.0k	147,118 lbs	Cluster 2 · 51.00″	1 strip/coil	100% 147,118 lbs buy	✓ covered
425057085	9.370″	38.8k · 40.8k · 41.6k	121,296 lbs	Cluster 2 · 51.00″	via rotation	100% 121,296 lbs buy	✓ covered
425057080	13.071″	40.0k · 42.9k · 36.9k	119,814 lbs	Cluster 1 · 51.00″	via rotation	100% 119,814 lbs buy	✓ covered
425057088	5.827″	22.6k · 25.0k · 0.0k	47,640 lbs	Cluster 2 · 51.00″	2 strips/coil	100% 47,640 lbs buy	✓ covered
422265015	8.070″	12.0k · 12.2k · 12.2k	36,386 lbs	Cluster 2 · 51.00″	1 strip/coil	100% 36,386 lbs buy	✓ covered
423019031	4.500″	9.6k · 12.1k · 9.9k	31,633 lbs	Cluster 1 · 51.00″	4 strips/coil	100% 31,633 lbs buy	✓ covered
423108034	7.323″	7.7k · 7.9k · 7.5k	23,149 lbs	Cluster 1 · 51.00″	2 strips/coil	100% 23,149 lbs buy	✓ covered
417138011	8.386″	5.7k · 7.1k · 6.8k	19,621 lbs	Cluster 1 · 51.00″	via rotation	100% 19,621 lbs buy	✓ covered
425057081	5.669″	8.4k · 9.0k · 0.0k	17,477 lbs	Cluster 2 · 51.00″	via rotation	100% 17,477 lbs buy	✓ covered
421074043	6.693″	5.1k · 5.1k · 5.1k	15,225 lbs	Cluster 3 · 51.00″	3 strips/coil	100% 15,225 lbs buy	✓ covered
418222032	8.937″	4.0k · 5.0k · 5.0k	14,000 lbs	Cluster 1 · 51.00″	1 strip/coil	100% 14,000 lbs buy	✓ covered
422025001	18.701″	0.7k · 5.8k · 5.0k	11,522 lbs	Cluster 2 · 51.00″	via rotation	100% 11,522 lbs buy	✓ covered
425057097	2.638″	5.5k · 5.8k · 0.0k	11,361 lbs	Cluster 2 · 51.00″	via rotation	100% 11,361 lbs buy	✓ covered
418215009	11.250″	2.0k · 5.0k · 4.0k	11,000 lbs	Cluster 1 · 51.00″	via rotation	100% 11,000 lbs buy	✓ covered
416222015	8.819″	3.3k · 3.3k · 3.3k	9,921 lbs	Cluster 1 · 51.00″	via rotation	100% 9,921 lbs buy	✓ covered
423003030	14.488″	3.9k · 2.0k · 3.9k	9,834 lbs	Cluster 1 · 51.00″	via rotation	100% 9,834 lbs buy	✓ covered
422343020	21.500″	0.0k · 0.0k · 9.6k	9,557 lbs	Cluster 1 · 51.00″	via rotation	100% 9,557 lbs buy	✓ covered
418215017	7.677″	3.0k · 3.0k · 3.0k	9,000 lbs	Cluster 1 · 51.00″	via rotation	100% 9,000 lbs buy	✓ covered
418268036	6.300″	2.9k · 2.9k · 2.9k	8,826 lbs	Cluster 2 · 51.00″	via rotation	100% 8,826 lbs buy	✓ covered
418222023	4.400″	3.0k · 2.0k · 2.0k	7,000 lbs	Cluster 1 · 51.00″	1 strip/coil	100% 7,000 lbs buy	✓ covered
421074103	5.719″	3.0k · 3.0k · 0.0k	6,000 lbs	Cluster 3 · 51.00″	2 strips/coil	100% 6,000 lbs buy	✓ covered
425057098	4.961″	2.0k · 2.0k · 0.0k	3,916 lbs	Cluster 2 · 51.00″	via rotation	100% 3,916 lbs buy	✓ covered
425324034	4.017″	1.1k · 1.1k · 1.1k	3,357 lbs	Cluster 1 · 51.00″	1 strip/coil	100% 3,357 lbs buy	✓ covered
425099081	6.053″	0.0k · 0.8k · 2.5k	3,309 lbs	Cluster 2 · 51.00″	via rotation	100% 3,309 lbs buy	✓ covered
418222024	2.625″	1.0k · 1.0k · 1.0k	3,000 lbs	Cluster 1 · 51.00″	via rotation	100% 3,000 lbs buy	✓ covered
423132002	3.730″	0.0k · 2.0k · 0.0k	2,000 lbs	Cluster 2 · 51.00″	via rotation	100% 2,000 lbs buy	✓ covered
425057074	6.181″	0.1k · 0.2k · 0.0k	328 lbs	Cluster 2 · 51.00″	via rotation	100% 328 lbs buy	✓ covered
425057092	9.921″	0.0k · 0.2k · 0.0k	195 lbs	Cluster 2 · 51.00″	via rotation	100% 195 lbs buy	✓ covered
425058017	5.197″	0.0k · 0.0k · 0.0k	66 lbs	Cluster 2 · 51.00″	via rotation	100% 66 lbs buy	✓ covered
425351037	5.079″	0.0k · 0.0k · 0.0k	24 lbs	Cluster 1 · 51.00″	via rotation	100% 24 lbs buy	✓ covered