Print Shop Management ERP
Printing Press & Job-Shop Manufacturing
Quote-to-dispatch ERP for a printing press: scheduling, job costing, inventory and multi-process production tracking.
Quote → Dispatch
Flow
Multi-process
Costing
FIFO ledger
Inventory
PDF reports
Output
Overview
A printing-press ERP that manages job orders from quotation to completion, schedules presses, tracks paper and consumable inventory, and costs jobs across pre-press, press and post-press stages.
The business problem
Job costing, machine scheduling and inventory were tracked on paper and spreadsheets, making it hard to quote accurately, plan capacity, or know true job profitability.
The solution
I built a modular Flask backend with complex BOM and job-costing logic over PostgreSQL, an Angular front office, and PDF reporting — capturing the full multi-process production workflow.
My responsibilities
- Built job-order management from quote to completion
- Implemented press scheduling and capacity tracking
- Developed multi-process job costing and inventory ledgers
- Delivered production, dispatch and utilization reports
Challenges solved
- Costing jobs accurately across multiple production processes
- Planning press capacity against live job load
- Tracking paper consumption and stock with FIFO valuation
Key features
Architecture highlights
- Modular Flask REST API with complex relational models
- Job-costing engine spanning pre-press, press and post-press
- FIFO inventory valuation with a stock ledger
- WeasyPrint PDF reporting and Excel import/export
Technologies used
Scalability
Modular handlers and a normalised model let new processes and machines be added without disrupting existing flows.
Performance
- Set-based job-costing roll-ups
- Indexed stock-ledger access
- Batched report generation
Security
- JWT authentication and RBAC
- Audit trail for job modifications
- Validated material and job entry
Screenshots
Product screenshots available on request (NDA-protected).
Architecture diagram
Detailed system architecture available on request.
Related work
View allQuality Lifecycle Management Platform
Manufacturing Quality (Forging)
Standardised manufacturing quality and eliminated errors from outdated process documents through strict version control.
Manufacturing ERP System
Discrete Manufacturing & Production Planning
A full production ERP spanning BOM, planning, procurement, WIP and costing — modernised from a legacy desktop system.
Human Resources Management System
Human Resources & Workforce Management
Automated the full employee lifecycle — attendance, leave, payroll and recruitment-to-onboarding — in one integrated system.