No Tags Found!


Akankshakhandelwal
1

Hi All,
I am Akanksha working in an IT Company in Indore. Can anyone help me with the MIS report format.
I am in urgent need of the format, else tell me what are the things which should be covered in a MIS report.
Thanks
Akanksha

From India, Bhopal
Amitmhrm
496

Hi Akansha...

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 very much helpful for you,,

Regards,

Amit Seth.

From India, Ahmadabad
M.Peer Mohamed Sardhar
733

Hi,,,
Please click the following link,,,
You will get lots of information..
#124202
#50348
#146348
#160545
#51380

From India, Coimbatore
Jagadeeshsd82
I also very useful for this MIS formats.. thanks i am m.com graduate in india.. I would like to thank you akansha & amit.. very good this is helping to develop my future
From India, Madras
Surbhi Gupta
11

Hi everyone.
I would like to add on to Amit.
Sheet 1
Department wise number of employees (staff in 1 column and workers in other).
Sheet 2
Level wise or designation wise number of employee.
Sheet 3
Ratios
1. Male employees Vs Female employees
2. Technical staff Vs Non technical staff
3. Staff Vs workers
4. Budgeted Vs Actual employees
Number of Engineers Vs Diploma Holders Vs CA Vs MBA Vs others etc.
Sheet 4
Number of emolyees joined in that month. Their names, Designation, Level, department, Date of joining, CTC
Sheet 5
Number of emolyees left in that month. Their names, Designation, Level, department, Date of joining, Date of leaving, CTC
Hope this will help you.
Regards,
Surbhi Gupta

From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.