Calculating the Profit margin in %

[Former Member]

Hi gurus

i want to calculate the profit margin in the pricing so when my client check the sale order they can know how much profit they are making

so i first used 11 in cal typ but that one display the profit margin as value so after some search used 18 as cal type it was giving the profit margin in % but its is considering the freight , excise condition types to so the profit margin is actually showing very high

is there any cal type i can use to calculate the profit margin in % only considering the base price after discount and VPRS

Can you give any suggestion it will be helpful

thanks

[Lakshmipathi]

but its is considering the freight , excise condition types to so the profit margin is actually showing very high

Ideally, in the above case, profit margin should be less and am not sure, how you are saying, it is very high.

Moreover, while this can be achieved by using some pricing routines or Alternate Calculation Type routines, logically what you had indicated is wrong.  In general, for any business, profit means, after deducting all expenses from the selling price which includes, freight, duties etc.

G. Lakshmipathi

[Former Member]

hi thanks

yes u r right business profit is after freight and duties only but when i use 18 cal type i am getting the profit margin including duties and freight which is wrong

can u please let me know any routines i can use i want calculate profit margin for the price after discount and the VPRS in %

it will be very helpful i am very new to SAP please guide

Thanks

[former_member184065]

Dear,

Kindly ,read 18 calculation type with the help of documentation.With this ,we can not get exactly Profit Margin.This is useful for comparing the cost and net value of line item.

You need to maintain different kinds of " from and to "  ( in V/08 ) to exclude the freight ,tax etc like to get the final profit of the line item .

Kindly ,let me know if you want any further help.

Thanks,

Naren

[Former Member]

100	0	ZPR0	Price	0	0			0	0	0	ERL
110	0	Z007	Customer Discount	100	100			0	0	0	ERS
115	0		Price after Discount	100	110			0	0	0
120	0	JEXP	IN: A/R BED %	115	115			0	0	0	EXD
121	0	JECS	IN A/R Educ ECess	120	120			0	0	0	EXD
122	0	JHCS	IN A/R Sec ECess	120	120			0	0	0	EXD
123	0		Total duty	120	122			0	0	0
124	0		Copy of price	115	115			0	0	0
125	0		Base + Duty	123	124			0	0	0
128	0	ZFRE	IN Freight	0	0			0	0	0	ERF
129	0		With Freight	125	128			0	0	0
130	0	JVAT	IN A/R VAT	129	129			0	17	0	MWS

131	0	JCST	IN A/R CST	129	129			0	17	0	ZWS
135	0		Total Tax	130	134			0	0	0
136	0	ZFR1	Freight after VAT	0	0			0	0	0	ERF
137	0		copy of base+freight bef tax	129	129			0	0	0
140	0		Total Tax + Freigh after tax	135	136			0	0	0
141	0		Sub Total	137	140			0	2	0
142	0	JTCS	IN: TCS %	141	141			0	0	0	TCS
145	0	DIFF	Rounding Off	0	0			13	16	4	ZRS
150	0		Final Price	141	145			0	4	0
800	0	VPRS	Internal price	0	0		B	4	0	0
810	0		profit margin	0	0			0	18	0
___	__	____	______________________________	___	___	_	_	___	___	___	___	___

this is my pricing procedure i have used any help how can u calculate the profit margin of 115 and VPRS in % i need not as a value to be displayed thanks

[shashi_thakur]

Hi Rani Raja,

Have you thought of using Sub-totals and then adding an alternate calculation to derive the difference for Profit Margin.

Regards,

Shashi