🌳

Mimir Plan 2712 · Audit

Forecast demand997,008 lbs

Orders29

Covered29

Short0

Buy vs forecast105%

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 71″W × 60.0″OD × 20″ID 1 series / strip OD-floored

Coil weight50,499 lb

PIW711.3 lb/in

Coils13

Spec OD window60.0–60.0″

Demand624,216 lb

Buy656,490 lb

Buy vs forecast105%

Over-buy32,274 lb

% Scrap1.4%

$/cwt to run$43.50

Reworksnone

Series17

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

Strip width	Lbs / master	Finished coils	Each	Finished OD
16.300″	11,593 lb	1×	11,593 lb	60.0″
16.000″	11,380 lb	1×	11,380 lb	60.0″
15.600″	11,096 lb	1×	11,096 lb	60.0″
14.500″	10,313 lb	1×	10,313 lb	60.0″
12.500″	8,891 lb	1×	8,891 lb	60.0″
11.600″	8,251 lb	1×	8,251 lb	60.0″
11.000″	7,824 lb	1×	7,824 lb	60.0″
10.600″	7,539 lb	1×	7,539 lb	60.0″
10.000″	7,113 lb	1×	7,113 lb	60.0″
8.500″	6,046 lb	1×	6,046 lb	60.0″
7.000″	4,979 lb	1×	4,979 lb	60.0″
6.380″	4,538 lb	1×	4,538 lb	60.0″
6.375″	4,534 lb	1×	4,534 lb	60.0″
6.300″	4,481 lb	1×	4,481 lb	60.0″
4.400″	3,130 lb	1×	3,130 lb	60.0″
4.000″	2,845 lb	1×	2,845 lb	60.0″
1.650″	1,174 lb	1×	1,174 lb	60.0″

Cluster 3 71″W × 64.0″OD × 24″ID 1 series / strip OD-floored

Coil weight55,549 lb

PIW782.4 lb/in

Coils3

Spec OD window64.0–72.0″

Demand162,000 lb

Buy166,647 lb

Buy vs forecast103%

Over-buy4,647 lb

% Scrap1.6%

$/cwt to run$43.50

Reworksnone

Series3

Cut pattern (per coil): 7.638″ + 7.638″ + 7.638″ + 5.827″ + 6.875″ + 6.875″ + 6.875″ + 6.875″ + 6.875″ + 6.875″

Strip width	Lbs / master	Finished coils	Each	Finished OD
7.638″	5,976 lb	1×	5,976 lb	64.0″
6.875″	5,379 lb	1×	5,379 lb	64.0″
5.827″	4,559 lb	1×	4,559 lb	64.0″

Cluster 2 71″W × 58.8″OD × 20″ID multi-series rewind

Coil weight48,186 lb

PIW678.7 lb/in

Coils3

Spec OD window—–47.0″

Demand144,557 lb

Buy144,557 lb

Buy vs forecast100%

% Scrap1.4%

$/cwt to run$43.50

Reworksnone

Series7 multi

Cut pattern (per coil): 3.504″ + 3.504″ + 3.504″ + 3.504″ + 3.504″ + 3.504″ + 3.740″ + 3.740″ + 3.740″ + 3.740″ +5 more

Strip width	Lbs / master	Finished coils	Each	Finished OD
20.000″	13,573 lb	2×	6,787 lb	43.9″
3.740″	2,538 lb	2×	1,269 lb	43.9″
3.661″	2,485 lb	2×	1,242 lb	43.9″
3.543″	2,405 lb	2×	1,202 lb	43.9″
3.504″	2,378 lb	2×	1,189 lb	43.9″
3.346″	2,271 lb	2×	1,136 lb	43.9″
3.307″	2,244 lb	2×	1,122 lb	43.9″

Cluster 4 71″W × 55.8″OD × 24″ID 1 series / strip OD-floored

Coil weight40,000 lb

PIW563.4 lb/in

Coils2

Spec OD window49.0–59.0″

Demand66,235 lb

Buy80,000 lb

Buy vs forecast121%

Over-buy13,765 lb

% Scrap3.2%

$/cwt to run$43.50

Reworksnone

Series2

Cut pattern (per coil): 15.250″ + 15.250″ + 15.250″ + 15.250″ + 7.700″

Strip width	Lbs / master	Finished coils	Each	Finished OD
15.250″	8,592 lb	1×	8,592 lb	55.8″
7.700″	4,338 lb	1×	4,338 lb	55.8″

