Ever wonder how the calculations are worked out in Sage Pastel accounting?

Below is a list of the inventory calculations and how they work.

GP = Sales – COS

GP% equation is GP/Total salesx100

Example = Sale is 1800 COS is 1000

1800-1000=800

800/1800x100 = 44.44%

Mark Up = Sale – Cost

Mark up % = Mark Up amount / cost

Example = Sale is 1800 Cost is 1000

1800-1000=800

800/1000x100 = 80%

Average Cost

Total of the items on hand x the cost of 1 item

Example = you buy 10 pairs of shoes at R150.00 each

10x150 = 1500

Sell 3 pairs at R200

COS = 150x3 = 450

You buy 5 pairs of shoes at R200.00 each

200x5 = 1000

Average cost equation = (10x150)-(3x150)+(5x200)/total quantity on hand

1500-450+1000=2050/10-3+5=12

= 170.83

Vat Equations

Exclusive x 1.14 = Inclusive

Inclusive / 1.14 =Exclusive

Excl 150 x 1.14 = 171

Inc 171 / 1.14 = 150

Vat is Incl – Excl

171 – 150 = 21