The initial point of interest was around Spectrum Digital’s expertise in world-leading Business Intelligence and Data Visualisation software, Qlik™. Enviro Aggregates 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, Spectrum Digital was 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 Enviro 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 Enviro the effort of processing price queries.

Phase two of Spectrum Digital’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.