Purchase Orders

The data model captures purchase order and receipt metrics, including counts, delays, quantities, delivery status, service rates, and tax details. It integrates supplier performance, order timelines, product volumes, and financial elements. Views offer insights into order trends, supplier evaluation, delays, and stock reception for comprehensive analytics and decision-making. Key measures encompass order quantities, delivery timelines, delays of various durations, global pricing, returned products, and tax analysis, enabling a holistic view of procurement operations and supply chain performance.

Benefits of This Data Model

• Improved Supplier Performance Analysis: The data model allows for detailed evaluation of supplier performance through metrics like service rates, aiding in vendor assessment and decision-making.
• Enhanced Order Tracking: By capturing order timelines and delivery status, the data model provides insights into order trends, delays, and successful completions, enabling effective order monitoring.
• Optimized Inventory Management: Identification of delayed purchase orders and tracking stock reception metrics facilitates better supply chain optimization and inventory planning.
• Informed Product Popularity Analysis: Analysis of orders by product helps in understanding product popularity and demand patterns, assisting in product-related decision-making processes.
• Comprehensive Financial Analysis: With measures like global pricing, tax analysis, and returned products tracking, the data model enables a holistic view of procurement operations and financial elements for in-depth financial analysis and decision support.

Key Performance Indicators (KPIs)

• Order Count: The total count of purchase orders in the system.
• Receipt Count: The total count of receipts generated for the purchase orders.
• Receipt (Delayed) Count: The count of receipts that were delayed.
• Supplier Service Rate: Rate of service provided by suppliers.
• Number of Lines: Total number of lines across all purchase orders.
• Order Days to Deliver: Number of days taken for orders to be delivered.
• Quantity Ordered: Total quantity ordered across all purchase orders.
• Qty Delayed 2 to 3 Days: Quantity delayed by 2 to 3 days.
• Qty Delayed 4 to 6 Days: Quantity delayed by 4 to 6 days.
• Qty Delayed 1 Week: Quantity delayed by 1 week.
• Qty Delayed 2 Weeks: Quantity delayed by 2 weeks.
• Qty Delayed > 2 weeks: Quantity delayed by more than 2 weeks.
• Qty Non Delivered: Quantity that was not delivered.
• Qty Delivered: Quantity that was delivered in full.
• Qty In Part Delivered: Quantity that was partially delivered.
• Qty Delivered Within Deadline: Quantity delivered within the stipulated deadline.
• Quantity PUR: Quantity purchased specifically for the company's internal use.
• Quantity STK: Quantity kept in stock for future use.
• Quantity Returned: Quantity returned to the suppliers.
• Volume Line: Volume of products across all lines.
• Weight Line: Weight of products across all lines.
• Total Line Weight: Total weight of all lines in the purchase orders.
• Total Line Volume: Total volume of all lines in the purchase orders.
• Line Amount -Tax: Line amount excluding taxes.
• Total Tax: Total amount of taxes across all lines.
• Order % of Return: Percentage of orders that resulted in returns.
• Reporting Currency Line Amount -Tax: Line amount excluding taxes in the reporting currency.
• Total Reporting Currency Tax: Total taxes in the reporting currency.
• Price Global Gross: Gross price of products on a global scale.
• Price Global Net: Net price of products on a global scale.
• Total Global Line Amount -Tax: Total line amount excluding taxes on a global scale.
• Total Global Tax: Total taxes on a global scale.
• Total Global Returned: Total quantity of products returned in a global context.
• Product-Site Lines: Number of lines connecting products to specific sites.
• Earliest Reception Status: Status of the earliest reception of products.
• Latest Reception Status: Status of the latest reception of products.

Available Visualizations

View Name	Description
Orders vs Returns	Compares orders placed vs returns made for insights into product demand.
Orders by Supplier	Breaks down orders based on supplier, useful for vendor performance analysis.
Orders by Product	Provides a breakdown of orders by product, aiding in product popularity analysis.
Closed Orders	Lists orders that have been successfully completed and closed for tracking purposes.
Orders by Product Chart	An illustrative representation of orders by product for easy visualization.
Supplier Service Rate	Calculates the service rate provided by each supplier for vendor evaluation.
Delayed Purchase Order	Identifies purchase orders that are delayed, helping in supply chain optimization.
Stock Reception Weekly Load - Combination	Combination view of stock reception metrics over a weekly period.
Supplier Service Rate Chart	Visualizes the service rates of suppliers in a chart format for comparison.
Stock Reception - Weekly Load	Tracks the weekly load of stock reception for planning and monitoring purposes.
Stock Reception by Day	Breaks down stock reception data based on days, offering insights into daily trends.