Weekly Average

Checking the Weekly Average

After you have confirmed the order cycle has been set appropriately, review the product average for product or products in question. 
Is the product average correct? The average on your Product History screen is the foundation on which the system builds a suggested order. The system uses exponential smoothing to calculate this number. Exponential smoothing puts more emphasis on recent history while still taking into account all the history available to the system. If you think demand patterns are changing, you have the ability to take the average from any previous period you choose. 

If your history is displayed monthly, rather than weekly, click here for this step.

For items where weekly history is displayed, the system will display 1 full year of history divided into 13 separate 4-week periods. The first column of history will be the first 4 weeks of the year, the last column will be the last 4 weeks of LAST year. The most recent period completed will be shown in red.

Review your history and your product average. If your product average does not look correct based on the history shown, follow the following step:

Adjusting the Average

It is possible to adjust the average directly by clicking on the average field and typing in a new average. While in some situations this is the best solution, most of the time this is not the most effective way to adjust the average. By typing it in directly you are actually telling the system to ignore all the past history and start clean with the number you just typed. The more effective way of adjusting the average is to do it indirectly by going to the edit history screen and telling the system to re-average from a new point in time.

Click the Edit History button on the Product History screen and you will now be in Edit History mode.

The box around your product history should turn a light green and it will say Edit History in the upper left hand corner (see picture to the right). Take your cursor and place it in a periods history and hit enter. The system calculate a new average using this period as its starting point. On the bottom of the screen it will display how many periods were used to calculate this new average. This is not 'set' until you click save.

Did someone adjust this?

It is possible you (or even another user) had adjusted the average earlier and you had forgotten about it. There is a very simple way to see if there were any prior adjustments. Click the 'Changes Log' button to see what what prior adjustments had been made.

Did this resolve the issue? No >