Default Outside Purchase Pricing
Pricing options for outside purchases include the same options as options for Inventory Pricing with two additional pricing methods that can be set up by associated labor. Pricing options include:
- Cost Plus Multiplier (CPM)
- Matrix by Supplier
- Matrix by Department
- Linear by Supplier
- Linear by Department
Cost Plus Multiplier (CPM)
This matrix is accessed when the Use Cost Plus Multiplier (CPM) option is selected for either Parts in Inventory or Outside Purchase. This matrix can also be accessed regardless of what option is set in Set Pricing Method from Configuration Parts Price Levels Default Pricing.
A change to any one of the fields (Multiplier, % Profit, or % Markup) will cause a corresponding change in the other two fields. By adjusting these fields, the relation between profit margin and markup can been seen. A different margin can be set for each of the five pricing levels. The price is calculated as follows: Average cost * Multiplier.
Also as part of the default pricing, there is a minimum margin that must be set. This should be set several percent lower than the retail margin. If the overall profit margin for a part falls below this amount, R.O. Writer will warn the user, and ask if the pricing should be modified. As a starting guideline, set the minimum about 1.5 to 2.0 percentage points lower than what is set for the retail margin.
The minimum profit margin is a global setting and applies to all matrices.
NOTE: This is the default CPM matrix. When parts departments are selected, the matrix for that department is used. To access the matrices for each department, select Configuration > Parts > Parts Departments.
Matrix by Supplier
Define the cost ranges. If certain suppliers will have different pricing, decide who those suppliers are, and separate matrices can be set up. Click the New button to add a new price matrix.
If the shop has been using R.O. Writer and has historical information, it is advisable to run the sales history and see what the historical margins have been.
Select the dropdown list to edit other matrices. Click the New button to create a new matrix for alternate suppliers. It is recommended when naming new matrices to use a descriptive enough name so you can identify the correct matrix when editing (Example: CARQUEST Inventory or CARQUEST Outside Purchase). Click the Save Changes button to save the matrix.
The first item to configure is the cost ranges. Enter the dollar values to define the pricing matrix.
Next, select the suppliers that are to be included in the pricing matrix. Individual suppliers may have their own pricing matrix.
- Suppliers in the Included list are assigned to this matrix.
- Suppliers in the Excluded list are removed from this matrix.
If historical information is available, the next step would be to review the parts sales history to see what the historical margins have been for the newly established pricing range. This information could prove to be useful in establishing the pricing matrix margins. If historical information is not available, the user would proceed to the next step of establishing margins for each of the pricing levels.
If needed, set the date range. By default, R.O. Writer will select the last 12 rolling months.
Based on the cost ranges you set and your included suppliers, R.O. Writer will run an analysis of your actual purchases during the date range.
The last step of establishing the pricing matrix is to set the margins for the pricing levels. The margins screen displays the pricing levels established in step one. If the sales analysis was run for historical information, the percent of total parts sales for each pricing level will appear below the pricing levels. To complete the pricing matrix, enter the cost plus multiplier, the margin, or the markup that is desired for each pricing level. Entering one of these values will cause the others to be calculated.
As part of the matrix pricing, there is a minimum price that can be set for each cost range. If the calculated price is less than the minimum price, then that price is used.
When the information has been entered, select Save Changes to save and remain in this screen or select Save to save and exit.
Careful attention should be paid to the Aggregate Profit Margin. This percentage provides powerful information regarding total parts sales profitability.
As part of the matrix pricing, there is a minimum margin that must be set. This should be set several percent lower than the aggregate profit margin. If the overall profit margin for a repair order falls below this amount, R.O. Writer will warn the user, and ask if the pricing should be modified. As a starting guideline, set the minimum about 1.5 to 2.0 percentage points lower than what is set for the aggregate profit margin.
The minimum profit margin is a global setting and applies to all matrices.
Setting the Global Parts Rounding Option applies to all matrices.
- No Rounding - Does not round the values up or down.
- Round Up To - Select the number you wish to round prices up to.
The Default CPM for Manual Price Calc is the multiplier that is used when using the Price Calc button from the Editing Part Window.
Matrix by Department
Define the cost ranges. If certain departments have different pricing, decide what those departments are and separate matrices can be set up. Click the New button to add a new price matrix.
If the shop has been using R.O. Writer and has historical information, it is advisable to run the sales history and see what the historical margins have been.
Select the dropdown list to edit other matrices. Click the New button to create a new matrix for alternate departments. It is recommended when naming new matrices to use a descriptive enough name so you can identify the correct matrix when editing (Example: Brakes Inventory or Brakes Outside Purchase). Click the Save Changes button to save the matrix.
The first item to configure is the cost ranges. Enter the dollar values to define the pricing matrix.
Next, select the departments that are to be included in the pricing matrix. Individual departments may have their own pricing matrix.
- Departments on the Included list are assigned to this matrix.
- Departments on the Excluded list are removed from this matrix.
If historical information is available, the next step would be to review the parts sales history to see what the historical margins have been for the newly established pricing range. This information could prove to be useful in establishing the pricing matrix margins. If historical information is not available, the user would proceed to the next step of establishing margins for each of the pricing levels.
If needed, set the date range. By default, R.O. Writer will select the last 12 rolling months.
Based on the cost ranges you set and your included departments, R.O. Writer will run an analysis of your actual purchases during the date range.
The last step of establishing the pricing matrix is to set the margins for the pricing levels. The margins screen displays the pricing levels established in step one. If the sales analysis was run for historical information, the percent of total parts sales for each pricing level will appear below the pricing levels. To complete the pricing matrix, enter the cost plus multiplier, the margin, or the markup that is desired for each pricing level. Entering one of these values will cause the others to be calculated.
As part of the matrix pricing, there is a minimum price that can be set for each cost range. If the calculated price is less than the minimum price, then that price is used.
When the information has been entered, select Save Changes to save and remain in this screen or select Save to save and exit.
Careful attention should be paid to the Aggregate Profit Margin. This percentage provides powerful information regarding total parts sales profitability.
As part of the matrix pricing, there is a minimum margin that must be set. This should be set several percent lower than the aggregate profit margin. If the overall profit margin for a repair order falls below this amount, R.O. Writer will warn the user, and ask if the pricing should be modified. As a starting guideline, set the minimum about 1.5 to 2.0 percentage points lower than what is set for the aggregate profit margin.
The minimum profit margin is a global setting and applies to all matrices.
Setting the Global Parts Rounding Option applies to all matrices.
- No Rounding - Does not round the values up or down.
- Round Up To - Select the number you wish to round prices up to.
The Default CPM for Manual Price Calc is the multiplier that is used when using the Price Calc button is clicked on the Editing Part Window.
Matrix by Associated Labor
Define the cost ranges. If there are certain types of labor that will have different pricing, decide which categories and/or operations are priced differently and separate matrices can be created. Click the New button to add a new price matrix.
If the shop has been using R.O. Writer and has historical information, it is advisable to run the sales history and see what the historical margins have been.
Select the dropdown list to edit other matrices. Click the New button to create a new matrix. It is recommended when naming new matrices to use a descriptive enough name so you can identify the correct matrix when editing (Example: Transmission Labor Inventory or Transmission Labor Outside Purchases). Click the Save Changes button to save the matrix.
The first item to configure is the cost ranges. Enter the dollar values to define the pricing matrix.
Next, select the labor categories that are to be included in the pricing matrix. Individual categories may have their own pricing matrix.
- Labor Operations in the Included list are assigned to this matrix.
- Labor Operations in the Excluded list are removed from this matrix.
If you only want to include one or more labor operations within a category and not the entire category, here you can select the labor operations that are to be included in the pricing matrix. Individual operations may have their own pricing matrix.
- Labor Operations on the Included list are assigned to this matrix.
- Labor Operations on the Excluded list are removed from this matrix.
The next step of establishing the pricing matrix is to set the margins for the pricing levels. To complete the pricing matrix, enter the cost plus multiplier, the margin, or the markup that is desired for each pricing level. Entering one of these values will cause the others to be calculated. When the information has been entered, select Save Changes to save and remain in this screen or select Save to save and exit.
As part of the matrix pricing, there is a minimum price that can be set for each cost range. If the calculated price is less than the minimum price, then that price is used.
As part of the matrix pricing, there is a minimum margin that must be set. This should be set several percent lower than the aggregate profit margin. If the overall profit margin for a repair order falls below this amount, R.O. Writer will warn the user, and ask if the pricing should be modified. As a starting guideline, set the minimum about 1.5 to 2.0 percentage points lower than what is set for the aggregate profit margin.
The minimum profit margin is a global setting and applies to all matrices.
Setting the Global Parts Rounding Option applies to all matrices.
- No Rounding - Does not round the values up or down.
- Round Up To - Select the number you wish to round prices up to.
The Default CPM for Manual Price Calc is the multiplier that is used when using the Price Calc button is clicked on the Editing Part Window.
When using pricing by associated labor, you also have the option to adjust the final calculated price per parts supplier on the last tab, Supplier Adjustment.
Using the dropdown list, select the supplier you wish to adjust for and enter the percentage in the Price Adjustment box. When finished, click the Save button.
As you can see below, when using the dropdown list, you should be able to see the adjustment percentages set up for each supplier already.
Linear by Supplier
Define the cost ranges. If certain suppliers will have different pricing, decide who those suppliers are, and separate matrices can be set up. Click the New button to add a new price matrix.
If the shop has been using R.O. Writer and has historical information, it is advisable to run the sales history and see what the historical margins have been.
Select the dropdown list to edit other matrices. Click the New button to create a new matrix for alternate suppliers. It is recommended when naming new matrices to use a descriptive enough name so you can identify the correct matrix when editing (Example: CARQUEST Inventory or CARQUEST Outside Purchase). Click the Save Changes button to save the matrix.
The first item to configure is the cost ranges. Enter the dollar values to define the pricing matrix. With Linear Pricing, the levels are infinite. It is a gradual stair step effect where halfway is 50%. It's usually a progression down but it doesn't have to be.
The next step of establishing the pricing matrix is to set the margins for the pricing levels. The margins screen displays the pricing levels established in step one. If the sales analysis was run for historical information, the percent of total parts sales for each pricing level will appear below the pricing levels. To complete the pricing matrix, enter the cost plus multiplier, the margin, or the markup that is desired for each pricing level. Entering one of these values will cause the others to be calculated. When the information has been entered, select Save Changes to save and remain in this screen or select Save to save and exit.
As part of the linear pricing, there are minimum prices that can be set for each cost range. If the calculated price is less than the minimum price, then that price is used.
Setting the Global Parts Rounding Option applies to all matrices.
- No Rounding - Does not round the values up or down.
- Round Up To - Select the number you wish to round prices up to.
The Default CPM for Manual Price Calc is the multiplier that is used when using the Price Calc button is clicked on the Editing Part Window.
As part of the linear pricing, there is a minimum margin that must be set. This should be set several percent lower than the aggregate profit margin. If the overall profit margin for a repair order falls below this amount, R.O. Writer will warn the user, and ask if the pricing should be modified. As a starting guideline, set the minimum about 1.5 to 2.0 percentage points lower than what is set for the aggregate profit margin.
The minimum profit margin is a global setting and applies to all matrices.
When in doubt you are able to enter a sample cost and click the Calculate button to see what price would be calculated using the currently saved matrix.
You will see a window that shows you step by step how the price was calculated.
If historical information is available, the next step would be to review the parts sales history to see what the historical margins have been for the newly established pricing range. This information could prove to be useful in establishing the pricing matrix margins. If historical information is not available, the user would proceed to the next step of establishing margins for each of the pricing levels.
Careful attention should be paid to the Aggregate Profit Margin. This percentage provides powerful information regarding total parts sales profitability.
If needed, set the date range. By default, R.O. Writer will select the last 12 rolling months.
Based on the cost ranges you set and your included suppliers, R.O. Writer will run an analysis of your actual purchases during the date range.
The last step of establishing a price matrix is to select the suppliers that are to be included in the pricing matrix. Individual suppliers may have their own pricing matrix.
- Suppliers in the Included list are assigned to this matrix.
- Suppliers in the Excluded list are removed from this matrix.
Linear by Department
Define the cost ranges. If certain departments will have different pricing, decide what those departments are, and separate matrices can be set up. Click the New button to add a new price matrix.
If the shop has been using R.O. Writer and has historical information, it is advisable to run the sales history and see what the historical margins have been.
Select the dropdown list to edit other matrices. Click the New button to create a new matrix for alternate parts departments. It is recommended when naming new matrices to use a descriptive enough name so you can identify the correct matrix when editing (Example: Brake Inventory or Brake Outside Purchase). Click the Save Changes button to save the matrix.
The first item to configure is the cost ranges. Enter the dollar values to define the pricing matrix. With Linear Pricing, the levels are infinite. It is a gradual stair step effect where halfway is 50%. It's usually a progression down but it doesn't have to be.
The next step of establishing the pricing matrix is to set the margins for the pricing levels. The margins screen displays the pricing levels established in step one. If the sales analysis was run for historical information, the percent of total parts sales for each pricing level will appear below the pricing levels. To complete the pricing matrix, enter the cost plus multiplier, the margin, or the markup that is desired for each pricing level. Entering one of these values will cause the others to be calculated. When the information has been entered, select Save Changes to save and remain in this screen or select Save to save and exit.
As part of the linear pricing, there is a minimum price that can be set for each cost range. If the calculated price is less than the minimum price, then that price is used.
Setting the Global Parts Rounding Option applies to all matrices.
- No Rounding - Does not round the values up or down.
- Round Up To - Select the number you wish to round prices up to.
The Default CPM for Manual Price Calc is the multiplier that is used when using the Price Calc button is clicked on the Editing Part Window.
As part of the linear pricing, there is a minimum margin that must be set. This should be set several percent lower than the aggregate profit margin. If the overall profit margin for a repair order falls below this amount, R.O. Writer will warn the user, and ask if the pricing should be modified. As a starting guideline, set the minimum about 1.5 to 2.0 percentage points lower than what is set for the aggregate profit margin.
The minimum profit margin is a global setting and applies to all matrices.
When in doubt you are able to enter a sample cost and click the Calculate button to see what price would be calculated using the currently saved matrix.
You will see a window that shows you step by step how the price was calculated.
If historical information is available, the next step would be to review the parts sales history to see what the historical margins have been for the newly established pricing range. This information could prove to be useful in establishing the pricing matrix margins. If historical information is not available, the user would proceed to the next step of establishing margins for each of the pricing levels.
Careful attention should be paid to the Aggregate Profit Margin. This percentage provides powerful information regarding total parts sales profitability.
If needed, set the date range. By default, R.O. Writer will select the last 12 rolling months
Based on the cost ranges you set and your included suppliers, R.O. Writer will run an analysis of your actual purchases during the date range.
The last step of establishing a price matrix is to select the suppliers that are to be included in the pricing matrix. Individual suppliers may have their own pricing matrix.
- Departments in the Included list are assigned to this matrix.
- Departments in the Excluded list are removed from this matrix.
Linear by Associated Labor
Define the cost ranges. If there are certain types of labor that will have different pricing, decide which categories and/or operations are priced differently and separate matrices can be created. Click the New button to add a new price matrix.
Select the dropdown list to edit other matrices. Click the New button to create a new matrix for different types of labor. It is recommended when naming new matrices to use a descriptive enough name so you can identify the correct matrix when editing (Example: Brake Inventory or Brake Outside Purchase). Click the Save Changes button to save the matrix.
The first item to configure is the cost ranges. Enter the dollar values to define the pricing matrix. With Linear Pricing, the levels are infinite. It is a gradual stair step effect where halfway is 50%. It's usually a progression down but it doesn't have to be.
The next step of establishing the pricing matrix is to set the margins for the pricing levels. To complete the pricing matrix, enter the cost plus multiplier, the margin, or the markup that is desired for each pricing level. Entering one of these values will cause the others to be calculated. When the information has been entered, select Save Changes to save and remain in this screen or select Save to save and exit.
As part of the linear pricing, there are minimum prices that can be set for each cost range. If the calculated price is less that this price, this price is used.
Setting the Global Parts Rounding Option applies to all matrices.
- No Rounding - Does not round the values up or down.
- Round Up To - Select the number you wish to round prices up to.
The Default CPM for Manual Price Calc is the multiplier that is used when using the Price Calc button is clicked on the Editing Part Window.
As part of the linear pricing, there is a minimum margin that must be set. This should be set several percent lower than the aggregate profit margin. If the overall profit margin for a repair order falls below this amount, R.O. Writer will warn the user, and ask if the pricing should be modified. As a starting guideline, set the minimum about 1.5 to 2.0 percentage points lower than what is set for the aggregate profit margin.
The minimum profit margin is a global setting and applies to all matrices.
When in doubt you are able to enter a sample cost and click the Calculate button to see what price would be calculated using the currently saved matrix.
You will see a window that shows you step by step how the price was calculated.
Next, select the labor categories that are to be included in the pricing matrix. Individual categories may have their own pricing matrix.
- Labor Operations in the Included list are assigned to this matrix.
- Labor Operations in the Excluded list are removed from this matrix.
If you only want to include one or more labor operations within a category and not the entire category, here you can select the labor operations that are to be included in the pricing matrix. Individual operations may have their own pricing matrix.
- Labor Operations in the Included list are assigned to this matrix.
- Labor Operations in the Excluded list are removed from this matrix.
When using pricing by associated labor, you also have the option to adjust the final calculated price per parts supplier on the last tab, Supplier Adjustment.
Using the dropdown list, select the supplier you wish to adjust for and enter the percentage in the Price Adjustment box. When finished, click the Save button.
As you can see below, when using the dropdown list, you should be able to see the adjustment percentages set up for each supplier already.