Actual Usage numbers

 

Field

Details

8. Description

The Item Descriptions are listed in this column and they’re sorted in alphabetical order. The items are first classified by Sales Category then further categorized by item/Product Group.

TIP: Double-click on an item description to generate an item activity report for that item

9. Category Sales Totals

The total amount of sales for that Sales Category that was either imported automatically when Sales Mixes were processed or manually entered in the Daily Sales Summary.

10. UOM

The unit of measure (UOM) selected as the Reporting Unit in the items window under case information.

11. Opening Inventory

The last periods closing inventory

TIP: Double-click on opening count number to view supporting documentation on the Item’s inventory valuation

12. Period Purchases

The total amount of purchases during the specified reporting period.

TIP: Double-click on the amount purchased to view the purchase detail report for that item

13. Ending Inventory

The summarized inventory counts from the Closing Inventory.

TIP: Double-click on the ending count number to view supporting documentation on the item’s inventory valuation

14. Actual Usage Amount/Value

The total amount used calculated by the Opening Inventory count combined with the Period Purchases less the Ending Inventory count.

 

 

Opening Inventory + Period Purchases –Ending Inventory = Actual Usage Value