Ansicht
Dokumentation

/SAPAPO/PPDS_RES_UTIL_PER_CALC - Utilization calculation based on moving average

Vendor Master (General Section)   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Functionality

For implementing the moving average formulae in utilization percentage calculation, this function module gives utilization percentage for a given day for based on a given moving average.

Utilization percentage calculation:

The basic formula used for utilization percentage calculation is:

Utilization (in %) = (Capacity used / Capacity supplied) x 100.

You can maintain a moving average period (in days) in the capacity utilization profile settings. Based on this value, the utilization percentage is calculated.

When the moving average is not maintained or moving average number is ‘1’. Then the formula mentioned above for utilization is used.

Moving Average Concept

A moving average (rolling average or running average) is a calculation that helps you analyze data points by creating series of averages of different subsets of the full data set. It is also called a moving mean (MM) or rolling mean.

Given a series of numbers and a fixed subset size, the first element of the moving average is obtained by taking the average of the initial fixed subset of the number series. Then the subset is modified by "shifting forward"; that is, excluding the first number of the series and including the next value in the subset.

A moving average is commonly used with time series data to smooth out short-term fluctuations and highlight longer-term trends or cycles. The threshold between short-term and long-term depends on the application, and the parameters of the moving average will be set accordingly.

For several applications, it is advantageous to avoid the shifting induced by using only 'past' data. Hence a central moving average can be computed, using data equally spaced on either side of the point in the series where the mean is calculated.

For the Monitor Capacity Utilization app, the moving average is used for levelling capacity load analytics. "Moving average" for capacity loads with building averages over a period of specified days

Example

Suppose that there are n days denoted by d1, d2, d3, …, dnand the corresponding values of the standard utilization percentages per day variable are U1, U2, U3, …, Un. First, we decide the period of the moving averages. For a short time series, we use a period of 3 or 4 values, and for a long time series the period may be 7, 10 or more. Suppose the given time series is in days and we have decided to calculate 3 or 4 day moving averages. The moving averages are calculated as follows:

Moving Average for Odd period (example 3 days).

For moving average period 3, the moving average is the average of utilizations of current day, one day in past and one day in future.

General Formulae:

Moving average on 2nd day is calculated as (U1+U2+U3)/3

Moving average on 3rd day is calculated as (U2+U3+U4)/3

Boundaries handling:

As the data of previous day of D1is not available, the current day utilization is considered twice to balance between the weights on past and future.

Moving average on first day is calculated as (2 X U1 + U2)/3

Moving average for even period (example 4 days).

As for moving average period with even number has no midpoint. The calculation is different from odd number period.

General Formulae:

Moving average on 3rd day is calculated as follows: (U1+2*U2+2*U3+2*U4+U5)/8

Boundaries handling:

As the data of previous days are not available, the current day utilization is weighted more to balance between the weights on past and future.

The moving average of 1st day D1 is calculated as (5*U1+2*U2+U1)/8

The moving average of 2nd day D2 is calculated as (2*U1+3*U2+2*U3+U4)/8.

Notes

Further information

Parameters

EV_UTIL_PER
IT_CAPA_ENTRY
IV_MANF_ORDERS
IV_MVG_AVG
IV_TABIX

Exceptions

Function Group

APO/SAPLPPDS_RES_MONITOR

Addresses (Business Address Services)   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 5229 Date: 20240510 Time: 224600     sap01-206 ( 79 ms )