Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Margin is the profit to be earned by the retailer for sales of their products. Obviously if the margin has a tax component to it, the actual margin goes down. Hence, now there is an option to consider tax as outside the margin being set - Net of Tax feature in Margin Rule.

...

 In case of Effective Cost

Effective Charge (Eff. Ch.) = Sum of Charges Included in Cost for the item

...

Mark Type Tax CalculationPercentage BasedAmount Based
Mark UpGross of Tax  

Proposed MRP (exclusive of Tax) = (Rate + Eff. Ch.) + ((Rate + Eff. Ch.) X Margin factor of MRP/100)

Proposed WSP (exclusive of Tax) = (Rate + Eff. Ch.) + ((Rate + Eff. Ch.) X Margin factor of WSP/100)

Proposed MRP (exclusive of Tax) = (Rate + Eff. Ch.) + Margin factor of MRP

Proposed WSP (exclusive of Tax) = (Rate + Eff. Ch.) + Margin factor of WSP

Mark UpNet of Tax

MRP before Net of Tax = Rate + ((Rate X Margin factor for MRP )/100)

WSP before Net of Tax = Rate + ((Rate X Margin factor for WSP)/100)


MRP Inclusive of Tax =MRP before Net of Tax+((MRP before Net of Tax X TaxRate)/100)

WSP Inclusive of Tax=WSP before Net of Tax+((WSP before Net of Tax X TaxRate)/100)

  • Display MRP Inclusive of Tax & WSP Inclusive of Tax till 3 decimal place

MRP before Net of Tax = Rate + Margin factor for MRP 

WSP before Net of Tax = Rate + Margin factor for WSP

MRP Inclusive of Tax =MRP before Net of Tax+((MRP before Net of Tax X TaxRate)/100)

WSP Inclusive of Tax= WSP before Net of Tax+((WSP before Net of Tax X TaxRate)/100)

  • Display MRP Inclusive of Tax & WSP Inclusive of Tax till 3 decimal place
Mark DownGross of Tax  

MRP Exclusive of Tax (where MRP taken as MRP) = MRP - (MRP X Margin factor for MRP)/100

MRP Exclusive of Tax (where MRP taken as RSP) = RSP - (RSP X Margin factor for MRP)/100

WSP Exclusive of Tax= WSP-(WSP X Margin factor for WSP)/100

  • Display MRP Exclusive of Tax & WSP Exclusive of Tax till 3 decimal place

If MRP Exclusive of Tax < WSP Exclusive of Tax, then

Proposed Rate**MRP Exclusive of Tax

Otherwise,

Proposed RateWSP Exclusive of Tax

**Proposed Rate is the rate proposed by the system to the user if the margin rule validation fails.

MRP Exclusive of Tax (where MRP taken as MRP) = MRP - Margin factor for MRP

MRP Exclusive of Tax (where MRP taken as RSP) = RSP - Margin factor for MRP

WSP Exclusive of Tax= WSP- Margin factor for WSP

  • Display MRP Exclusive of Tax & WSP Exclusive of Tax till 3 decimal place

If MRP Exclusive of Tax < WSP Exclusive of Tax, then

Proposed Rate**MRP Exclusive of Tax

Otherwise,

Proposed RateWSP Exclusive of Tax

**Proposed Rate is the rate proposed by the system to the user if the margin rule validation fails.

Mark DownNet of Tax

MRP Exclusive of Tax (where MRP taken as MRP) =  ((MRP - Tax on MRP) X (100 - Margin factor for MRP))/100 - Eff.Ch.

MRP Exclusive of Tax (where MRP taken as RSP) =  ((RSP - Tax on MRP) X (100 - Margin factor for MRP))/100 - Eff.Ch.

WSP Exclusive of Tax = ((WSP - Tax on WSP) X (100 -Margin factor for WSP))/100 - Eff.Ch.

  • Display MRP Exclusive of Tax & WSP Exclusive of Tax till 3 decimal place

If MRP Exclusive of Tax < WSP Exclusive of Tax, then

Proposed Rate**MRP Exclusive of Tax

Otherwise,

Proposed RateWSP Exclusive of Tax

**Proposed Rate is the rate proposed by the system to the user if the margin rule validation fails.

MRP Exclusive of Tax (where MRP taken as MRP)  = (MRP - Tax on MRP - Margin factor for MRP) - Eff.Ch.

MRP Exclusive of Tax (where MRP taken as RSP) = (RSP - Tax on MRP - Margin factor for MRP) - Eff.Ch.

WSP Exclusive of Tax = (WSP - Tax on WSP - Margin factor for WSP) - Eff.Ch.

  • Display MRP Exclusive of Tax & WSP Exclusive of Tax till 3 decimal place

If MRP Exclusive of Tax < WSP Exclusive of Tax, then

Proposed Rate**MRP Exclusive of Tax

Otherwise,

Proposed RateWSP Exclusive of Tax

**Proposed Rate is the rate proposed by the system to the user if the margin rule validation fails.

...