Matrix Pricing for Outside Purchases

R.O. Writer has seven different methods to assist you in pricing outside purchases of non-stock parts.

Configuring Matrix Pricing for Outside Purchases

To select the pricing method you wish to use for outside purchases of non-stock parts, click Configuration module > Configuration menu > Parts > Set Pricing Method.

In the Outside Purchases section, select the pricing method you wish to use.

The Outside Purchases section circled on the Set Parts Pricing Method window.

NOTE: The options with a red star are not supported in the NAPA catalog, Nexpart, or ACDelco Connect interfaces.

The options are:

Depending on the pricing method you select, there are additional options available.

Setting up Matrices

When you have selected a pricing method for Inventory parts and Outside Purchases, you will want to set up matrices.

For outside purchases, select Configuration > Parts > Default Outside Purchase Pricing. The setup for the option you selected under Set Pricing Method will appear.

Required Entries

If you have any required entries set up that can affect part prices when finalizing the repair order, you can choose to have R.O. Writer

These options are important because the total price of the repair order can change during finalization if prices are recalculated.

Associated Labor

When using a pricing method based on associated labor, the prices can be affected when

Select whether you want R.O. Writer to automatically recalculate the price based on the new labor operation associated, never recalculate the price, or prompt the user whether or not to recalculate the price.

When There is an Inventory Record But Zero On Hand

When you have an inventory record but zero on hand when posting outside purchase parts,

Overriding Matrix Pricing

You can

Complete these steps:

1. On the Editing Part Window, deselect the smart pricing checkbox if checked and manually enter the new price.

2. If you click Yes, the Part Price Calculator will be displayed. The mark up will be based on your default set up.

To Post the Original Price Back to the Part

Complete these steps:

  1. If the part number is in your inventory file, you can post the original part Cost and Price back to the part.
  2. Open the part on the ticket.

THe Editing Parts window with the search inventory button circled.

  1. Click the Search Inv button and the Part List window appears.

The Parts List window showing the part.

  1. Select the part number and click OK to post the original prices back to the part.

If the retail price brought over from inventory was calculated using an inventory smart pricing matrix, the Smart Pricing box would be checked.

Using the Pricing Matrix to Analyze Parts Purchases

When using the following pricing methods, you can also use the pricing matrix, to analyze the parts purchases:

The analysis shows the amount of your purchases and the margin.

Complete these steps:

  1. Start the Configuration module
  2. Click on Configuration > Parts > Default Outside Purchase Pricing. The default matrix appears.
    • The current cost ranges or cost points will be displayed depending on the price method selected either matrix or linear. You can either use these ranges or edit them as needed.
    • Do not select Save Changes or OK to avoid saving any changes to your existing matrix.

The Smart Matrix pricing window open to the Settings tab.

  1. Click the Sales History tab for matrix pricing or the Sales Analysis tab for linear pricing.
    (These options are not available when using Smart Matrix Pricing or Matrix Pricing by Associated Labor.)
  2. The date range defaults to one year. Adjust the date range if needed.
  3. Click the Run Analysis button.

The Sales History after an analysis has been run in the smart matrix wizard.

The Sales History after an analysis has been run in the parts price matrix wizard.

  1. The wizard will display your purchases based on cost range.
    • Here you can determine the cost range(s) where you purchase most of your parts.
    • This is where you need to focus to improve margin.
  2. Click the Margins tab if using matrix pricing.
  3. If you had used the mark ups displayed during the above time period, your margin would be the Aggregate Profit Margin.

The Margins tab showing the aggregate profilt margin as what the margin would be.

The analysis results on the smart matrix wizard window pointing to the aggregate profit margin.

  1. You can do "what if" scenarios by adjusting the mark ups or changing suppliers and/or departments depending on the matrix you selected and clicking the Run Analysis button again.
  2. When you are done running your analysis, click Cancel so that your default pricing matrix does not change.