How to define Routine in Pricing - It's very urgent

[Former Member]

Dear all,

I want to create MRP based pricing.

In MRP based pricing all calculations are done by backward.For that i have to develop one formula which contains Multiplication & division, so for that i have to develop routine, how we define routine?

Is there any std. routine is available for MRP based pricing?

I explain the detail senario as follows:

My invoice value is 1000 which contains all the inclusive price containing Freight,P& F,Sales tax(CST or VAT),& Excise Duty which is calculated on based of MRP (67% of MRP Value-Assessable Value)

When i want to calculate 5% P&F which is already included in pricing for that i have to develop one formula for that like (Invoice Value=1000 * (100/100 + P&F=5))=A=952.38

After this calculation I got the correct value for P&F like

Invoice Value- A (Which is calculated)=1000-952.38=47.62

same formulla i want to use for CST,VAT & Freight.

so i can calculate exact sales revenue value.

So plz send me some information about the same.

Thanks & Regards,

PM

[Former Member]

hi

Below logic you can put in the alternate calculation of each of the tax condition.

P is the price of the product

Y is the MRP

P&F = x1.P (x1 of P)

ST = x2.P (x2 of P)

ED = x3 .P (x3 of P)

x1 x2 x3 are constants. P = Y/(1-x1-x2-x3)

P&F=x1P, ST = x2.P ED=x3P

Hope this helps.

Reward if helpful.

Kind regards

sandeep

[Former Member]

Hi,

Thanks for yor reply.

But i cannot understand your logic.

How i maintain alternative calculation type? is it routine?

then how i define.

Plz send some solution for the same.

Thanks & Regards,

PM

[Former Member]

Hi

P is the price of the product

Y is the MRP

P&F = x1.P (x1 of P)

ST = x2.P (x2 of P)

ED = x3 .P (x3 of P)

x1 x2 x3 are constants. P = Y/(1x1x2+x3)

P&F=x1P, ST = x2.P ED=x3P

You have mentioned that all the pricing is based on MRP. Hence you will entering MRP as input price. Now P will be selling price before taxes and discounts. P&F, ST and ED will be always mentioned as % of Product and not MRP. So considering the equation

P + P(x1x2x3)=Y

Hence P = Y (1x1x2+x3) and hence further calculations.

Now in V/08 you can maintain pricing procedure. Here alternate calcualtion type will be routine which you can create new and add to the step.

Hope now its clear.

Kind regards

sandeep