Workforce Analysis Template 

Member of Basic Production Templates Pack

Version: 1.00

Benefits:

Workforce Analysis Template provide Manpower Status Report including Organization Structure - Department and Section, Position and Position Level, Age and Service Year information.

How to Use:

This Excel template has 7 worksheets:
consist of 4 master data, 1 workforce database, and 2 reports.

Worksheet#1 [1 - Department]
Step 1 - Input Department Name

Worksheet#2 [2 - Section]
Step 2 - Input Section and link to its Department Name

Workwheet#3 [3 - Position Level]
Step 3 - Input Position Level

Worksheet#4 [4 - Position]
Step 4- Input Position and link to its Position Level

Worksheet#5 [5 - Workforce Database]
Step 5 - Input Workforce Database ( Employee No, Employee Name, Date of Birth, Hiring Data, Position, Section )

Worksheet#6 [6 - Manpower Report]
Step 6 - View/Print Manpower Report

Worksheet#7 [7 - Service Year Report]
Step 7 - View/Print Service Year Report

Tip: Reports are created using pivot table, you can drill down or hide detail by press '+' or '-' locate on the left of column. 

Return from Workforce Analysis Template to Basic Production Templates Pack