Direct labor template

Planning for direct labor employees is usually done on a weekly basis. Therefore, the direct labor template includes calculated FTE numbers with weekly planning frequency. Accounts that require manual input also use weekly values.

The template is divided into three categories. Each of these categories contains one or more subcategories:

  • Demand
    This category represents FTE numbers that are required to fulfill the forecast workload. These FTE numbers are calculated using the Direct Labor calculation method.
    Note: The Direct Labor calculation method is part of the demo content. If you remove the demo content, a user with Administrator role must define new calculation methods. Then, the Demand category displays calculation results from the third calculation method that is defined by the administrator.

    The Demand category is divided into three subcategories. Each subcategory represents a stage with different factors that might increase the final FTE numbers that are required to fulfill the workload.

    This table shows the structure of the Direct labor template. It includes the Demand category, its subcategories with their associated accounts, descriptions, and whether the account requires manual entry. All editable accounts require manual data entry by the planner or the approver. Additionally, the template lists the type of data for each account and, if applicable, the calculation method that is used.

    Subcategory Accounts Editable Description Category
    IE WFD_TOTAL_ALLOCATION-Calculation results after allocation No Represents calculated FTE numbers that are required to fulfill the forecast workload.

    Calculated results for the Direct Labor calculation method are displayed.

    		 DEMAND
    EXTRA_FTE_IE-Extra FTE Calculated By IE Yes Additional FTE numbers from industrial engineering.
    FTE_AFTER_EXTRA_IE-Additional FTE Demand From IE No
    FTE demand that is based on Workforce Planning calculations and additional FTE demand from industrial engineering.
    Calculation results after allocation + Extra FTE Calculated By IE
    OPS INEFFICIENCY_RATE-Expected Inefficiency Rate Yes The expected inefficiency rate as a percentage.
    FTE_WITH_INEFFICIENCY-Extra FTE Based On Inefficiency No The FTE demand that is based on Workforce Planning calculations and extra FTE demand from industrial engineering that takes into account the expected inefficiency.
    EXTRA_FTE_OPS-Extra FTE Calculated By OPS Yes Additional FTE numbers from industrial engineering.
    FTE_AFTER_ALL_OPS-Additional FTE Demand From OPS No The FTE demand that is based on Workforce Planning calculations and additional FTE demand from industrial engineering. This account considers inefficiency and the additional demand from operations.
    HR INOP_ABSENT_RATE-Inoperative And Absenteeism Rate Yes The inoperative time and absenteeism rate as a percentage.
    EXTRA_AFTER_INOP_ABSENT-Extra FTE Based on Inoperative And Absenteeism Rate No The additional FTE demand that takes into account inoperative time and absenteeism and additional FTE numbers from industrial engineering and operations.
    [Additional FTE Demand From IE + Additional FTE Demand From OPS] * Inoperative And Absenteeism Rate
    TOTAL_DEMAND-Total FTE Demand No Total FTE numbers that are required to fulfill the expected demand.
    [Additional FTE Demand From IE + Additional FTE Demand From OPS + Extra FTE Based on Inoperative And Absenteeism Rate]
  • Supply

    This category represents direct labor in the company and different factors that might increase or decrease its numbers in the coming weeks. It provides a comparison between the approved FTE plan for direct labor and actual direct labor numbers at the company.

    This table shows the structure of the Direct labor template. It includes the Supply category, its subcategories with their associated accounts, descriptions, and whether the account requires manual entry. All editable accounts require manual data entry by the planner or the approver.

    Category Subcategory Accounts Editable Description
    SUPPLY HR WFD_FTE-Actual FTE No Actual FTE numbers for the actual weekly version.
    PROJECTED_ACTUAL_FTE_DL-Projected Actual FTE DL No The projection of actual FTE numbers including attrition rates.
    [Projected Actual FTE DL (from Period_xxx-1)] * [(1-0,7 * Local Attrition Rate (from Period_xxx-1) - 0,3 * Foreign Attrition Rate (From Period_xxx-1)] Calculations start from the current period
    LOCAL_FTE-Local Actual FTE No The number of local employees who are expected to leave the company.
    0,7 * Projected Actual FTE DL
    LOCAL_ATTRITION_RATE-Local Attrition Rate Yes The attrition rate for local employees as a percentage.
    FOREIGN_FTE-Foreign Actual FTE No The number of foreign employees who are expected to leave the company.
    0,3 * Projected Actual FTE DL
    FOREIGN_ATTRITION_RATE-Foreign Attrition Rate Yes The attrition rate for foreign employees as a percentage.
    LOCAL_AND_FOREIGN_ATTRITION-Additional FTE Based On Local And Foreign Attrition No Additional FTE numbers that include the local and foreign attrition.
    [Local Actual FTE * Local Attrition Rate] + [Foreign Actual FTE * Foreign Attrition Rate]
    INVOLUNTARY_ACTUAL_ATTRITION-Involuntary Actual Attrition Yes FTE numbers that result from involuntary attrition.
    VOLUNTARY_ACTUAL_ATTRITION-Voluntary Actual Attrition Yes FTE numbers that result from voluntary attrition.
    TOTAL_ACTUAL_ATTRITION-Total Actual Attrition No FTE numbers that result from both voluntary and involuntary attrition.
    Involuntary Actual Attrition + Voluntary Actual Attrition
    ACTUAL_ATTRITION_RATE-Actual Attrition Rate No Actual attrition rate as a percentage.
    Total Actual Attrition / Projected Actual FTE DL
    ACTUAL_AFTER_ATTRITION-Actual FTE After Attrition No Available FTE numbers that include actual attrition.
    Projected Actual FTE DL - Total Actual Attrition
    DEMAND_PROJECTION_DIFF-Difference In FTE Demand And Projection No The difference between available FTE numbers after actual attrition is included and the total FTE numbers that are required to fulfill the expected demand.
    Actual FTE After Attrition - Total FTE Demand
    TOTAL_HIRING_PLAN-Additional FTE From Previous Hiring Plan No The total number of employees who are expected to be hired.
    [Additional FTE From Previous Hiring Plan (from Period_xxx-1)] + [Hiring Plan For Local FTE + Hiring Plan For Foreign FTE]
    LOCAL_HIRING-Hiring Plan For Local FTE Yes Employees to be hired locally.
    FOREIGN_HIRING-Hiring Plan For Foreign FTE Yes Employees to be hired abroad.
    FTE_WITH_HIRING-Available FTE With Included Hiring Plan No Available FTE numbers including attrition and new hires.
    Actual FTE After Attrition + Additional FTE From Previous Hiring Plan
    DEMAND_SUPPLY_GAP-FTE Difference Between Demand And Supply No The difference between the available FTE numbers including attrition and new hires and the total FTE number that is required to fulfill the expected demand.
    Available FTE With Included Hiring Plan - Total FTE Demand
  • MPS

    This table shows the structure of the Direct labor template. It includes the MPS category, its subcategories with their associated accounts, descriptions, and whether the account requires manual entry. All editable accounts require manual data entry by the planner or the approver. Additionally, the template lists the type of data for each account and, if applicable, the calculation method that is used.

    Category Subcategory Accounts Editable Description
    MPS MPS APPROVED_FTE_DL-Agreed FTE Plan DL Yes The approved FTE plan for direct labor.
    HIRING_IMPACT-FTE Impact On Hiring No The difference between the approved FTE plan and the actual hiring plan.
    Agreed FTE Plan DL - Available FTE With Included Hiring Plan
    FTE_GAP_DL-FTE Gap DL No

    The difference between the agreed FTE plan and the total FTE numbers that are required to fulfill the expected production demand.

    Agreed FTE Plan DL - Total FTE Demand