BP12 STRUCTURAL PRODUCTION
Production capacity & backlog
Schedule the work. Track the backlog. Retain every report snapshot.
Planned Capacity vs Scheduled Hours
Compares the supervisor-adjustable weekly capacity plan against the ticketed production hours scheduled into each week.
Planned vs Actual Credited Hours
Historical planned capacity compared with credited Jointing + Fabrication equipment hours.
Largest Ticketed Jobs
Latest Weekly Piece Change
What changed between the two most recent Weekly Piece snapshots.
Ahead / Behind Forecast
Weekly capacity position and the running cumulative recovery or deficit.
Weekly Production Capacity Scheduler
These are the shared scheduler controls. Capacity and workday changes save automatically. Selected Week Ending focuses the KPIs, credited production, job summary, and matching schedule row.
Credited Production — Selected Week
Machine Hours are posted after production. Only Jointing and Fabrication are used here; other work centers are ignored.
Current Week Schedule Movement
Shown when the current week is selected. The first Weekly Piece import establishes a shared baseline so reductions and newly added work can be separated.
Weekly Production Capacity Schedule
Weekly Capacity + Job Breakdown
Past-due work rolls into the current week. Planned capacity can be overridden by week for holidays, shutdowns, overtime, or staffing changes.
| Week Ending / Job | Job Name | Job Detail | Open Pieces | Scheduled Hrs | Planned Cap Hrs | Available Cap Hrs | Ahead / (Behind) | Cumulative A/(B) Hrs | Cum. Days A/(B) | Status | Notes |
|---|
Ticketed Backlog Trend
Historical scheduled runtime retained from Weekly Piece report snapshots.
Click a point to inspect that week.
Job Summary — Selected Week
Grouped by Job Number + Fab Date + Color + Finish + Description.
| Job Number | Job Name | Pieces | Color | Finish | Description | Fab Date | Runtime Hrs |
|---|
Production Backlog
| Job | Description | Family | Project Manager | Stone PM | Ticket Complete | Open Hrs | Open Sq Ft | Fab Date | CNC Hrs | Sandblast Hrs | Assembly Hrs |
|---|
Import History
The database keeps each distinct report upload instead of replacing the previous snapshot.
Retained Ticketed Backlog History
Weekly values created from Weekly Piece Report imports.
| Week Ending | Scheduled Hrs | Open Pieces | Last Updated |
|---|
Credited Production History
Retrospective Jointing and Fabrication equipment hours from Machine Hours reports, assigned to the Friday production week inside each report period.
| Week Ending | Jointing Hrs | Fabrication Hrs | Report Period | Source |
|---|
Import Production Reports
Drop the same reports supervisors already use. The browser reads the report, previews normalized data, and saves the structured snapshot to MySQL.
Drop a production report hereWeekly Piece PDF/CSV • Production Backlog XLSX/CSV • Machine Hours PDF (Jointing + Fabrication only)
No file selected.
Import Preview
Scheduler Controls
Capacity and workday settings now live where supervisors use them: at the top of Weekly Schedule.
Use Weekly Capacity, Daily Capacity, Workday Start, Workday End, and Selected Week Ending on the Weekly Schedule tab. Weekly overrides remain editable in the schedule table.
Accounts
Version 1 is supervisor-only, while the database retains a role field for future access levels.
Passwords, sessions, CSRF protection, login throttling, and account revocation follow the same pattern used by Quarry Demand.
Production Schedule
Enter holidays and plant shutdown days. Closed weekdays automatically reduce that production week's planned capacity.
No closed production days have been entered.
| Date | Type | Description | Capacity Effect | Action |
|---|
Current Data
Latest active snapshots used by the application. Older imports remain available in History.
Report Ingestion Path
Manual upload is the first reliable stage. The import-batch model is deliberately built so server-side scheduled ingestion can be added later without changing the production tables.
Exact duplicate files are blocked by SHA-256 fingerprint. A new report creates a new import batch and preserves the prior snapshot for historical analysis.