CM-Cabinets Library User Guide
In This Topic
    Pricing Drawer Runners
    In This Topic

    Drawer Runners can be costed by using the Runner Editor in the Catalog/Drawing Properties, which can be accessed from multiple places.

    In this topic we will discuss :-

    Tutorial 1 - How to apply a cost price to runners dependant on depth and apply a markup to the cost price.

    Tutorial 2 - How to apply Labour pricing.

    Tutorial 3 - How to apply a cost price to each runner group without the use of tables i.e. table cost price is zero.

     

    The Runner Editor can be accessed from the Catalog/Drawing Properties and located on either the:-

    Hardware > Drawers  -  Click to Expand

    Hardware > Drawers  -  Click to Expand

    This tutorial will refer to this page, as it is best to price Runners that are used for the majority of jobs/drawings.

         or

    Click to view

    Hardware > Managers page  -  Click to Expand

    Hardware > Managers page  -  Click to Expand

    The Form/Table buttons shown here are used to set up what is included in each Runner Set and cannot be used for pricing.

         or

    Click to view

    Pricing > Material/Hardware page  -  Click to Expand

    Pricing > Material/Hardware page  -  Click to Expand

    Pricing Category and Markups

    For all tutorials you need to ensure you have the Hardware category is ticked and any other required Categories.

    Labour category must be enabled if labour costing for drawer runners is required.

    Pricing > Pricing/Markups page  -  Click to Expand

    Pricing > Pricing/Markups page  -  Click to Expand

     Tutorial 1 Cost and Markup
           

    Step 1 Locate relevant Runner

    In this example we will cost the runners on a Floor 1 Drawer, which uses a 'Blum Antaro D No Element 30kg Inserta' in the Metal Premium Runners group with a depth of 500mm.

    Floor 1 Drawer showing Runner used for this tutorial 

    The Cabinet Details > Drawers page provides the relevant information concerning the drawer runner Group/Type and the Depth.

    • In step 2 you will notice that the depth's in the drop list relate to the rows in the table.

    Step 2 Edit Runner

    On the Hardware > Drawers page, click on the relevant Edit button (as shown).

    • This will open the Properties sheet, tick the Override Set checkbox (as shown).
      • This makes all the Runners that make up the selected 'Runner Set' available for Edit.
      • As you can see the Runner used in our sample cabinet is underlined.
    • Click on the Edit button that corresponds to the runner that needs to be priced - this will open the Runner Editor.

     

     

    Step 3 Using the Runner Editor

    Clicking on the Edit button opens the Runner Editor.

    Runners are grouped into one of three Runner Groups, which can be changed using the radio buttons...

    • Using the Runner Depth drop list (as shown below), select 500mm
      • this corresponds to the sample drawer used for this tutorial.
    • Click on the Commercial Only button
      • this is a single page editor that allows just the Cost, Part number etc to be amended.

    The View Original Table is only useful for viewing the current/original table and any changes made using the Form Editors will not be applied to these tables.

     

    Step 4 Pricing for All Lengths

    The following shows the Commercial page for our selected Runner i.e. 500mm.

    Note that there are a number of different Runner Depths which will use identical pricing details e.g. for this tutorial...

    • Supplier - see Pricing Hardware Accessories Tutorial 3 as this will not be discussed here.
    • Markup percentage
    • Labour Pricing - for now enter Time/Rate and 'No' to Use Labour as this will be discussed in Tutorial 2 below.

    So to save time and effort, enter the repeat data and then click on the Save All Lengths button (as shown).

    • Note that a message below this button will then confirm the Current Overrides i.e. runner depths.

    Step 5 Costing Individual Depths

    Now we will cost each Runner Depth.

    • As we already have the 500mm property sheet open, type in the Cost as $8.00;
      • Remember the Markup was 10% (0.1), so the applied cost will be $8.80.
    • Then click the Save 500mm button, which saves only the details for the current selection.

    • To Cost all the other Runner Depths - .
      • Using the Runner Depth drop list (as per Step 3)...
        • select each of the other individual depths e.g. 550mm
        • Type in the required Cost price (before Markup applied)
      • Then click the Save... button
        • Current depth will be displayed on button.

    In this example, enter a different Cost as per the image below i.e 550mm is $9, 500mm is $8 etc

    Step 6 Cost Runners in Set

    This isn't required for this tutorial but you would return to the Runner Properties discussed in Step 2 and price each of the related runners in the Set in the same way.

    Step 7 Test Report

    To test the effect of this process, run a Quantities report.

    The following report shows that the Cost is $8 plus the Markup (10%) $0.80 = $8.80

    The above report shows only pricing details pertaining to this tutorial.

    Rounding during the calculation process can cause amounts to increase by a few cents.

    To calculate Sell price set Markup Percentages per category on the Pricing > Pricing/Markups page.

     

     Tutorial 2 Labour Rate

    In this tutorial we will only Use Labour for the example cabinet i.e. for Depth 500mm.

    Step 1 Use Labour

    • In the Labour Time edit box, type in the estimated quantity of time it will take to process this task in minutes.
      • Type in 10.00mn (unless already entered in Tutorial 1)
    • In the Labour Rate edit box, type in the cost rate of performing this task in this time.
      • Type in $12.00
    • Use the Use Labour drop list and select Yes

    This process would be repeated for all lengths, ensuring the Labour Time and Rate are also correctly set.

    Step 2 Test Report

    Test the results by running a Quantities By Category report, as shown.

    The calculation of processing time is the number of items i.e. 1 runner multiplied by 10 minutes10 minutes

    The calculation is hourly rate of $12.00 divided by 60 minutes multiplied by 10 minutes.

    Therefore the labour cost of this part would be $2.00

     

    Tutorial 3 Zero Pricing

    The Pricing > Settings page allows you to set the default price if the tables are not setup with a value i.e. a $0.00 price.

    If no cost pricing has been set for drawer runners, i.e. table price is $0, then you can enable and set a cost price for each Runner Group on the Pricing > Settings page of the Catalog/Drawing Properties.

    In this example we are pricing a Blum Antaro D No Element 30kg Screw in the Premium Runner group

    • The table for this drawer runner has a cost value of $0 i.e. has not been updated.
    • If you want to test this for yourself then change the drawer runner on the Cabinet Details > Drawers page used in Tutorial 1.

    See tutorial Pricing Zero for more details.

    Step 1 Enable Zero Pricing

    On the Pricing > Settings page for each Runner Group, as shown below:-

    Pricing > Settings page  -  Click to Expand

    Pricing > Settings page  -  Click to Expand

     

    Step 2 Test

    To test the effect of this process, run a Quantities report.

    The following report shows that the Cost of the Premium runner used is $80.  

     

    The above report shows only pricing details pertaining to this tutorial.

    Rounding during the calculation process can cause amounts to increase by a few cents.

    To calculate Sell price set Markup Percentages per category on the Pricing > Pricing/Markups page.

     

    See Also