An introduction to setting up job costing in WoodCAM.

All configurable pricing changes are handled in the ‘Data File Maintenance’. 

To open this, navigate to ‘Maintenance’ at the top of the WoodCAM menu bar and select ‘Data File Maintenance’.

The primary sources for these costings are the ‘Price’ fields that are provided in each of the following tables.

These prices should be entered in the way that you wish to see them in the Job Costing reports.

ie. including/excluding taxes, including overheads and other processes, etc.

The costing method can be set to either Square Meter, Lineal Meter, Per Unit, or Pair depending on what the item is.

In most cases, the required prices are for each individual unit so hardware such as screws, which may be supplied in boxes of 100 must be entered as the box divided by the number of items in the box.

All prices are assumed to have been entered as dollars, so for a screw that costs $5.45 for a box of 100, the price for each screw must be entered into the database as $0.0545.

The Boards prices are normally maintained as the price per square measure, therefore a board costing $85.00 for a 2400 x 1200 sheet would be entered as $29.51 per square meter.

Boards

The first table we will look at is ‘Boards’.

The boards' table allows you to specify a Square Meter or a Lineal Meter price. This can be changed by changing the Unit from SQ (Square) to LM (Lineal Meter) The default price option is Square Meter.

In the above example, the unit price has been set to $55 per square meter. 

Generating the ‘Job Costings’ report under the ‘Reports’ tab in WoodCAM, it has populated the price set in the database for this material, against the three products in the job.

Example board pricing output

Edging

Edging – allows you to specify a Lineal Meter cost for the edge tape

An edging breakdown is also populated under ‘Edge Band Materials’ on the abovementioned Job Costing reports.

Example edging pricing output

Hinges

Hinges - allows you to specify a price for a single hinge or a pair.

Hinges can be priced per unit (each) or as a pair (pair). In the below example, the Softclose Inserta has been priced as a pair. The total price has been specified here, whereas the non-soft close option has been priced per hinge.

You can also set the price for the hinge plate that is referenced, which can be confirmed through the HingeSeries table.

Example hinges pricing output

Handles

Handles are priced per handle, so simply enter in the cost per unit. If the product requires more than one handle, the price specified will be multiplied for each required handle.

Example handles pricing output

Drawer Slides

Drawer Slides

The drawer slides can be priced either as a pair of each. Generally, as drawer slides are purchased as a ‘pair’ (Left and Right runner), the unit cost should be set to pair. If drawer slides are purchased individually, each should be used for the pricing unit.

Alternatively, hardware kits can be set up in the drawer tables allowing you to price the drawer slides as ‘Kit’.

Example drawer slides pricing output

Accessories

Accessories

The accessories should be priced per individual item, meaning for a screw that costs $5.45 for a box of 100, the price for each screw must be entered into the database as $0.0545.

Example Accessories pricing output

Costing Series

To include all other overhead costs, this needs to be done through the ‘CostingSeries’ table.

Costing Series can define a number of optional tasks that need to be costed for each part that is manufactured

Default properties for each room can be set by pressing the [Edit Costing Series] button in the Room property area of the screen. Anything checked on will appear on the report.

The [Add] button: allows you to add a new costing item, for example, site measure. This will automatically create a table in the WorkCentres table.

WorkCenters table

The WorkCentres table is where costing is added for any values that have been created in the CostingSeries table above.

You may also specify the HourlyRate field in the WorkCentres records.

Where an Hourly Rate is specified for any costing process, the hourly rate is retrieved and multiplied by the accumulated Hours (Minutes x 60) for each process on the Job Costing reports.

If the Hourly Rate exists for a given Costing process, then the ‘Price’ fields will become ‘Minutes’ instead of ‘Dollars’

This costing breakdown will also generate on to the 'Job Costing' report.