Loading

References

Ploegsteert

Steenbakkerijen Ploegsteert improves production process with more reporting

Steenbakkerijen Ploegsteert has been through a whole series of changes since the company decided to maximise automation of its production reporting. These changes are currently mainly to do with the way data is collected and processed. The ultimate objectives are to improve the production process, understand the relationship between cost price and sale price better, complete the statutory reporting faster and reduce energy consumption.

Kris Maelbrancke, IT Manager: “We’ve already earned back the full cost of the project thanks to the time we’re saving on manual processing and reporting. Everything is much faster now and we avoid mistakes because manual interventions are no longer required. There’s a uniform method for data registration now too. The production, finance and sales departments all used to have their own reporting, which sometimes resulted in discrepancies in figures and could lead to worthless internal discussions, and so wasted time. We avoid all that now.”

150705bKris Maelbrancke, IT Manager: “No more discrepancies in our figures leads to less wasted time on worthless internal discussions.”

Emissions and traceability

Ploegsteert also has to provide an increasing number of reports about the production process for legal commitments such as emissions and product traceability. It used to operate using a flat-rate calculation for its CO2 emissions, but now detailed reports are required per product type to be able to submit emissions correctly. There are also more requirements for monitoring the quality and traceability of products in the framework of BENOR and CE standards. All this demands more reporting, so automating the reporting process is very beneficial.

Francis Deboever, Production Director: “The long-term aim is still to optimise production based on the real cost. The collection of this basic data now runs in a much more structured and validated way. Each item only appears once in our reporting, for example, so mistakes and misunderstandings are eliminated. We’re already modifying the process for some production units; we can match the actual output of precast concrete beams with the theoretical output, for example. We noticed from this that too much steel wire was being used, so now we’re monitoring this on a daily basis and can intervene as required.”

150705cFrancis Deboever, Production Director: “We want to optimise our production based on the real production cost.”

Production cost in detail

The production supervisors are the main users of the reports. It gives them a good overview of the consumption of packaging and raw materials for better costing, for example. Detailed reporting on energy consumption is a next big step. Peter Schotte, Financial Director: “Over 15% of our production cost is spent on gas and electricity, but we can’t yet allocate this per product. So we know we’re going to be able to save here, but first we need the real figures to see what’s possible and what we need to prioritise. It’s very important to determine our peak consumption precisely too, and estimate day and night consumption correctly. We want to schedule our production to avoid peak moments, which will make our cash planning easier. At the moment it’s not so easy to forecast our electricity procurement in our budget correctly because of the fluctuating peak consumption.”

The production supervisors are also responsible for the correct data entry, but an increasing amount of information is automatically being read in from the machines themselves via Siemens PLCs or software for time registration. Francis Deboever: “Manual counting and tracking, such as for example counting packed pallets per product type, is gradually becoming a thing of the past. It comes out of the packaging machines automatically now. Our IT department has also ensured it’s become easier to enter data manually, so mistakes are minimised there too.”

Choice between SAP and Microsoft

To set up this BI project, Ploegsteert called on the services of Kohera. Peter Schotte: “We work with SAP for our ERP and Microsoft for most other applications within the group. So we had to choose between the two for our BI system. Microsoft was the better option for a company our size, also because the amount of work required to implement Microsoft BI is relatively limited. Power Pivot and Microsoft Excel can also be used very flexibly. Most production supervisors are already familiar with Excel and this makes it much easier to work with our new reports, in particular because of its flexibility.”

Kris Maelbrancke: “We didn’t approach anyone but Kohera because we’d already had a couple of convincing conversations with some of their other customers. From our very first contact with Kohera we felt they would really understand our operation and problems, which is of course essential in a BI project. The cost of the project was realistic and the action plan very pragmatic, so the decision was actually made quite quickly. We were also able to defend the project quite easily internally because it was clear to everyone that it would offer us very concrete benefits and really add something to the organisation.”

150705dPeter Schotte, Financial Director: “Better reporting will make our cash planning easier.”

Standard reports for production figures

Kohera provided the data analysis and then set up a data model. When everyone could identify with the data carriers, products, categories, ingredients, averages, maximums, aggregates, etc. being used, Kohera drew up standard reports. Everyone can also create their own reports in Microsoft Excel based on the structured information in the company’s newly created data warehouse. Franky Leeuwerck, BI Consultant for Kohera: “Ploegsteert is looking at its processes in more detail than many other manufacturers. We help them convert their data into useful information so they can anticipate new developments and improve their operation.”

Ploegsteert now knows its production figures per product category – such as stones, lintels and floor systems – in quantities, weights and with use of packaging and raw materials. Another standard report shows the monthly stock levels, which can be used to explain big differences. More reports are being implemented for the deliveries of certain raw materials and energy consumption, including the surplus energy that Steenbakkerijen Ploegsteert puts back on the grid and sells. Laboratory data and quality control are additional reports that can be added later. Kris Maelbrancke: “Whenever we launch a new report, we’ve already validated first with figures from our existing sources, so we’re reducing the amount of manual reporting.”

Self maintenance after knowledge transfer

The intention is for Ploegsteert to manage the BI project and continue to expand it largely by itself. Kohera will provide training, coaching and consultancy on larger projects, and remains available via third line support. Kris Maelbrancke: “We’ll perform the smaller components, evolutions and modifications with our own IT staff. We’re not currently very familiar with the procedures and subtleties of BI, but Kohera is ensuring a good transfer of knowledge. This means we always have up-to-date reporting which we make optimal use of.”

News

21 Mar 2017
The endless possibilities of Power BI, that’s what makes us happy

We’ve already demonstrated once or twice that with Power BI, you can do much more than just make a simple analysis of your company data. To us, possibilities are truly endless, as long as you do some creative thinking. And today is no different.

14 Mar 2017
R Services: advanced analytics binnen SQL Server 2016

In een vorige blogpost kon je lezen wat R is, wanneer en waarvoor je R kunt gebruiken en hoe je ermee van start gaat. Vandaag vertellen we je hoe je met deze meest gebruikte open source programmeertaal een statistische analyse en een grafische presentatie van jouw gegevens maakt. Plus, waarom dat nuttig is.

07 Mar 2017
Securing the data tier of an Azure SQL Server Database – Part 2

One of the most prominent questions when working with PaaS databases is how to secure them. In the previous blodpost of these defence series, I talked about limiting access to objects through firewalls and encryption. Today I'll discuss protecting and auditing your data. Also, I’ll add some extra resources for a complete overview of the available security features on an Azure SQL Sever Database.

28 Feb 2017
Securing the data tier of an Azure SQL Sever Database – Part 1

One of the most prominent questions when working with PaaS databases is how to secure them. In these defence series, I will talk about limiting access to objects, protecting your data and auditing. Ok, let’s get started with the first layer. Enjoy!