Trimloss last updated

17th January 2018

by Julie Moorcroft

Moorcroft Computer Services

Thinking clear       Thinking software

Thinking Trimloss


by Julie Moorcroft

Moorcroft Computer Services


Page Buttons:





Simple Sealed Unit Pricing



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,



             Click Here