Job, contract and price tracking for a consulting forester

About the client

The client is a consulting forester who manages timber jobs on behalf of landowners.

The challenge

Each job involves several parties: landowners, mills that buy the wood, trucking companies and labour crews. Prices differ by wood product and change over time, and contracts with mills and truckers vary. Keeping track in spreadsheets made it hard to know which jobs were profitable.

What we built

• Job records: Every job linked to its landowner, mills, trucking and labour.
• Stakeholder contracts: Contract terms with each mill and trucking company stored and applied to jobs.
• Wood product prices: Current and past prices for each wood product, used in job calculations.
• Job profitability: Revenue and costs brought together per job so margins are visible.

Zoho apps used

• Zoho Creator: Jobs, stakeholders, contracts, prices and profitability

What changed for the client

The forester has one place for every job and contract, with prices kept current, and can see margins before and after a job instead of after the season.