Throughout the production process all materials used and produced are traced by serial numbers. Especially, but not only, medical products require the full tracability from the raw material acquired from a vendor till the finished product. The standard ERP reporting is not adequate enhough to have a speedy and thorough overview of required data. Data extracted from the ERP combined with an in house developed project for quality rejections & follow up (internal, customer & vendor related), is presented in a dashboarding way combined with a detailed view for several datasets.​​

Working Hours: Hyper Analyzer delivers daily an overview of multiple past months detailed activity on the workfloor. Hours performed on workorders as well as quantities produced are stored in the dataset. The dataset is extended with the HR performed hours per employee. Extensive reports are put in place and can be altered by the production staff to measure performance, efficiency and rentability.

Scrap & material losses reporting: To have a clear follow up on scrap and losses figures, a dataset is created that holds not only the performed production consisting of material use and parts produced, but also the theoretic consumption allowed according to the amount produced. This dataset can be used to pin point the moments where components are wasted and allow tackling the issues. This dataset also is linked to the P&L figures where accounting variances on material loss can be compared with actual production figures.​​

The figures generated in the ERP system that were previously cumulated and exported to be uploaded in the accounting system can now be analysed in detail. A dataset was build to include all detail general ledger transactions. For instance P&L material losses can now be traced back to the most detailed information.​​

Based on the current stock in the ERP system and MRP calculations a Hyper Analyser dataset is build which gives the possibility of analysing future stock situations on any date required. Not only that, analysis can also be done on the reason of the demand on any leve, for instance the reason of a purchase requirement can be broken down into it's source, i.e. sales orders, forecast and many others.​​

Daily planning: On the basis of the MRP ERP Workorder information and detailed planning made in the HR system, datasets are made for analysis of workload and machine/personell availability. A link between data stored in database from different vendors is made with Hyper Analyzer on a daily schedule.

Long term planning: Future demands resulting from forecast and open salesorder are combined with bill of material data stored in the ERP system. As a result, the planning department has a detailed overview of future machinal and human resources needed.

Based on the data available in the MFG-PRO ERP system and combined with data provided by the sales staff, supply chain team and financial department, several datasets are created to have in detail past and future predicted sales figures analysis. Combined data are "open sales orders" and "invoices" extracted from the ERP system, "forecast figures" entered by the salespersons in dynamically created Excel files, "statistical forecast figures" generated by the logistics team and the plan figures made available by the financial department. The project complexity came from the combination of requirements based on the specific work of sales person with off line connectivity and the on site data maintenance of the ERP system.

Every business has its own way to evaluate. But in financial terms a number of indicators are standard. By collecting all financial transactions we create a perfect analysis environment for financial professional who can customize further the results for any type of business.
Hyper Analyzer is able to collect several years financial transactions and make high accuracy financial estimations.
Several highlights of this analysis are: turnover, sold production, revenue from merchandise sales, production assets, operating revenues, expenses and supplies raw materials, water and energy expenditures, personnel costs, salaries expenses, expenditure insurance and social protection, expenditure vouchers, operating expenses, work expenses from third parties, expenditure taxes, financial income, financial expenses, total income, total expenses, operative result, financial result, gross margin, net earnings. They are the result of simple formulas based on the accounts number and transaction type.
More refined analysis can be made, based on the type of business: interest coverage, self-financing capacity, market capitalization, net working capital, permanent capital, cash flow management and any other indicator available considered useful to financial analysts for a particular type of business.
If for transactions analysis, was facile to generate a demo data set, for financial analysis the situation is different, for many information about documents we cannot generate arbitrary data.

 

The daily situation resulting from the salesreporting is prepared by Hyper Analyzer to upload to the SalesForce CRM. The Hyper Analyzer scripting facilities helped to automate ETL process without having to use any other ETL tool.​​

A major interes of managers and financials analysts are sales analysis. LogBis extended the sales analysis with purchasing analysis and inventory analysis in a very atractive dataset. Several advanced graphical representations and what if analysis are included.



Several highlights of this analysis are:
Large amount of data: 3 years full type of transactions in a company with a large amount of transactions.
Ready to run analysis with latest tendency in graphical representation.
High level mathematical/statistical prognosis
What-if analysis example with prices variation.

Download the large demo dataset (30MB) and see what Hyper Analyzer is able to do. This data set contains 3 years of data from a WinMentor database. WinMentor is one of the most know romanian ERP systems (http://www.winmentor.ro/main_ro.php).