Inventory Analytics

The Inventory Analytics dashboard provides a comprehensive overview of ingredient usage, supplier purchases, wastage, and stock movements.
It helps managers track inventory performance, identify inefficiencies, and make data-driven purchasing and operational decisions.

Filters

• Branch – Select the branch to analyze inventory data.
• From / To – Apply a date range filter to focus on a specific analysis period.

Analytics Sections

1. Fast Moving Ingredients

• A line chart showing the most frequently consumed ingredients over time.
• Helps identify which items are in high demand and need frequent restocking.

2. Top Suppliers by Purchase Amount

• A bar chart ranking suppliers based on the total purchase value.
• Provides insights into supplier dependency and spending distribution.

3. Ingredient Purchases Summary

• A list of top ingredients by purchase quantity with unit details.
• Useful for tracking bulk purchases and monitoring supplier performance.

4. Most Wasted Ingredients

• A bar chart highlighting ingredients with the highest wastage.
• Assists in identifying inefficiencies in storage, preparation, or menu planning.

5. Low Stock Ingredients

• A list of ingredients currently below stock threshold.
• Shows negative or critically low balances in respective units.
• Enables timely reordering to prevent shortages.

6. Purchase Order Status Summary

• A pie chart summarizing purchase orders:
  • Pending – Orders not yet processed.
  • Partially Received – Orders partially fulfilled by suppliers.
  • Received – Fully received purchase orders.

7. Stock Movement Summary

• A donut chart showing different stock transaction types:
  • In: Purchase or manual addition.
  • Out: Usage for sales or kitchen production.
  • Spoil: Items marked as spoiled.
  • Adjust Add / Subtract: Manual adjustments.
  • Transfer In / Out: Movement between branches.
  • Return Supplier: Items returned to suppliers.
  • Sample: Taken as sample/tasting.
  • Waste: Wasted during prep or handling.

8. Wastage & Spoilage

• A pie chart differentiating between wastage (avoidable losses) and spoilage (expired/damaged goods).
• Helps optimize storage and reduce unnecessary losses.

Key Benefits

• Monitoring: Track fast-moving and low-stock items instantly.
• Cost Control: Monitor top suppliers and wastage to optimize expenses.
• Operational Efficiency: Manage stock adjustments and prevent shortages.
• Decision Support: Provides data-driven insights for purchasing, menu design, and supplier negotiations.