Workset tab

An employee is designated as a Workset employee based on the employee record. A Workset employee can book multiple labor activities at the same time. The grouping of these labor activities is referred to as a Workset. The time spent on activities within a Workset are prorated based on the setting of the parameters on this tab. If labor and machine reporting are combined a separate parameter is provided to specify how machine time must be prorated.

Labor Proration

The method to divide labor between multiple jobs of a workset. Possible options:

Straight: Labor is divided evenly across all jobs. For example, if a workset has three jobs and is run for 120 minutes, 40 minutes of labor is allocated to each job.
Run Time: Time is allocated to jobs based on the run time. A job run time is either its run duration (hours/pieces) multiplied by its released quantity, the setup time is added to this number if the Include Setup in Runtime check box is selected, or its fixed schedule duration. To determine the percentage of the total time to allocate to each job on a workset, this equation is used: workset run duration X (job run time / total run time of all jobs on the workset). For example, a workset has three jobs: Job A, Job B, and Job C with runtimes of 60 minutes (Job A), 30 minutes (Job B), and 15 minutes (Job C). This workset is run for 120 minutes, so 69 minutes is allocated to Job A (120 min X (60 min/ 105 min)), 34 minutes is allocated to Job B (120 min X (30 min / 105 min)), and 17 minutes is allocated to Job C (120 min X (15 min / 105 min)).
Planned Quantity: Time is allocated to jobs based on the planned quantities. To determine the percentage of the total time to allocate to each job on a workset, this equation is used: workset run duration X (planned quantity of the job / total planned quantity of all jobs on the workset). For example, a workset has three jobs: Job A, Job B, and Job C with planned quantities of 100 pieces (Job A), 50 pieces (Job B), and 25 pieces (Job C). This workset is run for 120 minutes, so 69 minutes is allocated to Job A (120 min X (100 pieces / 175 pieces)), 34 minutes is allocated to Job B (120 min X (50 pieces / 175 pieces)), and 17 minutes is allocated to Job C (120 min X (25 pieces / 175 pieces)).

Machine Proration

The method to divide labor between machines used for multiple jobs on a workset: Machine proration is slightly different than Labor proration. Where labor proration applies the proration to each job in the workset, machine proration only prorates time on machines that have multiple jobs from the workset running on them. The examples below illustrate this point.

Note: If you specify a machine ratio for a machine, the ratio is applied after the proration method has been calculated. For example, if 60 minutes are allocated to a machine based on the proration method, and the machine has a machine ratio of .75, the final time allocation to the machine is 45 minutes.

Straight: Time is allocated to each machine that is used. If a single machine is used for more than one job on the workset, the time for that machine is allocated evenly among those jobs. For example, if a workset has three jobs, two that use Machine A and one that uses Machine B, and that workset is run for 120 minutes, 120 minutes (60 minutes for each job) is allocated to Machine A and 120 minutes are allocated to Machine B.
Run Time: Time is allocated to each machine that is used. If a single machine is used for more than one job on the workset, the time for that machine is based on the individual run times of those jobs. A job run time is either the run duration (hours/pieces) multiplied by the released quantity. The setup time is added to this number if the Include Setup in Runtime check box is selected, or if it is a fixed schedule duration. To determine the percentage of the total run duration of the workset that is allocated to a machine used for multiple jobs, the run time of each individual job is divided by the total run time of all jobs using that machine. For example, a workset has three jobs, two that use Machine A and one that uses Machine B. The two jobs that use Machine A have run times of 60 minutes and 30 minutes for a total of 90 minutes. The job that uses Machine B has a run time of 15 minutes. The workset is run for 120 minutes. 120 minutes are allocated to Machine A: 80 minutes for Job A (120 min X (60 min / 90 min)) and 40 minutes for Job B (120 min X (30 min / 90 min)). 120 minutes are allocated to Machine B (120 min X (15 min / 15 min)).
Planned Quantity: Time is allocated to each machine that is used. If a single machine is used for more than one job on the workset, the time for that machine is based upon the planned quantities of those jobs. To determine the percentage of the total run duration of the workset that is allocated to a machine used for multiple jobs, the planned quantity of each individual job is divided by the total planned quantity of all jobs using that machine. For example, a workset has three jobs, two that use Machine A and one that uses Machine B. The two jobs that use Machine A have planned quantities of 100 pieces and 50 pieces for a total of 150 pieces. The job that uses Machine B has a planned quantity of 25 pieces. The workset is run for 120 minutes. 120 minutes are allocated to Machine A: 80 minutes for Job A (120 min X (100 pieces / 150 pieces)) and 40 minutes for Job B (120 min X (50 pieces / 150 pieces)). 120 minutes are allocated to Machine B (120 min X (25 pieces / 25 pieces)).
Labor Dependent: Time is allocated to each machine based on the number of jobs on the workset and how many of them use that machine. Time is distributed evenly to each job on the workset and to the machines used for those jobs. For example, if a workset has three jobs, two that use Machine A and one that uses Machine B, and that workset is run for 120 minutes, 80 minutes (40 minutes for each job) are allocated to Machine A and 40 minutes are allocated to Machine B.
None: All machines are allocated full time. For example, if a workset has three jobs, two that use Machine A and one that uses Machine B. If the workset is run for 120 minutes, 120 minutes are allocated to each machine.

Include Setup in Runtime

If this check box is selected, you can include setup time when the run time is calculated for a job. This field is displayed only if the Labor Proration or the Machine Proration field is set to Run Time.