Chart Design & Mechanics

• X-Axis (Horizontal): Total Location Revenue (in Millions) — Represents the scale/importance of the location to your business.
• Y-Axis (Vertical): Average Delay (in Days) — Represents the collection speed (waiting days for payments).
• Bubble Size: Total Outstanding Value (in Millions) — The larger the bubble, the higher the amount of cash currently locked/uncollected at that site.
• Bubble Colors: Colored dynamically matching your existing Region colors (Western, Central, Eastern, Southern).
• Interactivity: Hovering over any bubble displays a high-fidelity tooltip detailing the Location Name, Region, Total Revenue, Total Outstanding Balance, and Average Payment Delay.

What Insights It Unlocks

This chart provides an instant quadrant analysis for executives:

• Top-Right (High Revenue, High Delay): High Risk — Major locations contributing high revenue but taking a long time to pay. Prioritize for accounts receivable follow-up.
• Bottom-Right (High Revenue, Low Delay): Healthy Operations — Key high-revenue locations with fast collection times.
• Bubble Size Focus: A large bubble instantly signals a cash-flow bottleneck regardless of the location's total revenue size.