How it Works: A F&B>Food Cost>Actual By Item report shows the actual usage cost for items sold between two dates based on a starting and ending physical inventory. This report can also include retail sales and actual cost percent for items.
Generating the Report:
Go to the Standard Reports section in Yellow Dog:
- Select Standard Reports
- Open the folder titled ‘F&B’
- Select ‘Food Cost’
- Select ‘Actual By Item’
- Select the starting and ending inventories that you would like to run the report for; this will be the time period the report will reflect.
- Choose any filters that you would like to add.
- Generate report
Reading the Report:
- Shows the filters used to produce the report’s data, including the date selected for the report.
- Change columns, sorting, and grouping: This allows users to add or remove data columns to this report as well as organize and group the data.
- Store Name: Shows the store that the sales were captured from.
- COGS: Shows the COGS category for the if one has been assigned.
- Level: Shows the level the item is assigned to.
- Vendor: Shows the primary vendor assigned to the item.
- SKU: Shows the SKU number for the item.
- Item: Shows the item description.
- Actual Usage Cost: Shows the actual usage cost for the item during this selected time period (Starting Cost + Purchasing Adjustments Cost - Actual Ending Cost)
- Retail Sales: Shows the retail sales total for this time period (Sales Adjustments Quantity x (POS Retail - POS Discounts)
- Actual Cost Percent: Shows the cost percent for items during this time period (Actual Usage Cost / Retail Sales)
- This row allows you to save, export, print, or close the current report.