TOMAS - USE OF FORMULAS FOR CALCULATION OF PRODUCT PRICES AND MATERIAL TRANSACTIONS

TOMAS is a single system on the market that enables the user to use any type of formulas for various calculations. In other words, TOMAS accepts external knowledge and uses it in data operations.

Formulas are used in TOMAS for calculation of:

• elements of product prices
• sales quotations
• invoices
• all kinds of material transactions
• inventories
• simulation of various business policies, e.g. increase or decrease of sam price elements.
Elements that could be used in formulas are the following:
• Various types of prices from price register.
• Tax rate, margin and other elements that could be registered either in product characteristics and/or in register of constants.
• Commercial conditions for sales and purchasing, that relate to partners and products or class of product.
• Ad hoc increase or decrease entered via screen, for a particular delivery.
Formulas in TOMAS could be structural or calculative.
With structural formulas price elements to be calculated are specified.
calculative formulas define how an price elements is to be calculated.

Structural formulas have the following content:

code       description

XXX         E1,E2,E3,E4,E5,
!            ----------------------
!                       !_ price elements
!_ structural formula code

Calculative formulas have the following content:

code       description

E5          (E1+E2)*E3/E4=
!            ...........................
!                                !_ how E5 is to be calculated, using other price elements
!_ price element code

In general, the content formulas is the following:

G              A,C,D,@E,F,

A              A=                          to be taken from price register

C             \$A=                         A is corrected by % or amount registered in commercial conditions

D              #K*A/100=            K= VALUE in product characteristic "K".

E                                             to be taken from a constant (type = VRIJ, code = E)

F              A+C-D*E=              any combination of previous price elements.

Effects of using formulas in TOMAS are the following:

• unlimited elasticity of TOMAS, i.e. adaptability to user needs, without programming
• total insensitivity to changes in the environment, e.g. change of tax rate
• hence, stability and reliability of information system is ensured, i.e. the user can adapt TOMAS to current needs, without programming
• in the same way, user's independence upon the supplier of TOMAS is ensured
• TOMAS' maintenance costs are very much decrease.