The Item Usage Report provides a detailed look at food and beverage that was used in a site or profit center during a specific time frame. Grouped for effective analysis, this report presents usage as compared to historical average usage for each inventoried item. Many operators use this report to evaluate category performance, while others claim it to be invaluable in identifying specific item usage problems. The report can be filtered to include a single Profit Center as well as only Key Items.
The report uses sales mix information, item yields and product recipes to calculate the amount of each item that should have been used. Each item’s ideal use is calculated and compared against the amount of that item which was actually used (beginning inventory plus purchases minus ending inventory) to determine the usage variance. With this information, it becomes possible to identify the exact loss of any item in inventory.
It is important to note that the purchasing figures on the Item Usage Report are calculated based on the accounting method currently in use. In other words, purchases (in units) are multiplied by the current cost per unit, according to the accounting method used. This is why purchasing amounts on the Item Usage Report tend to differ from the purchasing amounts listed on the Cost of Goods Report, and why the total values on these two reports will also differ. The figures for the two reports are based on different calculations.
Select from Physical Counts or Perpetual Counts.
Physical counts include only items that have been physically counted on both start and end forms. This option is best for full inventories or matching partial inventories.
Perpetual counts use perpetual inventory levels if a physical count does not exist for an item.
Select how you want the report to be grouped - Entire Site, By Profit Center or By Location Group. If you wish to create a Profit Center report, click the By Profit Center option and select the Profit Center from the list that becomes available. Only Profit Centers that you have access to are displayed. The Entire Site option is available only to users that have access to ALL profit centers in a site.
Select the start date of the report by selecting an inventory form from the list. Then select the end date of the report by selecting the ending inventory form.
Select the items to include.
You can select any or all of the additional options that appear on the next wizard:
Display Average Usages instead of Ideals
Use Department Level Percentage of Sales
Include Per Customer Information.
You have the option of selecting 1 of 4 sort orders for the report:
By Report Group. Select the default All Report Groups or use the drop-down list to select a single Report Group.
By Variance Percentage of Sales.
By Actual Usage Percentage of Sales, or
By Ideal Usage Percentage of Sales.
Click Submit to run the report.