Analysis of Awarded Opportunities
This analysis provides insights into the average contract values, average opportunity ages, and total contract values across different age groups of awarded opportunities. Below is a breakdown of the findings:
Key Metrics
| Age Group | Average Contract Value | Average Opportunity Age (days) | Total Contract Value | Number of Records |
|---|---|---|---|---|
| Under 10 days | $5,600.14 | 3.17 | $1,971,249.00 | 352 |
| 10-100 days | $8,212.63 | 44.82 | $2,504,851.60 | 305 |
| 101 and over days | $14,053.49 | 321.98 | $4,426,848.75 | 315 |
| Total (1 record) | $3,075.00 | 1,527.00 | $3,075.00 | 1 |
| Grand Totals | $9,153.16 | 121.00 | $8,906,024.35 | 973 |
Summary
The analysis reveals that:
- Opportunities under 10 days old had the lowest average contract value of $5,600.14, with an average age of 3.17 days.
- Opportunities aged between 10 and 100 days showed a higher average contract value of $8,212.63, with an average age of 44.82 days.
- Opportunities aged 101 days and over had the highest average contract value of $14,053.49, with an average age of 321.98 days.
- The grand total across all records shows an average contract value of $9,153.16, with an average opportunity age of 121 days, and a total contract value of $8,906,024.35.
This data provides valuable insights into the performance and timing of awarded opportunities, helping to inform strategies for improving contract success rates.