Skip to main content

Alternative Items

The data model incorporates views such as Alternative Item List, Alternative Item Prices, Alternative Item Availability, Alternative Item Supplier, and Alternative Item Sales History. Stock (Alt) Value represents the total value of alternative items in stock, while Expected Selling (Alt) Value forecasts sales. Quantity (Alt) Actual and Quantity (Alt) Reserved track alternative item quantities. Quantity Actual and Quantity Reserved account for both primary and alternative items in stock and on reserve, aiding in inventory and sales management.

Benefits of This Data Model​

  • Enhanced Substitution Decision-Making: The data model enables better purchasing decisions by providing a comprehensive list of alternative items and their prices for substitution or comparison.
  • Improved Inventory Management: Through tracking alternative item availability and quantities, the model enhances inventory management and facilitates effective fulfillment planning.
  • Supplier Analysis Optimization: The model supports supplier analysis and relationship management by listing alternative item suppliers, aiding in vendor comparison and selection.
  • Sales Forecasting and Trend Identification: Historical sales data for alternative items in the model helps analyze trends and forecast demand accurately, contributing to improved sales planning.

Key Performance Indicators (KPIs)​

  • Stock (Alt) Value: This measure represents the total value of alternative items currently in stock.
  • Expected Selling (Alt) Value: This measure indicates the expected value of sales for alternative items.
  • Quantity (Alt) Actual: The actual quantity of alternative items in stock.
  • Quantity (Alt) Reserved: The quantity of alternative items that have been reserved for future orders.
  • Quantity Actual: The total actual quantity of items in stock, including both primary and alternative items.
  • Quantity Reserved: The total quantity of items that have been reserved for future orders, including both primary and alternative items.

Available Visualizations​

View NameDescription
Alternative Item ListProvides a list of alternative items for substitution or comparison in purchasing decision-making.
Alternative Item PricesDisplays pricing information for alternative items to support cost analysis and budgeting.
Alternative Item AvailabilityShows the availability status of alternative items for inventory management and fulfillment planning.
Alternative Item SupplierLists the suppliers offering alternative items for supplier analysis and relationship management.
Alternative Item Sales HistoryOffers historical sales data for alternative items to identify trends and forecast demand.