Details

There is an issue with the Standard Deviation calculation. It looks like, instead of adding a subtracting a standard deviation as derived from the data set, from the average of the data set, the formula is adding or subtracting the number configured in the "Standard Deviation" section.

Testing Environment

In JAT:

• Store #: 04489
• Vendor: THE MARTIN-BROWER COMPANY
• Item: APRON, DISPOSABLE (007872)
• Order Quantity: 10
• Total orders used in average: 5
• Standard deviations: 2

Test Details

Order the item above (or any item) enough times to trigger the min/max calculation. In this case 5 total orders. I used the same order quantity of 10. The average for this is 10. Because all the orders are of the same value, the standard deviation is zero

The Math

• Average
  • (10+10+10+10+10)/5 = 10

• Standard Deviation of a Sample
  
  • (10-10)^2 = 0
  • (10-10)^2 = 0
  • (10-10)^2 = 0
  • (10-10)^2 = 0
  • (10-10)^2 = 0
  • Average (Sum of sample divided by (total number of samples -1) of the above dataset = 0
  • Standard Deviation (Square root of the average) = 0

Expected Min/Max

• Min: 10
• Max: 10

Actual Min/Max

• Min: 8
• Max: 12

AC

Confirm

1. The calculation is updated to include the statistical standard deviation instead of adding or subtracting the number configured in MMS