Skip to main content

Parts & Service - Pricing Matrix

  • Updated

Parts pricing matrices are created to standardize how part pricing is set up. This is the first step when creating pricing tiers in your program. These tiers can be customized on the individual part profiles, if needed. If there is a vendor entered, the matrix applies only to products from that supplier.

The pricing matrix can be assigned to entity profiles so that parts will automatically ring up under the appropriate price calculation.

Add Pricing Matrix

Price Matrix Calculations

Add Pricing Matrix

  1. From any module in MotilityAnywhere, select the user icon in the upper right of the screen to open the menu.
  2. Choose the Settings option from the menu. This will open a screen where, depending on your security permissions, you may view or update company settings.
  3. Select the App Settings tab.
  4. Click the Parts & Service section from the subtabs to the left side of the screen.
  5. Locate and click to expand the Pricing Matrix section. Any previously-entered matrices will show in a list.

pricingmatrix.png

  1. In the upper left, you will choose how you want this matrix to calculate. The options available include Average Cost, Replacement Cost, and List Price. This selection applies to the numbers entered into the starting and ending amounts you enter.
  2. Select the Add New Record button to the upper right of the pricing matrix section to create a new line in the table. To make changes to an existing row, click the edit button for the row.
  3. Optionally, you can choose the vendor for the matrix. Leaving this blank will affect parts from all vendors.
  4. Optionally, you can choose the source to limit which parts are affected by this matrix. If there is a vendor entered on the same line, the matrix applies to products solely from that supplier.
  5. Enter the starting and ending price to limit which parts will be affected. The numbers you enter here will affect the parts with costs (or prices, if selected in step 6) between these amounts.
  6. Enter price levels. You will enter a number, then the letter that corresponds to the cost that you wish to use into each field (Price A, Price B, etc.).

The letters that can be used are:

  • L = percentage of list price
  • A = percentage over average cost (commonly used)
  • C = percentage over replacement cost
  • M = percentage over margin price
  • G = percent over gross margin (based on replacement cost)
  • S = percent over gross margin (based on standard cost)

In the example above, Price A sets the retail price to 100% of list price, while Price D will charge 25% over replacement cost.

  1. Click the Update button on the row to save the changes.

Price Matrix Calculations

L

List Price
Price = PriceCalc * RetailPrice / 100

A

Average Cost
Price = AverageCost * (1 + (PriceCalc / 100))

C

Replacement Cost
Price = ReplacementCost * (1 + (PriceCalc) / 100))

M

Margin Price = (RetailPrice - ((RetailPrice - ReplacementCost) * PriceCalc / 100))

G

Gross Margin by Replacement Cost Price = (100 / ((100 - PriceCalc) / 100)) / 100 * ReplacementCost

S

Gross Margin by Standard Cost Price = (100 / ((100 - PriceCalc) / 100)) / 100 * StandardCost

Related articles