Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Normalised consumption calculation revisited for gap project

Description

As a R&R submitter, I want to enter data on “number of days of stockouts” and see a calculated column for “normalised consumption” for the period, which is equal to (consumption during period*90/(90- number of stockout days)) when filling ILS and TB&L program R&Rs so that I can calculate the actual required quantities for the next quarter

Acceptance Criteria:
Number of days stocked out can be added as a column on the R&R form through the requisition template
Normalized consumption is calculated as (consumption during period*90/(90- number of stockout days))

Note:
Some of the feature for normalized consumption calculation already exists in OpenLMIS 3.3
Through this ticket features and underlying calculations will be compared and if any gap is found those will be filled

Attachments

4

Activity

Elias MulunehJuly 17, 2018 at 2:08 PM

We met with Team from Tanzania and Zambia to clarify this (Alpha, Alfred, Hassan on 07/13/2018 and Chris, Wendy on 07/16/2018). From both countries the roundup rule is good. No further development required to accommodate the eLMIS version of the rounding.

Mary Jo KochendorferJuly 5, 2018 at 11:25 PM

, it would be good to get the input from Zambia and TZ. My hope is that rounding up to the nearest integer would be sufficient but I'd like their thoughts.

Elias MulunehJuly 5, 2018 at 6:10 PM
Edited

Given eLMIS and OpenLMIS v3.3 requisition templates were configured similarly, the adjusted consumption field may result in a slightly different calculation result for certain numbers.

There are a few reasons for this.

  1. OpenLMIS v3 calculation uses Math.ceil() to round to the nearest higher integer while the eLMIS TZ version uses Math.round() to round to whichever integer is closest. eLMIS can sometimes round down.
    Please see the screenshots attached for what the differences may look like.

decision is needed if Math.ceil() is okay, or if OpenLMIS needs to adopt change here. If so, we can consider what options there are.

  1. eLMIS can be configured to use the new patient’s field to calculate new normalized consumption. In the case of OpenLMIS v3, no such column exists that influences the calculation. It is worth noting that, while the new patient field has been included in eLMIS, it has never been used as included in this formula. Since there is no implementation that currently collects “new patients” for the purpose of the gap project, I believe we can avoid implementing changes relating to “new patients”.

NOTE: In some implementations, the new patient field is renamed and is used as “quantity required for new patients” That feature will be explored in OLMIS‌-4966

Elias MulunehJune 28, 2018 at 8:37 PM

"Normalized consumption" as known in OpenLMIS v0 - v2 looks very similar to "Adjusted Consumption" in OpenLMIS v3.

Won't Fix
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Labels

Story Points

Components

Sprint

Fix versions

Affects versions

Priority

Parent

Time Assistant

Created June 21, 2018 at 12:33 PM
Updated February 8, 2023 at 1:29 PM
Resolved July 17, 2018 at 2:09 PM