🌳

Mimir Plan 2699 · Audit

Forecast demand779,486 lbs

Orders35

Covered35

Short0

Buy vs forecast121%

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 60″W × 60.6″OD × 20″ID multi-series rewind OD-floored

Coil weight43,667 lb

PIW727.8 lb/in

Coils12

Spec OD window45.0–45.7″

Demand512,087 lb

Buy524,000 lb

Buy vs forecast102%

Over-buy11,913 lb

% Scrap1.2%

$/cwt to run$49.79

Reworksnone

Series17 multi

Cut pattern (per coil): 17.750″ + 17.750″ + 8.375″ + 8.375″ + 7.000″

Strip width	Lbs / master	Finished coils	Each	Finished OD
37.008″	26,934 lb	2×	13,467 lb	45.1″
26.701″	19,432 lb	2×	9,716 lb	45.1″
23.000″	16,739 lb	2×	8,369 lb	45.1″
19.500″	14,192 lb	2×	7,096 lb	45.1″
18.819″	13,696 lb	2×	6,848 lb	45.1″
17.750″	12,918 lb	2×	6,459 lb	45.1″
17.600″	12,809 lb	2×	6,404 lb	45.1″
12.677″	9,226 lb	2×	4,613 lb	45.1″
8.858″	6,447 lb	2×	3,223 lb	45.1″
8.375″	6,095 lb	2×	3,048 lb	45.1″
7.000″	5,094 lb	2×	2,547 lb	45.1″
6.050″	4,403 lb	2×	2,202 lb	45.1″
6.024″	4,384 lb	2×	2,192 lb	45.1″
5.433″	3,954 lb	2×	1,977 lb	45.1″
4.250″	3,093 lb	2×	1,547 lb	45.1″
4.125″	3,002 lb	2×	1,501 lb	45.1″
1.875″	1,365 lb	2×	682 lb	45.1″

Cluster 2 60″W × 68.0″OD × 20″ID multi-series rewind OD-floored

Coil weight56,333 lb

PIW938.9 lb/in

Coils4

Spec OD window50.0–54.4″

Demand199,459 lb

Buy225,333 lb

Buy vs forecast113%

Over-buy25,874 lb

% Scrap1.2%

$/cwt to run$49.79

Reworksnone

Series13 multi

Cut pattern (per coil): 13.600″ + 3.000″ + 3.000″ + 3.000″ + 3.000″ + 3.000″ + 3.000″ + 11.750″ + 7.750″ + 8.150″

Strip width	Lbs / master	Finished coils	Each	Finished OD
21.496″	20,182 lb	2×	10,091 lb	50.1″
14.680″	13,783 lb	2×	6,891 lb	50.1″
14.409″	13,528 lb	2×	6,764 lb	50.1″
13.600″	12,769 lb	2×	6,384 lb	50.1″
12.677″	11,902 lb	2×	5,951 lb	50.1″
12.362″	11,607 lb	2×	5,803 lb	50.1″
11.750″	11,032 lb	2×	5,516 lb	50.1″
11.417″	10,719 lb	2×	5,360 lb	50.1″
9.842″	9,241 lb	2×	4,620 lb	50.1″
8.700″	8,168 lb	2×	4,084 lb	50.1″
8.150″	7,652 lb	2×	3,826 lb	50.1″
7.750″	7,276 lb	2×	3,638 lb	50.1″
3.000″	2,817 lb	2×	1,408 lb	50.1″

Cluster 4 60″W × 69.7″OD × 24″ID 1 series / strip OD-floored

Coil weight57,188 lb

PIW953.1 lb/in

Coils2

Spec OD window60.0–71.8″

Demand57,188 lb

Buy114,376 lb

Buy vs forecast200%

Over-buy57,188 lb

% Scrap1.6%

$/cwt to run$49.79

Reworksnone

Series4

Cut pattern (per coil): 8.375″ + 8.375″ + 8.375″ + 8.375″ + 2.625″ + 23.000″

Strip width	Lbs / master	Finished coils	Each	Finished OD
23.000″	21,922 lb	1×	21,922 lb	69.7″
21.732″	20,714 lb	1×	20,714 lb	69.7″
8.375″	7,982 lb	1×	7,982 lb	69.7″
2.625″	2,502 lb	1×	2,502 lb	69.7″

Cluster 3 60″W × 58.3″OD × 20″ID multi-series rewind OD-floored

Coil weight40,000 lb

PIW666.7 lb/in

Coils2

Spec OD window—–37.1″

Demand10,752 lb

Buy80,000 lb

Buy vs forecast744%

Over-buy69,248 lb

% Scrap7.4%

$/cwt to run$49.79

Reworksnone

Series1 multi

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

Strip width	Lbs / master	Finished coils	Each	Finished OD
18.520″	12,347 lb	4×	3,087 lb	33.9″

