How it Works: An Actual vs Theoretical: By Item report shows the actual cost for items versus the theoretical cost. Users will need to select a starting inventory as well as an ending inventory to generate this report. It is important that the same items be included on the starting and ending physical selected. To get accurate data from this report, you must be performing regular physicals, keeping your purchasing up to date, and maintaining and using recipes.
Generating the Report:
Go to the Standard Reports section in Yellow Dog:
- Select Standard Reports
- Open the folder titled ‘F&B’
- Select the folder ‘Actual vs Theoretical’
- Select the report ‘By Item’
- Choose a starting and an ending physical inventory
- Generate report
Reading the Report:
- Shows the filters used to produce the report’s data, including the physical inventories 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 name that the physical was performed in.
- COGS: Shows the COGS (cost of goods sold) account that the item is assigned to in Yellow Dog.
- Level: Shows the level the item is assigned to in Yellow Dog.
- Vendor: Shows the vendor the item is assigned to in Yellow Dog.
- SKU: Shows the Yellow Dog SKU for the item.
- Item: Shows the item description or name for the item.
- Starting Cost: Shows the total purchase cost of on hand inventory at the start of the period determined by the starting physical inventory selected.
- Purchasing Cost: Shows the Purchasing Quantity x Vendor Price (at time of purchase)
- Sales Cost: Shows the Sales Quantity x Calculated Cost as of transaction date
- Sales Retail: Shows the Sales Quantity x (POS Retail - POS Discounts)
- Theoretical Ending Cost: Shows the Starting Cost + Purchasing Cost - Sales Cost
- Actual Ending Cost: The Total purchase cost of on hand inventory at the end of the period selected by the ending physical used for the report.
- Usage Variance: Shows the variance between the Actual usage and the Theoretical usage. Determined by Actual Usage - Theoretical Usage
- Theoretical Usage: Shows what the theoretical usage could be for the item by taking the Starting Cost + Purchasing Cost - Theoretical Ending Cost.
- Actual Usage: Shows the actual usage by taking the Starting Cost + Purchasing Cost - Actual Ending Cost.
- Actual Usage Quantity: Shows the actual quantity used by taking the Starting Quantity + Purchasing Quantity - Actual Ending Quantity.
- Theoretical Cost Percent: Determined by taking the Theoretical Usage divided by Sales Retail
- Actual Cost Percent: Determined by taking the Actual Usage divided by Sales Retail
- Cost Percent Variance: Determined by taking the Actual Cost Percent - Theoretical Cost Percent
- This row allows you to save, export, print, or close the current report