Qvinci offers a reporting tool known as Proforma. The Proforma is a trending, comparison tool. Much like Qvinci's Peer Benchmarking report, the Proforma allows individual users to view their data in a comparison manner while also applying a goal value which is based upon the average of the Top 10% best performers in your franchise/company. In short, it's like a Budget vs Actual report that is based upon best practices in your franchise/company.
How Proforma Is Calculated
For a specific Location Qvinci calculates the trend of growth or contraction (of a given month) as a percentage over a two year period. Qvinci then applies that number to the most recent previous years' outcome (of the same given month) to derive a forecast of what this years' same given month should be. The Top 10% vertical analysis percentage is then applied to the forecast to derive the Peer Target.
Example calculations for manually building a Proforma:
1) Qvinci calculates a forecast of the Location's Total Income line for a given month.
Using "Last Month" as the example target month the calculation for the Total Income Projection forecast is as follows:
2) Qvinci's Peer Benchmarking report is the second part of the baselines of calculation for the Proforma:
- Run a Peer Benchmarking report on the P&L
- Select "Compare to Top 10%" as the Frequency
- Choose "Last Month" (as an example) for the date range
- Enable Vertical Analysis to see the percent of income
Your report will look something like the below report; displaying both the Top 10% average column, Vertical Analysis percentage columns and your Location's data. The column which contains the "Top 10% VA" are the percentages that are pulled for the Proforma report.
3) The Top 10% Vertical Analysis ratios are then applied to the Total Income Projection. The results give each user an account-level report which is based upon their trend of growth/contraction as well as peer performance.The column called "Peer Target" is the output of the calculation: