Slit Coil Inventory Planner
Upload your on-hand master coil and slit coil inventories as CSV files. The Inventory Planner matches demand against available material and generates slitting plans to fulfill any shortfall.
Overview
The Inventory Planner bridges your physical stock with your production demand. Upload two CSV files — one for master coils, one for slit coils — and the system tells you which master coils to slit, which slit coils are already available, and what additional slitting is needed.
Both CSV templates are available to download directly from the Inventory Planner panel in the app.
Master Coils CSV
This file describes the master coils currently in your warehouse or available for processing.
Required columns
| Column | Description |
|---|---|
| coil_number | Unique identifier for each master coil (e.g., MC-001). |
| lot_number | Lot number for traceability. It will be used to identify the coil for weight calculation purposes. |
| width | Full width of the master coil in your selected unit (inches or mm). |
| weight | Coil weight in your selected weight unit (kg or lbs). |
Uploading
Slit Coils CSV
This file describes your current slit coil inventory — what widths you have on hand, what's allocated, and what the production goal is.
Required columns
| Column | Description |
|---|---|
| slit_id | Unique identifier for this slit coil entry. |
| master_coil_number | Which master coil this slit coil came from. Links back to the master coils file. |
| width | Slit width in your selected unit. |
| on_hand | Quantity currently in stock (weight — consistent with your unit preference). |
| allocated_to_jobs | Quantity already committed to existing jobs. Subtracted from available inventory. |
| goal | Target quantity to have available. The planner calculates what additional slitting is needed to reach this goal. |
Running the Planner
Once both CSV files are uploaded:
Reading Results
Results appear in two sections:
Inventory Overview
A table showing each slit width, current on-hand stock, allocated quantity, available quantity, the production goal, and the shortfall (how much more needs to be produced).
Slitting Plans
For each shortfall, the system generates one or more cut patterns against the selected master coil — showing how to slit it to produce the needed widths with minimal scrap. Each plan card looks like a Coil Slitting result, with pattern details and a visual bar.
Exporting Plans
Two export options are available from the results section:
| Export | Description |
|---|---|
| ↓ CSV | Downloads the slitting plans as a CSV file for use in production tracking or ERP systems. |
| Downloads a formatted PDF of the slitting plans — ready to hand to the floor operator. |