Inventory

This data model includes measures such as Average Unit Cost, Cost Of Carry, Cost To Replenish, Landed Unit Cost, Last Phys Count Var, Last Unit Cost, Max Stock Qty, Min Stock Qty, Order Point, Phys Count Tol Pct, Quantity On BO, Quantity On PO, Quantity On SO, Quantity On Transfer, Quantity On WO, Quantity Req. For Transfer, Quantity Req. For WO, Rank By COS, Rank By Gross Margin, Rank By Hits, Rank By Qty Sold, Replenishment Unit Cost, Replenishment Level, Standard Ord Qty, and Standard Unit Cost. The model provides insights into inventory management, including stock levels by warehouse and year, as well as details on individual inventory items.

Benefits of This Data Model

• Enhanced Inventory Management: The data model provides insights into stock levels by warehouse and year, enabling better inventory management decisions.
• Cost Analysis: The model includes measures like Average Unit Cost and Landed Unit Cost, facilitating detailed cost analysis for inventory items.
• Replenishment Optimization: With measures such as Replenishment Unit Cost and Replenishment Level, the model can aid in optimizing stock replenishment processes.
• Performance Ranking: The model allows for ranking by metrics like Cost of Sales, Gross Margin, and Quantity Sold, helping identify top-performing inventory items.
• Inventory Tracking: By utilizing dimensions like Item Code and Item Description, the model enables detailed tracking and analysis of individual inventory items.

Key Performance Indicators (KPIs)

• Avg Unit Cost: Average cost of each unit of inventory.
• Cost Of Carry: Cost associated with holding and storing inventory.
• Cost To Replenish: Cost required to replenish inventory.
• Landed Unit Cost: Total cost incurred to bring each unit of inventory to the warehouse.
• Last Phys Count Var: Variance between the last physical count of inventory and the recorded count.
• Last Unit Cost: Cost of the last unit of inventory purchased.
• Max Stock Qty: Maximum quantity of inventory that should be maintained in stock.
• Min Stock Qty: Minimum quantity of inventory that should be maintained in stock.
• Order Point: Inventory level at which new stock should be ordered.
• Phys Count Tol Pct: Percentage tolerance allowed for variance in physical inventory counts.
• Quantity On BO: Quantity of inventory on backorder.
• Quantity On PO: Quantity of inventory on purchase order.
• Quantity On SO: Quantity of inventory on sales order.
• Quantity On Transfer: Quantity of inventory in transit for transfer between locations.
• Quantity On WO: Quantity of inventory on work order.
• Quantity Req. For Transfer: Quantity of inventory required for a transfer order.
• Quantity Req. For WO: Quantity of inventory required for a work order.
• Rank By COS: Ranking of inventory items based on Cost of Sales.
• Rank By Gross Margin: Ranking of inventory items based on gross margin.
• Rank By Hits: Ranking of inventory items based on popularity or demand.
• Rank By Qty Sold: Ranking of inventory items based on quantity sold.
• Replenishment Unit Cost: Unit cost for replenishing inventory.
• Replenishment Level: Level at which replenishment of inventory should occur.
• Standard Ord Qty: Standard quantity to be ordered when restocking inventory.
• Standard Unit Cost: Standard cost for each unit of inventory.

Available Visualizations

View Name	Description
Stock by Warehouse	View showing stock levels grouped by warehouse.
Stock by Year	View displaying stock levels categorized by year.
Inventory	Comprehensive view of all items in stock.