Production floor & OEE template
The production floor on one screen for a small machining and sheet-metal shop: work centres, production orders, shift reports with the full OEE chain (Availability × Performance × Quality), a downtime log with a Pareto of lost minutes, and maintenance requests — with late-order flags, a public downtime form and four ready dashboards.
Tables
Work centres
Code, Name, Status, Type, Area lead, Hall, Planned hours / week, Typical ideal cycle (s), Machine-hour cost, OEE target, Last service, Next service, Planned weekly cost, Service and 10 more
Production orders
Order no., Part / product, Status, Customer, Work centre, Work centre record, Machine, Material, Priority, Qty ordered, Qty good, Qty scrap, Unit price, Start and 11 more
Shift reports
Report no., Date, Shift, Work centre, Work centre record, Machine, Order no., Production order, Part, Operator, Planned time (min), Run time (min), Ideal cycle (s), Total count and 10 more
Downtime
Event no., Date, Shift, Work centre, Work centre record, Machine, Reason, Minutes, Planned stop, Reported by, What happened, Hours, Unplanned (h), Long stop
Maintenance requests
Request no., Problem, Status, Work centre, Work centre record, Machine, Category, Priority, Reported by, Technician, Reported at, Closed at, Parts cost, Description and 1 more
Views
- All shift reports (grid)
- OEE by work centre (chart)
- Shifts below 60% OEE (grid)
- By work centre (grid)
- Shift calendar (calendar)
- Good parts per day (chart)
- All orders (grid)
- Orders board (kanban)
- Late orders (grid)
- Production schedule (timeline)
- Due dates (calendar)
- Load per work centre (workload)
- …and 11 more
Forms
- Report downtime
- Maintenance request
Automations
- Unplanned stop over 30 min — call maintenance
- Breakdown logged — open a maintenance request
- Morning check — orders past due
- Order finished — tell planning
- Shift below 60% OEE — alert the production manager
- Daily production summary
- Repair closed — machine back in service
- “Planned stop” was ticked in “Downtime”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.