Visualizing ERP planning data and simulation data in Office products.
Supplement
EXCEL is used to prepare ERP data, visualize it in pivot charts and automate it for interactive analysis.
Subject description
The current machine and department utilization data is kept up-to-date in ERP. In preparation for a decision as to whether an additional order can be dispatched, planned utilizations are added to the actual utilizations. Visualization in MS EXCEL uses various displays to clarify the effects on rough capacity. Dynamic analysis using pivot charts makes it possible to investigate the raw data from various perspectives and document the decision visually.