Reporting Explained: Actual Vs Theoretical By Level By Department
Business Need: This report is helpful for users who want a report to show the actual cost during a time period versus the theoretical cost. This report is summarized by department rather than by individual item. This report also shows the difference between the theoretical usage and what was actually used for that department.
How it Works: An Actual vs Theoretical: By Department 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 folder ‘By Level’
- Select the report ‘By Department’
- 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.
- Department: Shows the department being summarized for this period.
- Starting Cost: Shows the total purchase cost of on hand inventory included in this department 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) for this department.
- Sales Cost: Shows the Sales Quantity x Calculated Cost as of transaction date for items in this department.
- Sales Retail: Shows the Sales Quantity x (POS Retail - POS Discounts) for items in this department.
- Theoretical Ending Cost: Shows the Starting Cost + Purchasing Cost - Sales Cost for items in this department.
- Actual Ending Cost: The Total purchase cost of on hand inventory for items in this department 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 for items in this department. Determined by Actual Usage - Theoretical Usage
- Theoretical Usage: Shows what the theoretical usage could be for items in this department by taking the Starting Cost + Purchasing Cost - Theoretical Ending Cost.
- Actual Usage: Shows the actual usage for items in this department 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 for the department divided by Sales Retail for the department.
- Actual Cost Percent: Determined by taking the Actual Usage for the department divided by Sales Retail for the department.
- Cost Percent Variance: Determined by taking the Actual Cost Percent for the department - Theoretical Cost Percent for the department.
- This row allows you to save, export, print, or close the current report.
Related Articles
Reporting Explained: Actual Vs Theoretical By Level By Department, Sub Department
Business Need: This report is helpful for users who want a report to show the actual cost during a time period versus the theoretical cost. This report is summarized by sub department rather than by individual item or department. This report also ...Feature Overview: Actual vs. Theoretical Module
Actual vs Theoretical (AvT) compares two numbers over the same time period: Theoretical Usage This is what the system expects you to use. Yellow Dog calculates this from: POS sales Recipes mapped to POS items Ingredient quantities and yields in each ...Reporting Explained: Actual Vs Theoretical By Item
Business Need: This report is helpful for users who want a report to show the actual cost for items during a time period versus the theoretical cost of those items. This report also shows the difference between the theoretical usage and what was ...Reporting Explained: Summary By Period
The Inventory Summary by Period report provides an overview of inventory activity for a selected date and time range. It shows the starting inventory cost, all inventory movements during the period, and the ending inventory cost. Reports > Standard ...Reporting Explained: Food Cost by COGS Department/Category
The Food Cost by COGS Department report shows food cost summarized by COGS department. Use this report to compare inventory costs with sales revenue and monitor food cost performance by department. Reports > Standard Reports > F&B > Food Cost > COGS ...
Popular Articles
How To: Find Your Yellow Dog Inventory Version
Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...Feature Overview: Par & Re-Order Points
Par levels and reorder points help streamline purchasing in Yellow Dog. Par level is the ideal quantity to keep on hand. Reorder point is the minimum quantity that triggers reordering. You can update par and reorder points in the following locations: ...Tips & Tricks: How do I download and install drivers for my Zebra Printer?
**As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...How To: Swap the On-Hand/Parent Size (Edit Base Unit)
When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...FAQs: What are Bins?
Question: What are Bins? Answer: Bins are optional location identifiers that specify exactly where an item is stored. You don’t need to create bins in advance. You can assign them: In the Stores tab of the item editor Through a Balto import Bins ...