Skip to content
Industrial equipment detail

Case study / Beverage manufacturing

They already had SAP. The operation was still running on spreadsheets.

A beverage manufacturer in Angola runs its business on SAP. What it could not see was raw materials, sales, and goods on the road. So the planning team built their own answer in Google Sheets - and spent their week keeping it alive. We built the two systems that gave them the picture back.

21 September 20269 min readERP integrationAI & LLMMobile appLogistics visibility
Client
Beverage manufacturer, name withheld
Region
Angola
Core system
SAP ERP
YOTT's role
Consulting + engineering
Delivered
AI knowledge platform, driver mobile app
Scope
ERP-connected, built around existing processes
01The situation

A working ERP, and a blind spot next to it.

The manufacturer had a structured ERP environment built on SAP, with several other systems and data sources feeding the operation. Most of the information already existed, somewhere.

Forecasting was the problem. Nobody had a dependable view of raw materials coming in, sales going out, or goods sitting between the two. Planning happened without it.

So the team built their own tool: a lightweight forecasting and planning sheet in Google Sheets.

02The workaround

The spreadsheet worked. Then it became a job.

To be fair to the sheet, it did what it was meant to do. It filled a gap SAP was not filling, and it gave the planners something to work from.

It also asked for hours back every week: collecting figures from different systems, pasting them in, rechecking formulas and references after every change, and keeping planning data in step with everything else. The numbers still had to be read by hand before they meant anything.

The tool that was supposed to make planning easier had turned into a process of its own - one that needed attention whether or not anything had changed.

Before: keeping the plan aliveRecurring manual work
  1. 01Collect

    Figures pulled out of several systems by hand

  2. 02Update

    Numbers pasted into the planning sheet

  3. 03Maintain

    Formulas and references rechecked after every change

  4. 04Sync

    Planning data kept in step with the rest of the business

  5. 05Interpret

    Someone reads the result and works out what it means

  6. Then it starts again next week.

Illustrative of the maintenance load described, not a measured figure.
The underlying problem

The company did not need another dashboard. It needed operational data that stayed current, and a way for people to use it to decide something.

03Our approach

We left the ERP alone and built around it.

We came in as an operations technology consulting and systems engineering engagement, not a software pitch. The ERP was producing value. It was not producing answers.

So we asked a narrower question: where does operational data have to travel before a person can use it to make a decision today?

Two systems came out of that. An AI-powered operational knowledge and intelligence platform, and an AI-powered transportation and stock visibility platform. One works on understanding the data. The other follows the goods.

Connect, understand, automate, visualiseEngagement principle
  1. 01ConnectReach into the ERP and the systems beside it
  2. 02UnderstandTurn records into information people can question
  3. 03AutomateRemove the collecting, pasting, and rechecking
  4. 04VisualizeShow data and physical stock where decisions happen
System 01

AI operational knowledge platform

Connects ERP and subsystem data, so people can ask questions instead of assembling spreadsheets.

System 02

Transportation and stock visibility

Follows vehicles and the stock they carry, fed by an application on the drivers' phones.

04Solution 01

Operational data you can ask a question.

The first system connects to the company's ERP and other operational sources, and keeps a live knowledge layer across all of them. Nobody has to know which system holds which number before they can start.

They ask in plain language. The platform reads from the connected data, answers the question, and any answer can be saved as a dashboard the team reuses next week.

What teams can do now
  • Ask operational questions in natural language
  • Pull figures from ERP and subsystem data
  • Build a custom dashboard without a spreadsheet project
  • Investigate a number without preparing a report first
  • Combine sources that used to be reconciled by hand
From data to a dashboardIllustrative system view
  1. 01DataERP and operational sources
  2. 02AIKnowledge layer over connected data
  3. 03QuestionsAsked in plain language
  4. 04AnswersRetrieved from the connected data
  5. 05DashboardsSaved and reused by the team
From dashboards to questions

Conventional dashboards assume somebody already knows the question. This works the other way around: the question comes first, and the view is built from the answer.

05Solution 02

Stock does not stay in the warehouse.

The second gap was physical. Inventory was not only sitting on shelves. It was loaded on trucks, moving between sites and customers, and the operational picture stopped at the warehouse door.

