Stock to date

The data model includes measures related to Planned Manufacturing Process (PMP) amounts in the company's and reporting currency, base quantity for PMP, various internal stock quantities by type ('A', 'Q', 'R', and total), stock statuses like reapproval, customer orders, dock quantities by type, loaned stock quantities by type, third-party stock quantities by type, internally allocated stock quantities by type, global stock allocation, missing stock details, third-party stock allocations by type, stock in transit, stock transferred with amounts in company and reporting currency, third-party stock availability, and stock pending output. Views capture stock monitoring by individual items and stock levels categorized by Class ABC classification.

Benefits of This Data Model

• Improved Stock Monitoring: The data model allows for detailed tracking of stock levels by individual items, providing accurate insights into inventory levels.
• Efficient Stock Allocation: Enables efficient allocation of stock internally and with third parties by providing quantities by type and currency measures.
• Enhanced Stock Management: Facilitates better stock management by capturing details such as reapproval stock, customer orders, dock quantities, loaned stock, and third-party stock availability.
• Optimized Reporting Currency Insights: Allows for analysis of stock amounts in both company currency and reporting currency, aiding in better financial decision-making.
• Data-Driven Stock Analysis: Provides a comprehensive view of stock statuses and allocations, helping in identifying missing stock details and optimizing global stock allocation strategies.

Key Performance Indicators (KPIs)

• PMP Amount Company Currency: This measure represents the Planned Manufacturing Process (PMP) amount in the company's currency.
• PMP Amount in Reporting Currency: This measure indicates the Planned Manufacturing Process (PMP) amount in the reporting currency.
• PMP Base Quantity: This measure shows the base quantity related to the Planned Manufacturing Process (PMP).
• Internal Stock Qty 'A': Quantity of internal stock type 'A'.
• Internal Stock Qty 'Q': Quantity of internal stock type 'Q'.
• Internal Stock Qty 'R': Quantity of internal stock type 'R'.
• Internal Stock Qty 'A'+'Q'+'R': Total quantity of internal stock types 'A', 'Q', and 'R'.
• Stock in Reapproval: Quantity of stock currently in the reapproval stage.
• Stock in Customer Order: Quantity of stock in customer orders.
• Stock at Dock Qty 'A': Quantity of stock at the dock of type 'A'.
• Stock at Dock Qty 'Q': Quantity of stock at the dock of type 'Q'.
• Stock at Dock Qty 'R': Quantity of stock at the dock of type 'R'.
• Stock at Dock Qty 'A'+'Q'+'R': Total quantity of stock at the dock for types 'A', 'Q', and 'R'.
• Loaned Stock Qty 'A': Quantity of loaned stock type 'A'.
• Loaned Stock Qty 'Q': Quantity of loaned stock type 'Q'.
• Loaned Stock Qty 'R': Quantity of loaned stock type 'R'.
• Loaned Stock Qty 'A'+'Q'+'R': Total quantity of loaned stock types 'A', 'Q', and 'R'.
• Third-party Stock Qty 'A': Quantity of third-party stock type 'A'.
• Third-party Stock Qty 'Q': Quantity of third-party stock type 'Q'.
• Third-party Stock Qty 'R': Quantity of third-party stock type 'R'.
• Third-party Stock Qty 'A'+'Q'+'R': Total quantity of third-party stock types 'A', 'Q', and 'R'.
• Stock Internal Allocated Qty. 'A': Quantity of internally allocated stock type 'A'.
• Stock Internal Allocated Qty 'Q': Quantity of internally allocated stock type 'Q'.
• Stock Internal Allocated Qty 'R': Quantity of internally allocated stock type 'R'.
• Stock Internal Allocated Qty 'A'+'Q'+'R': Total quantity of internally allocated stock types 'A', 'Q', and 'R'.
• Stock Allocated Global: Total stock allocated globally.
• Stock Missing Detail: Quantity of missing stock with detailed information.
• Stock Missing Global: Quantity of missing stock globally.
• Third-party Stock Allocated Qty 'A': Quantity of third-party stock allocated for type 'A'.
• Third-party Stock Allocated Qty 'Q': Quantity of third-party stock allocated for type 'Q'.
• Third-party Stock Allocated Qty 'R': Quantity of third-party stock allocated for type 'R'.
• Third-party Stock Allocated Qty 'A'+'Q'+'R': Total quantity of third-party stock allocated for types 'A', 'Q', and 'R'.
• Stock Transit: Quantity of stock currently in transit.
• Stock Transferred: Quantity of stock transferred from one location to another.
• Stock Amount Transferred in Company Currency: Amount of stock transferred in the company's currency.
• Stock Amount Transferred in Reporting Currency: Amount of stock transferred in the reporting currency.
• Third-party In Stock: Quantity of third-party stock currently available.
• Third-party Allocated: Quantity of third-party stock that has been allocated.
• Stock Pending Output: Quantity of stock pending for output.

Available Visualizations

View Name	Description
Inventory Monitoring by Item	Provides detailed tracking of stock levels by individual items.
Stock Monitoring by Class ABC	Offers a summary view of stock levels categorized by Class ABC classification.