
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.
- 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
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.
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.
01Collect
Figures pulled out of several systems by hand
02Update
Numbers pasted into the planning sheet
03Maintain
Formulas and references rechecked after every change
04Sync
Planning data kept in step with the rest of the business
05Interpret
Someone reads the result and works out what it means
Then it starts again next week.
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.
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.
- 01ConnectReach into the ERP and the systems beside it
- 02UnderstandTurn records into information people can question
- 03AutomateRemove the collecting, pasting, and rechecking
- 04VisualizeShow data and physical stock where decisions happen
AI operational knowledge platform
Connects ERP and subsystem data, so people can ask questions instead of assembling spreadsheets.
Transportation and stock visibility
Follows vehicles and the stock they carry, fed by an application on the drivers' phones.
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.
- 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
- 01DataERP and operational sources
- 02AIKnowledge layer over connected data
- 03QuestionsAsked in plain language
- 04AnswersRetrieved from the connected data
- 05DashboardsSaved and reused by the team
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.
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.
- 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
One view of inventory, movement included.
- Vehicle 01LoadingBeverage pallets
- Vehicle 02In transitMixed customer order
- Vehicle 03DeliveredReturns
Illustrative interface - not client data
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.
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
Transportation visibility
01Driver app in the cab
Installed on the drivers' devices
02Transportation data
Vehicle, load, movement
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.
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
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.
Exports from ERP, manual collection, spreadsheet updates, formulas rechecked by hand
Connected sources, questions asked in plain language, dashboards built from the answer
Visibility ended when the truck left the gate
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.
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.
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.
- 01How does the organisation forecast better and see the operation clearly?
- 02How do people work with operational data without maintaining spreadsheets?
- 03How does the company know where its stock is while it is moving?
The systems were designed around those answers.
“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.”