54
Example 5
Setting:
GST = 5% (NON TAX LIMIT PRICE = 100)
PST1 = 10% (NON TAX LIMIT PRICE = 100)
PST2 = 20% (NON TAX LIMIT PRICE = 100)
PST3 = 30% (NON TAX LIMIT PRICE = 100)
TAX LIMIT: GST
TAX ON TAX ON TAX
DEPT#001: GST
DEPT#002: GST + PST1 + PST2
DEPT#003: GST + PST1 + PST3
DEPT#004: GST + PST2 + PST3
GST AMOUNT = GST sales total x GST
PST1 AMOUNT = (The sales total containing PST1 x GST + The sales total containing PST1) x PST1
PST2 AMOUNT = The sales total containing PST2 x GST --- ①
(The sales total containing PST1 & PST2 x GST) + The sales total containing PST1 & PST2 --- ②
② x PST1 --- ③
(① + ③ + The sales total containing PST2) x PST2
PST3 AMOUNT = The sales total containing PST3 x GST --- ①
(The sales total containing PST1 & PST3 x GST) + The sales total containing PST1 & PST3 --- ②
② x PST1 --- ③
(The sales total containing PST2 & PST3 x GST) + The sales total containing PST2 & PST3 --- ④
④ x PST2 --- ⑤
(① + ③ + ⑤ + The sales total containing PST3) x PST3