Nowadays for almost every manager who supervises more than 5 people the question of getting the actual information, proceeding it and sending it back to the employees is still actual.

What do the employees do? What resources are necessary for the result achievement? What are the detailed conclusions of the activities? Those and billions other question appear during the working process.

This article will be interesting for those companies who don't have "huge" information system. But not for those only. The problem is that every big system has so called "reacting period". Also the resources used for the improvement of big information system could be extremely wide and inadequate to the task given.

As an example say you want to give a trip to the sea as a bonus to your successful employees. Let's imagine that you already have informational systems CRM and ERP. However we have a very specific task and none of the modules of information system provides an opportunity to collect recommendations and motivational explanation for this bonus from all the managers.

So what are we supposed to do? Improve the system? But it is going to take about half an year and cost around 20 000 dollars. And it also might be useless in the future. Ask the managers to send the information over? Than it is going to be hard to proceed and analyze. So what should one do?

I offer you one of the approaches that can be considered relevantly universal. For solving the issues above you should answer 3 questions. 1. How to collect information from managers? 2. How to analyze the information? 3. How to inform managers about the decision made?

Collecting and consolidating the information. The most convenient easy and understandable way of information collection is spreadsheet. For further data analyses one should make a template with such columns that we are going to analyze. As an example let's make a table. * Column B - "Manager"- the manager who prepared the table. In this column we put the information about managers in. * Column C - "Employee" - contains the information on employees that are listed by manager for the trip. * Column D - "Department" - contains the information about the department where the employee listed works. * Column E - "Sales if Employees USD"- contains the information on how much sales did the employee accomplished * Column F - "Sum needed UDS" - contains the information on which sum of money is necessary for providing employee with the trip voucher. * Column G - "Sum approved USD" - contains the information on the sum approved. After completing the table one should send copies to all the managers in order to fill in the information. Managers have to fill in columns from B to F. After the columns are followed up managers are supposed to send it back. There could be hundreds of files. Before the information could be analyzed it should be consolidates (meaning combined into one data base). The most suitable software for this purpose is MergeExcel (http://www.merge-excel.com). In fact in order to combine all the MS Excel file into MergeExcel one should only fill in the import parameters ("explain" to the software which columns it is supposed to analyze) and press the Import button. Software will do all the rest.

Page 1 of 2 :: First | Last :: Prev | 1 2 | Next