The KARASTO Armaturenfabrik Oehler GmbH and the registered trademark GEKA stand for quality, delivery reliability and engineering. KARASTO supplies specialised wholesale in the following segments: technical trade, gardening supply, ironware, sanitary accessories and building materials. Over the last years the development department was expanded (3D construction and rapid-prototyping). Besides the standard range of products KARASTO also offers customer-specific developments such as concepts for private labelling as well as different logistic concepts upon request. Due to the increasing complexity of the business, customer requirements and competition it was necessary to reorganise the sales and corporate planning and establish an integrated business planning.
The extremely complex product-oriented and customer-oriented sales planning, as well as the procurement planning are carried out by a BI tool. Afterwards the data are imported into the CoPlanner on a monthly basis. The structure of the profit and loss statement is imported from Microsoft NAV. Thus the CoPlanner can start the integrated and very detailed financial and liquidity planning. The yearly expense planning is continuously carried out with the CoPlanner Excel integration and automatically imported into the CoPlanner database. Thus the planning process presents itself integrated, flexible, easy and very fast. The CoPlanner management reporting and the integration into the BI tool support detailed analyses.
The possibility to plan using dimensions (people, products, place, time etc.) as a guideline allows very detailed project planning in the CoPlanner. For the cash flow planning all payment details are imported from Microsoft Dynamics NAV on the basis of payment dates of the accounts payable and accounts receivable and processed in the planning. Likewise all open orders from Microsoft Dynamics NAV are used as information for the cash flow calculation. Integrating the CoPlanner into the BI tool enables us to create complex and meaningful reports, which serve as a basis for future measures (budget overview of the individual departments).
The planning tool CoPlanner supports our strategic decision-making. All our requirements were met by the CoPlanner, such as our main requirement for an integrated business planning, but also the mapping of seasonal fluctuations in the sales affecting the purchase (Chinese New Year) and the liquidity.