🌳

Mimir Plan 31 · Audit

Forecast demand457,070 lbs

Orders30

Covered30

Short0

Buy vs forecast112%

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 infeasible — no buyable coil

🛑 OD specs conflict — hard floor 48.0" exceeds ceiling 47.0"; check MXODFR/MXODTO data

Cluster 3 65″W × 60.5″OD × 24″ID 1 series / strip

Coil weight44,516 lb

PIW684.9 lb/in

Coils4

Spec OD window60.0–62.0″

Demand178,063 lb

Buy178,063 lb

Buy vs forecast100%

% Scrap1.2%

$/cwt to run$49.79

Reworksnone

Series8

Cut pattern (per coil): 15.709″ + 12.638″ + 12.638″ + 14.095″ + 9.170″

Strip width	Lbs / master	Finished coils	Each	Finished OD
28.874″	19,775 lb	1×	19,775 lb	60.5″
19.000″	13,012 lb	1×	13,012 lb	60.5″
15.709″	10,758 lb	1×	10,758 lb	60.5″
14.095″	9,653 lb	1×	9,653 lb	60.5″
12.638″	8,655 lb	1×	8,655 lb	60.5″
9.170″	6,280 lb	1×	6,280 lb	60.5″
5.500″	3,767 lb	1×	3,767 lb	60.5″
3.362″	2,303 lb	1×	2,303 lb	60.5″

Cluster 2 65″W × 57.8″OD × 24″ID multi-series rewind OD-floored

Coil weight40,000 lb

PIW615.4 lb/in

Coils2

Spec OD window36.0–41.6″

Demand23,037 lb

Buy80,000 lb

Buy vs forecast347%

Over-buy56,963 lb

% Scrap2.1%

$/cwt to run$49.79

Reworksnone

Series4 multi

Cut pattern (per coil): 39.055″ + 2.284″ + 2.284″ + 2.284″ + 8.875″ + 8.875″

Strip width	Lbs / master	Finished coils	Each	Finished OD
49.882″	30,697 lb	3×	10,232 lb	38.7″
39.055″	24,034 lb	3×	8,011 lb	38.7″
8.875″	5,462 lb	3×	1,821 lb	38.7″
2.284″	1,405 lb	3×	468 lb	38.7″

