SECTION 18.104.22.168 - DEBTOR SALES ANALYSIS - ACTUAL GROSS MARGIN
USAGE: To analyse sales and print totals for the largest Debtors. The analysis is for a range of dates but can be filtered using a number of fields. Facilities are included for exporting the report to an ASCII file. This report is only available where enabled for site.
DISCUSSION: This program is a management aid. The report scans the Inventory transaction file for the ranges chosen and totals the value of sales (exclusive of tax and freight) and presents totals for the first few Debtors, sorted by sales. The report also shows the Cost-of-Sales and various breakdowns based on nominal Settlement Discounts, Advertising Allowances, etc. to give a reasonable estimate of the profit expected in the date range chosen.
When you enter this program, the following questions will appear:
USE LONG FORMAT REPORT If you are using wide stationery, reply Y, otherwise reply N. This question will only be displayed if the relevant option is set to A, see SECTION 7.1.2.
CONSOLIDATE SUB-ACCOUNTS If you answer Y here, all subsidiary accounts will be treated as if the sale was to the head office.
INCLUDE ALL TRANSACTIONS If you answer Y here, HiFinance will scan through the entire Inventory master-file. If you answer N, you will be able to limit the report to various ranges.
The following question asks you to enter both a lower and upper limit. The upper limit must not be less than the lower limit. The default answers define the extreme limits of the field. You do not have to change all of these limits. Only change the ones you wish to, and tab past the others.
DATE RANGE This defines the range of transaction dates you wish to include in the report. The fields default to the beginning of the current financial year through to the current date.
DEBTOR CODE RANGE This is the range of Debtor codes.
DEBTOR GROUP RANGE This is the range of Debtor Group codes.
NAME RANGE This is the range of Debtor Named (first 10 characters).
POSTCODE RANGE This is the range of Postcodes.
OTHER DR KEY RANGE This represents the 3 user definable keys for Debtors. This may appear as a different literal depending on how you have defined the field in SYSTEM PARAMETERS
SALESMAN RANGE This is the range of Salesmen. It is the nominal salesman, as defined on the Debtor master-file record.
INVENTORY CODE RANGE This is the range of Inventory codes.
INVENTORY GRP RANGE This is the range of Inventory Group codes.
OTHER INV KEY RANGE This represents the 3 user definable keys for Inventory. This may appear as a different literal depending on how you have defined the field in SYSTEM PARAMETERS
To start the report, press <Enter> through each field or simply press <F10>.
The report itself will detail the Total Gross Sales (excluding Freight and Tax); the Cost-of-Sales for the same transactions; the Gross Margin (Sales less COS); Rebate and Settlement Discount values (computed from the percentage on the Debtor record); the Gross Margin after Rebate and Discount; Advertising value (computed from the percentage on the Debtor record); the Gross Marge after Fixed Costs (Rebate, Discount and Advertising).