Raw Materials
1. Overview & Purpose
What are Raw Materials in Production?
2. When to Use Raw Materials Tracking
Pre-Production Stock Availability Check
Plant manager schedules a 500-unit batch run and verifies available raw ingredients.
Automated Procurement Reorder Alerts
High-usage raw materials (e.g. Flour, Sugar, Packaging Film) drop below reorder buffers.
Ingredient Expiration & Lot Inspection
Perishable ingredients near shelf-life expiration require quarantine before batch staging.
Bill of Materials Explosion & Bulk Purchasing MRP Calculation
Factory plans 10.000 units of finished output for next month and needs to explode BOM lines to calculate total raw sugar, flour, and oil required.
Packaging Foil & Pre-Printed Film Scrap Tracking
Automated horizontal flow-wrapper machines consume printed plastic packaging rolls, with 3% scrap during machine calibration.
3. Data Dictionary & Fields
Schema structure for the raw ingredient stock and allocation tracking registry:
| Field / Column | Input Type | Requirement | Description & Operational Guide |
|---|---|---|---|
productId | BIGINT (FK) | Required | Reference to master products table identifying the raw material or ingredient SKU. |
productCode | STRING(50) | Required | Unique internal inventory item code (e.g. RM-FLOUR-01). |
name | STRING(255) | Required | Full descriptive title of the raw ingredient or component. |
uomName | STRING(50) | Required | Standard inventory measurement unit (e.g. kg, liter, meter, pcs). |
currentStock | DECIMAL(18,6) | Required | Total real-time physical on-hand quantity available across production storage rooms. |
allocatedStock | DECIMAL(18,6) | Required | Quantity reserved for currently active or approved production work orders. |
availableStock | DECIMAL(18,6) | Required | Net unallocated quantity available for new production scheduling (current - allocated). |
minStockAlert | DECIMAL(18,6) | Optional | Safety buffer threshold triggering automated purchasing replenishment notifications. |
4. Interface Preview
Raw Materials monitoring console displaying physical on-hand stocks, run allocations, safety thresholds, and reorder alerts.
Screen Preview: Raw Materials Inventory Interface
Visual interface illustration and control layout for menu Route: /admin/production/raw-materials
5. Monitoring Raw Stock
Open Raw Materials Dashboard
Navigate to Production > Raw Materials from primary sidebar.
Filter by Factory / Storage Location
Select operational Branch and Storage facility to review localized stock levels.
Inspect Stock Allocation Ratios
Compare on-hand stock against allocated quantities committed to pending runs.
Initiate Stock Reorder
Click Create PO Requisition for items flagged below minimum safety thresholds.
6. Requisition & Procurement Alerts
Adjust Safety Stock Parameters
Edit reorder alert thresholds to account for seasonal ingredient lead time fluctuations.
Refresh Allocation Status
System automatically recalculates available stock upon production run completion.
7. Quarantine & Scrap Management
Perishable Shelf-Life Isolation
Material Obsolescence & Discontinuation
Obsolete ingredients with zero on-hand stock can be marked inactive in master data.
8. Cross-Module Impact
| Target Subsystem | Relational & Transactional Effect |
|---|---|
| Recipes & BOM | Requires all declared BOM components to exist as active raw material items. |
| Raw Material Issues | Decrements physical on-hand stock when raw ingredients are weighed and issued to factory floors. |
| Purchasing (PO & GR) | Goods Receipts from suppliers replenish raw material currentStock balances. |
Operational Best Practices
- Maintain a minimum 15% safety buffer for imported ingredients subject to customs clearance delays.
- Always conduct weekly cycle counts on high-value flavoring agents and active packaging foils.