Case Study: Coca Cola Enterprises

Coca Cola Enterprises is the manufacturing and distribution arm of Coca Cola. Cloud Street worked with their distribution team at Edmonton, who operate 24 hours a day, seven days a week and handle 9,000 pallets a day.

Cloud Street worked with Coke CCE to develop a system to manage the movement of haulage lorries through the Edmonton site, and report on turnaround performance. The system included basic check-in screens for use by the site security team, detailed real-time load and performance information for use by shift scheduling managers, and large-screen displays showing to-the-minute performance statistics, placed on the shop floor and in management offices.

Processes supported by the system include:

• Upload of csv & text-based movement schedules to the database, including data validation and de-duplication
• Check-in of actual vehicle arrivals against arrival schedule
• Detailed display of movement schedule information, with user-friendly filter and search
• Visual overview of current loading-bay situation, with data-display matched to bay layout, colour coding to highlight vehicle status and click-by-click movement of vehicles throught the workflow process
• Tracking of workflow issues
• Large screen display of by-the-minute and whole shift KPI performance
• Management reporting on various KPI performance measures

Cloud Street also provided interface and display design to align with Coca Cola branding.

The Distriview system has been in live use 24/7 since launch. Coca Cola plan to roll-out the Distriview system at more sites in the future.

Microsoft SQL Server 2008 database platform with a Microsoft Access 2007 user interface and Windows .NET application display.

• Download a PDF version of this case study