Skip to Content
0
Former Member
May 13, 2008 at 06:14 PM

Profit and Loss Percentage Challenge

161 Views

We control our Gross Margins and Costs by expressing every Profit and Loss item as a percentage of the Total Sales. So our Total Sales is 100%. So everything is divided by the 100% to calculate a Percentage. So for example a Gross margin is 45% (Of the 100%). Advertising Cost is 15% of Total Sales. Net Profit may be 4% etc. My question is if anybody knows if such report exisits in SAP b1. as a Standard or how can I achieve this?

EG

SALES $10,000 100%

COST OF GOODS $ 5,500 55%

Gross Profit $ 4,500 45%

Advertising Cost $ 1500 15%

Telephone $ 200 2%

Admin $ 1600 16%

Overheads $ 800 8%

-


Net Profit $ 400 4%

Thanks

Robert