BI-Entities at Risk / Best Performers Analysis

Overview

Qvinci is proud to offer a new Business Intelligence Entities at Risk report for Coaching for Performance:

• BI-Entities at Risk / Best Performers Analysis (S)

This report is designed to run on multiple entities or locations and allows you to analyze specified P&L account's Percentage of Income based on a set Percentage and determine which Entities are either below or over the expected Percentage indicating that the Entity is at risk or is one of the Best Performers. This information will provide a clear picture of desired performance metrics that allows Coaching for Performance to help improve entities or locations in need.

As always, our reports are found in the Library >Gallery section:

Example 1: A "Food Sales" account has an expected (set) percentage of income of 10% or higher for all Entities, and "Entity 1" has a "Food Sales" percentage of Income of 9%, then "Entity 1" will be displayed in the Entities at Risk report. This is because Entity 1 has a percentage below expectations.  (For COGS/Expense accounts the entity is considered at risk when it has a higher percentage than expected)

Summary of Contents

Qvinci is proud to offer an At Risk Report for Coaching for Performance to help entities that have an account or a few that need attention.  It also has a Best Performers Report option to determine who is doing better to help find what their best practices to help other franchisees.

BI-Entities at Risk / Best Performers Analysis

What's New:

 For the BI-Entities at Risk / Best Performers Analysis: 

• A new Interact section on the right hand side has 6 different options for changing the report findings.  It will help provide material for coaching in multiple areas.
• It has three reporting periods: Reporting Month, 3-Month, and Fiscal YTD, all based on the "As of Date":
  • Reporting Month: Twelve months of historical data
  • 3-Month: Five 3-month Periods of historical data
  • Fiscal YTD: The current and last two prior FYTD periods
• The Standard accounting accounts will be shown and can be customized if required. These accounts are from your Gross Profit, Total COGS, Total Expense, Total Other Income, Total Other Expense, Net Ordinary Income, Net Income and up to 3 Customizable accounts of your choosing.
  • The 3 Customizable accounts can be selected to meet your coaching or performance analysis needs. 

Instructions For the at Risk / Best Performers Analysis:

1.  Add/Change Default Accounts:

You can Add or Modify the accounts in the Default Accounts Column (Cells "W10" to "W19" on the Instructions tab). The template will do the analysis on these specific accounts for the filtered Entities. We added the most common accounts as a starting point, but you can enter any account from your P&L Qvinci Standard Chart of Accounts (SCoA).

SUGGESTION: Run the "P&L-Det-FYTD v PY + $ % (S)" report located in the Qvinci Gallery, export to EXCEL then copy and paste the Customized account names in the appropriate default accounts table on line 8, 9 and 10.

NOTE: This template has been optimized to run up to 300 Entities max.

2. Set your expected % of Income for Each account:

Income Accounts: Enter expected percentage in the yellow highlighted cells under the Low and High Columns in the table to the right. (Cells "Y10" to "Z19" of this Instructions tab). For Income accounts only the "Low" percentage will be considered for the Entities at risk to display the Entities that fall below the Low target, and only the "High" percentage will be considered for "Best Performers" analysis to display Entities that perform above the High target, indicating income better than expected.

Expense Accounts: Enter the expected percentage in the yellow highlighted cells under the Low and High Columns in the table to the right. (Cells "Y10" to "Z19" of this Instructions tab). For Expense accounts only the "High" percentage will be considered for the Entities at risk to display the Entities that have a percentage higher than the High target, , and only the "Low" percentage will be considered for "Best Performers" analysis to display Entities that perform under the Low target, indicating spending better than expected.

3.  "Save As" your template:

Once you enter your desired accounts and expected percentages, you can click on the "Save As" button to save your own template. This will save it in your "Mine" tab in the Qvinci Library.

4.  Preview The Report:

Preview the report, it may take up to 1 minute depending on the amount of Entities included in the Filter. Once its done it will only show "Entities at Risk or Best" tab where you will have the respective Entities displayed. You can also use the "Interact" section which includes additional options for your analysis.

Viewing Interact Options

5.  EXCEL or PDF Instructions:

This template has been optimized to be used in MS EXCEL, but due to its nature and design it is not enabled to be printed as PDF.

Entitles at Risk / Best Performers functionality:

When the report is run the system will determine based on the set percentages which entities will be included as part of the "at risk" or "Best Performers" list for each P&L account.

The Interact section on the right hand side of this report helps with the analysis by giving the user the following options:

A) Change the period: from Fiscal YTD to Reporting Month or Reporting 3 Months and the Entities will change if they fell in the "at risk" category don the selected period.

B) The Number of Entities in the specified range will populate. YOU will be able to see the graph on the right hand side.  The bar chart will show the distribution of entities. (see below)

You can select one of the specified accounts and see how many entities fall on each Percentage of income range. Example: 32 entities with Gross Profit account that have a percentage of income between 31.7% and 42.2%.

C) Entities at Greater Risk or the Best Performers: When you have many entities in the summary report that were considered "entities at risk" there are some that will possibly be part of more than one defined P&L account (meaning they have failed more than one target).

In this case, we have chosen the number 5.  If an entity shows up 5 or more times then it will be high lighted in the excel sheet. (See above)

D) Filter specific Entity: There is a Filter Specific Entities dropdown on the Interact right hand side that will have all entities that fall in the "At Risk" or "Best Performance" category.  Click on the Filter drop down arrow to make your selection when you want to view only one entity for Coaching purposes.  

E) Filter Entities that fall in more than a set number of  Categories: There is a dropdown in the Filter Entities section under the Interact, that allows to filter the entities that fall in more than 5 categories as an example if the dropdown is set to 5.

F) At Risk vs Best Performers: There is a toggle/dropdown functionality to change the analysis to display either entities that fail to meet targeted percentage of income or entities that exceed expectation based on the selected target

________________________________________________________________________________________________________

Have Questions?
We're More Than Happy To Help

Schedule a Call with Customer Success below, email us at support@qvinci.com or call us at 1-512-637-7337 Ext. 1 Available M-F, 7:30am-6:30pm CT and it is always FREE!

Schedule an Appointment with Customer Success