Purchasing & Inventory - Summary Usage Analysis Report – Customer Care

Summary Usage Analysis Report

This report summarises the usage of outlets within the property. The report will include transactions since the close of the previous period.

To run the Summary Usage Analysis report, go to Report Center > Accounting Reports > Summary Usage Analysis
To open the report criteria screen, as per Fig.1, double-click Summary Usage Analysis or select the report itself and select Run Report

Fig.1 - Running the Summary Usage Analysis report

Report Criteria:

Fig.2 - Report Criteria for the Summary Usage Analysis report

Fields	Description
Date Range Option	Ability to run report for financial period or between specific dates.
Period	Selects the financial period and year to generate the report for.
From Date	When running by Date Range will need to be entered. When running by period will auto populate with the start date of the period.
To Date	When running by Date Range will need to be entered. When running by period will auto populate with the end date of the period.
Include Inventories	If checked will include the Inventory values in the calculation.
Include Storeroom	If checked will include the Storeroom cost category.
Display Outlet GL Account	If checked will display the Outlets GL Account as defined under Property > Setup > Location > Outlet > General Ledger Account field. [If applicable]

Report Results:

When the Summary Usage Analysis report is generated, the result should look similar to Fig.3

Fig. 3 - Summary Usage Analysis results

Fields	Description
Fiscal Period	Displays the Fiscal Period number as defined under Property > Setup > Fiscal Calendar.
Fiscal Year	Displays the Fiscal year as defined under Property > Setup > Fiscal Calendar.
Outlet	The Adaco outlet number.
Outlet Name	The Adaco outlet Name.
Outlet GL Account	Displays the outlet GL Account as defined under Property > Setup > Location > Outlet > General Ledger Account field. [If applicable]
Period to Date	Net Sales: Outlet sales entered under Accounting > Period Reporting > Enter Outlet Sales menu. Mix %: This is a one outlet report so this percent age will always be 100 %. Cost of Sales: [Beginning Inventory Value + Total Purchases + Requisitions & Transfers + Inventory Adjustments + Usage Adjustments] - Closing Inventory Value. % of Sales: calculation % of Sales = PTDUsageCost / PTDSales x 100.
Year To Date	Net Sales: Year to Date Outlet sales entered under Accounting > Period Reporting > Enter Outlet Sales menu since the start of the year up t the period selected. Mix %: Year to date mix percentage Cost of Sales: % of Sales:
Category	The category number and name as defined Property > Setup > Categories.
Net Totals	The sum of each column.