Done
Pinned fields
Click on the next to a field label to start pinning.
Details
Assignee
Przemysław StudzińskiPrzemysław StudzińskiReporter
Mary Jo KochendorferMary Jo Kochendorfer(Deactivated)Labels
Story Points
8Original estimate
Time tracking
3w 2d 2h logged5h remainingComponents
Sprint
NoneFix versions
Priority
Blocker
Details
Details
Assignee
Przemysław Studziński
Przemysław StudzińskiReporter
Mary Jo Kochendorfer
Mary Jo Kochendorfer(Deactivated)Labels
Story Points
8
Original estimate
Time tracking
Components
Sprint
None
Fix versions
Priority
Time Assistant
Time Assistant
Time Assistant
Created August 10, 2016 at 11:02 PM
Updated January 31, 2017 at 2:30 PM
Resolved January 26, 2017 at 11:45 AM
As an implementer, I want the option to include the "Average Consumption" (P) attribute on the requisition forms so that the user (storeroom and program manger) can see and understand what the typical or average consumption for that commodity is while he/she is making a request for more products.
Note: if the periods within a schedule are monthly, this calculation will serve as Average Monthly Consumption (AMC)
New Feature: implement the option for an implementer user to define the number of periods to average. This is a new option and part of the P attribute.
Acceptance Criteria
Verify that:
an implementer (who is an authorized API user) can configure this field to appear in the Requisition template for their program
an implementer (who is an authorized API user) can configure it with a field label string
P is available to be associated with a requisition template by program
can be assigned a display order in the requisition form
average consumption is based on a period moving-average window of adjusted consumption (N) from most recent period(s)
(N t0 + N t-1 + N t-2 + N t-(n-1)) / ( n )
user defines "n" (to indicate how many periods will be averaged)
"n" cannot be 1 or 0, must be greater than or equal to 2
"n" must have a value if (P) is selected to be displayed/included in the template
n = number of periods
t = indicates relative period (t0 = current reporting period)
For data entry, if not enough periods exist, compute based on the following:
if no previous periods, and there is only t0 ; use P = N (instead of the formula above)
if one previous period, so t0 and t-1 ; use P = Roundup( (N t0 + N t-1) / 2)
if more than one previous period, just compute the average of what periods are available (even if less than the defined "n")
If
Then
no data exists for a specific product lineitem in previous periods, and there is only t0 (the current requisition is being filled out)
use P = N (instead of the formula above)
there is only data for one previous period for a specific product lineitem, so data is available for t0 and t-1
use P = Roundup( (N t0 + N t-1) / 2)
more than one previous period exits but fewer than "n"
compute the average of what periods are available and Roundup
Variable
Indicator
Associated Table
Remarks
Adjusted consumption for a reporting period
N
RequisitionLineItems table
saved for prior periods in the RequisitionLineItems table—t subscript indicates relative period