...
Successful logistics systems are all characterized by appropriate product availability in constantly changing circumstances. Data and information on the quantity of goods distributed or consumed by customers is important for supervisors to make logistics decisions. CommTrack
CommTrack provides the feature of automatic consumption calculation based on information including products that are consumed in certain date range.
stock on hand and average monthly consumption. By definition,
AMC is the average quantity of products dispensed to users in the most recent three months. That said, there is no way to get an AMC in the first three months of a CommTrack system. To solve the problem, we use the default monthly consumption value for each product as a proxy for average monthly consumption. Once the system receives data for more than three months, dynamic AMC would be available for automatic consumption calculation.
If you do not want to use CommTrack automatic calculation, you can just estimate monthly consumption by using default monthly consumption data. Still, using consumption data from one month is risky as consumption fluctuates - might be risky to use as a reference for decision making.
There are two ways to configure monthly consumption values:
...
product transactions. You can get a view of average monthly consumption of each registered product from Inventory Report. One way to get that piece of information is by providing a default monthly consumption data as follows:
Default Consumption
1. Click 'Setup' and select 'Consumption'.
2. Fill in default consumption value for each product and Update consumption info.
...
Advanced Settings
Still, using consumption data from one month is risky as consumption in real world fluctuates - might be risky to use as a reference for decision making. You can enable CommTrack automatic calculation to capture the dynamic. By setting up the minimum transactions and window days for calculation, CommTrack would return a real-time calculated monthly consumption whenever a mobile worker submits a transaction report (aka products are consumed).
1) Select 'Use automatic consumption calculation'.
...
| Tip |
|---|
If the default consumption uploaded with excel is a decimal number, CommTrack would round it up. The higher you make minimum transactions, minimum and optimal window for calculation, the more accurate the monthly consumption would be. |