HiFinance 5
SECTION
1.4.3.5 - 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).
