A comprehensive Food & Beverage (F&B) ERP system designed to streamline inventory management, production, and cost control. Developed using Google Apps Script and Google Sheets, this system provides real-time KPIs, including stock levels, recipe costing, waste tracking, and sales analytics. Key features include:
Dynamic Inventory Tracking: Real-time management of raw materials, finished goods, and low-stock alerts.
Production & Recipe Management: Accurate recipe/BOM logic and production tracking to maintain consistency.
Sales & Profitability Analytics: Automated reporting for daily sales, revenue trends, and gross margin analysis by category.
Customizable Reporting: Automated export functionality for inventory valuation, purchase reports, and consumption logs.
