🌳

Mimir Plan 1835 · Audit

Forecast demand797,993 lbs

Orders32

Covered32

Short0

Buy vs forecast107%

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

Coil weight40,841 lb

PIW600.6 lb/in

Coils9

Spec OD window39.0–48.7″

Demand367,571 lb

Buy367,571 lb

Buy vs forecast100%

% Scrap1.1%

$/cwt to run$50.80

Reworksnone

Series14 multi

Cut pattern (per coil): 7.250″ + 7.250″ + 7.250″ + 9.000″ + 9.000″ + 9.000″ + 3.700″ + 3.700″ + 3.700″ + 3.700″ +1 more

Strip width	Lbs / master	Finished coils	Each	Finished OD
13.750″	8,258 lb	2×	4,129 lb	41.9″
11.929″	7,165 lb	2×	3,582 lb	41.9″
10.500″	6,306 lb	2×	3,153 lb	41.9″
9.850″	5,916 lb	2×	2,958 lb	41.9″
9.100″	5,466 lb	2×	2,733 lb	41.9″
9.000″	5,405 lb	2×	2,703 lb	41.9″
8.200″	4,925 lb	2×	2,462 lb	41.9″
8.000″	4,805 lb	2×	2,402 lb	41.9″
7.250″	4,354 lb	2×	2,177 lb	41.9″
5.905″	3,547 lb	2×	1,773 lb	41.9″
5.800″	3,484 lb	2×	1,742 lb	41.9″
4.300″	2,583 lb	2×	1,291 lb	41.9″
3.700″	2,222 lb	2×	1,111 lb	41.9″
2.795″	1,679 lb	2×	839 lb	41.9″

Cluster 4 68″W × 64.3″OD × 20″ID 1 series / strip

Coil weight56,381 lb

PIW829.1 lb/in

Coils5

Spec OD window60.0–71.0″

Demand281,905 lb

Buy281,905 lb

Buy vs forecast100%

% Scrap1.1%

$/cwt to run$50.80

Reworksnone

Series11

Cut pattern (per coil): 7.776″ + 7.776″ + 7.776″ + 7.776″ + 7.776″ + 4.100″ + 3.050″ + 3.050″ + 3.050″ + 3.050″ +3 more

Strip width	Lbs / master	Finished coils	Each	Finished OD
23.858″	19,782 lb	1×	19,782 lb	64.3″
14.882″	12,339 lb	1×	12,339 lb	64.3″
7.776″	6,447 lb	1×	6,447 lb	64.3″
5.905″	4,896 lb	1×	4,896 lb	64.3″
4.601″	3,815 lb	1×	3,815 lb	64.3″
4.560″	3,781 lb	1×	3,781 lb	64.3″
4.480″	3,715 lb	1×	3,715 lb	64.3″
4.100″	3,399 lb	1×	3,399 lb	64.3″
4.000″	3,317 lb	1×	3,317 lb	64.3″
3.050″	2,529 lb	1×	2,529 lb	64.3″
2.950″	2,446 lb	1×	2,446 lb	64.3″

Cluster 3 68″W × 55.4″OD × 20″ID 1 series / strip

Coil weight40,306 lb

PIW592.7 lb/in

Coils3

Spec OD window—–59.0″

Demand120,917 lb

Buy120,917 lb

Buy vs forecast100%

% Scrap1.1%

$/cwt to run$50.80

Reworksnone

Series6

Cut pattern (per coil): 5.600″ + 4.100″ + 4.100″ + 5.500″ + 5.500″ + 7.362″ + 7.362″ + 7.362″ + 7.362″ + 6.500″ +1 more

Strip width	Lbs / master	Finished coils	Each	Finished OD
7.362″	4,364 lb	1×	4,364 lb	55.4″
6.654″	3,944 lb	1×	3,944 lb	55.4″
6.500″	3,853 lb	1×	3,853 lb	55.4″
5.600″	3,319 lb	1×	3,319 lb	55.4″
5.500″	3,260 lb	1×	3,260 lb	55.4″
4.100″	2,430 lb	1×	2,430 lb	55.4″

Cluster 2 68″W × 55.2″OD × 20″ID multi-series rewind OD-floored

Coil weight40,000 lb

PIW588.2 lb/in

Coils2

Spec OD window—–45.7″

Demand27,600 lb

Buy80,000 lb

Buy vs forecast290%

Over-buy52,400 lb

% Scrap1.6%

$/cwt to run$50.80

Reworksnone

Series1 multi

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

Strip width	Lbs / master	Finished coils	Each	Finished OD
13.386″	7,874 lb	2×	3,937 lb	41.5″

