Mission Control is our planning and purchasing analysis platform, comprising two main sections: Current Status and Inventory History.
Current Status data encompasses the most recent point-in-time information, which is either the present moment or data collected within the past few hours.
Inventory History is presented as a chronological series categorized by month, excluding the ongoing month. You can access historical data for up to 18 months.
In both sections, all records are systematically organized by item-location-company for easy reference and management.
Inventory History Charts
Inventory History
Definition: The Inventory History chart illustrates the fluctuation of inventory value over time, calculated based on the transaction costs of items and the duration for which the inventory was held. Average Values are the calculated by obtaining the average of the month starting value and the month ending value.
Value: This information allows businesses to gain a comprehensive understanding of their inventory management efficiency. It aids in identifying trends, optimizing purchasing decisions, and ensuring effective allocation of resources.
Data Sources:
P21:
p21_inv_tranAverage Inventory Quantity and Value are derived from this source table using the
quantityandunit_cost_amountcolumns.
SAPB1:
oinm (inventory transactions)Average Inventory Quantity is derived from the source table using the
inqty - outqtyand the value is applied using the current supplier cost.
Sales History
Definition: The quantity OR value of items invoiced within each month.
Value: By tracking sales performance over time, businesses can identify trends, assess market demand, and make informed decisions regarding inventory management and sales strategies. This chart enables businesses to optimize inventory levels, identify product trends, and capitalize on opportunities for growth and profitability.
Data Sources:
P21: Tables
p21_invoice_line&p21_invoice_hdr.SAPB1: Tables
inv1 (ar invoice rows)&oinv (ar invoices).
Backorder History
Note: This chart exists only for P21 customers.
Definition: Depicts the trend of backorders over time, utilizing the quantity backordered and the historical average cost. This chart provides insights into the fluctuations and patterns of unfulfilled orders, aiding in inventory management and resource allocation.
Value: By analyzing the quantity backordered and the historical average cost, businesses can identify patterns, assess the impact on customer satisfaction, and optimize inventory management processes. This chart helps businesses proactively address supply chain challenges, minimize backorder occurrences, and improve overall operational efficiency.
Data Sources:
P21: Tables
p21_inv_tran.
Annualized Turns
Definition: Turns are calculated by dividing the total cost of goods sold by the average inventory value over the month, annualized for each month.
Value: It enables businesses to assess the efficiency of their inventory management processes, identify slow-moving items, and optimize purchasing and stocking strategies. This chart enables businesses to improve cash flow, reduce carrying costs, and maximize profitability through effective inventory turnover management.
Formula:
Cost of Goods Sold: Total expenses incurred for items invoiced within each month.
Average Inventory Value: See Inventory History above.
Data Sources:
P21: Tables
p21_inv_tran,p21_invoice_line&p21_invoice_hdr.SAPB1: Tables
oinm (inventory transactions),inv1 (ar invoice rows)&oinv (ar invoices).
Annualized GMROI
Definition: Gross Margin Return on Inventory Investment (GMROI) measures the profitability (return) of inventory investments over each month, calculated by analyzing the gross margin history and the corresponding inventory value during that period. Each month is annualized for the value over that window.
Value: By tracking GMROI over time, businesses can continuously evaluate and improve their inventory management strategies to drive long-term financial success.
Formula:
Sales: The total sales for items invoiced over each month.
Cost of Goods Sold: Total expenses incurred for items invoiced within each month.
Average Inventory Value: See Inventory History above.
Data Sources:
P21: Tables
p21_inv_tran,p21_invoice_line&p21_invoice_hdr.
Fill Rate
Definition: Percentage of all orders placed that are shipped on time and complete. Cancelled orders are excluded.
Value: By analyzing fill rates over time, businesses can assess their order fulfillment efficiency, identify bottlenecks in the supply chain, and improve customer satisfaction. It enables businesses to identify areas for improvement and implement strategies to meet customer demands effectively.
Formula:
Orders Shipped Complete: All all orders fulfilled within each month for previous 1 month where order is complete and shipped on time.
We calculate on time and complete based on the following data points:
Amount Requested
Amount Shipped
Requested by Date
Shipped Date
If an item was completed and shipped within three weeks of the expected ship date it is considered on-time and complete
Total Orders: All orders within each month for previous 1 months
Time Granularity: Month
Data Sources:
P21: Tables
p21_oe_hdr_vw,p21_invoice_hdr_vw,p21_oe_line_vw&p21_invoice_line_vw.SAPB1: Tables
ordr_orders_vw,rdr1_order_rows_vw&inv1_ar_invoice_rows_vw.