Task 7

I would like to analyze the current proportion of Brightpath Churn and Annual Recurring Revenue. 

1. Based on the ARR from the discount approval file and the Churned ARR from customer segmentation file, calculate the required reduction in $ in Churned ARR for every Pricing Tier whose current Churned ARR proportion exceeds 0.5% of its Overall ARR, so that the proportion for that tier is reduced to exactly 0.5%.
2. Calculate the number of additional deals (each valued at the average ARR per deal ...

I have analysed the Potential obtained ARR and churned ARR for Brightpath. Here are the updates per your request.

1. The churned ARR that Brightpath must reduce to achieve 0.5% percentage of Churned ARR are as follows:
- Business: $35,833 
- Enterprise: $46,204 
- Team: $42,986 

2. Brightpath must secure a total of 155 deals to achieve 0.5% percentage of Churned ARR.