Forecasted Inventory
Watch for changes
Introduction
The Forecasted Inventory report shows non-cumulative dispensing unit quantities available over time. Forecasted inventory values are shown with variability, the average value will equal the inventory from the Trial Supply Projection report (without rounding). The report data can be shown for different network levels, determined by the report selector (i.e., the Select Network level dropdown).
Example
Report Selectors
Depot: Shows the cumulative inventory quantities available at depots over time.
Site Group: Shows the cumulative inventory quantities available at site groups over time.
Actual Site: Shows the actual site inventory at the date of the Actuals Extract.
Average Site: Shows the cumulative inventory quantities available at an average site overt time.
Note: By default, the depot and site group data appears stacked. Applying a filter may be necessary to rationalize the data.
Fields and Filters
Depot
Determines for which depot(s) data is shown in the report.
Only shown when depot is selected as the network level.
Dispensing Unit
Defines the dispensing unit(s) for which inventory quantities are shown. By default, stacked data for all dispensing units are shown in the report. Therefore, it often makes sense to filter for a specific dispensing unit.
Measure
Controls the display of variable data. The report is filtered to show min, max, and average results by default.
Only forecasted inventory quantities are represented with variability. Min, max, and average results display as three separate lines on the graph.
Actual inventory quantities from the RTSM data extract are shown without variability (displayed as a single line).
For Depot Level Only, each measure is shown in ‘# of Units’ and ‘# of Packs’. If Pack Size is defined in the Dispensing Units Table, the # of Packs will be detailed in multiples of that Pack Size.
Site Group
Determines for which site group(s) data is shown in the report.
Only shown when average site or site group is selected as the network level.
Time
Defines the periods for which inventory is shown. The duration of a period is determined by the interval for enrollment and demand value selected in the forecast configuration.
Period start dates are displayed as rows by default.
RTSM Data Extracts
In forecast calculations with RTSM data extracts, the Forecasted Inventory report shows actual data according to the RTSM extract data (without variability). The first period displayed in the report is the period after the period with the RTSM extract date