Average days outstanding metric
Identifies operational performance of receivables.
- Name
- Average Days Outstanding
- Category
- Operational
- Analysis objective
- Determines which payment issues exist, including bad creditors. Can be used to indicate whether to terminate a contract.
- Description
- Lease receivables that are measured in average days outstanding.
- Source
- Customer Focus Group
- Measurement
- Average of Outstanding Receivables (TODAY – Payment Due Date)
- Dependent data that is calculated
- Payment Line Items:
- Outstanding Receivables = Payment Line Items, where due date less than or equal to TODAY AND date paid is NULL
- Payment Due Date
- Paid Date
- Roles
- RE Contract Manager
- Display chart types
- Value-based: Horizontal Grouped Bar (percent) Chart
- (Capture Period: Vertical Grouped Bar (percent) Chart)
- Thresholds
- Low Threshold: 10
- High Threshold: 30
- Range 1: Good/Positive/Green
- Range 2: On Target/Caution/Yellow
- Range 3: Poor/Negative/Red
- Fact details
- Module: triMetricFactBusiness Object: triREPaymentFact
Metric Queries: triREPaymentFact - Metric - Average Days Outstanding
- Drill paths
- Organization
- Payment Type
- Contract Name
- Contract Type
- Capture Period
- Interactive filters
- Organization
- Contract Name
- Payment Type
- Contract Type
- Static filters
- Payment Line Items paid in data point refresh period
- RE Contracts filtered to Active User (USERID) = Contract Administrator
- Suppress zero values
- Yes, suppress graphic display of zero values
- Yes, suppress interactive filters list or drill-path list with zero values
- Time
- Months
- Data point refresh rate
- Monthly
- License dependency
- Real Estate
- Facilities
- Functional dependency
- Space Use Agreements (Real Estate)
- Space Allocations (Facilities)