Manually Price a Line Using the Built-In Formulas

Within the line's price field, there is logic to quickly derive a customer price from the item’s average cost, last cost, or company defined cost.  The cost used in the calculations, where cost is the basis, is completely dependent on how the user’s security option is set in the User Security interface within the Acclamare Command Center.  The user can also quickly derive a price using the item’s list price as the basis.  In each case, the user simply types the formula's character immediately followed by an integer value. This is a review of the available formulas:

• Cost Based Formulas
  • M (Margin%): This formula uses gross margin to derive the customer price.
    • Example
      • cost is $5
      • user types M30, which the system interprets as "give me a price with a 30% margin."
      • price = cost / (1 - %)
      • price = 5 / (1 -0.30)
      • price = 5 / 0.70
      • price = $7.14
  • C (Cost Up): This formula derives the price by adding a percentage of the cost to the cost.
    • Example
      • cost is $5
      • user types C20, which the system interprets as "give me a price that is 20% higher than cost."
      • price = cost + (cost * %)
      • price = 5 + (5 * 0.20)
      • price = 5 + 1
      • price = $6.00
• List Price Based Formulas
  • L (List Down): This formula derives the price by subtracting a percentage of the list price from the list price.
    • Example
      • List price is $5
      • user types L10, which the system interprets as "give me a price that is 10% lower than list price."
      • price = list price - (list price * %)
      • price = 5 - (5 * 0.10)
      • price = 5 - 0.50
      • price = $4.50
  • X (List Multiplier): This formula derives the price by multiplying a percentage against list price.
    • Example
      • List price is $5
      • user types X90, which the system interprets as "give m e a price that is 90% of list price."
      • price = list price * %
      • price = 5 * 0.90
      • price = $4.50
  • U (List Up): This formula is the opposite of L (List Down). Rather than deriving a price by discounting the list price, this formula derives a price that is greater than list price. It works the same what the C (Cost Up) works, but is based on list price instead of cost.
    • Example
      • list price is $5
      • user types U20, which the system interprets as "give me a price that is 20% higher than list price."
      • price = list price + (list price * %)
      • price = 5 + (5 * 0.20)
      • price = 5 + 1
      • price = $6.00