In Whiteboard cycles represent the time it takes for a machine/line to produce one unit of a product. For example, if a machine is bottling some soda, how long does it take for the machine to produce one bottle. Cycles is not the same as the number of parts that were made. In a given cycle, a machine could make eight parts but it only took one cycle. Cycle calculations come in many forms, each representing a variation in the cycle calculations.
Many cycle calculations in whiteboard will show the actual, expected and variance between these two calculations.
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
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
Expected Cycles - the amount of cycles that were expected
Cycle Time [seconds per cycle]
Actual Cycle Time = Uptime [seconds] / Cycles *
Expected Cycle Time = Scheduled [seconds] / Expected Cycles *
Cycle Time Gauge = Actual Cycle Time - Expected Cycle Time
Strikes Per Hour (SPH) [cycles per hour]
Actual SPH = Cycles / Uptime [hours]
Expected SPH = Expected Cycles / Scheduled [hours]
SPH Gauge = Actual SPH - Expected SPH
Strikes Per Minute (SPM) [cycles per minute]
Actual SPM = Cycles / Uptime [minutes]
Expected SPM = Expected Cycles / Scheduled [minutes]
SPM Gauge = Actual SPM - Expected SPM
Part Cycle Time (PCT) [seconds per part]
Actual PCT = Uptime [seconds] / Total
Expected PCT = Scheduled [seconds ] / Expected
PCT Gauge = Actual PCT - Expected PCT
Parts Per Hour (PPH) [parts per hour]
Actual PPH = Total / Uptime [hours]
Expected PPH = Expected / Scheduled [hours]
PPH Gauge = Actual PPH - Expected PPH
Parts Per Minute (PPM) [parts per minute]
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 blended formulas.
Blended Rate = [Fact Core].[Expected Production] / [Fact Core].[Scheduled Hours]
Blended Cycle Factor = [Fact Core].[Expected Production] / [Fact Core].[Expected Cycles] *
[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.
* Note: use a measure filter to remove unscheduled time from Expected and Actual Cycle fields:
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