This article will provide an overview of the Part Pricing in EMDECS.
Video Walkthrough
Manage Parts Contracts
1. To manage part markup contracts, open the Administration menu and select Standard Codes.
2. Select the Customer tab at the bottom, then open the Parts Contract tab.
3. The screen will be blank if you have not added any parts contracts to your EMDECS account. To add a new part markup contract, click + Add.
Parts Contract Wizard
Adding a new parts contract, as detailed above, will open the Parts Contract wizard.
Each new contract requires a Code and Description. Notes are optional.
Put a check next to Default to make the parts contract the default markup for any customers in EMDECS who are not assigned a specific contract.
Markup or Discount
The following markup fields are available:
-
Markup % : Enter a percentage to markup parts based on your default costing method (Average, Standard, Last, Landed, or Average Landed).
-
Discount % : Leave this field blank unless you want to maintain retail prices for all of your parts. If you enter a value here, the sale price of parts will be based on each part's retail price instead of purchase cost history. To sell parts at a fixed retail price, enter a percentage to discount off the retail price (enter 0% to sell at the retail price without a discount). If you want to sell parts above the retail price, using a retail price markup, enter 0% in field and then refer to the section titled Change Retail Prices in Bulk section for instructions on how to set retail markup percentages for parts in bulk.
-
Core Markup % : Enter a percentage if cores should be marked up differently from other parts. Leave blank for core markups to be the same as other parts.
-
Core Discount % : Only applicable when using the discount % option above. Enter a percentage if cores should be discounted at a different rate. Leave blank if cores should be sold at the same discount rate as other parts.
-
Sublet % : Optional. Enter a percentage to markup the cost of sublet parts.
Note: You can enter markup percentages, or discount percentages, not both.
Fill in the percentage(s) then click Next to continue.
Markup by Cost Range
The Markup by Cost Range step is optional and only applicable when using a markup contract. You can click Next to skip this step. This is useful if you want to have different markup rates based on the cost of the part. For example, you might want a 50% markup on any parts that cost less than $10 while having a 35% markup on all other parts.
Note: Markup by Cost Range cannot be used with a discount contract.
To add cost range markups, click + Add Markup .
Each time you click + Add Markup , a new line will appear in the Markup by Cost Range section. Enter the cost of the parts to be included in the markup in the Include Up To field, the Markup %, and a Core Markup % if your markup should be different for core parts.
With multiple cost range markups entered, you have the flexibility to vary your markup rates for different part cost ranges, as pictured in the example below. Click Next to continue.
Markup by Markup Code
The Markup By Markup Code screen is optional. You can click Save/Exit to save your new parts contract without adding markup codes.
Markup codes are useful if you need to price or markup groups of parts differently from other parts in EMDECS.
For example, if you need to sell oil filters with a different markup percentage from other parts, this can be accomplished by creating a markup code. If this is applicable for your repair shop or parts counter, this section will walk you through how to create markup codes with contain different markup groups for those parts with different markups.
To configure markup by markup code settings, click Add.
If you have not created any markup codes in your system the Markup Code drop-down list will be blank. Click on Add New / Manage to create your first markup code.
Each markup code can contain multiple markup groups with different rates. Begin by adding a markup code. Click + Add Markup Code.
Enter a code and description then click OK to save.
In the example pictured below, I've created a markup code named BRACKET. After adding a markup code, rates need to be added. Click Add Rate .
A markup group name can be selected from the drop-down list, or click + Add New to create a markup group name.
Enter a Code name and Description for the markup group.
Enter the markup percentage or discount percentage. The Core fields should be left blank, unless you want to markup or discount core parts at a different rate. Click OK to save.
In the example pictured below, a new markup group named BRACKET, with a 5% markup rate, has been added under the BRACKET markup code. Additional rates can be added by clicking on + Add Rate again.
Back on the Markup By Markup Code screen, the Location and Markup Code must be entered. Effective and termination dates are optional. Click Save/Exit to close the screen and save your changes.
You can repeat the steps above to assign additional markup codes for different groups of parts, or for other repair shop locations. When done, click Save / Exit to complete the parts contract wizard.
Assign Markup Groups to Parts
If you have created markup code assignments, the markup groups need to be assigned to individual parts. To assign a markup group to a part, open the Parts > Part Master then search for and click on the part number. Under the Settings tab, select the markup group from the drop-down list and click OK to save your changes.
You can also add new markup groups or edit the exisitng one by clicking on + or Edit.
Note: If you have a large number of parts to update, it can be done in bulk by importing a list of parts with the markup group code entered in the "ITEMARGRO_CODE - Item Markup Group" column of the import spreadsheet ( Parts menu → Part Master → Import Parts tab). Click here for more information on Part imports.
Assign Parts Contract to Customers
After creating parts contracts, they need to be assigned to the appropriate customers (unless it is your default parts contract). The default parts contract will be used for any customers who are not set to a specific contract.
To assign a parts contract to a customer, navigate to Administration > Customer then search for and click on the customer name.
Select the appropriate Parts Contract from the drop-down list. You also have the option to create a new parts contract by clicking + Add or click Edit to edit the current parts contract that's assigned to this customer. Click OK at the bottom of the screen to save your changes.
Now that the contract is assigned to the customer, the parts should be priced based on the contract when the customer is chosen for an RO or a counter sale.
Costs & Pricing Tab
Part Costing Methods
When you sell parts through a counter sale or a repair order in EMDECS, the part sale prices are based either on a markup of the part purchase cost or using retail prices (either a fixed retail price or a markup/discount of the retail price). The most common choice is to markup based on cost, as this ensures your part sales continue to be profitable when part purchase costs increase over time, and does not require manually maintaining retail prices for your parts in EMDECS.
Your EMDECS system will be set with a default costing method for new parts. If you need to change your default costing method, please email us at help@brightorder.com, and ask to change your COSTINGMETHOD system parameter to the appropriate default for your business. Individual parts can be set to a different costing method from the part settings screen (Parts > Part Master > search for and click on a part number and select the Costs & Pricing tab).
The following markup costing methods are available in EMDECS:
- Average : Part price is marked up based on the mean average part cost.
- Standard : Part price is marked up based on a standard cost. The part cost and price will not change over time unless you manually update the standard cost, by updating individual parts, importing an updated parts price list, or using the Monitor & Update Standard Costs tool.
- Last : Part price is marked up based on your last or most recent purchase cost of the part.
- Landed : Part price is marked up based on your last or most recent purchase of the part, including any added costs when the part is received and invoiced, such as freight fees. Add on costs are divided between all parts received on the purchase invoice.
- Average Landed : Part price is marked up based on the mean average part average cost, including any added costs when the part is received and invoiced, such as freight fees. Add on costs are divided between all parts received on the purchase invoice.
The Retail Markup % and Retail Price fields are only applicable when a discount contract is used. Entering a retail price or a retail markup percentage will not affect the price of parts when a cost markup contract is used. If you are using discount contracts, the discount is applied to the retail price. If you select the Use Retail Markup % option, this will add a markup on top of the retail price instead of discounting the retail price.
Note:
If you have multiple inventory warehouses, you may see differences between the company costs in the top panel and the warehouse costs in the middle panel. This depends on whether you have us enable a "cost by warehouse" system parameter in your EMDECS system. If cost by warehouse is enabled, each of your inventory warehouses will keep track of its own purchase cost history.
Note:
If cost by warehouse is enabled, and you want to import part costs in bulk, you must use the Import Parts Location Details tab from the Part Master screen to upload different costs for each of your warehouses. The Import Parts tab only updates the company costs. Our customer experience team can assist you with changes to your cost by warehouse system setting (system parameter USE_WAREHOUSE_COST can be set to Y or N).
Override Contract Pricing
EMDECS allows for overriding the cost / price of parts. You can override a part price by location or for all your locations. To set an override, Under the Costs & Pricing tab, open the Override Contract Pricing sub-tab and click + Add Override .
To create an override, select a Contract code and Currency from the drop-down lists and set an Effective Date (defaults to the current date).
The contact pricing override can be based on either Percent or Price .
If you base your override on a Percent, the system will ignore any other discount or markup settings and use the percent entered to markup the part based on its costing method (this will ignore any discount contracts). If you select the Price option, the price you enter will be the price charged for the part.
After filling in the override screen, click OK to save.
To instead do an override by specific location, open the Override Contract Pricing By Location tab and click + Add Override.
This opens an identical override pop-up window, except it also has an option to select a Location.
After filling in the override screen, click OK to save.
Show Contract Pricing
The Show Contract Pricing button will open a pop-up window to view part charges based on the location.
Select a location at the top then you can view all the contracts and the unit charges based on the markup or discount percentage of that contract.
Purchase History
In the Costs & Pricing tab there is a Purchase History button.
Clicking on this button will open a pop-up which shows the purchase and receiving history of the part.
Change Costing Method In Bulk
The Things To Do list on the left-hand side of the Part Master screen contains tools for bulk changes to part cost and pricing settings. If you need to make bulk changes to the costing method of parts or groups of parts in EMDECS, click on the Change Costing Method In Bulk link.
Using the filters at the top of the screen, you can select From and To part numbers to generate an alphabetic listing of parts. You can also narrow down your results by product group or markup group. There are also radio buttons for selecting active parts and stock parts. If you leave all the fields blank, the system will generate a list of all of your parts.
Once you have selected your search criteria, click the Refresh button. This will generate a list of parts to be updated. To perform the bulk change, select a New Costing Method from the drop-down list and click Apply.
Monitor & Update Standard Costs
If you use standard costs to markup part prices, the Monitor & Update Standard Costs tool can be used to change standard costs to equal the current last purchase cost. To access this tool. click on Monitor & Update Standard Costs under the Things To Do List.
Click on the Generate List of Parts button
Enter the appropriate inventory warehouse at the top of the screen, select a radio button to generate a list of parts with a last purchase cost that is greater than or less than the current standard cost, then enter an amount or percent under variance before clicking Generate .
A list of parts will be generated and displayed. Use the Select All, De-select All, and Select check boxes to select which part prices to modify, then click Update Standard Costs at the bottom of the screen to change the standard price to be equal to your last purchase cost for the selected parts.
Change Retail Price Based On
If you sell parts based on retail prices, you need to decide whether you want your retail prices to be fixed or based on a markup of the retail price.
If you use fixed pricing, parts will be sold based on a discount of the retail price. For example, you could create a discount contract of 0% to sell at the retail price, or have a discount of 20% to sell to your preferred customers at 20% off the retail price. Alternatively, if you want to add a markup on top of the retail price, then you can use a retail markup (this should not be confused with the markup option in the parts contract wizard)
The fixed vs. markup behaviour is controlled by the "retail price based on" setting for each of your parts. If you need to change the default setting for new parts created in EMDECS, please contact our customer experience team to change your RETAILPRICEBASE system parameter to either fixed or markup.
This setting can be changed in the Change Retail Price Based On link from the Things To Do list on the left-hand side.
Click on Generate List of Parts.
Before generating a list of parts, the list can be narrowed down by Product Group, Vendor, Active status, and Stock status. Leave the fields blank to generate a list of all parts in your EMDECS system. Click the Generate button to generate a list of matching parts.
Using the Select All, De-select All, and Select check boxes, ensure there is a check next to the parts that need the retail price base changed.
At the bottom of the screen, select Set Retail Price To Be Fixed (for fixed pricing based on the discount percentage) or Set Retail Price To Be Markup (to have parts pricing set using a markup of the retail price). Click Change to update the price base.
Note: Markup contracts that are assigned to a customer based on cost will override retail prices.
Change Retail Prices in Bulk
If you use a discount contract and maintain retail prices for parts, retail prices can be changed in bulk, based on a percentage, using the Change Retail Prices in Bulk screen.
To access this tool, click on the Change Retail Prices in Bulk link from the Things To Do list on the left-hand side.
Click on Generate List of Parts.
Before generating a list of parts, the list can be narrowed down by Product Group, Vendor, Active status, and Stock status. Leave the fields blank to generate a list of all parts in your EMDECS system. Click the Generate button to generate a list of matching parts.
Using the Select All , De-select All , and Select check boxes, ensure there is a check next to the parts that need retail prices adjusted.
At the bottom of the screen, select a change option ( Increase Retail Price by % or Change Retail Markup % to ) and then enter the appropriate percentage. Click Change to update the retail prices or markup.
Change Standard Costs in Bulk
If you need to make bulk changes to the standard costs of parts in bulk click on the Change Standard Costs in Bulk link from the Things To Do list on the left-hand side.
Click on Generate List of Parts .
Before generating a list of parts, the list can be narrowed down by Product Group, Vendor, Active status, and Stock status. Leave the fields blank to generate a list of all parts in your EMDECS system. Click the Generate button to generate a list of matching parts.
Using the Select All , De-select All , and Select check boxes, ensure there is a check next to the parts that need standard costs adjusted.
At the bottom of the screen in the Charge % field, input the percentage to increase the standard costs by. Click Change to update the standard costs.