casestudy
Protelligent Limited
Issues
Protelligent Limited asked us to develop a cash-flow forecasting application based upon a sophisticated spreadsheet the business had developed. The spreadsheet used data imported from Sage Line 50 to create various scenarios that could then produce Management Information (MI) reports. The problem was that spreadsheets have inherent issues that are extremely difficult to protect from data errors.
Protelligent Limited used Microsoft Excel, but the spreadsheets had limitations and were unable to process data beyond sub-ledgers, where as they wanted to drill down further, enabling users to forecast income and expenditure far more accurately.
Outcomes
Protelligent Limited historically provided an outsourced / interim Financial Director for Small to Medium sized Enterprises (SME), but wanted to create a software solution that enable them to generate a revenue stream from their Intellectual Property (IP).
They also wanted to address the issues with using spreadsheets, whilst also being able to create cash-flow forecasts that could be drilled down to each transaction (beyond the current limitations of sub-ledgers).
Solution
Ayrmer Software undertook an extensive business analysis that proved invaluable, avoiding a number of potential issues, by ensuring we had a thorough understanding of what the end solution would look like. Good communication continued throughout the development process and ensured the successful completion and continued support.
Cash-flow forecasting software
The cash-flow forecasting software underwent extensive testing prior to launch with improvements to the software being made following the completion of User Acceptance Testing (UAT).
Ayrmer Software have continued to supported Protelligent Limited post launch, designing and developing a brochure style website and blog (using WordPress) - www.ooble.co.uk - to help market the software.
Ayrmer Software have developed a piece of software which will allow SMEs to produce management information and cash flow forecasts. From the start they listened carefully and, through the Definition of Requirements process, gained a clear understanding of what we required. They considered a number of possible technical solutions and finally recommended that we use an Apache Derby database with Java as the programming language. They have delivered on their promise of 'making complex tasks simple' and have given us an excellent application...
Mike Cosby, Managing Director of Protelligent
Our Managing Director was able to introduce Bill Wells (who runs 2.0 Ltd.,) to Mike Cosby, who commissioned a promotional video for the website from Plymouth based video production company 2.0 Ltd., which you can see on his website. As part of the process, Bill used some of the video footage to create the testimonial video below.
Date: 01/10/2012
gettingintouch
If you like to get in touch, please telephone our offices on
+44 (0) 1364 582017 or complete our
on-line form and we'll get back to you
as soon as possible.
stayingintouch
Stay in touch with what we're up to at Ayrmer Software by following us on one of our
social media feeds: we'd be delighted to welcome you as a follower on
twitter,
become friends on facebook
or add us to your circle on Google+.
You'll also find us on Linkedin, of course.
relatedpages
home
Our expertise lies in our ability to interpret your business requirements and provide a solution that meets your needs; find out how we achieve this level of understand. It's what makes us different ...
database applications
Find out about how database applications are used to develop a variety of different business solutions and how you can leverage your critical data within your business.
methodologies
Find out more about how we ensure that we have a clear understanding of the scope of the project, enabling us to present a solution that will meet your business requirements.
identify the issues
People rarely think with sufficient clarity, because they are too close to the business, this can make it difficult for the business to be objective. Find out how we tackle this to ensure that we can identify teh issues and not just the symptoms.
agree the outcomes
If asked, most people will describe what they want, rather than what they need; this confusion can lead to the wrong solution. Find out how we ensure that the outcomes are well defined.
