Automated file processor
SPCK is a charity with a core focus on publishing. They utilise Microsoft Azure to host their e-commerce environment and Microsoft Power BI as a re...
Coregeo specialise in taking fresh produce brands to market through Intellectual Property Protection, Brand management and Trade and consumer marketing services, pioneering well-known brands such as Pink Lady apples and Tenderstem broccoli.
A series of Excel spreadsheets were being used to manage very complicated processes, in particular the method whereby licensees submit their monthly sales returns. This was not only a significant administrative overhead but was also vulnerable to errors. Plans for growth raised concerns over how this would scale.
Following a detailed analysis phase, it was possible to design a solution whereby the Licensees could add their sales returns via a web-based portal that utilises a Microsoft SQL database. A separate web-based application was developed for the office staff that shares the same database, and that is capable of processing the captured data and generating reports at the click of a button. These reports had previously taken days to create via spreadsheet.
This offers a far more robust solution, which is capable of providing fast and accurate reporting as well as providing a firm foundation for future growth. And since the initial phase, the system has evolved to include a quality control module, additional brand management and advanced financial reporting.
If you have a similar project that you’d like to discuss, please call on 01634 299800 or send an email to get the ball rolling.