Skip to main content

Low Stock

The data model includes measures such as Quantity On Hand, Quantity On Purchase Order, Quantity On Sales Order, Quantity On Back Order, Quantity Required For WO, Quantity On Work Order, Quantity Reorder Point, Quantity Available, and Action Quantity. Views like Low Stock and Item Qty below Reorder Point Qty help monitor items at risk of stockouts by identifying products below reorder thresholds, aiding in inventory management and replenishment decision-making.

Benefits of This Data Model​

  • Improved Inventory Management: The data model allows for accurate monitoring of stock levels, helping businesses to proactively manage inventory and avoid stockouts.
  • Enhanced Replenishment Strategy: By providing insights into quantities on purchase orders, sales orders, and back orders, the data model facilitates informed decisions on when to reorder, optimizing replenishment processes.
  • Efficient Work Order Management: With measures like Quantity Required For WO and Quantity On Work Order, the data model enables efficient tracking and management of work orders, ensuring timely completion of production tasks.
  • Timely Action: The Action Quantity measure supports timely interventions by highlighting items that require immediate attention or action, enhancing operational efficiency and responsiveness.

Key Performance Indicators (KPIs)​

  • Quantity On Hand: The current quantity of a product available in stock.
  • Quantity On Purchase Order: The quantity of a product that has been ordered from suppliers but not yet received.
  • Quantity On Sales Order: The quantity of a product that has been ordered by customers but not yet shipped.
  • Quantity On Back Order: The quantity of a product that customers have ordered but is currently out of stock.
  • Quantity Required For WO: The quantity of a product required to fulfill a work order.
  • Quantity On Work Order: The quantity of a product that is currently in the process of being assembled or produced.
  • Quantity Reorder Point: The minimum quantity of a product that triggers a reorder to prevent stockouts.
  • Quantity Available: The quantity of a product that is available for immediate sale or use.
  • Action Quantity: The recommended quantity to order or produce based on current stock levels and demand.

Available Visualizations​

View NameDescription
Low StockView showing items with quantity below reorder point, indicating potential shortage.
Item Qty below Reorder Point QtyView displaying items whose current quantity is lower than the reorder point.