The data from the materialManager and materialAssist can be accessed from Excel via the HOMAG Connect interface . This allows for easy evaluation of the data.
We have created various templates that can serve as a basis for an evaluation.
The handling is described on the page Evaluating data with Excel.
Slow sellers - records and leftovers
Excel Template: Candidates for Disposal (Plates).xltx
Over time, plates and leftovers accumulate in the warehouse that are no longer needed. From time to time, space has to be created again. The report helps to identify the slow sellers.
The report can be printed and the QR code can be scanned with the materialAssist boards to quickly find the plate or the rest in the warehouse.
Overview of stock levels. All plates are sorted by age and type. The QR code can be used directly in the materialAssist to dispose of the plate.
Slow sellers - edge tapes
Excel Template: Candidates for Disposal (Edge Tape).xltx
Like slabs and scraps, edges accumulate over time. The report helps to clean up.
Overview of stock levels. All edges are sorted by age and type. The QR code can be used directly in materialAssist to find the edge band.
Development of inventory in the warehouse
Power BI Template: Development Inventory (Disks).pbit
This report provides a comprehensive overview of the development of inventories over time, from which any need for action can be derived.
A continuous increase in remaining stocks may indicate that it makes sense to adjust the material-dependent parameters. If certain materials tie up a lot of capital, it may be advisable to rethink the purchasing strategy for these materials.
The report provides an overview of the evolution of stocks over time. A distinction is made between the number of panels, the total area in m² and the value in €.
Stock Remains by Length, Width and Value
Power BI Template: Leftovers (Size and Rating).pbit
This report provides an overview of the stock of leftovers, differentiating by number, size, and value. It helps to identify residues where the handling effort exceeds the value. If there are many small leftovers with a low value, it is advisable to adjust the material-dependent parameters .
Stock of remains by length, width and category
Parts History
Excel Template: Part history.xltx
In the part history, there is a complete record of which part was cut for which order and when with the help of productionAssist Cutting - including information on the time, workplace or sheet material used, right down to the ID of the plate used or the remainder.
This ensures efficient and complete traceability of your production steps.
History of the cut parts
History of the cut parts