Buy timber by size and tiles by the box.

Set Sold by to CFT (by size) for timber or Tiles (boxes) for tiles. On a bill, enter the size or the area, and WorkBook works out cubic feet or boxes.

Updated , for WorkBook 2.0i.

Timber is priced by the cubic foot, but you count it in pieces of each size. Tiles are priced by the box, but you measure the floor in square metres. WorkBook does the sum for you on every line.

Before you start.

Tiles use a ready-made profile, Tiles (boxes). You can see it, and add your own, under Settings, Measurement Profiles.

Steps.

  1. Click Inventory, then Items and Services, then New item.

  2. For timber, enter a Code and Name, and set Sold by to CFT (by size). Choose the accounts, then click Save.

    The New item screen for Teak board, sold by CFT (by size)
  3. For tiles, make another item and set Sold by to Tiles (boxes).

    The New item screen for Floor tile, sold by Tiles (boxes)
  4. Click Purchases, Bills, New bill, and choose the supplier. Add the timber and type its T (in), W (in), L (ft) and Pcs. Enter the Price for one cubic foot. The line shows the cubic feet and the amount.

    A bill line for 30 pieces of timber, 2 by 6 inches and 12 feet, giving 30.000 CFT
  5. Add the tiles and type the Area (in m²), Per box (m² in one box) and Wastage % in the small boxes under the item. WorkBook rounds up to whole boxes. Enter the Price for one box.

    A bill line for tiles: 48 m² with 10% wastage at 1.44 m² per box gives 37 boxes
  6. Click Post. To see the timber you hold, click Reports, then Stock by Size.

    The Stock by Size report with 30 pieces of 2 by 6 inch by 12 foot teak

Good to know.

  • Cubic feet are thickness × width × length × pieces ÷ 144, to three decimals.
  • On a tile line you can skip the sum and type the number of boxes instead.
  • Timber stock is kept per size. Stock of any other measured item is kept as a total.

Related.