...
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).
CommTrack does provide an automatic consumption calculation feature in CommTrack to help projects forecast consumption within a specific date range for any given supply point. CommTrack needs the following data input to calculate the dynamic monthly consumption:
- minimum transaction (count): e.g. 3
- minimum window for calculation (days): e.g. 3
- optimal window for calculation (days): e.g. 15
In this scenario a mobile agent has to report at least 3 stock on hand reports over at least 3 days before CommTrack can calculate a monthly consumption automatically. Users can fill in any number here but the bigger the number, the better the result of monthly consumption calculation would be.
1) Select 'Use automatic consumption calculation'.
...
4) Save and upload the location file. Go to Setup and under Manage Locations, select any reporting facility you registered. Scroll down and you will see the unchangeable default consumption value for each product.
What would happen if you do both?
...
| 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. |