Price list, regions and the Price Book
The prices of materials, labour and plant, by region, the starter library, price surveys and the HodariQ Price Book.
The Price List (Estimating › Rate Library › Price List) is where a build-up takes its unit costs: cement per bag, sand per m3, a fundi per day, a mixer per day. Each item is a resource of one type: Material, Labour, Plant or Subcontract.
The list
- Pick a Type or a Category in the panel on the left to see its items. Categories can sit within others (Sand & aggregates / Sand); they are kept under Rate Library › Categories.
- Columns: Type, Code (left empty, it is made from the type: M-001 for materials, L- labour, P- plant, S- subcontract), Category, name, Unit, Price, Price as of, Usual wastage % (proposed on every build-up line that uses it) and Rates (how many rates use it).
- A price is shown grey when there is none yet, and yellow when it is more than 180 days old. The filters No price yet, Old price and With a HodariQ price find them.
- Changing a price dates it today and adds a row to the item's Price history, with who changed it.
Start with the starter library
Press Load Starter Library and confirm. HodariQ adds 98 usual materials, labour and plant items in categories, and 22 typical build-ups for common items of work (excavation, concrete, walling, plaster...), all without prices: your prices are your own. Items you already have with the same HodariQ code are kept as they are, so the button can be pressed again safely. Every starter build-up carries the note to check its quantities against your own practice before pricing a tender with it.
Regions
Your own prices are for your home region, set under Configuration › Settings › All settings › Prices › Our prices are for (Dar es Salaam unless changed). For any other region, under Rate Library › Regions, each region has a Code (e.g. MWZ) and Price factors: how much dearer or cheaper it is than home, by Type and/or Category, e.g. Materials +8 (transport), Labour -10.
| Price of an item in a region | Comes from |
|---|---|
| Home region, or a rate with no region | The item's Price (shown on its form as Our price (home region)). |
| Another region, the item has its own price there | That price, typed in Prices in other regions on the item. |
| Another region, no own price | Home price x (1 + factor / 100), with the most precise factor that applies. |
The most precise factor wins: a factor for a category beats one for its parent category, any category factor beats a factor for a whole type, and a type beats a factor for everything. Price used on the item's region table shows what a rate for that region takes.
A rate set to a region is priced with that region's prices. To price a set of rates for a region, select them in Rates, open the gear menu, Rates for a Region, choose the region and press Make Regional Rates: each gets a copy coded with the region (e.g. CON-025-MWZ) priced with the region's prices. Running it again prices the copies again. The home region is refused: its rates are the ones with no region.
Price survey in Excel
- 1Press Price Survey (Excel) on the price list, or open Rate Library › Price Survey.
- 2Press Download: the price list with one row per item and one price column per region.
- 3Fill in the prices collected from suppliers (one unit, before VAT). Leave a cell empty to keep the price as it is.
- 4Choose the filled file and press Upload. Every changed price is dated today and kept in the price history. Codes not in the price list and cells that are not a price are listed and left as they were.
The HodariQ Price Book
- HodariQ publishes reference prices from the market. They arrive in your price list as HodariQ price beside your own, for your home region and for the other regions, with their date. Configuration › Settings › All settings › Prices › HodariQ Price Book shows the date of the last one, or Not received yet.
- Your own prices are never changed by it. Diff % shows your price against the HodariQ price: (yours - HodariQ) / HodariQ x 100, in red above +15% and green below -5%.
- To take them, select the items and press Use HodariQ Prices: your home and regional prices become the HodariQ prices, dated with the Price Book's date.
Good to know
Whatever the source, a new price reaches a rate only when the rate is updated, and never a BoQ already priced. HodariQ prices are a guide: you stay responsible for the prices in your BoQs.
Something unclear? Ask us on WhatsApp: we answer the same day.