Order	Width	Forecast (Aug · Sep · Oct)	Total	Served by	In pattern	Buy vs Forecast	Cover
426154028	7.776″	129.3k · 0.0k · 0.0k	129,319 lbs	Cluster 4 · 68.00″	5 strips/coil	100% 129,319 lbs buy	✓ covered
419025003	9.000″	20.0k · 24.0k · 24.0k	68,000 lbs	Cluster 1 · 68.00″	3 strips/coil	100% 68,000 lbs buy	✓ covered
422297039	7.362″	19.8k · 23.8k · 15.9k	59,517 lbs	Cluster 3 · 68.00″	4 strips/coil	100% 59,517 lbs buy	✓ covered
426056031	11.929″	12.0k · 12.0k · 18.0k	42,000 lbs	Cluster 1 · 68.00″	via rotation	100% 42,000 lbs buy	✓ covered
422171042	9.850″	20.0k · 10.0k · 10.0k	40,000 lbs	Cluster 1 · 68.00″	via rotation	100% 40,000 lbs buy	✓ covered
413199045	8.000″	13.3k · 12.8k · 11.4k	37,525 lbs	Cluster 1 · 68.00″	via rotation	100% 37,525 lbs buy	✓ covered
423125071	9.100″	9.1k · 13.7k · 13.7k	36,536 lbs	Cluster 1 · 68.00″	via rotation	100% 36,536 lbs buy	✓ covered
422353027	5.905″	12.0k · 12.0k · 12.0k	36,000 lbs	Cluster 1 · 68.00″	via rotation	100% 36,000 lbs buy	✓ covered
426154030	3.050″	35.9k · 0.0k · 0.0k	35,916 lbs	Cluster 4 · 68.00″	4 strips/coil	100% 35,916 lbs buy	✓ covered
421046024	4.560″	0.0k · 30.0k · 0.0k	30,000 lbs	Cluster 4 · 68.00″	2 strips/coil	100% 30,000 lbs buy	✓ covered
419231015	13.386″	9.2k · 9.2k · 9.2k	27,600 lbs	Cluster 2 · 68.00″	5 strips/coil	290% 80,000 lbs buy	✓ covered
422228031	7.250″	8.8k · 8.8k · 8.8k	26,454 lbs	Cluster 1 · 68.00″	3 strips/coil	100% 26,454 lbs buy	✓ covered
419024044	23.858″	0.0k · 0.0k · 20.0k	20,000 lbs	Cluster 4 · 68.00″	via rotation	100% 20,000 lbs buy	✓ covered
423123011	3.700″	7.9k · 5.6k · 5.6k	19,087 lbs	Cluster 1 · 68.00″	5 strips/coil	100% 19,087 lbs buy	✓ covered
425071012	6.500″	6.0k · 6.0k · 6.0k	18,000 lbs	Cluster 3 · 68.00″	2 strips/coil	100% 18,000 lbs buy	✓ covered
421046023	4.601″	15.0k · 0.0k · 0.0k	15,000 lbs	Cluster 4 · 68.00″	via rotation	100% 15,000 lbs buy	✓ covered
421046026	4.480″	0.0k · 15.0k · 0.0k	15,000 lbs	Cluster 4 · 68.00″	via rotation	100% 15,000 lbs buy	✓ covered
423234052	6.654″	6.0k · 8.4k · 0.0k	14,400 lbs	Cluster 3 · 68.00″	via rotation	100% 14,400 lbs buy	✓ covered
419231008	5.600″	7.0k · 7.0k · 0.0k	14,000 lbs	Cluster 3 · 68.00″	1 strip/coil	100% 14,000 lbs buy	✓ covered
421270024	13.750″	4.5k · 4.5k · 4.5k	13,500 lbs	Cluster 1 · 68.00″	via rotation	100% 13,500 lbs buy	✓ covered
423123012	5.800″	4.9k · 4.9k · 3.7k	13,403 lbs	Cluster 1 · 68.00″	via rotation	100% 13,403 lbs buy	✓ covered
425071013	10.500″	6.0k · 0.0k · 6.0k	12,000 lbs	Cluster 1 · 68.00″	via rotation	100% 12,000 lbs buy	✓ covered
425338016	2.950″	6.0k · 6.0k · 0.0k	12,000 lbs	Cluster 4 · 68.00″	1 strip/coil	100% 12,000 lbs buy	✓ covered
422290046	2.795″	4.3k · 3.8k · 3.6k	11,674 lbs	Cluster 1 · 68.00″	via rotation	100% 11,674 lbs buy	✓ covered
425059026	4.100″	0.0k · 10.0k · 0.0k	10,000 lbs	Cluster 4 · 68.00″	1 strip/coil	100% 10,000 lbs buy	✓ covered
413184014	5.500″	0.0k · 0.0k · 8.0k	8,000 lbs	Cluster 3 · 68.00″	2 strips/coil	100% 8,000 lbs buy	✓ covered
423181028	8.200″	0.0k · 3.6k · 3.6k	7,178 lbs	Cluster 1 · 68.00″	via rotation	100% 7,178 lbs buy	✓ covered
419231014	4.100″	0.0k · 3.5k · 3.5k	7,000 lbs	Cluster 3 · 68.00″	2 strips/coil	100% 7,000 lbs buy	✓ covered
413193039	4.000″	0.0k · 2.5k · 4.5k	7,000 lbs	Cluster 4 · 68.00″	via rotation	100% 7,000 lbs buy	✓ covered
423181029	4.300″	2.1k · 2.1k · 0.0k	4,214 lbs	Cluster 1 · 68.00″	via rotation	100% 4,214 lbs buy	✓ covered
422200062	5.905″	0.0k · 0.0k · 4.0k	4,000 lbs	Cluster 4 · 68.00″	via rotation	100% 4,000 lbs buy	✓ covered
426069078	14.882″	0.0k · 1.3k · 2.4k	3,670 lbs	Cluster 4 · 68.00″	via rotation	100% 3,670 lbs buy	✓ covered