Reporting Explained: Actual Vs Theoretical By Level By Department, Sub Department

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 shows the difference between the theoretical usage and what was actually used for items assigned to that sub department.

How it Works:  An Actual vs Theoretical: By Department, Sub Department report shows the actual cost for items assigned to a sub department 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:

  1. Select Standard Reports
  2. Open the folder titled ‘F&B’
  3. Select the folder ‘Actual vs Theoretical’
  4. Select the folder ‘By Level’
  5. Select the report ‘By Department, Sub Department’
  6. Choose a starting and an ending physical inventory
  7. Generate report



Reading the Report:


  1. Shows the filters used to produce the report’s data, including the physical inventories selected for the report.
  2. 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.
  3. Store Name:  Shows the store name that the physical was performed in.
  4. Sub Department:  Shows the sub department being summarized for this period.
  5. Starting Cost:  Shows the total purchase cost of on hand inventory included in this sub department at the start of the period determined by the starting physical inventory selected.
  6. Purchasing Cost:  Shows the Purchasing Quantity x Vendor Price (at time of purchase) for this sub department.
  7. Sales Cost: Shows the Sales Quantity x Calculated Cost as of transaction date for items in this sub department.
  8. Sales Retail:  Shows the Sales Quantity x (POS Retail - POS Discounts) for items in this sub department.
  9. Theoretical Ending Cost:   Shows the Starting Cost + Purchasing Cost - Sales Cost for items in this sub department.
  10. Actual Ending Cost:  The Total purchase cost of on hand inventory for items in this sub department at the end of the period selected by the ending physical used for the report.
  11. Usage Variance:   Shows the variance between the Actual usage and the Theoretical usage for items in this sub department. Determined by Actual Usage - Theoretical Usage
  12. Theoretical Usage:   Shows what the theoretical usage could be for items in this sub department by taking the Starting Cost + Purchasing Cost - Theoretical Ending Cost.
  13. Actual Usage:   Shows the actual usage for items in this sub department by taking the Starting Cost + Purchasing Cost - Actual Ending Cost.
  14. Actual Usage Quantity:   Shows the actual quantity used by taking the Starting Quantity + Purchasing Quantity - Actual Ending Quantity.
  15. Theoretical Cost Percent:  Determined by taking the Theoretical Usage for the sub department divided by Sales Retail for the sub department.
  16. Actual Cost Percent:  Determined by taking the Actual Usage for the sub department divided by Sales Retail for the sub department.
  17. Cost Percent Variance:   Determined by taking the Actual Cost Percent for the sub department - Theoretical Cost Percent for the sub department.
  18. This row allows you to save, export, print, or close the current report

    • Related Articles

    • 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 ...
    • 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 ...
    • Reporting Explained: Food Cost by COGS Department/Category

      Business Need: This report is helpful for F&B customers using COGS for tracking inventory. It allows clients to see their cost of goods sold percentage to better manage purchasing habits. For more information on setting up COGS please see How to ...
    • Reporting Explained: ReOrder

      Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...
    • Reporting Explained: Inventory Aging by Department By Quarter

      Business Need:  This report is helpful for users who want a report to show how long the current inventory has been in stock, summarized by department and quarter.  How it Works:  An Inventory>Aging>By Department report shows a summary how long the ...
    • Recent Articles

    • Send Saved Report Emailing

      You can configure saved reports to be automatically emailed to you and/or team members on a set schedule. How do I schedule daily email reporting? You can configure saved reports to be automatically emailed to you and/or team members on a set ...
    • Purchasing Flow for Food and Beverage

      The Yellow Dog Inventory purchasing flow ensures that all aspects of inventory management, from restocking to adjusting errors in transfers, are covered systematically. Each document type in the flow serves specific functions that collectively ...
    • Updating Count XL Application

      You may need to update your Count XL application on your handheld device to ensure it runs properly and smoothly. If you have received the following errors, your Count XL application may need to be updated: • “Invalid network error” • “API error” • ...
    • Removing Items with On-Hand Quantity (Decimal)

      You might encounter difficulty removing specific inventory items due to an error indicating that the item cannot be removed since its on-hand quantity is not zero, possibly because the decimal point is not properly adjusted. Changing the Decimal ...
    • ZD411 Printer Troubleshooting

      Labels Skipping When Printing When you are not able to print labels or labels are skipped when printing you will need to adjust the sensor inside the printer. If your labels are skipping when printing, make sure you have adjusted your sensor. To do ...