Order	Width	Forecast (Aug · Sep · Oct)	Total	Served by	In pattern	Buy vs Forecast	Cover
422298031	11.220″	30.9k · 40.6k · 38.8k	110,225 lbs	Cluster 1 · 65.00″	2 strips/coil	100% 110,225 lbs buy	✓ covered
422180105	12.638″	26.8k · 30.9k · 24.2k	81,950 lbs	Cluster 3 · 65.00″	2 strips/coil	100% 81,950 lbs buy	✓ covered
422026050	14.095″	14.2k · 7.6k · 17.7k	39,513 lbs	Cluster 3 · 65.00″	1 strip/coil	100% 39,513 lbs buy	✓ covered
422354057	13.098″	13.3k · 13.3k · 6.7k	33,300 lbs	Cluster 1 · 65.00″	via rotation	100% 33,300 lbs buy	✓ covered
422356134	5.500″	6.6k · 4.8k · 7.2k	18,600 lbs	Cluster 3 · 65.00″	via rotation	100% 18,600 lbs buy	✓ covered
426163044	10.080″	14.0k · 0.0k · 0.0k	14,000 lbs	Cluster 1 · 65.00″	via rotation	100% 14,000 lbs buy	✓ covered
419247040	8.875″	5.0k · 4.1k · 4.1k	13,288 lbs	Cluster 2 · 65.00″	2 strips/coil	347% 46,145 lbs buy	✓ covered
422355053	8.550″	2.7k · 5.8k · 3.8k	12,300 lbs	Cluster 1 · 65.00″	via rotation	100% 12,300 lbs buy	✓ covered
418345035	9.625″	4.0k · 4.0k · 4.0k	12,045 lbs	Cluster 1 · 65.00″	via rotation	100% 12,045 lbs buy	✓ covered
425322070	15.709″	0.0k · 6.0k · 6.0k	12,000 lbs	Cluster 3 · 65.00″	1 strip/coil	100% 12,000 lbs buy	✓ covered
423318051	19.600″	0.0k · 11.1k · 0.0k	11,100 lbs	Cluster 1 · 65.00″	via rotation	100% 11,100 lbs buy	✓ covered
413184004	11.000″	0.0k · 10.0k · 0.0k	10,000 lbs	Cluster 1 · 65.00″	1 strip/coil	100% 10,000 lbs buy	✓ covered
415114004	32.244″	0.0k · 0.0k · 10.0k	10,000 lbs	Cluster 1 · 65.00″	via rotation	100% 10,000 lbs buy	✓ covered
425322067	10.591″	2.0k · 4.0k · 4.0k	10,000 lbs	Cluster 1 · 65.00″	via rotation	100% 10,000 lbs buy	✓ covered
411012017	9.170″	4.0k · 2.0k · 4.0k	10,000 lbs	Cluster 3 · 65.00″	1 strip/coil	100% 10,000 lbs buy	✓ covered
421004031	2.231″	8.0k · 0.0k · 0.0k	8,000 lbs	Cluster 1 · 65.00″	10 strips/coil	100% 8,000 lbs buy	✓ covered
425322069	19.000″	0.0k · 3.0k · 5.0k	8,000 lbs	Cluster 3 · 65.00″	via rotation	100% 8,000 lbs buy	✓ covered
422357039	28.874″	0.0k · 0.0k · 7.0k	7,000 lbs	Cluster 3 · 65.00″	via rotation	100% 7,000 lbs buy	✓ covered
420197042	4.500″	3.0k · 3.0k · 0.0k	6,000 lbs	Cluster 1 · 65.00″	via rotation	100% 6,000 lbs buy	✓ covered
422290005	2.284″	1.6k · 1.9k · 1.8k	5,212 lbs	Cluster 2 · 65.00″	3 strips/coil	347% 18,100 lbs buy	✓ covered
415356017	4.375″	0.0k · 5.0k · 0.0k	5,000 lbs	Cluster 1 · 65.00″	via rotation	100% 5,000 lbs buy	✓ covered
415356024	4.750″	1.5k · 1.5k · 1.5k	4,500 lbs	Cluster 1 · 65.00″	via rotation	100% 4,500 lbs buy	✓ covered
423318047	39.055″	0.0k · 0.6k · 1.7k	2,333 lbs	Cluster 2 · 65.00″	1 strip/coil	347% 8,102 lbs buy	✓ covered
422361045	49.882″	1.1k · 0.0k · 1.1k	2,204 lbs	Cluster 2 · 65.00″	via rotation	347% 7,654 lbs buy	✓ covered
415356016	4.625″	0.0k · 2.0k · 0.0k	2,000 lbs	Cluster 1 · 65.00″	1 strip/coil	100% 2,000 lbs buy	✓ covered
415356023	3.700″	0.0k · 0.0k · 2.0k	2,000 lbs	Cluster 1 · 65.00″	via rotation	100% 2,000 lbs buy	✓ covered
416343014	3.625″	0.0k · 0.0k · 2.0k	2,000 lbs	Cluster 1 · 65.00″	via rotation	100% 2,000 lbs buy	✓ covered
426117014	9.134″	2.0k · 0.0k · 0.0k	2,000 lbs	Cluster 1 · 65.00″	via rotation	100% 2,000 lbs buy	✓ covered
415356013	3.875″	0.0k · 0.0k · 1.5k	1,500 lbs	Cluster 1 · 65.00″	1 strip/coil	100% 1,500 lbs buy	✓ covered
422013019	3.362″	0.0k · 1.0k · 0.0k	1,000 lbs	Cluster 3 · 65.00″	via rotation	100% 1,000 lbs buy	✓ covered