🌳

Mimir Plan 887 · Audit

Forecast demand676,188 lbs

Orders17

Covered17

Short0

Buy vs forecast106%

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

Coil weight53,552 lb

PIW877.9 lb/in

Coils8

Spec OD window—–52.8″

Demand428,419 lb

Buy428,419 lb

Buy vs forecast100%

% Scrap1.3%

$/cwt to run$50.80

Reworksnone

Series9 multi

Cut pattern (per coil): 15.000″ + 15.000″ + 30.197″

Strip width	Lbs / master	Finished coils	Each	Finished OD
30.197″	26,510 lb	2×	13,255 lb	48.7″
29.150″	25,591 lb	2×	12,796 lb	48.7″
22.050″	19,358 lb	2×	9,679 lb	48.7″
20.500″	17,997 lb	2×	8,999 lb	48.7″
16.500″	14,485 lb	2×	7,243 lb	48.7″
15.000″	13,169 lb	2×	6,584 lb	48.7″
12.441″	10,922 lb	2×	5,461 lb	48.7″
9.440″	8,287 lb	2×	4,144 lb	48.7″
2.820″	2,476 lb	2×	1,238 lb	48.7″

Cluster 3 61″W × 64.8″OD × 20″ID 1 series / strip

Coil weight51,442 lb

PIW843.3 lb/in

Coils4

Spec OD window60.0–70.0″

Demand205,769 lb

Buy205,769 lb

Buy vs forecast100%

% Scrap1.6%

$/cwt to run$50.80

Reworksnone

Series5

Cut pattern (per coil): 16.000″ + 16.000″ + 7.598″ + 10.236″ + 10.236″

Strip width	Lbs / master	Finished coils	Each	Finished OD
16.496″	13,911 lb	1×	13,911 lb	64.8″
16.000″	13,493 lb	1×	13,493 lb	64.8″
11.732″	9,894 lb	1×	9,894 lb	64.8″
10.236″	8,632 lb	1×	8,632 lb	64.8″
7.598″	6,408 lb	1×	6,408 lb	64.8″

Cluster 1 61″W × 59.1″OD × 20″ID multi-series rewind OD-floored

Coil weight42,000 lb

PIW688.5 lb/in

Coils2

Spec OD window—–38.0″

Demand42,000 lb

Buy84,000 lb

Buy vs forecast200%

Over-buy42,000 lb

% Scrap3.5%

$/cwt to run$50.80

Reworksnone

Series3 multi

Cut pattern (per coil): 18.110″ + 18.110″ + 11.880″ + 11.880″

Strip width	Lbs / master	Finished coils	Each	Finished OD
21.550″	14,838 lb	3×	4,946 lb	37.9″
18.110″	12,469 lb	3×	4,156 lb	37.9″
11.880″	8,180 lb	3×	2,727 lb	37.9″

Order	Width	Forecast (Aug · Sep · Oct)	Total	Served by	In pattern	Buy vs Forecast	Cover
422361056	15.000″	60.5k · 35.1k · 39.3k	134,842 lbs	Cluster 2 · 61.00″	2 strips/coil	100% 134,842 lbs buy	✓ covered
422361054	22.050″	61.2k · 30.4k · 38.3k	129,969 lbs	Cluster 2 · 61.00″	via rotation	100% 129,969 lbs buy	✓ covered
422180103	16.496″	22.0k · 28.7k · 26.5k	77,161 lbs	Cluster 3 · 61.00″	via rotation	100% 77,161 lbs buy	✓ covered
423269010	10.236″	17.6k · 17.6k · 17.6k	52,911 lbs	Cluster 3 · 61.00″	2 strips/coil	100% 52,911 lbs buy	✓ covered
422356095	16.000″	15.3k · 15.5k · 13.7k	44,500 lbs	Cluster 3 · 61.00″	2 strips/coil	100% 44,500 lbs buy	✓ covered
423072014	29.150″	18.0k · 13.4k · 11.7k	43,135 lbs	Cluster 2 · 61.00″	via rotation	100% 43,135 lbs buy	✓ covered
422361064	20.500″	13.3k · 7.7k · 9.9k	30,934 lbs	Cluster 2 · 61.00″	via rotation	100% 30,934 lbs buy	✓ covered
423058053	30.197″	0.0k · 15.0k · 15.0k	30,000 lbs	Cluster 2 · 61.00″	1 strip/coil	100% 30,000 lbs buy	✓ covered
419231007	2.820″	8.5k · 8.5k · 8.5k	25,500 lbs	Cluster 2 · 61.00″	via rotation	100% 25,500 lbs buy	✓ covered
423205053	7.598″	7.1k · 4.7k · 9.4k	21,197 lbs	Cluster 3 · 61.00″	1 strip/coil	100% 21,197 lbs buy	✓ covered
422171011	18.110″	10.0k · 10.0k · 0.0k	20,000 lbs	Cluster 1 · 61.00″	2 strips/coil	200% 40,000 lbs buy	✓ covered
423073004	16.500″	7.5k · 3.8k · 4.8k	16,039 lbs	Cluster 2 · 61.00″	via rotation	100% 16,039 lbs buy	✓ covered
418316020	11.880″	0.0k · 6.0k · 6.0k	12,000 lbs	Cluster 1 · 61.00″	2 strips/coil	200% 24,000 lbs buy	✓ covered
422171013	21.550″	10.0k · 0.0k · 0.0k	10,000 lbs	Cluster 1 · 61.00″	via rotation	200% 20,000 lbs buy	✓ covered
422171007	9.440″	5.0k · 5.0k · 0.0k	10,000 lbs	Cluster 2 · 61.00″	via rotation	100% 10,000 lbs buy	✓ covered
418129021	11.732″	0.0k · 10.0k · 0.0k	10,000 lbs	Cluster 3 · 61.00″	via rotation	100% 10,000 lbs buy	✓ covered
423058076	12.441″	0.0k · 0.0k · 8.0k	8,000 lbs	Cluster 2 · 61.00″	via rotation	100% 8,000 lbs buy	✓ covered