Labor Efficiency and Allocation Planner (LEAP)

The LEAP report is an interactive tool that allows production supervisors manage the staffing in their departments to balance the workload and meet established production goals.

Information for this report is automatically downloaded from the Kronos database indicating where people are punched in. All cells in white are filled in automatically. Cells in green are used for supervisor override.

Each department has its own tab in the spreadsheet, and there is a summary page and a page that shows where employees are punched in.

Shift is automatically calculated automatically. We have three shifts. Shift 1 starts at 4 AM and runs to 2:30 PM, four days a week. Shift 2 starts at 4 PM and runs to 2:30 AM the following morning, 4 days a week. Shift 3 starts at 5 AM and ends at 6 PM, three days a week. The shift is calculated by counting the number of hours into the week the system clock is registering, or it can be overridden by the supervisor.

Hours remaining into the shift is calculated by determining what shift is currently on staff, the current time and the remaining lunch breaks (one 30-minute break for 1st and 2nd shift and two 30-minute breaks for 3rd shift).

Job ID is a shortcut name for the labor code.

Direct Labor is an indication of whether the labor code constitutes direct or indirect labor.

Punched in is the number of people who have the indicated labor code as a home labor code that are currently punched in.

Transferred Out is the number of people who have the indicated labor code as a home labor code that are punched into a labor code other than their home code (labored away from the home code).

Transferred In is the number of people who do not have the indicated labor code as a home labor code that are punched into the labor code.

Total in Code is the total number of people currently punched into the labor code.

Override is a cell that the supervisor can use to put in an override total of people punched in. If the cell is empty, the calculations use the number Kronos supplies, otherwise the calculations are based on the supervisor-supplied number. This allows the supervisor to play "what if" with the staffing balance.

Standard is the number of units per hour that an associate should produce for this labor code. This information is read from a user maintainable table.

Produced is another override cell. The contents of this cell determine how the Forecast Production is calculated.

Forecast Production

• If the Produced cell is empty, the forecast production is calculated by the total number of people in code (either overridden or system supplied) times the total number of hours in the shift times the standard times the efficiency for the labor code.
• If the Produce cell has a value, the forecast production is calculated by doing the same computations as above except using hours remaining on the shift instead of total number of hours on shift. The forecast based on remaining hours is added to the number of items already produced to get the new Forecast Production.

Variance: Where one set of labor code productivity depends on the output of another set of labor codes, the variance shows the difference between the output of the upstream set of labor codes and the ability of the current labor code to process this output. In the example, ASN Verification can process 22 units more than Returns Processing Primary can produce.

Restaff: Where dependencies exist, the restaff is a recommendation of how much staff to add or reduce to balance the workload. In the example, Tunnel Sorting can process 1,726 more units than ASN Verification can feed it. These people will run out of work. Given the standard labor rates for Tunnel Sorting, the supervisor should reduce the staffing for this labor code by one person.

Max HC stands for maximum headcount. Management has recommendations for the maximum people who should be punched into specified labor codes. These values vary by shift. Where specified, the report shows the Max HC. If the number of people punched into the labor code exceeds this value and asterisk is also displayed.

Efficiency: Management designated a target efficiency (number of items actually produced / number of items that should have been produced) for direct labor codes. This information is maintained in a user-defined table.

Earned is the number of full time equivalents earned based on headcount and efficiency. This is a theoretical value that assumes that people are working to their targeted efficiency. Earned headcount for indirect labor is zero.

Summary Data shows the total number of people punched into direct labor code and the total number of people punched into indirect labor codes. The percentage is direct labor / total labor. This percentage would be the overall departmental efficiency if everyone worked at 100% efficiency given the direct / indirect labor ratio.

Efficiencies show the total number of people in code and the total earned FTEs. The overall departmental Efficiency is Earned FTE / Total FTE. This is a predictive value to help the supervisor balance the direct / indirect ratio.