HiFinance
5
SECTION 3.5.A12 – CUSTOMER YEILD ANALYSYS
USAGE: This routine is designed to
replace the spreadsheet routines used to compute pricing for large customers.
It firstly picks up all the stock sold to a specific customer; displays current
pricing and profitability. The program then allows you to fiddle with the
pricing so as to achieve a desired profitability. Finally the program writes
the changed prices back to the special pricing matrix, so that the next
invoice/order will reflect the new structure.
DISCUSSION: When
you start the program, you are asked for a Debtor code. Enter the Debtor code
or press <F9>
to initiate a search.
Once you have the Debtor,
you are asked for a date. HiFinance will only consider sales on or after this date.
If you leave the date as zero, all transactions will be included.
HiFinance will scan
through the transactions and display the following screen:
This screen shows you all
the items with any sale quantity. If there is more than one page, you can use
the cursor keys to move to the rest.
You will note that for
each Stock item, a full detailed breakdown is show in the lower window. A
summary is show on each line.
The last column is the one
you can change. If you enter a new price, HiFinance will automatically
recalculate the mark-up and so that you can compare your current pricing
structure with the modified one. You can modify any, or all, of the prices
until you are happy with the result. As the Mark-up is weighted by total value
sold, it should guide you as to the expected overall mark-up you are charging
this customer.
You can press <F3>, at any time, to print a
report of what is displayed. This can be useful for analysing the list if it is
particularly long.
If you do not wish to
apply your changes, press <ESC>.
If you have made any
changes, HiFinance will offer you <F10>.
If you press <F10>,
the new modified prices will be written back to the Special Pricing master-file
(see SECTION 3.5.1 – SPECIAL PRICING)
To return to the INVENTORY UTILITIES MENU, press <ESC>.