Inventory Management

The data model includes measures such as Quantity Pack, Quantity Stock, Quantity Allocated, Quantity In Process, Quantity Available, Quantity Active, Quantity Stock - Net, Planning Reorder Point, Planning Safety Stock, QC Quantity Rejected, QC Quantity Accepted, and QC Quantity Awaiting Disposition. Views like In Inventory Details, Inventory by Site, Quantities by Site, Out of Stock, and In Inventory provide insights into inventory levels, locations, and quality control statuses.

Benefits of This Data Model

• Improved Inventory Management: The data model provides insights into inventory levels, allocation status, and stock availability, enabling better decision-making processes for inventory management.
• Enhanced Quality Control Monitoring: With measures such as QC Quantity Rejected, QC Quantity Accepted, and QC Quantity Awaiting Disposition, the data model allows for detailed tracking and monitoring of quality control processes.
• Efficient Site and Location Analysis: By incorporating dimensions such as Site Code, Location Code, Location Category, and Location Type, the data model facilitates in-depth analysis of inventory distribution across different physical locations or sites.
• Optimized Product Tracking: The inclusion of dimensions like Product Code, Product Desc, and Product Category enables detailed tracking and analysis of products within the inventory system, enhancing product management processes.

Key Performance Indicators (KPIs)

• Quantity Pack: The quantity of products that are packaged in a set or bundle.
• Quantity Stock: The total quantity of products currently in stock.
• Quantity Allocated: The quantity of products that have been reserved or earmarked for specific orders or purposes.
• Quantity In Process: The quantity of products that are currently in the process of being manufactured, assembled, or processed.
• Quantity Available: The quantity of products that are available for sale or use, taking into account stock levels and allocations.
• Quantity Active: The total quantity of products that are currently in active status or available for transactions.
• Quantity Stock - Net: The net quantity of stock available after considering allocations and processes.
• Planning Reorder Point: The inventory level at which new stock needs to be ordered to replenish supplies.
• Planning Safety Stock: The extra inventory held to protect against unforeseen fluctuations in demand or supply chain disruptions.
• QC Quantity Rejected: The quantity of products that have been rejected during quality control inspection.
• QC Quantity Accepted: The quantity of products that have passed quality control inspection and are deemed acceptable for sale or use.
• QC Quantity Awaiting Disposition: The quantity of products that have undergone quality control inspection but are pending a decision or action for disposition.

Available Visualizations

View Name	Description
In Inventory Details	Provides detailed information about all items currently in inventory.
Inventory by Site	Displays inventory levels grouped by different physical locations or sites.
Quantities by Site	Shows quantities of items available at each site or location.
Out of stock	Identifies items that are currently out of stock in inventory.
In Inventory	Summarizes the total number of items currently present in inventory.