Licensee management system
Automation streamlines complex process
Case study icon svg Casestudy

Licensee management system

for Coregeo

  • Industry sector icon svgFresh produce
  • Location icon svgKent/International

Background

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.

Project description

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.

Umbraco logo MS SQL Server logo MS Dot Net logo MS Visual Studio logo MS Gold standard logo