AllSop Solution

In collaboration with Allsop Software, the Sysco Digital Innovation and Transformation programme successfully delivered the following:

• A fully integrated & automated customer order service
• A real time and fully automated Sales Pricing Tool
• AI Master Data Management
• Business Insight Dashboards

3000+

Happy customers and chefs

AllSop Solution

In close collaboration with the Vegetarian Express team, using the latest AI and digital innovation technology, AllSop developed a fully automated Order Management Solution.

By utilising Robotic Process Automation (RPA), the AllSop Procure Wizard Plug In scans all incoming email orders and automatically extracts the necessary information. The extracted data is then integrated with their ERP system for fulfilment.

Background

Technidrive Solutions, based in Ireland, is a dedicated Industrial Drives supplier offering a service which can be as simple as identifying and supplying replacement drive components such as Electric Motors, Reduction Gear units, Electronic Motor Controllers and Power Transmission equipment, or assisting in the design, selection and subsequent supply of complete new drives from prime movers to dedicated turnkey control systems. Technidrive supply international manufacturers and OEMs of industrial machinery.

Before Introducing a Power BI Solution 

All orders were handled through their accountancy package Sage and excel spreadsheets, however, visibility was poor and it required a lot of manual communication.

The primary issue was this limited visibility. Working from spreadsheets that needed manually updated meant that it wasn’t easy to see when an order was due to be shipped, the order status, who was looking after it and if it had been sent. Sometimes an order delivery date came and went, and nothing was flagged up as a late delivery as the office employees were relying on delivery notes coming back from the warehouse.

The Solution

Allsop developed a solution using Power BI to visually display information relating to Technidrive orders. The Power BI dashboard is connected directly to a Sage database and refreshed every 5 minutes using Power Automate and Power BI Premium capabilities. This allows employees to see data that is current but also data that can change quickly.

The dashboard shows at a quick glance the status of current orders and allows employees to work off this screen, while the report shows the more detailed information relating to orders.

Results

The solution has provided better visibility throughout the business which has allowed Technidrive to make customers aware if an order is going to be late or delayed. This early flagging of late orders has had a positive effect on customer relations. It has also had a very positive effect on internal communications and this is the main area that has been improved. As everyone is reading from the same script it has helped to bridge the gap between warehouse, production and office staff regarding who, when, where and what in terms of orders.

The reliance on printing paper orders and physically leaving them to the workshop has been greatly reduced. All order information is visually there on a screen and updated every 5 minutes, this has helped to increase productivity and decrease the time taken to process orders.

There has been a considerable time-saving from employees knowing the current status of orders and if they have been dispatched, as this can now be accessed by everyone online. This has also reduced the amount of verbal and face to face communication required which was a major benefit. This was especially beneficial during the Covid-19 pandemic as without this system it would have been more difficult to process orders as paper notes would have had to been passed between people and other such interactions.

Employees in the workshop also have a better structure to their work as this is no longer reliance on one person to schedule work. Everybody in the workshop is able to see what they should be working on.

To find out more about our Power BI Dashboards, check out our interactive demos here. Or drop us a message to arrange a call with our BI expert. 

Increased
Accountability

Background

Framptons are a world class processor of liquid foods based in Shepton Mallet in Somerset. Founded in 1898, Framptons have a heritage of more than a century in the food industry. Service and quality are paramount to what Framptons do and has allowed them to maintain a competitive advantage in their industry.

The Solution

The Factory Services Software we have built and developed for Framptons Ltd. is used to control and record production during the production run. This information is then transferred across the factory to the transport depot so that produce can be efficiently loaded.

The Factory Services software is accessed by all members of staff in Framptons, with varying levels of access controlled by unique 4 digit pins. The system is used throughout the factory from the back office to the touch screens placed on the factory floor. The intuitive software has been readily utilised by all staff members and has helped to reduce mistakes in production.

The software has enabled Framptons to significantly reduce paper from the factory floor which has helped to increase efficiency and traceability in production as well as improved visibility for managers. What used to take several sheets of paper has now been reduced to two taps on a touch screen.

Management now has increased visibility as data is fed back in real time. As well as being able to generate reports and have the flexibility of amending or modifying a product or a production line at any stage. This visibility also allows them to deliver improved customer service, helping them to keep many prestigious packing contracts.

Meeting food standards has never been a problem for Framptons but having Factory Services software makes the process a lot easier as traceability and accountability have been enhanced.

“We have seen cost savings through eliminating paper, reducing admin and labour time. Allsop has been a collaborative partner for us and any customisation or unique specifications we have required of Factory Services has been achieved to a high standard.”

 Declan Daly, Framptons Ltd.