Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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]

  1. Actual Cycle Time = Uptime [seconds] / Cycles *

  2. Expected Cycle Time = Scheduled [seconds] / Expected Cycles * 2

  3. Cycle Time Gauge = Actual Cycle Time - Expected Cycle Time

...

  1. Actual SPH = Cycles / Uptime [hours]

  2. Expected SPH = Expected Cycles * / Scheduled [hours]

  3. SPH Gauge = Actual SPH - Expected SPH

...

  1. Actual SPM = Cycles / Uptime [minutes]

  2. Expected SPM = Expected Cycles 2/ Scheduled [minutes]

  3. 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:

  1. Scheduled Time; AND

  2. (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: