What is the Food Usage Report?
The Food usage report combines your inventory and purchase data and allows you to view a per item breakdown of your Cost of Goods Sold.
Note: In order to use the Food Usage Report, you must have two inventories, each closed on different dates, to be able to compare them.
Only closed inventories show up on the Food Usage Report. If an inventory is in saved status its data will not be included on the day of a Food Usage Report.
To view Food Usage Report:
Go to Performance> Food Usage Report
Food Usage Report Top Display
What are the % figures that I see on top of the Food Usage Report?
The top of the screen displays the Cost % by Category Type during the time period being reviewed.
The number of boxes that appear will vary based on how many Category Types are used in the Restaurant Unit.
In the image above the Restaurant Unit has 4 Category Types- Food, Beer, Liquor, and Wine
Category Type Cost % = Category Type Total / Category Type Sales
More simply, it is the Food cost / Food sales, Liquor Cost / Liquor sales, etc.
As seen in the image below, the Category Type Cost % Liquor is 17%.
However, you'll note that the category Liquor is 13.9%.
With reference to the same example (seen in the image above):
So why don’t the Category Liquor and Category Type Cost % Liquor line up?
Answer- It is because the category type liquor includes category liquor and bar consumables as you can see in the image below.
Therefore, Category Type Liquor = Bar consumables (3.1%) + the liquor (13.9%) = 17.0%
Date Selector
The report is viewed within a date range between selected inventory periods.
Because our presumption is that inventory is taken at the end of the day after the close of business at the end of a period, thus we infer that the starting inventory value for the period will be the same as the ending inventory value of the previous period. This means that the selectable “starting inventory” dates will be one day after the inventories were taken, and but the closing inventory dates will match the dates the inventories were taken.
Show Filter
This filter allows you to see only usage for items on the inventories selected or all products “used” in the date range.
The Food Usage Report Explained
The food usage report is a per item breakdown of your Cost of Goods Sold.
Cost of Goods Sold = Starting Inventory + Purchases - Ending Inventory
In the food usage report, you see what is exported from your inventory summary.
How are inventory values calculated?
Let us look at the highlighted item in the following image:
The product is Blue Moon Belgian White 12oz Btl
Price x Count = Value
For example
Starting Inventory Price x Starting Inventory Count = Starting Inventory Value
$1.25 x 21 = $26.25
| Inventory Price |
x |
Inventory Count | = | Inventory Value |
| $1.24 |
x |
43 | = | $53.75 |
Purchased Units (72) – Starting Inventory Count (21) = Ending Inventory Count (43)
Where can I see my recipe products?
Anything that was created as a recipe and counted on inventory will appear on the Food Usage Report as their individual ingredient products. You can count the recipe as one complete product, but then you will only see the individual ingredients displayed proportionally on the reports.
COGS Calculations
Used Units = Starting Inventory Count + Purchased Units - Ending Inventory Count
Used Value = Starting Inventory Value + Purchased Value - Ending Inventory Value
Cost % = Used Value / Category Type Sales
Food Cost % = Purchased value / Category Type Total
The starting inventory count and starting inventory value should exactly match what's on your inventory summary.