Search
Search

# Insurance on P& F Charges - calculation

Pls refer my belw pricing structure ;

I have to get a output as per below;

Structre# 1

Base Price 1000.00

P& F charge -2% 20.00

ED -8% 81.60

Ed cess 2% 1.63

Se cess 1% 0.82

Insurance 1% 11.04 (10002081.61.63.83.01)

Freight - L/s 100.00

Total before tax 1215.09

Vat 12.5% 151.89

But i'm having problem in my insurance calcuation , its coming as blw;

Structre# 2

Base Price 1000.00

P& F charge -2% 20.00

ED -8% 81.60

Ed cess 2% 1.63

Se cess 1% 0.82

Insurance 1% 10.20 (1000+20.01)

Freight - L/s 100.00

Total before tax 1214.25

Vat 12.5% 151.78,

pls suggest , how to get the insurance value calculated on Base + P&F + Excise for P&F ..as per my above structure #1.

..

##### Gregory Mathewsreplied

Hello

Before the calculation of insurance cess, u calculate a subtotal (Base + P&F + Excise for P&F ..as per your structure #1) by not giving any condition type and then calculate the insurance cess on that subtotal amount.

Make sure to give the from step for the insurance cess calculation as that of the subtotal we just calculated.

Also remember to maintain an 'S' in the requirement field for the subtotal step.

Hope this helps

Regards

Gregory Mathews

0 View this answer in context
View more on this topic or