Moving average

One of the two methods to calculate the overall vendor ratings is Moving Average.

If the method is Moving Average, in the Moving Average Periods field of the Vendor Rating Parameters (tdpur0100m800) session, you must specify the number of periods that are taken into account.

LN calculates the overall vendor rating for the specified number of periods for each business partner as follows:


New overall vendor rating = sum (PR * PV) / sum (PV)

PRThe period rating per business partner/period combination.
PVThe total value of the period.

LN retrieves the value type that is taken into account, from the Weighting Method field of the Vendor Rating Parameters (tdpur0100m800) session.

Example
  • The period rating that is calculated for the newest period is 85%.
  • The value for the newest period is 1000 pieces.
  • The number of Moving Average Periods is three.
  • The previous two period ratings were as follows:
Period ratingValue period 1
70%2000
-Value period 2
80%1500

 

New overall vendor rating:

(85 * 1000) + (70 * 2000) + (80 * 1500)) / (1000 + 2000 + 1500) = 77%

LN writes the result of this calculation to the Vendor Ratings by Period (tdpur8102m000) and Vendor Ratings by Criterion (tdpur8102m100) sessions.

Related topics