Help Manual

Contents






Sigma Magic Help Version 18

Workload Balance

Overview

Workload Balance analysis can be used to compare the cycle time for each step in the process with the TAKT time. If the cycle time is greater than the TAKT time, then the process cannot meet customer needs.

To add this tool to your workbook, click on Lean and then select Workload Balance.

Inputs

Click on Analysis Setup to open the menu options for this tool.

Setup

A sample screenshot of the setup menu is shown below.
inputs
1
Analysis Type: Specify the tool format for this analysis. This selection is not enabled since there is only one format available.
2
Num Steps: Specify the number of steps in your process. This information is used to reformat your worksheet and create a table for data entry. Note that any data below this table will be cleared.
3
Completion Time: Enter the TAKT time. The TAKT time worksheet can be used to calculate the TAKT time. The TAKT time is the time available to complete all the process steps defined for this study.
4
Time Units: Enter the TAKT time units. Select the right units for this time that make sense for your process.
5
View Example: Click on this button to open the example file. You can view the example to get an idea of how to fill out this tool, or you can use the example as a starting point and modify it to meet your project needs.
6
Help Button: Click on this button to open the help file on this topic.
7
Cancel Button: Click on this button to exit without saving any changes.
8
Create Design: If this is your first time using this template, click this button to format the worksheet template. You can also update the worksheet format any time, but remember that you may lose any data entered on this worksheet. Once you are happy with the worksheet template layout, you must enter any required data on the worksheet. When the data entered into the worksheet is complete, you can click on Analysis Setup and then Compute Outputs to generate analysis results.
9
Analyze Design: Click on this button to save all changes and compute the outputs for this analysis. Review the results of your analysis and make changes to your inputs if required to update analysis results.
A sample screenshot of the worksheet is shown below.
inputs On the worksheet, enter the details of your process.
NumDescription
1Enter the person who is working on the process step
2Enter the step number of the process (for example, 10, 20, 30, etc.)
3Enter a description of the process
4Enter the cycle time for each step in the process for each product. Use the same units as the one used to specify the TAKT time

Charts

You will see the following dialog box if you click the Charts button. Charts
1
Title: The system will automatically pick a title for your chart. However, if you want to override that with your title, you can specify a title for your chart here. Note that this input is optional.
2
Sub Title: The system will automatically pick a subtitle for your chart. However, if you want to override that with your subtitle, specify a subtitle for your chart here. Note that this input is optional.
3
X Label: The system will automatically pick a label for the x-axis. However, if you would like to override that with your label for the x-axis, you can specify a different label here. Note that this input is optional.
4
Y Label: The system will automatically pick a label for the y-axis. However, if you would like to override that with your label for the y-axis, you can specify a different label here. Note that this input is optional.
5
X Axis: The system will automatically pick a scale for the x-axis. However, if you would like to override that with your values for the x-axis, you can specify them here. The format for this input is to determine the minimum, increment, and maximum values separated by a semi-colon. For example, if you specify 10;20, the minimum x-axis scale is set at 10, and the maximum x-axis scale is set at 20. If you specify 10;2;20, then, in addition to minimum and maximum values, the x-axis increment is set at 2. Note that this input is currently disabled, and you will not be able to change this setting.
6
Y Axis: The system will automatically pick a scale for the y-axis. However, if you would like to override that with your values for the y-axis, you can specify them here. The format for this input is to determine the minimum, increment, and maximum values separated by a semi-colon. For example, if you specify 10;20, the minimum y-axis scale is set at 10, and the maximum y-axis is set at 20. If you specify 10;2;20, then, in addition to minimum and maximum values, the y-axis increment is set at 2. Note that this input is optional.
7
Horizontal Lines: If you want to add a few extra horizontal reference lines on top of your chart, you can specify the values here. The format for this input is numeric values separated by semi-colon. For example, if you specify 12;15, two horizontal lines are plotted at Y = 12 and Y = 15, respectively. Note that this input is optional.
8
Vertical Lines: You can specify the values here if you want to add a few extra vertical reference lines on top of your chart. The format for this input is numeric values separated by semi-colon. For example, if you specify 2;5, two vertical lines are plotted at X = 2 and X = 5, respectively. Note that this input is optional.

Verify

If you click the Verify button, the software will perform some checks on the data you entered. A sample screenshot of the dialog box is shown in the figure below. Verify The software checks if you have correctly specified the input options and entered the required data on the worksheet. The results of the analysis checks are listed on the right. If the checks are passed, they are shown as green-colored checkmarks. If the verification checks fail, they are shown as a red-colored cross. If the verification checks result in a warning, they are shown in the orange exclamation mark, and finally, any checks that are required to be performed by the user are shown as blue info icons.
1
Item: The left-hand side shows the major tabs and the items checked within each section
2
Status: The right-hand side shows the status of the checks.
3
Overall Status: The overall status of all the checks for the given analysis is shown here. The overall status check shows a green thumps-up sign if everything is okay and a red thumps-down sign if any checks have not passed. Note that you cannot proceed with generating analysis results for some analyses if the overall status is not okay.

Outputs

Click on Compute Outputs to update the output calculations. A sample screenshot of the worksheet is shown below. outputs You can look at the chart to determine whether your cycle time for each step in the process is greater than or less than the TAKT time. If the cycle time for any step is greater than the TAKT time, then you may need to try to reduce this time to meet the TAKT time. The algorithm also checks if each cycle time is within +/- 10% of each other. If they are, the process is termed "Balanced"; otherwise, it is termed "Unbalanced." If the analysis is completed successfully, the following message box is displayed: outputs 2

Notes

Here are a few notes regarding this analysis:
  • Currently, the workload balance is only done by the person.
  • Workload balance calculations are based on +/- 10% variation. If the variation is larger than the output, it will indicate that it is not balanced.

Examples

The following examples are in the software's Examples folder.
  • Create a workload balance chart for the data given in the reference file (Workload Balance 1.xlsx)



© Rapid Sigma Solutions LLP. All rights reserved.