michael@theSpreadsheetCompany.co.uk
  01508 518 518

Ocean Spray Excel Automation Logo
Charlie Ocean Spray Excel Automation Pic

Ocean Spray – detailed supply/income tool – Charlie, Head of Business Development

 

Charlie came from another food manufacturer where he had used an automated forecasting tool to generate forward-looking business information. He described the tool to me and together we have created an improved version based on the same principles.

Their ‘data-landscape’ is huge, and this tool allows easy entry of known information by filtering out the items that are not currently used, and uses that data to produce a complex predictive breakdown of their marketplace, by products and customers.

The data can be sliced in many different ways to produce both detailed and management accounts showing both ‘actuals’ for the year to date and expected business information.

Michael: This was a challenging project, the size and complexity of the data for both input and output needed to be carefully considered to allow for smooth use of the facilities that Charlie needed, but in the end I was very pleased with the result.