The Above-Store Actual vs. Theoretical Analysis compares the theoretical cost of certain inventory items or categories against actual data. The report pulls data for selected dates to provide an overall view of the category or item's actual vs. theoretical dollar values for one or all locations in an organization. Users can assess outlier variances by drilling into an item and determining which locations need more support optimizing their inventory. In addition to viewing item details, users can opt to filter the report by the top and bottom 15 performers to directly see which locations are the most and least successful at utilizing inventory items. By evaluating these factors and implementing changes according to the most successful strategies, users can improve efficiency, minimize waste, and optimize their budget.

This report includes the option to calculate dollar values based on weighted average. Weighted average considers quantity along with cost when calculating dollar value per unit of measure, generating more precise calculations. 

Important Note: Purchase dollars do not equal the total purchases in the date range. It will equal the established unit cost multiplied by the total quantity purchased. The same unit cost must be applied against all transaction columns for variances to be meaningful.

Article Topics

• Navigation
• Report Parameters
• Report Columns
• Drilling Into an Item
• Email, Export, or Print the Report

Navigation

1. In the Reports section of the left navigation pane, select My Reports.
   The My Reports screen appears.
2. At the top of the My Reports screen, select Purch. & Inv.
   The screen generates a list of reports in alphabetical order.
3. Locate the Above Store Actual vs Theoretical Analysis.
4. Select Customize to adjust the report parameters and run the report.

Back to Top

Report Parameters

	Field	Description
	Filter By	Location reporting category by which to filter the report. Note: Options in the Filter By menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories.
	Filter	Allows users to apply one or more filter options from the location reporting category that they selected in the Filter By menu. The selected filters determine which locations appear in the generated report. For example, if Filter By is set to Region, the Filter menu might include options such as North, South, East, and West. A user can select West to display all locations belonging to this reporting category. Note: Options that appear in the Filter menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories.
	Start	First date to include in the report. The Start and End date fields create a date range for which data is generated.
	End	Last date to include in the report. The Start and End date fields create a date range for which data is generated.
	Key Items Only	If Yes is selected, the report includes key items only. If No is selected, the report includes all items.
	Show Unapproved	If Yes is selected, the report includes data from unapproved transactions. If No is selected, the report only accounts for approved transactions. Note: Yes is selected by default. This facilitates accounting staff, allowing them to close the period at their discretion, but operations can continue to run vital reports in real time without waiting for all transactions to be approved.
	Filter To Top/Bottom 15	If Yes is selected, the report displays only the top 15 items with the highest variances, both positive and negative, and displays item details. If No is selected, the report is not filtered by variance amounts.
	Item Category 1, 2, 3	Filters the items that appear in the report by the selected item categories.
	Subtotal By	Sorts and subtotals item categories. Recommended: Categories 1+2.
	Include Item Detail	If Yes is selected, the report displays a breakdown of all items in each item category. If No is selected, the report shows totals for the item category with no breakdown.
	Show Quantities	If Yes is selected, the report displays an additional item quantities row below the item cost and percentage details. If No is selected, the additional row is not included in the report.
	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 Method	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 when 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.
	View options	Provides the user with options to select, save, edit, or delete a report view. For more information about these controls, see My Reports: Using My Reports.
	Run	Generates the report. The green arrow button opens a drop-down from which users can Export, Email, or Print the report.

Back to Top

Report Columns

Note: The example shown below includes item quantities. Set the Show Quantities parameter to Yes to include this metric.

The header displays the date range for the report as well as the total sales amount.

The footer displays the total amounts for all item categories. 

Back to Top

Drilling Into an Item

Users can drill into an item to view its count details by location to better determine which locations have the biggest variances in dollar value and why.

To view item details, select the name of the item. A sub-report opens and displays item-level details. When finished reviewing the sub-report, select the back arrow icon in the top ribbon to return to the main report.

Back to Top

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.

Back to Top