ID #1077

When I enter Cost as Rs.200/- and Sale Price as Rs.20. Why it’s showing margin in long negative figure?

The formula for markup and margin is as follows

Markup : (MRP - PC) * 100 / PC OR Markup: =SP/CP % and
Margin : (MRP - PC) * 100 / MRP OR Margin: =(SP-CP)/CP %

 

Please try the above formula in Excel. It should show the following value.

Purchase Cost         

MRP 

Markup

Margin

100000

2

- 99.998  

-4999900

Tags: Information, Purchase Order

Related entries:

You cannot comment on this entry