Raw material cost

  • How will changes of raw material and labor costs influence the production costs?
  • Will such changes influence the product price?

Raw material purchase involves the need to continuously monitor prices offered by various suppliers. Logistics or Production Manger estimates the impact of the change in key material or labor cost by creating simulations on the basis of production cost calculations as well as technological, inventory and payroll data. It enables an ongoing control of production costs in relation to the sale prices, and an ongoing profitability check.

Inventory levels

  • How production plan changes influence the material demand?
  • What inventory levels allow maintaining continuous production, while keeping costs at a minimum?
  • When additional supplies will be required? What quantities will be needed?

When planning purchases, Logistics Manager uses information from various sources, e.g., current inventory levels, sales orders, technological documentation, plans and current production as well as supply orders that were already submitted. With this data, Xpertis safeguards company's business against any downtimes caused by material shortages. On the other hand, warehousing costs and means indented for material purchase may be reduced after safe inventory levels are defined.

Raw material consumption

  • How is raw material and intermediate product consumption controlled?
  • Are high costs of production materials justified?

The quantities of materials issued by the Warehouse Manager are either based on actual demand or approved by an authorized person. This way, unjustified issues are avoided, and the employees are aware that each additional quantity must be reported. Moreover, when closing orders, Production Manager may demand explanations on unusual material consumption indicated by comparing consumed quantities with company standards.

Customer service

  • Are customer orders completed timely and accurately?
  • How to achieve customer satisfaction and loyalty?
  • What terms of business may be offered to the existing customers?

Starting from the very first contact with the customer, Macrologic’s solution provides an effective support for sales management. Sales and customer relation management does not stop when the customer is won. Because of this, integration with the basic ERP functionalities based on other Xpertis components is very important. To achieve such integration in sales module, quotation, reservation and order completion processes are automatically connected with ERP system register and data. In Xpertis, sales and aftersale service were brought together, and further enhanced with electronic document circulation – this reduces the risk of mistakes and speeds up the order completion process. Traders or customers register orders (via the Internet) and the ordered goods are automatically reserved. Issue orders are created on the basis of these reservations and then sent to warehouse managers, who confirm that the goods are ready to be issued. Sales department draws up a shipping document which serves as a basis for the issue. Such procedure, together with the elimination of manual work, allows the distributors to save resources for claim processing. With such feedback, the traders receive information on payable invoices, while history of relations with a given customer serves as a basis for offering adequate terms of business.

Sales analysis

  • What are the sales of specific products in specific regions and periods?
  • Which customers generate the most income?
  • What product categories do they buy?
  • What are the least/most profitable products?

Today, companies store huge amounts of data in their IT systems but lack the knowledge on how to use them. Thus, companies need IT tools for searching the needed data (which is usually spread throughout the entire enterprise or its departments), processing it and supplying critical information in time to facilitate the decision-making process. Xpertis OLAP (On-Line Analytical Processing) multidimensional analyses are the answer to this need. Multidimensional data analysis is performed intuitively. For example, while querying for product or product group sales, one is not only interested in the overall amount of sales, but also in the sales split by customers and time periods. Since data in OLAP cube is saved hierarchically, it can be analyzed at various detail levels – from aggregated data (e.g., sales for a given month) to the extremely detailed information on individual transactions (e.g., sale of a given product to a given customer in a given month). These are the drill-down and drill-up operations, which were described before.

OLAP analysis provides an answer to “who?”, “what?”, “when?”, “how?”, and “why?” questions, and enables a comprehensive scenario analysis (“what if?”). It also allows for forecasting future trends on the basis of historical data.