A driver could be two hours down the road with a full load while planning still looked at yesterday's figures. That is not a reporting problem. It is a missing system.

So we built a transportation visibility application, with a mobile app installed on the drivers' devices. Drivers feed it from the road. The operations team sees the result on one map.

What operations can see
  • Where vehicles are
  • Which goods each vehicle is carrying
  • What stock is in transit right now
  • How goods move between locations
  • All of it plotted on a map
Warehouse stockProduction dataGoods in transitVehicle location

One view of inventory, movement included.

After: transport and stock, liveIllustrative interface
WAREHOUSEPLANT 02CUSTOMER AREAV1V2V3
Delivery stopsVehicle reporting in
Stock in transitUpdating
  • Vehicle 01Loading
    Beverage pallets
  • Vehicle 02In transit
    Mixed customer order
  • Vehicle 03Delivered
    Returns

Illustrative interface - not client data

Drivers update the system from their phones, so operations sees the same picture the driver does - without waiting for a phone call.
06How they fit together

One understands the data. The other understands the goods.

The knowledge platform tells the company what its systems know. The transportation app tells it where the physical stock is. On their own, each is half a picture.

Together they close the distance between what the records say and what is happening on the ground - and that distance is where most planning arguments come from.

Architecture of the delivered systemsERP kept in place
Existing environment
SAP ERPOperational subsystemsOther data sources
System 01Knowledge

AI knowledge layer

A continuously updated layer over ERP and subsystem data. People ask questions in plain language instead of assembling spreadsheets.

  • Operational questions
  • Custom dashboards
  • Ad-hoc investigation
System 02Movement

Transportation visibility

  1. 01Driver app in the cab

    Installed on the drivers' devices

  2. 02Transportation data

    Vehicle, load, movement

  3. 03Live map and stock visibility

    The operations view

Simplified view of the delivered systems. ERP integration is the common ground between them.

07 / What YOTT delivered

Two working systems on the company's own data.

Nothing here replaced SAP. Both systems sit around it, reading from it and feeding it where that made sense.

System 014 parts

AI-powered operational knowledge system

  • Integrating ERP and subsystem data into one knowledge layer
  • Answering operational questions through an LLM interface
  • Generating customised dashboards on demand
  • Reducing dependence on manually maintained spreadsheets
System 025 parts

AI-powered transportation system

  • Collecting information from drivers' mobile devices
  • Visualising transportation activity as it happens
  • Showing stock and goods in transit
  • Plotting vehicle and inventory movement on a map
  • Giving operations a wider view of physical logistics

No performance figures are quoted for this engagement. What is described is the workflow that changed.

08 / What changed

Less maintenance. More answer.

Planning and forecasting
Before

Exports from ERP, manual collection, spreadsheet updates, formulas rechecked by hand

After

Connected sources, questions asked in plain language, dashboards built from the answer

Goods in transit
Before

Visibility ended when the truck left the gate

After

A driver app feeding a live map of vehicles, cargo, and stock on the road

The change is in how the work is done, not a claimed percentage improvement.

09Why it matters

Most manufacturers are not short of data.

They are short of ways to make it accessible, current, connected, and worth acting on. That is the gap this project was really about.

An existing ERP environment can be extended with AI, custom software, and a mobile application to cover ground that standard enterprise systems leave open. Replacing the ERP is one option among several, and usually not the first one.

10YOTT's role

Consultant first. Engineer second.

Our role covered both sides of the line: understanding the operational problem, deciding where technology could genuinely help, defining the solution pattern, and then building the systems.

We did not start from a product we wanted to place. We started from three questions.

  1. 01How does the organisation forecast better and see the operation clearly?
  2. 02How do people work with operational data without maintaining spreadsheets?
  3. 03How does the company know where its stock is while it is moving?

The systems were designed around those answers.

Key takeaway
The objective was never to replace the ERP. It was to make the operational data and the physical movement around it visible enough to act on.
ERP integration + AI + custom software + mobile application + operational visualisation.

Similar problem?

Where does your operation lose the picture?

Tell us where planning stops, where data has to be collected by hand, or where stock disappears from view. That is usually enough to start.