OpTrac is an ERP-style system built to simplify manufacturing operations from quote to completion.

Optrac is a comprehensive, full-stack manufacturing operations management platform designed to streamline the entire production lifecycle from initial customer quotes through final shipping. Built with modern web technologies, this enterprise-grade application provides real-time visibility into shop floor operations, intelligent inventory management, and sophisticated workflow automation for metal fabrication and manufacturing businesses.

Optrac - Manufacturing Operations Management System

Technical Architecture

The application follows a robust client-server architecture with a React TypeScript frontend and a Node.js/Express backend. The frontend leverages Vite for lightning-fast development builds and hot module replacement, while utilizing Tailwind CSS for a beautiful, responsive iOS-inspired interface. The component architecture is built with reusability in mind, featuring custom hooks, context providers for state management, and React Query for intelligent data fetching with automatic caching and background updates. Advanced UI libraries including React Beautiful DnD enable intuitive drag-and-drop Kanban boards, while Framer Motion provides smooth animations throughout the application. The TypeScript implementation ensures type safety across the entire frontend codebase, reducing runtime errors and improving developer productivity.

The backend implements a RESTful API architecture with Express.js, featuring JWT-based authentication with bcrypt password hashing for security. The system uses SQLite as its database engine, providing a lightweight yet powerful relational database that's perfect for on-premise deployment without requiring complex database server infrastructure. The API follows best practices with middleware for authentication, request validation using express-validator, and comprehensive error handling. File uploads are managed through Multer middleware, supporting profile pictures, quote attachments, and material certifications. The modular route structure separates concerns across 20+ API endpoints covering authentication, jobs, quotes, materials, inventory, users, customers, vendors, purchase orders, and more.

Core Features & Functionality

Production Pipeline Management forms the heart of the system, featuring a visual Kanban board that tracks jobs through 12 distinct manufacturing stations organized into preproduction, production, and shipping stages. The workflow begins with quoting and material ordering, progresses through raw material receiving, then moves through various production operations including laser cutting, CNC machining, deburring, break press operations, welding, polishing, and quality inspection before final shipping. Each station supports drag-and-drop job movement, real-time time tracking with live countdown timers, and role-based user assignments ensuring qualified operators are matched to appropriate tasks.

Intelligent Quoting System automates complex pricing calculations by combining material costs, labor rates, machine time, setup times, and markup percentages. The system supports multi-item quotes with detailed breakdowns for each component, automatic cost calculations based on configurable rate categories, and one-click conversion of approved quotes into production jobs. Quote management includes attachment support for customer drawings and specifications, status tracking (draft, sent, approved, rejected), and complete audit trails showing quote history and modifications.

Advanced Inventory Management provides comprehensive tracking across multiple inventory types. The materials inventory system manages raw materials with automatic reservation when ordered for specific jobs, consumption tracking when production begins, and complete material traceability including certifications and mill test reports that follow materials from receipt through final product. The parts inventory automatically tracks finished goods as jobs complete, calculating actual values based on completed quantities rather than quoted amounts, accounting for scrap and quality issues. Additional inventory modules manage hardware components (fasteners, fittings, consumables) and tooling (cutting tools, fixtures, dies) with reorder point alerts and stock level monitoring.

Time Tracking & Labor Management enables precise job costing through integrated time tracking at each production station. Operators can start, pause, and complete work sessions with live timers displaying elapsed time against estimated durations. The system calculates real-time progress percentages, tracks multiple time log entries per station for interrupted work, and provides comprehensive labor reports showing time spent by user, station, and job. This granular time data feeds into job costing analysis and helps identify bottlenecks in the production process.

Quantity Tracking & Quality Control ensures accurate part counts throughout manufacturing. The system tracks completed quantities at each station, compares actual output against expected quantities, and prompts operators to confirm when parts are scrapped. Scrap tracking maintains running totals of parts lost at each stage, while the parts inventory reflects actual completed quantities rather than originally quoted amounts. This provides accurate revenue calculations based on delivered parts and maintains complete traceability of where and why parts were lost during production.

Purchase Order & Vendor Management streamlines procurement with comprehensive vendor databases, material order tracking linked to specific jobs, and purchase order generation with status tracking (ordered, received, partially received). The system supports multiple vendors per material type, tracks pricing history for cost analysis, and manages material certifications and documentation that automatically attach to jobs when materials are consumed.

Employee Recognition & Celebrations builds team culture through automated birthday and work anniversary detection, employee of the month tracking with nomination and voting systems, and celebration displays on the dashboard with beautiful gradient cards and personalized messages. The system calculates years of service and displays appropriate milestone recognition.

Role-Based Access Control provides three distinct user roles with carefully crafted permissions. Administrators have full system access including user management and system settings. Managers can access all operational features, view reports, manage quotes and jobs, and oversee inventory without user administration capabilities. Operators have focused access to their assigned jobs, time tracking, material viewing, and production tools, ensuring shop floor workers can efficiently complete their tasks without overwhelming interface complexity.

Real-Time Dashboard & Analytics provides at-a-glance visibility into operations with active job counts, station utilization metrics, material stock alerts, and upcoming due dates. The dashboard displays current time tracking sessions, recent job completions, low inventory warnings, and employee celebrations. Advanced reporting includes job costing analysis, labor efficiency metrics, material consumption reports, and production timeline analysis.

Sheet Nesting Tool optimizes material utilization through visual nesting of parts on sheet materials, DXF file import for precise part geometries, automatic calculation of material requirements and waste percentages, and support for multiple parts per sheet with rotation and positioning controls. This tool helps minimize material costs and improve quote accuracy.

Communication System facilitates team coordination with internal messaging, job-specific notes and attachments, station-level instructions, and notification systems for job assignments and completions. The message board supports image attachments and provides a centralized communication hub for the entire team.

The system is designed for on-premise deployment, giving manufacturers complete control over their data and enabling operation without internet connectivity. The architecture supports both local single-machine deployment and network-wide access across the shop floor, with a dedicated TV display mode for real-time production monitoring on large screens throughout the facility.

Previous
Previous

PHLUX

Next
Next

Cambium