Moving average

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

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

LN calculates the overall vendor rating for the defined 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 set to 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 the Vendor Ratings by Criterion (tdpur8102m100) sessions.

Related topics