End of Day - Process 3 Month Rolling Average for Peer Group Pricing

Contents Show

Business Rules:

EOD_3MONTHROLLINGAVG

EOD_3MONTH_ROLLING_AVG_NBR_STD_DEVIATIONS

EOD_3MONTH_ROLLING_AVG_VARIANCE_METHOD

The End of Day process can automatically recalculate the peer group average and maximum prices every 2 weeks based upon actual redemption to obtain a 3-month (12 week) rolling average for the peer group food instrument type or food item.

This business rule allows SPIRIT to indicate that the End of Day Process should automatically recalculate the peer group average and maximum prices as described above.

Values Allowed

Value

Result

Y

Automatically recalculate the peer group average and maximum prices

N

Do not recalculate the peer group average and maximum prices

The calculation for the 3-month rolling average can be adjusted by indicating how many standard deviations the system should apply to the mean. The EOD_3MONTH_ROLLING_AVG_NBR_STD_DEVIATIONS business rule allows SPIRIT to indicate how many standard deviations to use.

Values Allowed

Value

Result

1 - 9

Number of standard deviations to apply to the mean

The calculation for the 3-month rolling average can also be adjusted by indicating whether a biased or unbiased method should be used to calculate the standard deviation. The EOD_3MONTH_ROLLING_AVG_VARIANCE_METHOD business rule allows SPIRIT to indicate which method to use.

Values Allowed

Value

Result

B

Apply the Biased method

U

Apply the Unbiased method

DFDD References

Calculations for Computing 3 Month Rolling Average (Scheduled Job Administration)

Calculations for Computing 3 Month Rolling Average (Scheduled Job Administration)

Process Peer Group Pricing (Scheduled Job Administration)

Process Peer Group Pricing (Scheduled Job Administration)

|

Appendix