- Created by Jenny Egger, last modified by Jennifer Crowley on Sept 11, 2018
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 37 Next »
Decision Logic offers numerous avenues for Supply Chain analysis.
- Dig into trends and results, track revenue at every level and from multiple perspectives.
- Gain valuable insight into your product usage, waste, and efficiencies through detailed inventory analysis.
- Empower your managers with the information needed to make time-saving decisions, pinpoint gaps, and control food costs.
Find the following tools and more in the Decision Logic site menu under Reports > Cost and Variance.
Supply Chain Variance
Navigate to Reports> Cost and Variance> Usages Efficiency (IvA)
We've also added a useful metric called Usage Efficiency. To learn more on this feature visit the Usage Efficiency page.
Ideal vs Actual (IvA)
Navigate to Reports> Cost and Variance> there are several IvA reports to choose from.
Find more detail on IvA Reports on the Ideal vs. Actual (IvA) Reporting page.
Style | Description | Reports |
---|---|---|
Ideal vs Actual (IvA) | Ideal vs Actual usage is recommended for use by restaurant managers as it focuses on quantity wasted, not the dollar amount of waste. Example, instead of $50 of wasted chicken wings IvA displays 60 wings wasted Ideal vs Actual is the amount actually used compared to the ideal amount used. This is found by using the following formula: Beginning Inventory + Purchases - Ending Inventory = Actual usage Actual usage - Ideal usage = Variance Ideal usage, or the quantity that was used if 0 product was wasted, is calculated directly from product mix reporting that is pulled from the POS System |
|
Table of Contents:
For additional questions or assistance please submit a support ticket by visiting our Customer Support Portal
Hot Item Reporting:
Hot Item IvA
Navigate to Reports> Cost and Variance> Hot Item IvA
Hot Item IvA displays the same variance reporting as IvA but for the daily hot item inventory
Drill into specific food items to see the detail of the selected item
Theoretical vs Actual Reporting (TvA)
Navigate to Reports> Cost and Variance> there are several TvA reports to choose from
Style | Description | Reports |
---|---|---|
Theoretical vs Actual (TvA) | Theoretical vs Actual usage is recommended for use by restaurant overhead as it focuses on dollar amount wasted, not quantity. Theoretical vs Actual is the dollar amount of actually used product compared to the dollar amount of ideally used product. This is found by using the following formula: Beginning Inventory + Purchases - Ending Inventory = Actual usage Actual usage - Theoretical usage = Variance Theoretical usage or the dollar amount used if zero product was wasted is calculated directly from product mix reporting that is pulled from the POS System | TvA Store Summary Tva Rollup |
TvA Store Summary displays a store level view of the TvA Report. The TvA Report includes a recipe category, non-recipe category, and non-inventoried category.
- Recipe Category: Includes detail for ingredients that are in recipes and are inventoried
- Non-recipe Category: Includes detail for ingredients that are not in recipes but are inventoried
- Non-Inventoried: Includes detail for ingredients that are not inventoried or in recipes
To set up non-inventoried items be sure the recipe measure is set to zero in the bid file.
Drill into the category detail by selecting the category
TvA Rollup
TvA Rollup displays a roll-up view of the TvA detail including Sales, Theoretical percentage, Actual percentage, Variance in dollars and variance in percentage.
TvA Ranking
TvA Ranking displays a ranking of each store selected in best highest variance to lowest variance in the form of Sales, Theoretical percentage, Actual percentage, Variance in dollars and variance in percentage.
Cost of Goods Sold (COGS)
Navigate to Reports> Cost and Variance> Cost of Goods Sold
Style | Description | Reports |
---|---|---|
Cost of Goods Sold | Cost of Goods Sold is recommended for use by both restaurant overhead and store managers as it focuses on the percentage of salesCost of Goods Sold percentage is the percentage of sales of a product that was wasted in a specific time period. This is found by using the following formula: Beginning Inventory + Purchases - Ending Inventory = Cost of goods / Sales = Cost of Goods % of Sales | Cost of Goods Sold |
COGS Report Descriptions and Usage:
Cost of Goods reports shows a store level or a roll-up of the cost of goods formula.
Note, COGS Sales is the Net Sales.
Drill into the COGS category detail by selecting the category.
COGS Extended Price
COGS total extended price is calculated by taking the Inventory Quantity divided by the Inventory multiplier and then multiplied by the Case price in the bid.
FAQ
Researching Variance Issues
When reviewing variance reporting it is best to research as soon as possible after an inventory is recorded and entered into Decision Logic.
When users find items with a large variance take the following steps to help find a solution:
- Find high variance items in Decision Logic
- Confirm both beginning inventory and ending inventory values are correct
- Review purchases to be sure all product was received at the correct quantities and price
- Review ideal usage to be sure all product is depleting at the correct quantities (reminder: ideal usage is calculated directly from product mix reporting that is pulled from the POS System, depletion quantities are entered into menu maintenance in DL)
- If all data entered into Decision Logic is correct and all values are depleting properly take into consideration the following:
- over portioning
- under portioning
- theft
- waste issues
COGS has missing sales data
If your sales data is not reporting on my COGS report, the cause is that Decision Logic had not received the sales data for the end of the week at the time that inventory was posted.
The steps to correct this are:
- Validate you have sales in the DSR for Cogs week
Open your inventory
Go to Inventory Home > Enter Inventory > and post your inventory again
Note, posting inventory will cause an auto Cogs update to run for that current week, therefore you will not need to run a DL Update.
- No labels