Aggregated Budget Forecast
Introduction
The aggregated budget forecast shows aggregated costs over time for multiple scenarios. In forecast calculations with RTSM data extract, only costs forecasted by 4C Supply® are shown in the budget forecast.
Among others, the aggregated budget forecast can be used to determine the forecasted costs across multiple studies.
Notes
Data is aggregated on multiple levels in the aggregated shipment forecast:
Shipment types are aggregated by shipment type code. Therefore, users must choose common shipment type codes for shipment types where aggregation is intended.
Depots are aggregated by depot code. Therefore, users must choose common depot codes for depots where aggregation is intended.
Examples
Aggregated budget forecast graph of two studies without RTSM actuals
Report Selectors
Dispensing unit
Definition
The dispensing unit level aggregated budget forecast shows the aggregated budget 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.
Total forecasted costs are the same in the dispensing units view and the drug products view, but filtering capabilities are different depending on the view.
Drug product
Definition
The drug product level aggregated budget forecast shows the aggregated budget 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.
Total forecasted costs are the same in the dispensing units view and the drug products view, but filtering capabilities are different depending on the view.
Report Fields and Filters
Category
Definition
Defines the cost categories for which costs are displayed.
Rules
Cost categories are:
DP & Comparators
Logistics
Manufacturing
Displayed as filter be 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.
Type
Definition
Defines the type of costs which are displayed.
Rules
Cost types are:
depot shipment cost
drug product cost
fixed lot cost
kit related depot shipment cost
packaging & labeling cost
site shipment cost
storage cost
variable manufacturing cost
Displayed as rows in the totals report by default.
Displayed as columns in the report over time by default.
Dispensing Unit
Definition
Defines for which dispensing unit(s) costs are shown.
Rules
Shown as report column by default.
Only shown in dispensing units view.
Drug product
Definition
Defines the drug product(s) costs are shown.
Rules
Shown as report column by default.
Only shown in drug products view.
Measure
Definition
Average costs aggregated for the selected scenarios.
Rules
Shown as column by default.
Only average value is calculated and displayed for costs.
Time
Definition
Defines the periods in which costs are forecasted to occur.
Rules
Displayed as rows by default
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.
Total Sum of Cost
Definition
Cost quantity shown in the forecasted manufacturing cost report.
Rules
Displayed as values be default.