Date range
Pending Roll Work Order
–
Pending Plain Label Work Order
–
Pending Color Label Work Order
–
Pending Digital Work Order
–
Total Pending Work Order
–
Monthly sales
₹ lakh — FY 2026-27
Monthly profit
Net profit, ₹ lakh — FY 2026-27
Wastage Flow
Roll vs Label wastage value, ₹ lakh — FY 2026-27
Production trend by stage — FY 2026-27
Gumming
Output per month
Slitting
Output per month
Color
Output per month
Die Punch
Output per month
Ready Roll
Output per month
Financial year totals — FY 2025-26
Mfg cost
₹0
Raw material in
₹0
Goods out
₹0
Yearly trend — FY 2024-25 to FY 2026-27
Yearly Sales
₹ lakh, Sales/Profit/Mfg cost per financial year (Apr–Mar)
Wastage % by year
Average blended wastage %, per financial year
Month-wise snapshot
Today's snapshot — morning owner screen
No target/budget table existed in this schema — added one this session (
targets: metric, month, value), seeded from real history: Sales and production (Gumming/Slitting/Ready Roll) targets = same month last year × 1.08 (8% growth), Wastage ceiling = your own trailing-12-month average. All are normal editable rows now, not fixed by this dashboard. Color and Die Punch production targets, and Operator targets, are still not included — no real basis for those yet.Sales: target vs actual
₹ lakh — FY 2026-27
Wastage %: actual vs ceiling
Blended wastage % — FY 2026-27
Production targets by stage — FY 2026-27
Gumming: target vs actual
MTR / month
Slitting: target vs actual
MTR / month
Ready Roll: target vs actual
PCS / month
Manage targets
Add / update a target
Current targets
All rows in the
targets table — click Edit to load a row into the form aboveLive production pipeline (last 7 days)
This week's production by stage
Work order summary
Label orders: Color vs Plain
By order type (real field, replaces the old customer/stock split — no stock-order concept found in the schema)
Pending job queue by stage
Jobs awaiting processing — last 7 days
Work order status pipeline — by order value
Count of orders shown alongside each status; amount (₹) is the bar length since order value matters more than order count. Statuses with no live orders still show as a zero row. Grey bars are real statuses seen in the data outside the defined pipeline (e.g. Completed, Cancel).
Label work orders
Requested → Active → Assigned → Roll_Alloted → Job_Alloted → In_Production → QC → Packaging → Dispatched
Roll work orders
Requested → Active → Roll_Alloted → Assigned → In_Production → Completed → Dispatched → Cancel
Production totals by stage — FY 2026-27
From the real production/stock tables (prdctn_qt/sl/clr/dp/rr), each with its own rate & total — quantity and amount both shown, not just record count. Die Punch and Ready Roll are counted in PCS, not MTR (see the Ready Roll unit note elsewhere on this dashboard).
Material flow by stage — Total Production, Used Material & Stock Material
All-time, live on-hand figures (like the Business Overview's Raw Material / W.I.P. Stock tiles) — not scoped to the FY selector above. Used Material = consumed into the next stage; Stock Material = still-open, unconsumed lots on hand right now. Gumming/Slitting/Color are MTR; Die Punch and Ready Roll are PCS (see the note above).
Period
Today's sales
–
This month
–
Average invoice
–
Total customers
–
Active customers
–
Monthly sales
₹ lakh — FY 2026-27
Sales by channel
Label · Roll · Direct, this month
Monthly Summary
₹ lakh unless noted — FY 2026-27
Current week
22 Jun – 28 Jun
Previous week
15 Jun – 21 Jun
Daily sales vs previous week
Sales (₹) — day by day
Current week (solid) vs previous week (muted)
Daily wastage vs previous week
Wastage (₹) — day by day
Daily waste losses: current week vs previous week
Overall wastage
1.85%
Wastage value
₹0
Worst stage
—
Process-wise wastage
% of production value at each stage — mostly inherent winding/trim loss, not incident-based — FY 2026-27
Monthly wastage trend
Blended wastage % — FY 2026-27
Wastage by stage — quantity & amount, FY 2026-27
Lot-level wastage lookup
Search a production lot (by lot number or customer) to see its wastage broken down by stage, linked via
prdctnid — the same field used for lot-level job costing. Gumming/Slitting/Color are in MTR; Die Punch is in PCS (also covers what an older version of this dashboard mislabelled as separate "Ready Roll wastage" — there is no separate Ready Roll wastage table in this schema, see the note on this dashboard's Ready Roll unit fix).Keyed on the real production lot (
prdctno), not the work order — work orders have no real linkage to production/sales data anywhere in this schema (checked, not assumed). Profit here is Sale Value − Mfg Cost − Wastage Cost, so a lot's material waste counts against it, not just its sale margin.Profitable lots
0
Loss-making lots
0
Average margin
0%
Wastage cost impact
₹0
Lowest-margin production lots
Worst 8 lots (min ₹10,000 sale value) — red bars are losing money
Biggest production lots by sale value
Sale value vs mfg cost, wastage cost & profit
Sales
₹0
Purchase (raw material)
₹0
Mfg cost
₹0
Gross profit
₹0
"Gross profit" = Sales − Mfg Cost only. This ERP has no salary/electricity/overhead ledger, so a true bottom-line Net Profit can't be computed from this database — the old mockup's separate "Expense" and "Net profit" tiles are removed rather than shown with invented numbers.
Sales vs Purchase vs Mfg Cost
₹ lakh / month — FY 2026-27
Top raw materials by purchase value
FY 2026-27
Raw material stock value
₹0
"Finished goods", "Semi-finished", and "Scrap value" are removed — the
scrap table is completely empty (never used), and finished-goods stock would need the same lot-balance logic one level up the production chain, not yet built. No reorder-point field is populated anywhere either, so "months of stock remaining" (qty ÷ trailing-12-month average monthly consumption) is used instead of a fixed threshold.Stock status — months of cover remaining
Current stock ÷ average monthly consumption, top materials by value
Low stock alerts
Under 1 month of cover at current consumption rate
Raw material consumption
₹ lakh / month — FY 2026-27
New customers
22
Returning customers
112
Inactive customers
24
Customer-wise sales
Date range
Customer-wise sales — Roll
Top 20 by revenue — prdctn_sales rows with slid set or detail "PAPER ROLL"
Customer-wise sales — Label
Top 20 by revenue — all other prdctn_sales rows
No machine master table is used by production — machines are identified by their login account (flexo, inline, rotary, gumming, slitting, 1sliter, etc.), found via
bloomtech_login.bloom_personal = 'BLTAB785USERY816' (the token value shared by every real machine login, confirmed against the full login table), and each job records which one ran it via the usr field. That also means "Operator Dashboard" was really machine-level data all along; a true per-operator table (30 rows) exists but isn't referenced by any job record found. Hours only count jobs with a plausible (under 16hr) recorded duration — a real data-quality issue was found and worked around, not hidden: several job records show 800+ hour "runs" that are clearly stuck jobs force-closed together, not real production time.Machine performance
Jobs & running hours by machine, FY total
Time-tracking data coverage
Share of jobs with a usable start/end time — not an efficiency score
0%
of jobs have valid recorded duration
Amount of production by machine
Job records don't store a rate/amount themselves (checked — always 0) — amount comes from the matching production record each job is linked to (
jobid), real for 90–100% of jobs per stage in the selected window (exact coverage shown below the chart, not assumed 100%).This month
Same source as preport/slitinguser_data.php and preport/readyrolluser_data.php:
opt on each production table (prdctn_qt/sl/clr/dp/rr, not the job_* scheduling tables) resolves to operator_master.id. This also recovers Slitting, which the job_sl table has no operator data for at all — prdctn_sl.opt does.
Period
Production by operator (Roll count & Amount) — This month
Gumming
Slitting
Color
Die-Punch
Ready-Roll
Active operators
… operators with real production this period, across all 5 stages