Yarrows Aggregates IT@Spectrum Case Study

Yarrows Aggregates.

As a supplier to some of the UK’s most well- known builder.

Company Name

Yarrows Aggregates

Industry

Construction

Founded

2002

Location

Yorkshire & Lincolnshire

Website

www.yarrowsaggregates.co.uk

Print Case Study

Print

“IT@Spectrum’s expertise in Business Intelligence means that we now have a system that has transformed our daily stock ordering process, saving valuable time in reducing manual tasks.”

Yarrows Aggregates

Providing a friendly, efficient and cost-effective service throughout the UK.

The Company


As a supplier to some of the UK’s most well- known builder’s merchants, construction firms and private customers, Yarrows specialise in a wide range of building, recycled, decorative and specialist aggregates.

Objective


Managing stocks of many thousand tonnes of aggregate materials, Yarrows wanted to automate mundane manual processes to speed up invoicing, gain control over stock levels and make for a more efficient way of handling deliveries and collections.

Challenges

  • Requirement to reduce the reliance on manual assessment of stocks
  • Gain control of stock reordering processes
  • Need to speed up invoicing runs
  • Gain quick access to archived documents and reduce physical paper storage

Yarrows Aggregates take immense pride in the high quality of their products and wanted to introduce innovative information and document management technology into their state-of-the-art processing facilities.

The Solution


Yarrow’s initial point of interest was around IT@Spectrum’s expertise in world-leading Business Intelligence and Data Visualisation software, Qlik™. Yarrows were having trouble keeping track of stock levels after orders were placed, the product was picked and then weighed in readiness for delivery. The introduction of advanced drone technology meant that data could be collected on stock levels to estimate tonnage. This was then fed into stock records and, together with integration into Sage 200, IT@Spectrum were able to utilise Qlik to visualise the various elements of data in a number of easy to understand dashboards. This now allows for far closer monitoring of stocks and hugely influences the reordering process, ensuring Yarrows always have optimum stock levels. Qlik also calculates the correct rates to be used when supplying specific customers, again based on stock levels, saving the customer’s Finance team a substantial amount of time each month by avoiding the mundane analysis of spreadsheet in data - and saving Yarrows the effort of processing price queries.


Phase two of IT@Spectrum’s project was to revolutionise the weighbridge ticketing process using document management tools, Therefore™ and Spindle™. After redesigning the weighbridge slips and applying a barcode, tickets can be signed, scanned using our Canon hardware, labelled and digitally stored. Then, when an invoice run takes place in Sage 200, an invoice can be generated and all related tickets can be retrieved for sending to the customer. This improves cash flow as the cost breakdown and evidence is being provided at the point of invoice – drastically reducing the number of invoice queries.

document.jpg

Automated Scanning and Storage of Tickets

automation.jpg

Automation of Mundane Accounting Tasks

search.jpg

Visualisation of Crucial Information

barcode.jpg

Barcode Creation and Scanning

Improve workflows and save time and money with a bespoke information management package

Call today to for a full comprehensive audit of your information management and workflows. We’ll provide a completely bespoke solution to save you time and money

Make an Enquiry.