Help Me In Preparing The MIS Reports

Bhupesh.m
Hi My name is Bhupesh
I have recently joined a recruiting company n my boss is asking me to submit MIS reports
Can anybody tell me how to prepare MIS reports? :unsure:
Amitmhrm
Hi Bhupesh,

As you require the MIS Excel sheet, it would be better if you prepare the

same at your end.Because it will help you to prepare other such formats too.

I am describing you the contents with sheet wise..

First Sheet-

Details of employee

a. E.Code b. Name of employee

c. Date of birth d. Designation e. CTC

f. Address for communication

g.Permanent address h. Contact number

i. Blood group j. Maximum qualification

k. Extra qualification l.Total Experience



Second Sheet-


Salary structure

In this sheet write down the complete salary structure.. and make a column what is salary after any revision

Third Sheet -

New Joinees

In this sheet write down the name of New joinees of that month with detail

like

CTC,

Designation,

DOB n etc.

Forth Sheet -

Resigned employees

In this sheet write the name of employees who resigned during

that particular month with details like name, designation, date of joining,

Date of resignation, last working day.

Fifth sheet -

Attrition rate

Hope now it will be helpful for you,,

Regards,

Amit Seth.
K.Ravi
there are many many many MIS reports,, first ask ur boss what type of MIS REPORT,, then mail me on [Login to view]
I can also mail u formats of MIS reports once u confirm the exact type of report u are looking for,,,,
THX
SATISH KUMAR DHANWAL
Dear Amit,
i appreciate the guidance you have given to Bhupesh. MIS in a recruiting company cannot be mroe than that. However, In the sixth sheet one more column may be added "Exit Interview". Because this would assist the orgn. to exercise adequate control over attrition. :idea:
regards,
Yours Truly,
satish kumar
ntpc foundation, noida
Amitmhrm
Dear Satish,
Thank you.. :D
Its a good point that you have raised but Exit Interview is different actions that can't be taken in MIS separately, that can be put in the sheet resigned employees.. Just add another column and write whether exit Interview done or not..???
I think it can be a better option to include Exit Interview.
Regards,
Amit Seth.
leolingham2000
BHUPESH,

Based on your brief, you are working for a recruitment company.

YOUR MIS REPORTS COULD INCLUDE

MONTHLY / YEAR TO DATE.

1. NO. OF PROSPECTIVE ACCOUNTS [ COMPANIES] CONTECTED.

2. TYPES OF ACCOUNTS [ INDUSTRY TYPES]

3. TYPES OF ACCOUNTS [ SIZE -EMPLOYEES SIZE.

4. CLASSIFICATION OF ACCOUNTS

*RED HOT CLASSIFICATION.[ 85-100]%

*AMBER CLASSICATION [ 70-85]%

*GREEN CLASSIFICATION [ BELOW 70 SUSPECT]

5.NO. OF ACCOUNTS SIGNED.

6.NO. OF PEOPLE INVOLVED

7. ESTIMATE OF BILLING.

8. BUDGETED BILLING FOR THE MONTH.

9. ACTUAL BILLING FOR THE MONTH.

10.FORECASTED ESTIMATE FOR NEXT 3 MONTHS

BUDGETED BILLING.

11.NO. OF PEOPLE INTERVIEWED –CURRENT MONTH

12. NO. OF PEOPLE TO BE INTERVIEWED -NEXT

3 MONTHS.

13. SIGNIFICANT PROBLEMS IN PROSPECTING.

13. SIGNIFICANT PROBLEMS IN RECRUITMENT

13. SIGNIFICANT PROBLEMS IN SELECTION.

14. AN ANALYSIS OF RECRUITMENT CHANNELS

IN THE CURRENT MONTH.

15. ESTIMATE OF THE PLACEMENT MARKET

IN THE NEXT 3 MONTHS.

16. SIGNIFICANT COMPLAINTS FROM ACCOUNTS.

17. ANALYSIS OF ACCOUNTS REJECTING YOUR OFFER.

18. ANALYISIS OF ACCOUNTS LOST.

19. MARKET TRENDS IN THE RECRUITMENT.

20. COMPETITION ANALYSIS.

21. NEW COMPETITORS IN THE RECRUITMENT FIELD.

22.NEW TOOLS NEEDED TO DEVELOP BUSINESS.

ETC ETC

regards

LEO LINGHAM
maheswara rao chaduvula
Hai,
I have gone through the detailed explanation given by Mr. Amith , I would like to add further,
1.How many employees joined in the particular month
2.Final settlements made for the employees during the month and how much amount has paid towards gratuity, leave encashment etc.
3.you have to calculate the rate of turnover in the company.
By
Mahesh.CH
Amitmhrm
Dear Mahesh,
Just go through my points regarding MIS preparation once again.. I am just clearing your question point wise
You will get the details to write regarding new employees in the 3rd Sheet..
Regarding rate of turnover it is already detailed to do in 5th Sheet with the heading Attrition rate..
Regarding Final settlements made during a month, you may add another column in the 4th Sheet, with a heading status on Full & Final settlement..
Otherwise in my view no need to mention other details like how much salary been paid for Full & Final settlement..
thats an another statement that you do prepare at the time of preparing Full & Final settlement, so no need to include that in the MIS..
By the way thanks for taking concern on these points.. :D
Regards,
Amit Seth.
bhaliz
Dear Amit,
Its really useful information you have provided for updation of employees for quick retrival of the inframtion. Sir, i feel there should be one more coloum because at the time of increment it will help to have glance over it as what was their Previous salary,Date of Joining, Present Desigination, increment date, Incremented salary Total CTC . Pls give your sugesstions .Thanks
Regards
Lizetta
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute