Skip to main content

Adaco: Revenue Potentials by Outlet Report

Fourth Customer Success Portal
  • Updated

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
 

User-added image

Fig.1 - Running the Revenue Potential by Outlet Report 

Report Criteria

  • Enter report criteria to get desired results, as per Fig.2

 User-added image
Fig.2 - Report Criteria for the Revenue Potential by Outlet Report
 

Fields Description
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]
Report Type
  • Detailed: will include line item detail.
  • Summary: will summarize and group by category totals.
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.
Include Inventories If Checked will include the outlets inventory.
  • For closed periods it will be the ending inventory for the period.
  • For current periods it will be the period's beginning inventory.

 

Report Results

When the Revenue Potential report is generated, the result should look similar to Fig.3.

User-added image

Fig.3 - Revenue Potential Report results

 

Fields Description
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

Related articles

Comments

5 comments

Date Votes
  • Steven Barath

    Hi 

    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;

    0
  • David Fournier

    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.

    Best

    David

    Fourth

    0
  • Steven Barath

    Hi David;

    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 %

     

     

    0
  • David Fournier

    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.

    A couple other reports that show Sales and Costs are:
    You can review and assess which reports best fit your business needs; if you have any specific questions on those reports, please ask as you've done here.
     
    Best
    David
    Fourth
    0
  • Steven Barath

    Hey David,

    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

    Thanks Again

     

     

     

     

     

    0

Please sign in to leave a comment.