Order	Width	Forecast (Aug · Sep · Oct)	Total	Served by	In pattern	Buy vs Forecast	Cover
415082053	16.300″	68.0k · 86.0k · 34.0k	188,000 lbs	Cluster 1 · 71.00″	via rotation	105% 197,720 lbs buy	✓ covered
416152014	7.000″	51.4k · 47.3k · 31.2k	129,831 lbs	Cluster 1 · 71.00″	10 strips/coil	105% 136,544 lbs buy	✓ covered
420276057	7.638″	34.0k · 0.0k · 37.0k	71,000 lbs	Cluster 3 · 71.00″	3 strips/coil	103% 73,037 lbs buy	✓ covered
420276059	6.875″	31.0k · 0.0k · 31.0k	62,000 lbs	Cluster 3 · 71.00″	6 strips/coil	103% 63,778 lbs buy	✓ covered
423060002	3.504″	20.0k · 19.5k · 18.8k	58,254 lbs	Cluster 2 · 71.00″	6 strips/coil	100% 58,254 lbs buy	✓ covered
415348040	15.600″	22.5k · 24.4k · 9.4k	56,330 lbs	Cluster 1 · 71.00″	via rotation	105% 59,242 lbs buy	✓ covered
426092022	14.500″	18.0k · 14.0k · 16.0k	48,000 lbs	Cluster 1 · 71.00″	via rotation	105% 50,482 lbs buy	✓ covered
426092023	16.000″	30.0k · 0.0k · 14.0k	44,000 lbs	Cluster 1 · 71.00″	via rotation	105% 46,275 lbs buy	✓ covered
421097057	15.250″	14.0k · 22.0k · 7.0k	43,000 lbs	Cluster 4 · 71.00″	4 strips/coil	121% 51,936 lbs buy	✓ covered
418127002	8.500″	18.0k · 24.0k · 0.0k	42,039 lbs	Cluster 1 · 71.00″	via rotation	105% 44,213 lbs buy	✓ covered
420276058	5.827″	10.0k · 10.0k · 9.0k	29,000 lbs	Cluster 3 · 71.00″	1 strip/coil	103% 29,832 lbs buy	✓ covered
423352063	10.600″	7.9k · 7.9k · 7.9k	23,649 lbs	Cluster 1 · 71.00″	via rotation	105% 24,872 lbs buy	✓ covered
422007021	7.700″	7.7k · 7.7k · 7.7k	23,235 lbs	Cluster 4 · 71.00″	1 strip/coil	121% 28,064 lbs buy	✓ covered
421294060	3.740″	7.2k · 7.0k · 6.8k	21,010 lbs	Cluster 2 · 71.00″	4 strips/coil	100% 21,010 lbs buy	✓ covered
413140029	10.000″	4.8k · 6.0k · 8.0k	18,855 lbs	Cluster 1 · 71.00″	via rotation	105% 19,830 lbs buy	✓ covered
423348061	3.307″	5.7k · 5.8k · 5.5k	16,901 lbs	Cluster 2 · 71.00″	via rotation	100% 16,901 lbs buy	✓ covered
422070001	4.400″	3.5k · 5.5k · 7.6k	16,549 lbs	Cluster 1 · 71.00″	via rotation	105% 17,405 lbs buy	✓ covered
419088004	20.000″	0.0k · 0.0k · 16.0k	15,961 lbs	Cluster 2 · 71.00″	1 strip/coil	100% 15,961 lbs buy	✓ covered
424194052	3.661″	5.1k · 5.0k · 4.8k	14,987 lbs	Cluster 2 · 71.00″	2 strips/coil	100% 14,987 lbs buy	✓ covered
419267008	12.500″	5.3k · 1.9k · 6.5k	13,830 lbs	Cluster 1 · 71.00″	via rotation	105% 14,545 lbs buy	✓ covered
421294065	3.346″	4.1k · 4.1k · 3.9k	12,130 lbs	Cluster 2 · 71.00″	2 strips/coil	100% 12,130 lbs buy	✓ covered
425055016	6.375″	3.4k · 3.4k · 3.4k	10,092 lbs	Cluster 1 · 71.00″	via rotation	105% 10,614 lbs buy	✓ covered
421140053	1.650″	0.0k · 6.0k · 4.0k	10,000 lbs	Cluster 1 · 71.00″	via rotation	105% 10,517 lbs buy	✓ covered
421049013	11.000″	3.9k · 1.9k · 3.9k	9,707 lbs	Cluster 1 · 71.00″	via rotation	105% 10,209 lbs buy	✓ covered
420029013	11.600″	0.0k · 2.2k · 3.3k	5,502 lbs	Cluster 1 · 71.00″	via rotation	105% 5,786 lbs buy	✓ covered
421294047	3.543″	1.8k · 1.8k · 1.7k	5,314 lbs	Cluster 2 · 71.00″	via rotation	100% 5,314 lbs buy	✓ covered
419267023	4.000″	0.0k · 1.5k · 2.2k	3,667 lbs	Cluster 1 · 71.00″	via rotation	105% 3,857 lbs buy	✓ covered
420071030	6.380″	0.0k · 0.0k · 2.8k	2,800 lbs	Cluster 1 · 71.00″	via rotation	105% 2,945 lbs buy	✓ covered
418204041	6.300″	0.0k · 1.4k · 0.0k	1,365 lbs	Cluster 1 · 71.00″	via rotation	105% 1,436 lbs buy	✓ covered