Skip to content
  • There are no suggestions because the search field is empty.

Markup Formula for Cost Plus Calculations

When calculating cost plus amounts, the markup formula can be used, but can result in confusing results

Introduction

By default, EBIS 5 will come with the markup formula enabled, which will use a more complex formula for calculating the markup over cost.  This option is set in All City Options > Master Parts section > Options.

 

If you take a part that costs $10.00, and use the markup formula and 30%, you get $14.29.  If you take off the 30% of 14.29, you get back to the original $10.00.  Without the markup formula, you would lose money.  $10.00 with 30% markup (no markup formula) = $13.00.  Then 30% back off gets you $9.10.  

Note that if using the markup formula, the maximum percentage you can use is 99.99% - anything more will result in a negative number due to the formula.

Formulas

If using the markup formula, the calculation is: 

COST / (1-percent)


If not using the markup formula, the calculation is:

COST * (1 + percent)

Conclusion

In general, the markup formula is very polarizing: customers either absolutely require it, or prefer the simple cost + calculation.  The decision is up to how the business is run and what your customers prefer.