ChartGBT — Chart Review Help

Overview

The Chart Review screen shows coils that have been charted by planners but not yet produced. Each row is a master coil with the planner's cutting pattern — the strips they plan to create, orders allocated, and scrap generated. The screen scores every chart on key performance indicators (KPIs) so you can quickly find weak charts, prioritize what to re-examine, and compare planner decisions against the optimizer's recommendations.

KPI Dashboard (Top Bar)

The colored boxes at the top summarize all pending charts:

Box	What It Shows
Pending Charts	Total number of charted-but-unproduced coils and their combined weight in lbs.
Scrap (Pending)	Total scrap lbs across all pending charts, with the average scrap % below.
Avg $/CWT	Average estimated incremental cost per hundredweight across non-salvage charts. Includes setup cost and scrap disposal — does not include base material cost.
Avg Health	Average health score (0-100) across non-salvage charts. Higher is better.
Overdue	Charts with orders whose release date has already passed. Only appears if count > 0.
Firm Window	Charts with orders due within the next 4 business days.
Salvage	Charts on small coils (<10,000 lbs) — typically remnants being salvaged rather than optimized. Only appears if count > 0.

Search Box

Type any part of a tag number, purchase plan, or order number to filter the table instantly. The search matches against all three fields. Clear the box to show all charts again.

Sort Dropdown

Choose how to order the table rows:

Option	What It Sorts By
Health Score	Composite quality score (worst first by default). Best starting point for finding charts to improve.
Scrap %	Percentage of coil weight that becomes scrap (highest first).
Scrap Lbs	Absolute scrap weight in pounds (highest first).
$/CWT	Estimated incremental cost per hundredweight (highest first).
Chart Age	Days since the chart was created (oldest first).
Firm Coverage	Percentage of F/G lbs serving firm releases (lowest first).
Coil Weight	Total master coil weight in lbs.
Plan	Purchase plan number.

You can also click any column header to sort by that column. Click again to reverse the direction.

Include Produced

Check this box to also show charts that have already been produced (children exist in inventory). Useful for historical comparison — seeing how past charts scored. Unchecked by default since produced charts can no longer be changed.

Filter Buttons

Button	What It Shows
All	Every chart (no filter). Default view.
Overdue	Only charts with at least one order whose release date has passed.
Firm	Charts with orders due within the firm window (4 days) OR overdue.
High Scrap	Non-salvage charts with scrap >= 3%. These are the biggest improvement opportunities.
Low Health	Non-salvage charts with health score below 55. Indicates multiple KPIs are weak.
Salvage	Only salvage coils (<10,000 lbs). Small remnants where high scrap is expected.
Exclude Salvage	Hide salvage coils to focus on full-size coils with actionable improvement potential.

Table Columns

Column	Description
Tag	Master coil tag number and sequence (e.g., 726065016-2). This is the coil being slit. A SALVAGE badge appears on coils under 10,000 lbs.
Plan	Purchase plan number the chart belongs to.
Health	Composite score from 0 (worst) to 100 (best). Blends scrap quality, cost efficiency, firm coverage, aging, and urgency into a single number. Color bar: 65+ (good) 50-64 (needs attention) Below 50 (poor)
Scrap %	Percentage of total coil weight going to scrap. Color bar: 0-2% (good) 2-5% (acceptable) 5%+ (high)
$/CWT	Estimated incremental cost per hundredweight of finished goods. Includes setup cost (based on number of unique widths/series) and scrap disposal. Red if over $20, yellow if over $10.
Firm %	Percentage of F/G strip weight that serves firm releases (due within 4 days). Green if >50%, yellow if >0%, dim if no firm strips.
Age	Days since the chart was created. Yellow after 14 days, red after 30 — older charts may indicate material sitting idle.
Urgency	Based on the earliest release date across all orders on the chart: OVERDUE Release date has passed FIRM Due within 4 business days SOON Due within 5-14 days PLANNED Due within 15-30 days FORECAST Due in 30+ days UNKNOWN No release date found
Weight (lbs)	Total weight of the master coil being slit.
Strips	Number of F/G (finished good) strips the chart creates.
Widths	Unique strip widths in the cutting pattern. More widths = more series = more setup labor.

Row Colors

The left border of each row indicates overall chart quality:

Color	Meaning
Red	Health score below 50 — chart has significant issues across multiple KPIs.
Yellow	Health score 50-64 — chart could benefit from review.
Green	Health score 80+ — chart looks good.
None	Health score 65-79 — average, no action needed.

Detail Panel

Click any row to open the detail panel below the table. It shows:

Score Cards

Eight cards showing individual KPI values with color coding:

Card	Description
Health	Overall composite score (0-100).
Scrap	Scrap percentage and absolute lbs.
$/CWT	Estimated incremental cost per CWT.
Firm	Firm coverage % and count of firm strips.
Age	Days since chart was created.
Urgency	Urgency classification and days to earliest release.
Series	Number of unique widths (proxy for setup complexity).
Holding	Estimated interest/holding cost from material sitting in inventory.

Score Breakdown

Shows the individual sub-scores (0-100 each) that feed into the composite health score: Scrap, Cost, Firm, and Aging.

Optimizer Comparison

If the optimizer has been run for this chart's purchase plan, a side-by-side comparison appears:

• Planner Chart (left) — what the planner designed, with a strip-by-strip breakdown. Firm strips are highlighted.
• Optimizer Best (right) — the best option the optimizer found for this coil. Values better than the planner's are shown in green; worse in red.

A banner at the top shows the scrap delta. If no optimizer result is cached yet, a "Run Optimizer" link takes you directly to the optimizer with the plan and tag pre-filled.

Strips Table

Inside the Planner Chart box, every strip is listed with its sequence number, type (F/G or SCR), width, weight, order number, and whether it serves a firm release. Firm strips have a green FIRM badge and a highlighted row.

Open in Optimizer

The "Open in Optimizer" link at the top of the detail panel opens the main optimizer screen pre-filled with this chart's purchase plan and tag number, so you can run the full optimization and explore alternative cutting patterns.

What's Excluded

The following charts are automatically excluded from the review:

• Division P and Z — Painted and out-of-scope divisions. Checked against inventory PPG1 (all tag sequences) and order PPG1.
• Inspection-only charts — Charts with zero F/G strips (e.g., defect review inspections that only produce scrap).
• Already produced charts — Hidden by default (toggle with "Include produced" checkbox).

Health Score Formula

The composite health score is a weighted blend of five sub-scores:

Component	Weight	How It's Scored
Scrap Quality	25%	0% scrap = 100 pts, 5% = 75 pts, 20% = 0 pts. Salvage coils get a neutral 60.
Cost Efficiency	20%	Based on incremental $/CWT (setup + scrap). Lower is better. Salvage coils get a neutral 50.
Firm Coverage	25%	% of F/G lbs serving firm releases. 100% firm = 100 pts.
Aging	20%	0 days old = 100 pts, 30 days = 50 pts, 60+ days = 0 pts.
Urgency	10%	Bonus for firm window (+10), penalty for overdue (-20).

Recommended Workflow

1. Click Exclude Salvage to focus on full-size coils.
2. Sort by Health Score (default) — worst charts appear first.
3. Click a low-scoring chart to see what's dragging it down.
4. Click "Open in Optimizer" to see if the optimizer finds a better pattern.
5. Compare the planner's chart vs the optimizer's recommendation side-by-side.
6. If the optimizer is better, coordinate with the planner to re-chart before production.
7. If the planner's chart is better, that tells us where the optimizer needs improvement.