The Stock Usage Report displays the stock usage for a particular account and stock count. This can be beneficial in comparing stock counts to see a trend and help forecast future item orders.
Navigation
To navigate to the Stock Usage Report, click 'My Reports' in the Accounting Module and select 'Purch. & Inv.' in the top header. Once opened, a listing of reports will be shown.
Find 'Stock Usage', as displayed in the image above, and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.
Report Parameters
1) Stock Count - A listing of all stock counts
2) Run Button - Runs the report
Report Columns
1) Item Category - The Item Categories counted in the Stock Count
2) Beg Inv - The End Inventory count from the last Stock Count
3) Purchases - The amount of items that were purchased since the last Stock Count
4) Total - The total amount of items (Beg Inv + Purchases)
5) End Inv - The actual amount of Inventory counted int he Stock Count
6) Use $ - The amount of items that were used (Total - End Inv)
7) Sales - The amount of the item that was sold since the last Stock Count
8) % Sls - The Item Category's Use (#6) divided by the Sales amount (#7)
9) Inv Change - The change in Inventory from the Beginning Count to the End Count
10) Avg Inv - The average of the Beginning Inventory and End Inventory
11) Turns - The Use $ divided by the Average Inventory