🌳

Mimir Plan 2605 · Audit

Forecast demand513,200 lbs

Orders19

Covered19

Short0

Buy vs forecast123%

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

Coil weight59,667 lb

PIW1217.7 lb/in

Coils6

Spec OD window56.0–60.0″

Demand350,923 lb

Buy358,000 lb

Buy vs forecast102%

Over-buy7,077 lb

% Scrap2.0%

$/cwt to run$45.92

Reworksnone

Series13 multi

Cut pattern (per coil): 19.662″ + 3.550″ + 10.625″ + 5.310″ + 8.850″

Strip width	Lbs / master	Finished coils	Each	Finished OD
19.662″	23,942 lb	2×	11,971 lb	56.0″
16.500″	20,092 lb	2×	10,046 lb	56.0″
13.150″	16,013 lb	2×	8,006 lb	56.0″
10.625″	12,938 lb	2×	6,469 lb	56.0″
10.236″	12,464 lb	2×	6,232 lb	56.0″
8.850″	10,777 lb	2×	5,388 lb	56.0″
8.840″	10,764 lb	2×	5,382 lb	56.0″
8.583″	10,451 lb	2×	5,226 lb	56.0″
7.100″	8,646 lb	2×	4,323 lb	56.0″
6.500″	7,915 lb	2×	3,957 lb	56.0″
5.830″	7,099 lb	2×	3,550 lb	56.0″
5.310″	6,466 lb	2×	3,233 lb	56.0″
3.550″	4,323 lb	2×	2,161 lb	56.0″

Cluster 2 49″W × 68.0″OD × 24″ID 1 series / strip

Coil weight44,126 lb

PIW900.5 lb/in

Coils2

Spec OD window65.0–72.0″

Demand88,252 lb

Buy88,252 lb

Buy vs forecast100%

% Scrap5.9%

$/cwt to run$45.92

Reworksnone

Series2

Cut pattern (per coil): 18.000″ + 18.000″ + 10.100″

Strip width	Lbs / master	Finished coils	Each	Finished OD
18.000″	16,210 lb	1×	16,210 lb	68.0″
10.100″	9,095 lb	1×	9,095 lb	68.0″

Cluster 3 49″W × 71.6″OD × 20″ID multi-series rewind OD-floored

Coil weight51,438 lb

PIW1049.8 lb/in

Coils2

Spec OD window—–50.0″

Demand51,438 lb

Buy102,876 lb

Buy vs forecast200%

Over-buy51,438 lb

% Scrap4.5%

$/cwt to run$45.92

Reworksnone

Series2 multi

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

Strip width	Lbs / master	Finished coils	Each	Finished OD
15.594″	16,370 lb	3×	5,457 lb	44.4″
9.500″	9,973 lb	3×	3,324 lb	44.4″

Cluster 4 49″W × 63.8″OD × 20″ID multi-series rewind OD-floored

Coil weight40,000 lb

PIW816.3 lb/in

Coils2

Spec OD window—–48.0″

Demand22,587 lb

Buy80,000 lb

Buy vs forecast354%

Over-buy57,413 lb

% Scrap3.3%

$/cwt to run$45.92

Reworks4,209 lb

Series2 multi

Cut pattern (per coil): 10.600″ + 10.600″ + 10.600″ + 10.600″ + 1.250″ + 1.250″ + 1.250″ + 1.250″

Strip width	Lbs / master	Finished coils	Each	Finished OD
10.600″	8,653 lb	2×	4,327 lb	47.3″
1.250″	1,020 lb	2×	510 lb	47.3″

Order	Width	Forecast (Aug · Sep · Oct)	Total	Served by	In pattern	Buy vs Forecast	Cover
425100034	6.500″	47.3k · 47.3k · 47.3k	141,819 lbs	Cluster 1 · 49.00″	via rotation	102% 144,679 lbs buy	✓ covered
425227075	10.100″	25.0k · 48.3k · 0.0k	73,252 lbs	Cluster 2 · 49.00″	1 strip/coil	100% 73,252 lbs buy	✓ covered
423018024	8.840″	20.0k · 40.0k · 0.0k	60,000 lbs	Cluster 1 · 49.00″	1 strip/coil	102% 61,210 lbs buy	✓ covered
420350013	9.500″	13.8k · 13.8k · 13.8k	41,439 lbs	Cluster 3 · 49.00″	via rotation	200% 82,878 lbs buy	✓ covered
419282044	19.662″	8.8k · 8.8k · 17.6k	35,273 lbs	Cluster 1 · 49.00″	1 strip/coil	102% 35,984 lbs buy	✓ covered
426099019	10.625″	13.0k · 0.0k · 13.0k	26,000 lbs	Cluster 1 · 49.00″	1 strip/coil	102% 26,524 lbs buy	✓ covered
425008085	5.310″	13.0k · 4.7k · 4.7k	22,322 lbs	Cluster 1 · 49.00″	1 strip/coil	102% 22,772 lbs buy	✓ covered
423004012	5.830″	0.0k · 0.0k · 20.0k	20,000 lbs	Cluster 1 · 49.00″	via rotation	102% 20,403 lbs buy	✓ covered
420350029	10.600″	6.1k · 6.1k · 6.1k	18,378 lbs	Cluster 4 · 49.00″	4 strips/coil	354% 65,092 lbs buy	✓ covered
425174021	16.500″	0.0k · 0.0k · 15.0k	15,000 lbs	Cluster 1 · 49.00″	via rotation	102% 15,303 lbs buy	✓ covered
426019054	18.000″	0.0k · 15.0k · 0.0k	15,000 lbs	Cluster 2 · 49.00″	2 strips/coil	100% 15,000 lbs buy	✓ covered
424130062	10.236″	0.0k · 5.5k · 7.0k	12,470 lbs	Cluster 1 · 49.00″	via rotation	102% 12,721 lbs buy	✓ covered
421088014	15.594″	3.3k · 3.3k · 3.3k	9,999 lbs	Cluster 3 · 49.00″	3 strips/coil	200% 19,998 lbs buy	✓ covered
424011076	8.583″	0.0k · 3.5k · 3.5k	7,000 lbs	Cluster 1 · 49.00″	via rotation	102% 7,141 lbs buy	✓ covered
420350027	1.250″	1.4k · 1.4k · 1.4k	4,209 lbs	Cluster 4 · 49.00″	4 strips/coil	354% 14,908 lbs buy	✓ covered
424122027	8.850″	0.0k · 4.0k · 0.0k	4,000 lbs	Cluster 1 · 49.00″	1 strip/coil	102% 4,081 lbs buy	✓ covered
419319020	3.550″	1.1k · 1.1k · 1.1k	3,309 lbs	Cluster 1 · 49.00″	1 strip/coil	102% 3,376 lbs buy	✓ covered
425163012	13.150″	0.0k · 1.0k · 1.0k	2,000 lbs	Cluster 1 · 49.00″	via rotation	102% 2,040 lbs buy	✓ covered
422003033	7.100″	0.0k · 1.7k · 0.0k	1,730 lbs	Cluster 1 · 49.00″	via rotation	102% 1,765 lbs buy	✓ covered