...
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 SPH = Cycles / Uptime [hours]
Expected SPH = Expected Cycles * / Scheduled [hours]
SPH Gauge = Actual SPH - Expected SPH
...
Actual SPM = Cycles / Uptime [minutes]
Expected SPM = Expected Cycles 2/ Scheduled [minutes]
SPM Gauge = Actual SPM - Expected SPM
...
Actual PPM = Total / Uptime [minutes]
Expected PPM = Expected / Scheduled [minutes]
PPM Gauge = Actual PPM - Expected PPM
Blending different Job Rates and Cycle Factors
[Fact Core].[Expected Production] is the Job rate. (see https://slxdev.atlassian.net/wiki/pages/resumedraft.action?draftId=743112705)
In a situation where cycle factor or job rate is changing (over longer reporting periods) or needs to be represented in the aggregate, consider using the out-of-the-box formula:
Job Cycle Factor = [Fact Core].[Expected Production] / [Fact Core].[Expected Cycles] *
| 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 Cycle field:
Unscheduled Time - Understanding your Unscheduled Production metrics
Use “Measured Value” filters to remove Unscheduled time from [Expected Cycles] "Measured Filters" - Creating Formulas Based on Criteria and Conditions