Nowadays companies face markets and economic contingencies which change very rapidly and continuously. In order to take the right steps in such a dynamic environment, companies must master advanced control instruments: not only analytical accounts which calculate in real time profit margin for products, orders, divisions, etc. but also Business Intelligence, Advanced Statistics and Data Mining which allow the managerial and administrative staff to take the best decisions for the company.
BUDGET and BALANCE SHEET ANALYSIS
Comparison between Forecast budget data and final balance data (general accounting); budget reclassification, budget management for orders, cost centers or business areas, and following comparison with the final data highlighted in analytical accounts.
ANALYTICAL ACCOUNTS and COST ACCOUNTING
Detailed allocation of costs and revenues according to destination and pursuing 2 main goals: bookkeeping per order (which arises analytical budgets for areas, agents, items, etc., and profit margin is calculated) and bookkeeping per cost centre (out of which arise the costs for each division and the costs for each work are calculated – gross cost per hour of both staff and plants). Bookkeeping per business area (or division) budgets are generated per branch, production line, business areas etc. can be generated while “full-cost” analysis derives from sharing direct and indirect costs by means of customizable “analytical drivers”.
CALCULATION OF PROFIT MARGIN (orders)
Simplified and easy-to-understand functions help to calculate profit margin for each single order, invoice or customer.
Automatic allocation of costs and revenues for the various divisions and “business lines” also defined as “budget centre”. Each of them is associated with one or more “cost centres” and “revenue centres” such as branches, product lines, market areas, geographic areas, etc. All query functions have appropriate filters, the use of which allows to extract and work only on some specific elements: bills, invoices, book-keeping cards, bills of exchange, cash, payments, trial balance, etc. The same connections and functions are valid in the elaboration of analytical budgets and cost accounting.
Business Intelligence and Advanced Statistics
Information is automatically extracted and elaborated to monitor and lead the company; break-even-point, diagrams and graphics are generated and help the analysis and interpretation of this important information. Out of the results of these elaborations the managerial and administrative staff can take the best decisions for the various company’s areas.
The technology Analysis Services SQL2008 can be used in order to generate “measures” and “dimensions” on the CUBI OLAP (on-line analytical processing), performing a great analysis of relevant amounts of data. The analysis of objects with advanced and interactive functions allows to “schedule” and send the statistical analysis both to internal and external operators (agents, technicians, branches).