Actual vs. Theoretical Location Summary

The Actual vs. Theoretical Location Summary is a consolidated view of the Above Store Actual vs. Theoretical Analysis (AvT). This report shows the AvT at the location level across multiple locations. With this report, above-store operators can compare total food variance performance across all their locations in one place.

The data generated in this report is at the location level. To view variance at the item category and item level, run the Actual vs. Theoretical Analysis or the Above-Store Actual vs. Theoretical Analysis.

Navigation

Navigate to the My Reports page.
At the top of the My Reports screen, select Purch. & Inv.
The screen will generate a list of reports in alphabetical order.
Locate the Actual vs. Theoretical Location Summary.
Select Customize to adjust the report parameters and run the report.

Report Parameters

Button/Field	Description
Filter By	A list of all filter categories. Filter categories will vary based by report.
Filter	A list of filter options, determined by the 'Filter By' category selected (#1).
Start	First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for the data generated. The report then displays data for all dates within the date range, including the start and end dates.
End	Last date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for the data generated. The report then displays data for all dates within the date range, including the start and end dates.
Key Items Only	Indicates whether only data from items marked as key items is shown on the reports. When Yes is selected, the data will reflect key items from the location. When No is selected, the report data will be based on all inventory items.
Show Unapproved	Indicates whether unapproved transactions will be considered for the report. When Yes is selected, the values will reflect information tied to unapproved transactions in addition to approved transactions. When No is selected, the values will reflect information only tied to approved transactions.
Item Category 1	Filters the report data by the selected Item Category 1. This defaults to all.
Item Category 2	Filters the report data by the selected Item Category 2. This defaults to all.
Item Category 3	Filters the report data by the selected Item Category 3. This defaults to all.
Variance Includes Waste	If Yes is selected, variance calculations include amounts from waste log entries. If No is selected, variance calculations exclude amounts from waste log entries.
Variance Includes Donations	If Yes is selected, variance calculations include amounts from donation entries. If No is selected, variance calculations exclude amounts from donation entries.
Costing Methods	If Weighted Average is selected, item costs are calculated based on the per-unit weighted average of all purchases and the beginning balance. Select Weighted Average to see a more financially accurate picture of the inventory and identify past discrepancies. If End Count Cost is selected, item costs reflect amounts from the last inventory count. Select this option to view the report with a focus on variance.
Cost Based On	If Net Sales is selected, cost calculations are based on net sales amounts If Gross Sales is selected, cost calculations are based on gross sales amounts.
Items to Display	Counted Only - Only items with non-zero actual counts will be included. All Items - All items, including items with non-zero actual counts, will be included.

Report Columns

Column	Description
Location	List of report locations selected in the Filter parameter.
Begin	Total dollar value from the item count that occurred closest to the start date selected in the Start parameter. There is a +/-7 day threshold for finding the count closest to the dates selected. If a location does not have counts in that range, a (–) appears in this column on the report.
Purch	Total dollar value of all items purchased for the location.
Xfer (Transfer)	Total dollar value of all items transferred to or from this location.
End	Total dollar value from the item count that occurred closest to the end date selected in the End parameter. There is a +/-7 day threshold for finding the count closest to the dates selected. If a location does not have counts in that range, a (–) appears in this column on the report.
Actl	Total dollar value based on actual item use.
Theo	Theoretical dollar value of all items, based on all theoretical depletions across the system. This report uses product mix and menu item sales to calculate theoretical values.
Var	Difference between actual and theoretical dollar values.
Waste	Total dollar value logged as waste for the location. This column appears when the Variance Includes Waste parameter is set to Yes.
Donation	Total dollar value logged as donations for the location. This column appears when the Variance Includes Donation parameter is set to Yes.
Sales	The total net or gross sales for the location.
Actl %	Actual dollar value divided by total net or gross sales.
Theo %	Theoretical dollar value divided by total net or gross sales.
Var %	Difference between the Actl % and Theo %.