Item Theoretical Usage Report
Overview:
The Item Theoretical Usage Report calculates and lists the theoretical usage for a single item, for a selected date range, based on the number of Sales Items sold. Sales Item counts are imported from your Point of Sale system. An example of the report is shown below:
Things to know!
- This report will only be accessible and visible to users who are given access to this report function.
- The Item Theoretical Sales Usage Report will calculate and list theoretical Item usage based on Sales Item Counts.
- Theoretical inventory usage is the amount of inventory that should have been used based on recipes.
- The Item Theoretical Sales Usage Report will list Inventory Items and Combined Items.
Report Parameters
To Run the Item Theoretical Usage Report, use the Sidebar to navigate to the Inventory Usage Reports menu option and then select the Item Theoretical Usage Report from the submenu. Upon selection, a Report Parameters screen like the one below will display:
Begin Date: From the drop-down calendar, select a starting date range.
End Date: From the drop-down calendar, select an ending date range.
Item: Use the drop-down search to select a specific Item.
Run Report: Once you have selected your report parameters, click the Run Report button to list the report.
Item Theoretical Usage Report:
Selecting to Run the Report in detail will display a report similar to below. The below report was run for 2 Oz Pork Link Inventory Item:
The above report shows the Sales Item recipe and the Parent recipe (sub-recipe) that utilizes the Item. The next columns show the ingredient usage (Item portion size in the recipe), the quantity of the Sales Item that was sold, the theoretical usage in Recipe Units, and the theoretical usage in Pack Size.
The formula for the theoretical usage from sales calculation is: Theoretical Usage = # of Sales Items sold X quantity of Items used in recipes for those Sales Items.
Report Options: For a description of the toolbar provided at the top of the report, please see "Report Options" for help. Report Options link.