One of the biggest handicaps of most other order input programs, is their need to
use product codes, each code specifying the combination of glasses in a unit and
sometimes also the spacer bar and sometimes even extra processes like leading and
Georgian. Even 10 years ago, the number of these combinations and therefore the
number of required codes started going cosmic. Today, there are so many different
types of glass and other options, that to maintain a system based on product codes
is now totally impractical.
With UPS, the order input operator simply inputs the individual leaves of each unit
and for following lines of the same combination, a simple ditto feature enables easy
duplication. So how on earth does UPS calculate the unit price for all possible
combinations of glasses, I hear you ask. The answer is simple. For each type of
glass, there is a single glazed selling price and a double glazed selling price -
simple enough so far. From the quoted double glazed selling price, UPS calculates
another calculation double glazed price.
Here is a simple example. Suppose the quoted double glazed selling price of 4mm
Clear/4mm Clear units is £20 per square metre and the quoted double glazed selling
price of 4mm Clear/4mm Obscure units is £28 per square metre. The calculation double
glazed price of the 4mm Clear glass type is half the quoted double glazed selling
price, namely £10 per square metre, because the other leaf will always be the same
4mm Clear. For the obscure leaf however, the data record contains the glass code
which normally goes with this obscure leaf to achieve the quoted double glazed selling
price, in this case the 4mm Clear. The obscure calculation price is now calculated
as the quoted double glazed selling price of the obscure unit, minus the calculation
price of the 4mm Clear unit, which results in a figure of £18 per square metre.
Whenever different glass types are put together in a unit, it is the sum of the two
calculation prices which is the final selling price. This method works even if a
unit with a combination of glasses never used before is input to the system. If
for instance a customer wants an obscure unit with extra obscurity so specifies both
leaves obscure, the two calculation prices of £18 per square metre will be added
together to achieve a final selling price of £36 per square metre. If also 6.4mm
Laminate quoted unit selling price is £30 per square metre, making the calculation
unit price £15 per square metre and this is paired with an obscure leaf, the final
selling price will be £33 per square metre.
This pricing method is not only simple to use at order entry, but it makes pricing
updates infinitely quicker and simpler. Only the percentage or flat rate increases
to the quoted sealed unit selling prices need to be entered and all the calculation
unit prices are automatically recalculated. Also using this method, the glass types
appearing on each customer’s unique price list can be condensed to miss out any infrequent
glasses. Each customer’s quoted sealed unit price list can therefore usually be
condensed to one sheet of A4 paper. Some less capable systems need to print hundreds
of pages to achieve their results using their inefficient product codes.
Extra processes like Georgian, leading, artwork, interior blinds, bevelling, drilling
holes etc, are as easily entered. Their pricing can be by flat rate, per quantity,
per square metre, per linear metre, or by percentage. Some processes can be excluded
from any percentage discount applied to customers’ final prices. This gives a tremendous
amount of flexibility enabling the very competitive pricing of the sealed unit not
to be applied also to certain additional processes. UPS and Trimloss can cope with
up to 7 different processes on every order item, so the most challenging of situations
can be processed without compromise.
There is the option to use processes where both the description and price can be
amended by the order input operator. This means that a whole catalogue of individual
types of artwork, do not need individual processes, the operator being able to edit
each inclusion of such a process at order entry, to give all the correct details.
The simplicity of this pricing method is enabled by the fact that it is logical,
the final selling price being in effect the average of the quoted unit selling prices
of the two different leaves of glass. There are some “old school” sealed unit salesmen
however who refrain from educating their customers in these utterly simple methods
and prefer instead to pluck selling prices out of thin air. These prices are usually
of course completely illogical and are often more influenced by the flow of alcohol
at the nineteenth hole, than by any desire to rationalise and simplify administration
procedures. Even so, UPS can still cope with these illogical sealed unit prices
by adding a comment at the end of the glass description which makes it clear only
to the input operator, that this isn’t just a glass code, but in this case, it is
a unit code. The “old school” hack addicted to falling down water, can therefore
still get his occasional illogical prices, whilst the bulk of the pricing is done
the logical way.
In the very near future, triple glazing and quadruple glazing will be far more common.
This is no problem for UPS since the pricing methods are simple extensions of the
double glazing methods quoted above. Eventually however, other systems using only
product codes will in our opinion, become completely unusable.
“Pricing orders and maintaining price lists is now so utterly simple...” This is
a common remark we now hear from our new UPS and Trimloss customers.
If you manufacture sealed units and would like to reduce costs significantly,