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|