Skip to main content

Purchase Orders

The data model encompasses views analyzing purchase order quantities, vendor performance, and inventory management. It tracks back-ordered, received, pending delivery items along with costs and returns, aiding in supply chain monitoring and procurement efficiency. Visualizations offer insights into warehouse distribution and purchase patterns by quantity, supporting informed decision-making for inventory control and vendor relationships.

Benefits of This Data Model​

  • Improved Vendor Performance Tracking: Analyzing purchase order quantities invoiced by each vendor helps in evaluating and improving vendor performance over time.
  • Enhanced Inventory Management: Comparing ordered quantities with received quantities provides insights into inventory management and aids in optimizing procurement processes.
  • Supply Chain Efficiency Monitoring: Tracking back-ordered, received, and pending delivery items enables efficient monitoring of the supply chain to ensure timely deliveries and minimize disruptions.
  • Warehouse Distribution Insights: Visualizing purchase order quantities across warehouses offers valuable insights into inventory distribution patterns, facilitating better warehouse management and resource allocation.
  • Informed Inventory Control Decisions: Analyzing purchase patterns by quantity and buyer supports informed decision-making for inventory control strategies and building stronger vendor relationships.

Key Performance Indicators (KPIs)​

  • Quantity On BO: Quantity of items that are back-ordered and pending delivery.
  • Quantity Received: Total quantity of items received.
  • Quantity Ordered: Total quantity of items ordered.
  • Quantity Open To RCV: Quantity of items that are yet to be received.
  • Unit Cost: Cost per unit of the purchased items.
  • Ext Amount: Extended amount, which is the total cost of the purchased items.
  • Quantity Return (CR): Quantity of items that have been returned or credited.
  • Quantity Invoiced: Quantity of items that have been invoiced.
  • Quantity Original: Original quantity of items in the purchase order.

Available Visualizations​

View NameDescription
PO QTY Invoiced by VendorDisplays quantity of purchase orders invoiced by each vendor. Helps track vendor performance.
PO QTY Ordered Top 10Shows top 10 items ordered by quantity, assisting in managing inventory and procurement.
PO Ordered vs ReceivedCompares ordered quantities with received quantities to monitor supply chain efficiency.
PO QTY By Warehouse RadarVisualizes purchase order quantities across warehouses for inventory distribution insights.
stacked step area 100% ViewIllustrates purchase order distribution in a stacked step area format for data visualization.
Warehouse Buyer Quantity Area 100%Provides area charts of purchase quantities per warehouse and buyer for analysis.