Jedox certified partner Naked Data talks to Ian McLain, Management Accountant, and Pieter van der Merwe, Solutions Architect, of De Bortoli Wines about how Jedox technology is helping the company streamline its budgeting processes.
De Bortoli is a third-generation family wine company with wineries in New South Wales and Victoria, Australia. Its range of world-class premium wines includes the acclaimed Noble brand.
Modelling budgeting processes in the food and beverage production industry can be complex. De Bortoli introduced Jedox technology to streamline its processes, with its internal team developing a Jedox plug-in for the Kettle data integration tool.
Naked Data: Has Jedox made your budgeting easier?
Ian McLain: Jedox Web has opened up a lot of new avenues. Our branches can now enter their data directly and we can see it as it is updated and understand where in the workflow the branches are. Then the branch managers can review their input. It has cut out a lot of to-ing and fro-ing: the whole process is streamlined.
Pieter van der Merwe: Jedox Web has made a big difference. We used to send Excel spreadsheets out to the branches and get them back filled in, and then have to import them and make adjustments. But now everyone gets access to Jedox Web, so it has made a huge difference to our data collection and has saved a lot of time.
ND: How has Jedox benefited your planning process?
IM: Our pricing model has really benefited. We’re so much more precise now. We’re budgeting and planning by litres and we have a price list and discount and rebate structures based on our customer groups. For budgeting, we used to take the budget from the year before and add on 3 percent. Now we can work in much more precise measurements and the results are more accurate. We can break down data to any level for variance analyses. Instead of trying to figure out whether or not we are under budget, we can see why we are or aren’t, and we can see whether the discounts are too high, or if the litres produced are too low, or if the cost of goods is too high.
PvdM: Finance used to come to us with a general idea of what they wanted and then there would be back and forth as we tried to get an idea of what this was. Now Finance comes to us with a model and says ‘build this’, and we can model it straight away in Jedox, linking to any operational data sources.
ND: Does this mean you can model business processes more easily with Jedox?
IM: Yes. It’s such a flexible format. For instance, at the moment we are building our own labour model. We used to budget labour the same way as all the other departments, which did not provide enough detail to allow for meaningful analysis. Now we can extract data straight from the payroll package, upload it into Jedox and budget right down to individual staff. It’s fantastic for building budget models on real-time issues.
ND: How quickly do you get insight with Jedox?
IM: Previously, we used to update journals in the general ledger and would have to wait overnight for everything to update. We couldn’t get real-time data. That changed with Jedox: we now get information on the go. When I’m in sales meetings, sales managers ask me if I can incorporate certain things into reports and plans, and I can do it on the spot.
ND: What’s next for De Bortoli and Jedox?
IM: The writeback is useful for more than just budgeting. We are using this feature to record monthly comments on variances. At the moment we’re doing monthly forecasting as part of the budgeting cycle, but our next priority is rolling forecasting with Jedox.