This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Collections Strategy Analyst at T-Mobile. The finance team needs a collections scorecard for each customer to prioritize outreach. For every customer with at least 3 bills, calculate their total bill count, paid count, past-due count, collection rate (percentage of bills paid), total late fees incurred, and a risk classification label.
You are a Collections Strategy Analyst at T-Mobile. The finance team needs a collections scorecard for each customer to prioritize outreach. For every customer with at least 3 bills, calculate their total bill count, paid count, past-due count, collection rate (percentage of bills paid), total late fees incurred, and a risk classification label.