Aggregated Network Demand Forecast
Introduction
The aggregated network demand forecast shows aggregated demand per dispensing unit or drug product over time for multiple scenarios. In forecast calculations with RTSM data extract, only demand forecasted by 4C Supply® is shown in the network demand forecast.
Among others, the aggregated network demand forecast can be used to determine the forecasted demand of the same dispensing unit or drug product across multiple studies.
Aggregated network demand is defined as any inventory that leaves the location that is being filtered against. If the report is filtered to a single depot, the numbers include what is dispensed to patients from sites that are supplied directly by that depot including the site buffers as well as any expiring drug replacements.
Notes
Data is aggregated on multiple levels in the aggregated demand forecast:
Demand quantities aggregated by dispensing unit code or by drug product code. Therefore, users must choose common dispensing unit codes or drug product codes to achieve the desired aggregation.
Depots are aggregated by depot code. Therefore, users must choose common depot codes to achieve the desired aggregation.
Suppliers are aggregated by supplier name. Therefore, users must choose common supplier names to achieve the desired aggregation.
Examples
Aggregated network demand graph of two studies without RTSM actuals
Dispensing units view
Drug products view
Report Selectors
Dispensing unit
Definition
The dispensing unit level aggregated network demand forecast shows the aggregated network demand forecast per dispensing unit.
Notes
Display per dispensing unit is often not ideal for aggregation because dispensing units tend to have study-specific dispensing unit codes.
Drug product
Definition
The drug product level aggregated network demand forecast shows the aggregated network demand forecast per drug product.
Rules
Drug product quantities are shown under consideration of specified drug product units per kit.
Notes
Display per drug product allows a pooled view of dispensing units with the same drug product code in aggregated reports.
Report Fields and Filters
# of units
Definition
Quantity of kits shown in the report.
Rules
Shown as values by default.Depot
Definition
Determines for which depot(s) data is shown in the report.
Rules
Shown as report column by default.
Dispensing unit
Definition
Defines the dispensing unit(s) for which network demand quantities are shown.
Rules
Shown as report column by default.
Only shown in dispensing units view.
Drug product
Definition
Defines the drug product(s) for which network demand quantities are shown.
Rules
Shown as report column by default.
Only shown in drug products view.
Measure
Definition
Defines the measures (Min, Avg, Max) which are displayed in the table and graph.
Rules
Shown as report column(s) by default.
Study
Definition
Determines for which study/studies data is shown in the report.
Rules
Shown as report column by default.
Scenario
Definition
Determines for which scenario(s) data is shown in the report.
Rules
Shown as report column by default.
Supplier
Definition
Determines for which supplier(s) data is shown in the report.
Rules
Shown as report filter by default.
Notes
Supplier can usually be left unfiltered if data for all depots should be included in the report. However, if demand for a local depot is the intended output, supplier may have to be filtered to the supplying depot.
Time
Definition
Defines the periods in which kits are demanded in the network.
Rules
Period start dates are displayed.
Notes
The size of periods is determined by the interval for enrollment and demand value selected in the forecast configuration.