ViisonPickwareERPAnalyticsStockTurnoverRate

Extends \Shopware_Controllers_Backend_Analytics

package	Default

Methods

This report calculates the "stock turnover rate" (Lagerumschlags- häufigkeit) and the "avarage turnover period" (Durchschnittliche Lagerdauer) for all "inventory tracked" articles. The "stock turnover rate" for a given period is generally defined as:

getStockTurnoverRateAction()

number of sold articles stock turnover rate = --------------------------------- average inventory

with N inventory snapshots average inventory = --------------------------------- N

The number N of inventory snapshots is arbitrary. A simple implementation would take 2 snapshots: the beginning inventory and the ending inventiory of the article with respect to the given period.

To keep the complexity of the sql query manageble we use the avarage inventory over all stock changes made within the given period.