The Theoretical Usage Drilldown page displays menu items with mapped recipes that contain the inventory item, along with the units sold for the report period.
The Theoretical Usage Drilldown page is reached through:
-
The links in the Usage Units column of the quantity report version of the Theoretical Inventory Usage page.
-
The links in the Theoretical Usage / Theo Units column of the quantity report version of the Inventory Variance page.
-
The links in the Theoretical Usage / Theo Units column of the quantity report version of the Variance Report with Waste page.
The following information is displayed for the inventory Item, Area*, Store and Period displayed at the top of the page:
-
Menu Item: Lists the menu items that contain the inventory item.
-
Recipe: The name of the recipe that's currently mapped to the menu item (inventory items that are sold directly to the customer as a menu item may not have a recipe mapped to it).
-
Sales: This column is broken down to:
-
Sold: The quantity of the menu item that was sold.
-
Promo: The quantity of the menu item that was given for free.
-
Actual: The total quantity of the menu item that was either sold or given away.
Actual = Sold + Promo
-
-
Inventory: The term in brackets is the unit of measurement in which the usage is measured. This column is broken down to:
-
Per: The quantity of the inventory item used per unit of the menu item (taken from the current recipe, if there's one mapped, else it is the Sales Multiplier of the menu item).
-
Total: The total quantity of the inventory item consumed through the menu item for the period.
Total = Actual x Per
-
-
Report Method: The total (actual x per) recalculated in the unit of measurement that's selected as the Reporting Method for the supplier product An inventory item in a package size available from a particular supplier.. The unit of measurement is displayed in the header below Report Method.
-
Total from product mix sales using current recipes: The total quantity of the inventory item consumed, through all menu items sold (or given for free) during the period, as per current recipes in both units of measurement (inventory and report method). This is essentially the sum of each (the Inventory Total and Report Method) column and does not include fixed waste (if any).
-
Fixed Waste*: The total fixed waste assumed for the period (as set in Waste - Fixed/Reoccuring settings).
-
Total from current recipes plus fixed waste*: The total quantity of the inventory item consumed as per current recipes, with the addition of fixed waste.
Total from current recipes plus fixed waste = Total from product mix sales using current recipes + Fixed Waste
-
Total from recipes at time of count plus fixed waste*: The total quantity of the inventory item used calculated as per what the recipes were at the time the closing count was performed, with the addition of fixed waste.
-
Variance*: The difference between total from current recipes plus fixed waste and total from recipes at time of count plus fixed waste.
Variance = Total from product mix sales using current recipes - Total from recipes at time of count plus fixed waste - Fixed Waste*
-
Menu Items that were created or changed during the period of the report display
next to the menu item. Click on to open the Display Recipe window and then click on the Audit tab to view the details of the changes made. -
Recipes that have changed since the closing count was performed display
next to the recipe name. Click on to open the Menu Item Update window and then click on the Audit button for the inventory item to view the details of the changes made.
Report links:
-
Clicking on the name of a menu item will open the Menu Item Update page.
-
Clicking on the name of a recipe will open the Display Recipe page.
Associated Settings:
-
Inventory Reporting controls which sales amount is used to calculate the usage %, waste % and total %.
-
Inventory Categories controls the categories for inventory items.
-
Inventory Sub-Categories controls the sub-categories for inventory items.
-
Inventory Item Master List controls the complete list of inventory items in the organization.
-
Inventory Item by Location controls the inventory items for the store selected.
-
Inventory Items controls the set-up of individual inventory items.
*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.