Order	Width	Forecast (Aug · Sep · Oct)	Total	Served by	In pattern	Buy vs Forecast	Cover
424029049	17.750″	30.0k · 35.0k · 25.0k	90,000 lbs	Cluster 1 · 60.00″	2 strips/coil	102% 92,094 lbs buy	✓ covered
422354055	26.701″	27.6k · 27.6k · 27.6k	82,800 lbs	Cluster 1 · 60.00″	via rotation	102% 84,726 lbs buy	✓ covered
424039058	37.008″	34.5k · 23.0k · 23.0k	80,500 lbs	Cluster 1 · 60.00″	via rotation	102% 82,373 lbs buy	✓ covered
418038014	13.600″	21.8k · 21.8k · 21.8k	65,493 lbs	Cluster 2 · 60.00″	1 strip/coil	113% 73,989 lbs buy	✓ covered
426062061	8.375″	18.6k · 18.6k · 7.6k	44,800 lbs	Cluster 1 · 60.00″	2 strips/coil	102% 45,842 lbs buy	✓ covered
424039052	18.819″	21.0k · 10.5k · 10.5k	42,000 lbs	Cluster 1 · 60.00″	via rotation	102% 42,977 lbs buy	✓ covered
419043045	8.375″	9.0k · 16.0k · 14.0k	39,000 lbs	Cluster 4 · 60.00″	4 strips/coil	200% 78,000 lbs buy	✓ covered
424039055	19.500″	18.0k · 9.0k · 9.0k	36,000 lbs	Cluster 1 · 60.00″	via rotation	102% 36,837 lbs buy	✓ covered
424039056	23.000″	10.0k · 10.0k · 10.0k	30,000 lbs	Cluster 1 · 60.00″	via rotation	102% 30,698 lbs buy	✓ covered
418220020	14.409″	6.0k · 12.0k · 12.0k	30,000 lbs	Cluster 2 · 60.00″	via rotation	113% 33,892 lbs buy	✓ covered
426062054	12.677″	9.0k · 9.0k · 9.3k	27,300 lbs	Cluster 1 · 60.00″	via rotation	102% 27,935 lbs buy	✓ covered
417342027	6.050″	6.5k · 13.0k · 6.5k	26,000 lbs	Cluster 1 · 60.00″	via rotation	102% 26,605 lbs buy	✓ covered
413197041	17.600″	9.9k · 7.4k · 7.3k	24,548 lbs	Cluster 1 · 60.00″	via rotation	102% 25,119 lbs buy	✓ covered
418220019	8.150″	8.0k · 5.0k · 8.0k	21,000 lbs	Cluster 2 · 60.00″	1 strip/coil	113% 23,724 lbs buy	✓ covered
426170050	14.680″	8.0k · 13.0k · 0.0k	21,000 lbs	Cluster 2 · 60.00″	via rotation	113% 23,724 lbs buy	✓ covered
426062059	12.362″	7.0k · 6.1k · 7.0k	20,100 lbs	Cluster 2 · 60.00″	via rotation	113% 22,707 lbs buy	✓ covered
413178050	23.000″	4.5k · 1.6k · 7.9k	13,961 lbs	Cluster 4 · 60.00″	1 strip/coil	200% 27,922 lbs buy	✓ covered
426062063	7.000″	3.3k · 7.3k · 3.3k	13,900 lbs	Cluster 1 · 60.00″	1 strip/coil	102% 14,223 lbs buy	✓ covered
418264018	11.750″	6.0k · 0.0k · 5.5k	11,500 lbs	Cluster 2 · 60.00″	1 strip/coil	113% 12,992 lbs buy	✓ covered
423158003	18.520″	3.9k · 3.9k · 3.0k	10,752 lbs	Cluster 3 · 60.00″	3 strips/coil	744% 80,000 lbs buy	✓ covered
418201026	7.750″	0.0k · 4.5k · 3.0k	7,500 lbs	Cluster 2 · 60.00″	1 strip/coil	113% 8,473 lbs buy	✓ covered
426062058	9.842″	2.2k · 2.2k · 2.4k	6,866 lbs	Cluster 2 · 60.00″	via rotation	113% 7,757 lbs buy	✓ covered
418220016	12.677″	6.0k · 0.0k · 0.0k	6,000 lbs	Cluster 2 · 60.00″	via rotation	113% 6,778 lbs buy	✓ covered
422171036	8.858″	0.0k · 5.0k · 0.0k	5,000 lbs	Cluster 1 · 60.00″	via rotation	102% 5,116 lbs buy	✓ covered
413325002	1.875″	1.1k · 1.1k · 1.1k	3,171 lbs	Cluster 1 · 60.00″	via rotation	102% 3,245 lbs buy	✓ covered
422180041	21.496″	1.0k · 1.0k · 1.0k	3,000 lbs	Cluster 2 · 60.00″	via rotation	113% 3,389 lbs buy	✓ covered
426084027	3.000″	1.0k · 1.0k · 1.0k	3,000 lbs	Cluster 2 · 60.00″	6 strips/coil	113% 3,389 lbs buy	✓ covered
425078031	4.250″	0.8k · 1.1k · 0.7k	2,663 lbs	Cluster 1 · 60.00″	via rotation	102% 2,725 lbs buy	✓ covered
426117012	11.417″	2.5k · 0.0k · 0.0k	2,500 lbs	Cluster 2 · 60.00″	via rotation	113% 2,824 lbs buy	✓ covered
424008005	21.732″	0.0k · 0.0k · 2.2k	2,227 lbs	Cluster 4 · 60.00″	via rotation	200% 4,454 lbs buy	✓ covered
420311024	2.625″	0.0k · 0.0k · 2.0k	2,000 lbs	Cluster 4 · 60.00″	1 strip/coil	200% 4,000 lbs buy	✓ covered
422356053	8.700″	0.0k · 1.5k · 0.0k	1,500 lbs	Cluster 2 · 60.00″	via rotation	113% 1,695 lbs buy	✓ covered
423145032	4.125″	0.6k · 0.5k · 0.3k	1,405 lbs	Cluster 1 · 60.00″	via rotation	102% 1,438 lbs buy	✓ covered
423289048	6.024″	0.0k · 0.0k · 1.0k	1,000 lbs	Cluster 1 · 60.00″	via rotation	102% 1,023 lbs buy	✓ covered
423289050	5.433″	0.0k · 0.0k · 1.0k	1,000 lbs	Cluster 1 · 60.00″	via rotation	102% 1,023 lbs buy	✓ covered