Revenue Potentials by Outlet
The Revenue Potentials by Outlet report is used to view revenue potentials for liquid products based on product usage and entered pour sizes.
- To run the Revenue Potential by Outlet report go to Report Center > Accounting Reports > Revenue Potentials by Outlet Report
- To open the report criteria screen, double-click Revenue Potential by Outlet Report or select the report and click Run Report, as per Fig.1
Fig.1 - Running the Revenue Potential by Outlet Report
Enter report criteria to get desired results, as per Fig.2
Fig.2 - Report Criteria for the Revenue Potential by Outlet Report
|Fiscal Year||Select the fiscal year as defined under Property > Setup > Accounting > Fiscal calendar. Blank [Default]|
|Fiscal Period||Select the corresponding period to the fiscal year selected. Blank [Default]|
|Period Dates||Will auto populate base don the user and period chosen. Blank [Default]|
|Outlets||Select the outlet(s) to generate the report for.|
|Preview Potential Exceptions||Displays products assigned to the outlet that are not flagged as on Inventory Guide under Inventory > Maintain Guides.|
If Checked will include the outlets inventory.
When the Revenue Potential report is generated, the result should look similar to Fig.3.
Fig.3 - Revenue Potential Report results
|Product||The Adaco product number as defined under Property > Products.|
|Product Description||The Adaco product name as defined under Property > Products.|
|Unit||The Inventory unit as defined under Property > Product > Inventory Unit.|
|Unit Cost||The inventory unit cost.|
|Unit Potential||The unit potential as defined under Accounting > Budgets > Maintain Revenue Potential.|
|Usage||Calculation: USAGE = DIRECT CHARGE PURCHASE ORDER +/- OUTLET REQUISITIONS +/- TRANSFERS +/- INVENTORY COUNT
[If Include Inventory was selected and applicable to the outlet].
|Total Cost||Calculation: TOTAL COST = UNIT COST x USAGE|
|Total Potential||Calculation: TOTAL POTENTIAL = UNIT POTENTIAL x USAGE|
|Cost %||Calculation: COST % = TOTAL COST / TOTAL POTENTIAL|
|Purchase Information||Displays the purchase Information from the Property > Products > Purchase Info field. [If applicable]|
|Unit Description||Displays the purchase unit and [pack size & pack unit] as defined under Property > Products.|
|Retail Attributes||Displays additional characteristics defined for retail Retail Attributes for retail product under Property > Products > Retail button [If applicable].|
|Outlet||Displays the outlet number and name.|
|Category||Displays the category number and name.|
|Category Total||Display a category level sum of the following fields: Usage, Total Cost and Total Potential.|
|Outlet Category Grand Total||Calculated;
A grand sum of each Category Totals fields: Total Cost, Total Potential, Cost % and Sales Mix.
|Net Totals||Total Net Potential excluding any potential adjustments [If Applicable].|
|Actual Sales||Displays Revenue potential sales or potential quantity adjustments entered under Accounting > Period Budgets > Adjust Revenue Potentials.|
|Variance||Calculation: VARIANCE = NET TOTAL - ACTUAL SALES|
Recently activated POS interface and have been experimenting with this Revenue Potential report; unfortunately I am uncertain why the unit potential, Total Potential and Cost % columns are not populating, however unit cost, usage and total cost appear to be fine;
Hi Steven Barath,
Thank you for your query.
As per the table below Fig.3 above, the Unit Potential is populated based on the values entered in Accounting > Budgets > Maintain Revenue Potential.
Once those values are entered, the report will display them as well as be able to calculate Total Potential and Cost %.
Please let us know if you have any further questions on this report.
please help me better understand the function of Revenue Potential report. I am probably having an expectation different from how the current config is. I would expect that once the POS data is imported into adaco, i wouldn't have to enter sales again.
is there another report that auto populates and shows cost %
Hi Steven Barath,
This report is designed to calculate the potential, or optimal perfect-world, revenue that can be realized from a given item, e.g. 750ml bottle of liquor where the standard pour is 50ml would allow for 15 servings at $10 selling price/serving = $150 potential revenue; it does not take into account POS revenue.
that explanation re the Potential Report make much more sense to me now. Having explored the Menu Engineering Report for this exercise i am working with a Retail Outlet "gift shop" which uses only product numbers not recipes
the sort options contribution margin and sales mix percentage are very helpful, i use the calculate based on Average Actual Unit Profit. it very quickly hi-lights items that are incorrectly priced
Please sign in to leave a comment.