CASE STUDY -
Behrakis Group
Modernising an outdated inventory system for a leading wholesaler
PLATFORM
BUSINESS APPLICATION
INDUSTRY
WHOLESALE & DISTRIBUTION
The Challenge
The Behrakis Group, based in Tasmania, specialise in food distribution and wholesale. They operate several businesses including a chain of supermarkets and other food stores.
For the greater part of the last decade, Behrakis were using an inventory system that had become increasingly complex. Unfortunately, the use of their existing system fragmented the data on six of their businesses – meaning when they wanted to get a snapshot of performance, they needed to look in six different databases.
This became very time-intensive, with Behrakis needing to download different information from different places, input it into a spreadsheet then manually centralise the data. These heavy manual processes can open the company up to risk through human error.
Behrakis needed to modernise their legacy software.
The Solution
Kiandra realised Behrakis’ interaction with the decentralised databases needed to be centralised to cut down the risk of human error and make their processes simpler.
The first step was to create a modern user experience for their inventory system. This meant building a centralised application, so Behrakis only need to go to one place rather than six.
Using Microsoft Power Platform, Kiandra re-built the pricing adjustment system by creating a Power App that uses a data gateway to connect to the multiple SQL Server on-premises databases which allow them to adjust the pricing from one location.
Kiandra also made the interface of the price adjustment simpler, instead of Behrakis entering several fields to calculate pricing – this is now a single-entry field with automated calculations. This has removed manual user error and risk from the business.
The Outcome
The new application has also greatly improved Behrakis’ sales reporting. This process previously took up to half a day, now takes a click of a button with their new stock item pricing and reporting application.
On the successful implementation of the new inventory system, Kiandra is now working with Behrakis on a payroll reporting application, which will be a similar feat in centralising six different databases to improve internal processes.
.svg)
.svg)
.svg)
Let’s discuss your next project
Whether you’re curious about custom software or have a specific problem to solve – we’re here to answer your questions. Fill in the following form, and we’ll be in touch soon.
.svg)
