import pandas as pd
from datetime import datetime
def calc_requirements(bom, schedule):
req = {}
for product, qty in schedule.items():
for mat, per_unit in bom[product].items():
req[mat] = req.get(mat, 0) + per_unit * qty
return req
def check_stock(requirements, inventory):
orders = {}
for mat, needed in requirements.items():
available = inventory.get(mat, 0)
if needed > available:
orders[mat] = needed - available
return orders
# Generate material plan
04 Block Diagram
Menunggu Sedang aktif Selesai
05 System Schematic
Menunggu Sedang aktif Selesai
⚠️ Verify material availability with warehouse before submitting purchase orders.
06 Simulasi Material Planning
Mula Planning
Materials
0
Stock
0
Required
0
Shortage
0
07 Material Plan Report
Demo
Material Plan
Materials
0
Stock
0
Required
0
Status
Standby
Terminal Log
[SISTEM] Manufacturing Raw Material Planning Agent sedia
System Architecture
📱 Command Layer
WhatsApp instruction
🤖 Agent Layer
Requirement planner
Stock checker
PO generator
🏭 Manufacturing Layer
Inventory DB
BOM records
Purchase orders
Reports
Safety Notes
Verify material availability with warehouse before submitting purchase orders.
Configure role-based access for inventory data.
Audit all material planning changes for compliance.