The Actual vs Theoretical Analysis shows Actual vs Theoretical numbers in terms of both Quantities and Dollars. The User can drill down into the transactions that make up the numbers as well as roll up summary info by Category for a Controllable Cost of Goods approach to analysis. 


Overall, this report provides a deeper dive into the quantity and cost of each menu item to find solutions to limit the biggest item variances. Click here for guidance on Troubleshooting Variances in an AvT Report and here for learning how to email, export, or print this report. To watch a video explaining the benefit of running the AvT Analysis report for your Organization, view Tip #5 of R365's 'Back to School' Tips & Tricks.



Important Note


The Actual vs Theoretical Analysis report is not intended to tie back perfectly to the Inventory Count/Financials. This report uses one static Unit Cost for an item for the period, rounds Recipe conversions, and does not include any purchases made outside of the AP module, such as Paid Outs, among other examples.


The main purpose of this report is to provide quantities and approximate costs of each item so that the largest variances can be addressed and reduced. From here, Item records and transactions can be dug into to view the specific details of each cost. Click here to help align the AvT and P&L reports.



Navigation


To navigate to the Actual vs Theoretical Analysis Report, click 'My Reports' under 'Reports' in the left pane and then select 'Purch. & Inv.' in the top header of the reporting window. A listing of all reports will then be displayed.


Find 'Actual vs Theoretical Analysis' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define the report.



Report Parameters




1) Count From Date - A listing of all Inventory counts

2) Count To Date - A listing of all Inventory counts on and after the previously selected Inventory count

3) Key Items Only - This option will run the report for either only the items flagged as key items or for all items

4) Show Unapproved - This option either shows or hides unapproved Transactions. The 'Yes' option is recommended so that the Accounting staff can close the period at their discretion but operations can still run vital reports in real time without waiting for all transactions to be Approved

5) Count Time - The time of day that transactions are pulled. Options include:

  • Beginning of Day- This will use transactions from the DAY OF the from count to the day BEFORE the to count
    • E.g. If the Count From Date (#1) is set to 02/10/YY and the Count To Date (#2) is set to 02/17/YY, this option will use transactions from 02/10/YY to 02/16/YY
  • End of Day- This will use data from the day AFTER the from count through the DAY OF the to count
    • E.g. If the Count From Date (#1) is set to 02/10/YY and the Count To Date (#2) is set to 02/17/YY, this option will use transactions from 02/11/YY to 02/17/YY

6) Item Categories - These fields will filter the items by Item Categories

7) Subtotal by - This will sort and subtotal Item Categories. The 'Categories 1+2' option is recommended

8) Show % of Sales - This option turns on and off the final 3 columns (Actual %; Theo %; and Variance %)

9) Sales Account - This option filters in / out certain Sales Accounts depending on the data desired

10) Subtotal by Category - 'Summary' will roll all numbers into just the category totals (Meat vs Dairy vs Produce for example) while 'Detailed' will show all of the items in each category as well as category subtotals – the Summary option can be a good starting place to know which category to drill into to troubleshoot further

11) Efficiency Calculations (Waste)- This can be calculated using Waste or Not Using Waste in the percentage calculation

12) Efficiency Calculations (Donations) - This can be calculated using Donations or not including Donations in the percentage calculation

13) Actual Usage Dollar - This allows for one of the following costs to be included on the report:

  • Transaction Cost- This will pull the actual Item's cost from either the last invoice or Inventory Count based on the selected Count Time (#5)
  • Unit Cost - This will pull the Item's current Inventory Cost from the Item record as of the time the report was ran. If Item Locations are used, this will then pull from the Store's Item Location
  • End Count Cost - This will pull the cost of all items from the ending Inventory Count used for this report

14) Waste Calculations - This option either shows or hides all inventory that was documented in the Waste Count

15) Donation Calculations -This option either shows or hides all inventory that was documented in the Donation Count

16) Items To Display - This option includes all Purchased Items or just the Inventory Count items

17) Run Button - Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action. Click here to learn more about this functionality


Click here to learn more about Report Views and their added functionality.



Report Columns



1) Net Sales - The total Net Sales from all menu items

2) Operating Reporting Category - A listing of all Operating Reporting Categories broken down into Item Categories and then into Items

3) Count U of M - The Unit of Measure used for each item when conducting a Inventory Count

4) Unit Cost - The cost of each U of M

5) Begin - The beginning quantity of each item in the first Inventory Count

6) Purch - The amount of each item that was purchased

7) Trnsfer - The amount of each time that was transferred to / from that Location

8) End - The ending quantity of each item in the last Inventory Count

9) Actual - The actual item amount used. The Beginning Amount (#5), Purchased Amount (#6), Transfer Amount (#7), and End Amount (#8) are all included in the actual amount and are only displayed when expanded

10) Theo - The theoretical item amount used

11) Var - The difference between the theoretical amount (#10) and the actual amount (#9) used

12) Waste - The amount of an item that was wasted. This column is only displayed when the 'Show Waste Calculations' is selected in the report parameters

13) Donation - The amount of an item that was Donated. This column is only displayed when the 'Show Donation Calculations' is selected in the report parameters

14) UnExpl Var - The difference between the Variance (#11) and the Waste (#12). This column is helpful in analyzing why certain items have the biggest variances

15) Effcy - The theoretical quantity (#10) over the actual quantity (#9) used. This shows how efficiently this item is being used

16) Actual - The actual cost of the item. When expanded, the Beginning Cost, the Purchased Cost, the Transfer Cost, and the Ending Cost would also be displayed

17) Theo - The theoretical cost of the item. If 'Transaction Cost' was selected in the Report Parameters, the amount displayed here will be calculated as:

  • Calculation: ((the item's cost per UofM from the first Inventory Count up until the next) multiplied by (the amount of times the item was sold during that time)) + ((the item's cost per UofM from the second Inventory Count up until the next) multiplied by (the amount of times the item was sold during that time)) + and so on, based on the time range selected in the report. This total is then divided by the total quantity of transactions
  • For example: If a Inventory Count was taken on 1/4/21 with the item costing $5.37 per UofM and then the next was taken on 1/11/21 with the item costing $5.43 per UofM, when the report is ran for 1/7 - 1/14, all transactions from 1/7 - 1/10 will use the first $5.37/UofM cost and all transactions from 1/11 - 1/14 will use the second $5.43/UofM. The equation would then be:
                 (($5.37 x (# of items sold from 1/7 - 1/10)) + ($5.43 x (# of items sold from 1/11 - 1/14)))
                                                                    / total # of items sold

18) Var - The difference between the theoretical cost (#16) and the actual cost (#15) of an item

19) Waste - The cost of how much of an item that was wasted. This column is only displayed when the 'Show Waste Calculations' is selected in the report parameters

20) Donation - The cost of an item that was Donated. This column is only displayed when the Donations are set to 'Show' in the report parameters

21) UnExpl Var - The difference between the Variance (#17) and the Waste (#18). This column is helpful in analyzing why certain items have the biggest variances

22) Effcy -  The theoretical cost (#16) over the actual cost (#15) of an item. This shows how efficiently this item is being used

23) Actl % - The percentage of Actual Sales. This column is only displayed when 'Yes' is selected on the 'Show % of Sales' report parameter

24) Theo % - The percentage of Theoretical Sales. This column is only displayed when 'Yes' is selected on the 'Show % of Sales' report parameter

25) Var % -  The difference between the theoretical percentage (#22) and the actual percentage (#21) of Sales. This column is only displayed when 'Yes' is selected on the 'Show % of Sales' report parameter



Email, Export, or Print the Report



This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.