BI-Entities at Risk / Best Performers Analysis

Overview

Qvinci is excited to introduce the new Business Intelligence Entities at Risk report, specifically designed for Coaching for Performance. This report provides valuable insights into the performance of multiple entities or locations, enabling you to identify areas of concern and recognize top performers based on key financial metrics.

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

The BI-Entities at Risk report is designed to assess specified P&L accounts' Percentage of Income, comparing them against set percentage targets to identify entities that are either underperforming or exceeding expectations. Entities that fall below the target are considered "at risk," while those above the target are considered "Best Performers." This feature empowers Coaching for Performance by providing actionable data to improve underperforming entities or replicate the success of top performers.

As always, reports can be accessed through the Library > Gallery section.

Example Scenario:
For instance, if the "Food Sales" account has an expected percentage of income of 10% or higher, and "Entity 1" reports 9%, "Entity 1" will be flagged in the Entities at Risk report due to underperforming against the set target. Conversely, for COGS or expense accounts, entities are considered at risk if they exceed the expected percentage.

Summary of Contents

The Entities at Risk report for Coaching for Performance is designed to identify accounts that need attention, while the Best Performers report helps highlight top-performing entities, enabling you to learn from their best practices and share insights across your franchise network.

BI-Entities at Risk / Best Performers Analysis Features:

What's New:

• Q Interact: A new interactive feature on the right-hand side of the report offers six different options to refine and adjust the report's findings, providing a more tailored experience.
• Multiple Reporting Periods: The report supports three distinct periods for analysis: Reporting Month, 3-Month, and Fiscal YTD, all based on the "As of Date."
  • Reporting Month: Displays twelve months of historical data.
  • 3-Month: Displays five 3-month periods of historical data.
  • Fiscal YTD: Shows the current and prior two Fiscal Year-to-Date periods.
• Standard & Custom Accounts: The report includes default accounting accounts, such as Gross Profit, Total COGS, Total Expense, Net Income, and allows up to three customizable accounts to meet your coaching or performance analysis needs.

Instructions for At Risk / Best Performers Analysis:

1. Add/Modify Default Accounts:

You can add or modify the accounts listed in the Default Accounts column (Cells "W10" to "W19" on the Instructions tab). The template analyzes these specific accounts for the filtered entities. Common accounts are pre-loaded, 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 from the Qvinci Gallery, export to Excel, and copy and paste the customized account names into the default accounts table.

Note: This template supports up to 300 entities.

2. Set Expected Percentages:

• Income Accounts: Enter the expected percentage in the yellow-highlighted cells under the "Low" and "High" columns (Cells "Y10" to "Z19"). For Income accounts, only the "Low" percentage will be considered for Entities at Risk and the "High" percentage for Best Performers.
• Expense Accounts: Enter the expected percentages in the same yellow-highlighted cells for expense accounts. For Expense accounts, the "High" percentage is used for Entities at Risk, while the "Low" percentage is considered for Best Performers.

3. Save Your Template:

Once you’ve set up your desired accounts and percentages, click "Save As" to store your customized template in the Mine tab of the Qvinci Library.

4. Preview the Report:

The report will generate after a brief processing time (up to 1 minute depending on the number of entities filtered). It will display either the "Entities at Risk" or "Best Performers" tab, showing the respective entities. You can also interact with the Q Interact section for additional options to refine your analysis.

Viewing Interact Options

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%.

• Entities at Greater Risk or Best Performers: If an entity appears multiple times across different P&L accounts, it will be highlighted to identify entities that require more immediate attention (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 highlighted in the excel sheet. (See above)

• Filter Specific Entities: Use the Filter Specific Entities dropdown to isolate individual entities that are categorized as either at risk or Best Performers for more focused coaching.

• Filter Entities Across Multiple Categories: A dropdown allows you to filter entities that fall into more than a set number of categories (e.g., more than five).
• At Risk vs Best Performers Toggle: Easily switch between viewing entities that fall below the target (at risk) or exceed the target (Best Performers).

This functionality helps to refine your analysis and make data-driven decisions for performance coaching.

________________________________________________________________________________________________________

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