Die Excise duty Amortization Pricing procedure

[Former Member]

Hi,

M faceing a problem in defining pricing procedure for Excise duty amortization for Die.

The requirement is as follows:

Sr.No. Conditions Result Remark

1 Rate – Discount + Pakg & Forwarding Basic price (A)

2 Basic Price (A) x Excise Duty % Basic Excise Duty (B)

3 Amortisation Cost (C) x Excise Duty % Amortisation BED (D)

4 (B) + (D) = (E) Total BED (E)

5 Total BED (E) x ECess % Educational Cess (F)

6 Subtotal for Sales tax Calculation (A)(E)(F)=(G)

7 (G) x VAT or CST % Sales Tax (H)

8 (G)+(H) Total Value

Please guide me on this.

Thanks & Regards

Kishan Bhat

[Former Member]

hope your query is answered.

If any further query please update.

Reward points if helpful.

Regards,

Rajesh Banka

[Former Member]

For Ammortization, we require to create a 'Z' Condition, which can be copy of Discount / surcharge condition.

This will be a statistical condition & only fotr the purpose of calculation of Excise Duty to the customer. This Value will not be summed in Final value.

Regards,

Rajesh Banka

[Former Member]

You require to maintain pricing procedure as under:

Step | Condition Type | From | To | Remark

10 | Base Price | blank | Blank | This condition can be Mandatory / Manual. Account Key Required.

20 | Discount | 10 | blank | Account Key required

30 | Pkg & Forwarding | blank | blank | From & To blank or to me maintained depends on Scenaro. Account Key.

50 | Gross Price before Ammortization | 10 | 30 | (A)

70 | Ammortization | blank | blank | No account key. Statistical Condition

100 | Gross Price for Excise | 50 | 70 | (B)

110 | BED | 100 | blank | Account key required.

120 | Edu Cess on Exc duty | 110 | blank | Account key required

150 | Sum of Excise Duty & Edu Cess | 110 | 120 | Sum of Excise +Edu Cess only

160 | Gross Price before ammortization | 50 | blank | Sum of Gross Price before Ammortization.

200 | Price for Sales Tax Calculation | 150 | 160 | Price for Sales tax.

210 | VAT | 200 | blank | account key required.

220 | CST | 200 | blank | account Key required

250 | Total Value | 200 | 220 | Final Value.

The above is indicative. Hope this resolves your problem.

Reward points if helpful.

Regards,

Rajesh Banka

[Former Member]

Hi Rajesh, Thanks

I havnt understood this condition.

70 | Ammortization | blank | blank | No account key. Statistical Condition

This case is for Die cost amortization....i am looking out for Excise duty amortization

Eg:

Basic Cost = 200.00 Qty = 1 nos

Total Basic Cost = 200.00

ED 16% for component = 32.00 -

---

(I)

Amortization cost per component = 10.00

Excise Duty 16% = 1.60----

---

(II)

Total Exicse duty to be charged = 32.00 + 1.60 = 33.60-------(III)

So Invoice value will be as follows:

Basic Cost = 200.00

ED = 33.60

Edu Cess = 0.67

Total = 234.27

VAT 12.5 % = 0.12

Total Invoice Value = 234.39

Regards

Kishan

[Former Member]

hi, which pricing procedure ur using , from standard

[Former Member]

m using Taxinj procedure....n Jfact pricing procedure.

Regards

Kishan