Aluminium Stock Management

A production-grade inventory and manufacturing workflow system built for aluminium section factories to digitize and automate the complete lifecycle from raw aluminium waste to finished section bundles and dispatch. The system eliminates manual stock tracking and spreadsheet dependency by introducing barcode-driven bundle management and real-time inventory updates. It is built using Next.js for the frontend and backend logic, Supabase (PostgreSQL and Auth) for database and role-based access control, and is deployed live on Vercel. Problem Statement Aluminium manufacturing units often rely on manual registers or Excel sheets to track production bundles and dispatch records. This creates stock mismatches, calculation errors, lack of transparency, and difficulty in tracing bundle movement. The objective was to design a structured, reliable, and scalable system that ensures accurate stock tracking and operational visibility. Core Workflow 1. Raw aluminium waste intake and processing 2. Section production and bundle creation 3. Automatic Code 128 barcode generation for each bundle 4. Barcode label printing and reprinting 5. Dispatch management 6. Automatic stock deduction upon dispatch 7. Real-time inventory tracking 8. Production and dispatch reporting Each production bundle is assigned a unique Code 128 barcode that acts as its digital identity. When a bundle is dispatched, the system automatically deducts stock in real time, ensuring inventory consistency and eliminating manual errors. Key Features Bundle Management - Create production bundles - Generate unique Code 128 barcodes - Print and reprint bundle labels - Track bundle status (Produced or Dispatched) Inventory Management - Real-time stock visibility - Automatic stock deduction on dispatch - Section-wise and bundle-wise tracking - Production versus dispatch reconciliation Dispatch Management - Bundle dispatch processing - Dispatch history tracking - Dispatch reports with date filtering Reporting and Dashboard - Daily production reports - Monthly production reports - Custom date range reports - Dispatch reports - Central dashboard displaying operational KPIs Role-Based Access Control The system includes four user roles with controlled permissions: - Production User: Creates and manages bundles - Dispatch User: Handles dispatch operations - Admin: Monitors reports and operational data - Super Admin: Full system control including user management Technical Stack Frontend and Application Logic: - Next.js (App Router architecture) Backend and Database: - Supabase (PostgreSQL database) - Supabase Authentication - Role-based access policies Deployment: - Hosted and deployed on Vercel in a live production environment Business Impact - Eliminated manual stock calculations - Reduced human error in dispatch tracking - Improved factory-level operational transparency - Enabled real-time inventory monitoring - Streamlined production reporting and decision-making - Introduced barcode-based traceability in manufacturing workflow This system demonstrates the ability to design and implement real-world production management software with structured workflows, automated inventory logic, and scalable architecture.