...
Many cycle calculations in whiteboard will show the actual, expected and variance between these two calculations.
Cycle calculations in Analytics are designed for scheduled time analysis. If you want to analyze unscheduled time, contact your Customer Success Engineer to help customize your formulas to your situation.
Before listing the calculations, here is a description of a few of the variables used for the calculations:
Uptime - the amount of time the machine actually was up. 1
Scheduled - the amount of time the machine was expected to be up
Total - the amount of parts that were actually made
Expected - the amount of parts that were expected to be made
Cycles - the amount of cycles that actually occurred (does NOT include unscheduled).
Expected Cycles - the amount of cycles that were expected (includes unscheduled!) * 2
Cycle Time [seconds per cycle]
Actual Cycle Time = Uptime [seconds] / Cycles *
Expected Cycle Time = Scheduled [seconds] / Expected Cycles * 2
Cycle Time Gauge = Actual Cycle Time - Expected Cycle Time
...
Actual SPM = Cycles / Uptime [minutes]
Expected SPM = Expected Cycles * 2/ Scheduled [minutes]
SPM Gauge = Actual SPM - Expected SPM
...
| Info |
|---|
[Dim Jobs].[Job Max Run Rate] is a numerical value on a dimension (dim). The tool defaults a SUM(), but since its a dimension you will likely want to apply a MIN(). This field is replicated to [Fact Core].[Expected Production] for convenience. |
...
. |
1 Note: Uptime technical definition:
Scheduled Time; AND
(Classification = Uptime OR Classification = Slow Running)
Classification comes from the ReasonState.
2 Note: use a measure filter to remove unscheduled time from Expected and Actual Cycle fieldsfield:
Unscheduled Time - Understanding your Unscheduled Production metrics
Use “Measured Value” filters to remove Unscheduled time from [Expected Cycles] and [ Cycles] and [uptime] . "Measured Filters" - Creating Formulas Based on Criteria and Conditions