What and where is the TvA Store Summary report?

This article shows users how to navigate and interpret the Theoretical versus Actual (TvA) Store Summary report.

Overview

TvA means Theoretical versus Actual usage displayed in dollar amount. The TvA Store Summary report shows theoretical usage cost, actual usage cost, and the variance between them.

TvA Store Summary report considers all inventoried and distributor items with a Cost Of Goods Sold (COGS) Accounting Category and costs associated with ingredients used in Menu Item Recipes.

Managers can use this report for:

Cost analysis and planning.
Recipe usage monitoring.
Store-level oversight.

Here is an example of how this report can be used:

”At this store last week, $500.00 worth of Seafood theoretical cost should have been used, based on the Menu Items that were rung in and the Seafood ingredient portions in the recipes. However, based on Inventories and Purchases, the actual cost shows they used $600 worth of Seafood. Drilling into the TvA Store Summary Detail for Recipe Cost, I see that the first ingredient listed, Salmon, has the most significant variance (loss).”

“After speaking with the store manager, we found that the prep cook was portioning 7 oz Salmon Filets instead of 6oz. Since this has been corrected going forward, we should see a smaller variance for Salmon, Seafoods, and Food next week.”

View TvA Summary Report

The TvA Summary Report allows for viewing one store at a time. Users cannot view a rollup of multiple stores. Begin by navigating to:

Reports > Cost and Variance > TvA Store Summary

Select the Company, Region, Area, or Store.
Click View X Store.
Select a Date Range.
1. The green dot under a date represent an inventory cycle and will default to the current week.
2. Period Start is the beginning of that store’s period.
Click Apply.

Example Report

The TvA Store Summary sorts Categories by the highest theoretical loss followed by the highest theoretical growth. Categories displayed with a positive cost are a loss. This means that the store gave away or wasted more product than it should have. Categories shown with a negative cost are growth in products. This means the store did not give out as much as it should have.

Users can print each page by clicking Print.

Recipe Cost

The Recipe Cost is the theoretical cost for ingredients assigned to recipes that have IvA flagged in Ingredient Management. Users can click on the link(s) to expand the sub-categories and dive deeper into which ingredients contribute to variance.

Non-Recipe Cost

The Non-Recipe Cost includes items that are not part of a recipe or not flagged as IvA in Ingredient Management. These may be items that the store does not track because of customer usage, for example, tortilla chips or fountain soda syrup.

Users can click on the link(s) to expand the sub-categories and dive deeper into which ingredients contribute to variance. However, since stores may not track these items based on the recipe, the TvA Summary Report only provides the Actual Cost of Usage.

Non-Inventoried Purchases

Non-Inventoried Purchases displays the Actual Cost for items received from a distributor that is not assigned to an ingredient and may not be counted for inventory. For example, items could be cleaning supplies, such as bleach or gloves.

Actual COGS

Actual Cost of Goods Sold (COGS) is the dollar amount of the actual usage for the Category. Users can click on the link(s) to expand the sub-categories and dive deeper into which ingredients contribute to variance.

The details provide the Theoretical Cost, Actual Cost, Variance between the two, and Variance as a percentage of sales.

Calculations

Metric	Definition	Calculation	Example
Category	The parent COGS Category Section. COGS structure is configured in COGS Maintenance.
Recipe Cost	The theoretical recipe cost for usage of ingredients flagged for IvA in Ingredient Management.	Menu Mix Recipe Unit Usage X Recipe Unit $	Chicken = $0.50 per oz. Sold 10 Chicken Sandwiches with 5 oz portions. (10ea. X 5 oz = 50 oz) 50 oz Recipe Usage = $25 in Theoretical Recipe Cost 50 oz X $0.50 = $25
Non-Recipe Cost	The actual cost of usage for items not flagged for IvA in Ingredient Management or part of a recipe. Only the Actual Cost of usage will display using the COGS calculation. The reporting requires that it meets at least 1 of 3 conditions: Existed on an Inventory Set that the store is assigned to in the date range’s beginning inventory. Existed on an Inventory Set that the store is assigned to in the date range’s ending inventory. Had a distributor item mapped at the time an order was received for it.	Beginning inventory + Purchases - Ending inventory	The ingredient is not flagged for IvA, did not exist on an Inventory Set for Beginning Inventory, has $100 in Purchases, and a $25 Ending Inventory. $0 + $100 - $25 = $75 of Actual Usage of the Non-Recipe Cost
Non-Inventoried Purchases	Distributor item(s) received on an order (purchase) that was assigned to a COGS Category but not assigned to an ingredient.	Purchase value.	Cleaning supplies.
Theoretical COGS	The sum of the total dollar amounts that should have been used.	Recipe Cost + Non-Recipe Cost + Non-Inventoried Purchases
Actual COGS	The dollar amount used of the menu item recipe’s actual cost.	Beginning inventory + Purchases - Ending inventory
Variance	The difference between Theoretical COGS and Actual COGS.	Theoretical COGS - Actual COGS
Sales	The totals sales for each Category.
% of Sales	The dollar amount displayed as a percentage of the affected column directly to its left.

Table of Contents

1 Overview
2 View TvA Summary Report
- 2.1 Recipe Cost
- 2.2 Non-Recipe Cost
- 2.3 Non-Inventoried Purchases
- 2.4 Actual COGS
3 Calculations

For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.

Unable to access this feature in the Decision Logic platform?

Contact your Decision Logic Administrator to make Scope and Security adjustments to your user profile or add new features.
Some features are client-specific.

Check out these helpful links.

What and where is the Beverage IvA report?

What and where is the All Food IvA report?

What and where is the Negative Food IvA report?

What and where is the Non-IvA Usage report?

What and where is the Cost and Variance report, and how do I customize or export it?

What and where is the Payroll Report?

What and where is the Top 20 Food IvA report?

What and where is the Cost of Goods Sold (COGS) report?