Livna dashboard showing jobs on the floor, stock levels, upcoming deadlines and the workshop scheduling timeline

Dashboard: the floor, stock alerts, deadlines, schedule

Overview

Livna replaced the spreadsheets and whiteboards behind a horse-stable construction business. Parts, products and quotes live in one system, so when a client asks for a stable front 400 mm wider, the price, weight, bill of materials and workshop hours all update from one source of truth.

From stock rate to quoted price

Stock rates, product dimensions and workshop hours flow into the bill of materials and quoted price.

Stock rates, quantities, workshop hours and markup.

1

Stock

rates & measurement

Each line is priced per metre or per unit by its measurement type.

2

Product: Stable Front, swing door

parametric assembly
Materials$0.00
Workshop labour: 10.0 h × $130/h$1,300.00
Unit cost$0.00
Assembly weight0 kg

Rails track product_length, uprights product_height, infill a formula of both.

3

Quote

modifiers → markup → GST
6 × Stable Front @ $0.00$0.00
Powder-coat 0.0 m² × $38$0.00
Subtotal$0.00
Markup 15% (after modifiers, never on freight)$0.00
GST 10%$0.00
Total inc GST$0.00

Order is fixed: products → modifiers → markup → GST. Modifiers never see the marked-up total.

Product quantities and pricing

Product dimensions determine material quantities, weight and workshop hours. Modifiers, markup and GST complete the quote; freight stays outside the markup.

Product builder: parametric bills of materials

Products follow the frames used in the workshop. Stock, dimensions, material quantities, weight and labour hours stay with each part.

Three views:table, calculation trace, and a Sankey of cost through the assembly.
Livna product builder editing a stable front: assembly frames, material breakdown by category, workshop hours, and the searchable parts palette

Editing a stable front

Quoting: dimensions on the quote itself

Length and height are editable on each quote line; the engine re-prices, re-weighs and updates modifiers in place. A live stock check flags shortfalls, and accepted quotes convert to jobs with every line carried across.

Real scale:the same engine prices a four-figure panel and a seven-figure barn complex.
Livna quote editor with per-line dimensions, weights, infill and finish modifiers, and quote actions

Quote editor: per-line dimensions, convert-to-job

Stock: one ledger for the whole floor

Each stock line carries its measurement type, dimensions, weight and cost channels — the inputs the pipeline stands on. Low-stock thresholds split quantity from length shortages, and stock takes run on an auditable schedule.

Kept honest:orphaned stock — in the ledger, in no product — is surfaced for clean-up.
Livna stock ledger with measurement types, default dimensions, per-metre and per-unit costs, and low stock alerts

Stock ledger: cost channels and low-stock health

Scheduling: hours against capacity

Job hours sit against weekly workshop capacity. Overloaded weeks are flagged, with confirmed work and planning jobs carried into the forward schedule.

Forecast rules:planning jobs can be probability-weighted, showing the committed floor and the likely one.
Livna workshop scheduling timeline showing weekly capacity utilisation for confirmed and planning jobs

Confirmed vs planning jobs against weekly capacity

Jobs: from accepted quote to the floor

Accepting a quote creates the job: products, dimensions and pricing snapshots transfer automatically, so the floor builds exactly what was sold. A weighted workflow gives the dashboard an honest percent-complete.

Livna jobs board with workflow progress, due dates, and status filters

Jobs: workflow progress and due dates

Reporting: the feedback loop

The Impact Radar shows which stock the business depends on, what is ageing, and where vendor exposure concentrates. Job profitability compares quoted against actual, so the next quote's margins are set with evidence.

Impact Radar report: bubble chart of the most prolific stock parts and vendor coverage

Impact Radar

Job profitability report comparing quoted values with actual costs and margins

Quoted vs actual margin

Delivery

Powder coating, assembly checks, delivery and installation stay together on the job checklist.

Job 683-HOLLIS_ST3 · workshop checklist In progress
Powder coating
Assembly QA
Sent for delivery
Installation

Still running a workshop on spreadsheets?

I want to work on something together.

Get in touch