Food Usage Report

What is 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 inventories closed on two dates to 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-1.png

 

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%.

 

Food-Usage-category-type_.png

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 not 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%

 

Food-Usage-Category-type-Liquor.png

 

Date Selector

The report is viewed within a date range between selected inventory periods.

Food_Usage-Date-Selector.png

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.

Food_Usage-Show-Filter.png

 

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:

Food-Usage-2.png

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)

 

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.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.