Inform collects and tracks the following information about your inventory.
Data | Abbreviation | Description |
---|---|---|
12 Month Demand |
12 Mon Demand | The number of units of the product purchased and shipped from the warehouse over the last 12 months. |
12 Month Hits | 12 Mon Hits | The number of hits on the product over the last 12 months. |
12 Month Units | 12 Mon Units | The number of units of the product that the warehouse held over the last 12 months. |
Available | Available | The quantity of product available for purchase. This quantity will always be a zero or positive value. |
Average Gross Profit % | Avg G/P% | The Average Cost of the product as compared to the the Net Price. [(Net Price-Avg Cost)/(Net Price) * 100] |
Committed | Cmttd | Committed. The total quantity of product committed to or staged for a sales order. Hover over the Committed box to see the breakdown of how many On Sales Order, On Transfer Out, and On Work Order. |
Demand Trend % | Demand Trend |
The Demand Trend is calculated by comparing the most recent completed months. This number indicates that the demand for a product is on an upward or downward trajectory. Seasonal Products
A 3 Month Trend Analysis is used for seasonal products. This compares the previous three months with the same three months from the previous year. Regular Products
A 5 Month Trend Analysis is used for regular products. This compares the five most recent completed months. For example, if the current month is November, the analysis will compare June vs. July, July vs August, August vs September, and September vs October. Calculation
|
Forecast Type | Forecast Type | The reason that the Projected Purchase Order excludes this product on the inventory. For example, due to Recurring or Sporadic demand. |
Last Year Current Month Units | LYCM Units | Last Year Current Month Units Sold. The quantity of units of this product sold during the same month last year. |
Month to Date Units Sold | MTD Units Sold | Month to Date Units Sold. The number of units of the product sold so far this month. |
On Backorder | On B/O | The quantity of product backordered on current sales orders. |
On Drop Ship | On Drop Ship | The quantity of product being drop shipped from vendors. |
On Hand | On Hand | The total quantity of product on hand, including any that are committed or staged. (Cmttd + Available). |
On Purchase Order | On P/O | The quantity of product you are waiting to receive from purchase orders. |
On Purchase Order Future | On P/O Future | The quantity of product you are waiting to receive from future purchase orders. |
On Sales Order / Picked | On SO / Pckd | (Committed On Sales Order)/(Picked): The quantity of product that has been picked for sales orders. The total shown above in the Picked row includes this value. |
On Shelf | On Shelf | The total quantity of product on hand, excluding picked quantities (On Hand - Picked - Staged). For physical inventory, you can print this On Shelf quantity on the count sheets by setting File>Company>Master: Print On Shelf on Physical Inventory Worksheet to Y. |
On Transfer Out / Picked | Trans Out / Pckd | (Committed On Transfer Out)/(Picked): The quantity of product that has been allocated to outbound stock transfers. The total shown above in the Picked row includes this value. |
On Transfer In / Picked | Trans In / Pckd | On Tranfer In / Picked. The quantity of product expected in receipt from incoming stock transfers. |
On W/O Component | On W/O Comp | On Work Order Component. The quantity of product being used to fulfill a Kit Production Work Order. This number is the expected amount to be reduced from inventory upon completion of a Kit Production. |
On W/O Kit | On W/O Kit | On Work Order Kit. The quantity of kit products on the Work Order. This number is the expected amount to be added to your inventory upon completion of a Kit Production. |
Picked | Picked | The total quantity of product picked for ship confirmed sales orders and outbound stock transfers. Hover the mouse over the Picked box to view the quantity breakdown On Sales order and On Transfer Out. |
Primary Bin | Primary Bin |
The primary bin location where the product is stored in the warehouse. Assign bin locations on the Bins tab of the Product Master. See Specify bin locations for a product. |
Quarterly Projected Usage | Qrtly Proj Usage | Quarterly Projected Usage calculated as [(Monthly Demand Average)*3]. This information is for reference only; it is not used in forecasted projections. |
Rank | Rank | The rank of the product in each warehouse. For more information, see Configure product ranking criteria |
Reorder Point |
The Reorder Point determines when a product appears on the Critical Inventory Report and Projected Purchase Order. It is calculated as [[(Weekly Demand)*(Lead Time in Weeks)] + (Safety Stock)] For example: [[(10/week) * (2 weeks to get here)] + (20% safety stock)] = Safety Stock % is set in the Product Master > General tab, and the average weekly Demand is calculated for the last 12 months. Please note that if the Min Stock Quantity is greater than system calculated Reorder Point, the Min Stock Quantity will be used as the Reorder Point for the item. If demand increases so that the calculated Reorder Point is greater than the Min Stock Quantity, the system will use the calculated Reorder Point for the product. |
|
S/O Returns | S/O Rtrn | On Sales Order Return. The quantity of product being returned from sales orders. |
Staged | Staged | The quantity of product staged for a sales order. |
Stock Value | Stock Value |
The current value of your stock of this product in the warehouse. This value is calculated using the Sales Order GP% Cost Column, as specified in your Company Master, and may differ from the amount seen on your Inventory Value Report. This field is populated only if the user has permission to view cost and gross profit. See Available access levels . If the user does not have this access for this, the field will appear blank. |
Warehouse GP Cost | Whse Cost |
Sales Order Cost would be. For companies that use Cost by Warehouse, where each warehouse has a different cost, this value is equal to the sales order cost, should the order be fulfilled by that warehouse. This field is populated only if the user has permission to view cost and gross profit. See Available access levels . If the user does not have this access for this, the field will appear blank. |
Weeks Available | Weeks Available | The number of weeks of product available in the warehouse, based on projected demand. |
Year to Date Average Gross Profit % | YTD Avg GP% | The average year to date gross profit percentage received from sales of this product. |