Inventory Report
On each location or buffer, items are consumed by demand and replenished by supply. The inventory report shows this demand-supply on each bucket and how this translates into Inventory.
| Beginning Onhand | Inventory position at the beginning of the bucket |
|---|---|
| Supplies | Demand placed on this item on this bucket date considering BucketDate of Demand |
| Actual Demands | Demand placed on this item on this bucket date Considering LPST of Demnad |
| Ending Onhand | Inventory position at the end of the bucket. This equal to Beginning Onhand + Supplies - Demands |
| Actual Ending Onhand | Inventory position at the end of the bucket. This equal to Beginning Onhand + Supplies - Actual Demands |
| Inventory Turns | Inventory turns is Demand / ((Beginning Onhand + Ending Onhand) / 2) |
| Period of Cover | Number of buckets that Ending Onhand would last |
Viewing Inventory Report
- Select from and to bucket date. The bucket date populated here is based on the short, medium and long buckets as specified in the parameters.
- Select the items by clicking on the “Select Item” button. Either item or item group could be selected
- Select either Brief or Detailed
- Click on “Generate Reports”
Brief Report
A brief report shows the ending onhand position for each bucket for all the selected items.
On click of any individual item from the left pane, a detailed report for that item is displayed. To know more about the list of demands or supplies for any bucket, click on the number in the same row as Supplies or Demands. A datagrid will be shown in the bottom giving the list of orders for that bucket.
To view the graph, select any row(s) and the graph will be shown at the bottom for the selected row(s).
Detailed Report
Detailed reports show details for all the selected items in the same window.
On selecting the Graph checkbox, the graph is drawn automatically for all the items Supplies, Demands and Ending on Hand.
