Support at Home Coordinator Calculator
Calculate your Support at Home care coordination revenue
Input Parameters
$20K$5M$10M$15M$20M
15%20%25%30%
%
65%75%85%95%100%
%
Coordination Loading Revenue
| Loading / Activated Care | 65% | 70% | 75% | 80% | 85% | 90% | 95% | 100%Max Capacity |
|---|---|---|---|---|---|---|---|---|
15% | $69,368 | $74,704 | $80,040 | $85,375 | $90,711 | $96,047 | $101,383 | $106,719 |
20% | $88,636 | $95,455 | $102,273 | $109,091 | $115,909 | $122,727 | $129,545 | $136,364 |
25% | $106,364 | $114,545 | $122,727 | $130,909 | $139,091 | $147,273 | $155,455 | $163,636 |
30% | $122,727 | $132,168 | $141,608 | $151,049 | $160,490 | $169,930 | $179,371 | $188,811 |
Matrix Logic
Matrix shows your total Coordinator Loading revenue based on your inputs calculated by:
- • Step 1: Care Management = Total Funding × 10%
- • Step 2: Utilised Funds = (Total Funding - Care Management) × Activated Care Rate
- • Step 3: Trilogy Care Loading = Utilised Funds × 10 ÷ 110
- • Step 4: Coordinator Loading = (Utilised Funds - Trilogy Care Loading) × (Coordination % ÷ (100 + Coordination %))
100% Activated Care Benchmark
The highlighted column shows your maximum potential Coordinator Loading revenue at full capacity activated care, providing a clear benchmark for revenue optimisation planning.
Funding Breakdown
| Financial Component | Amount | % of Total |
|---|---|---|
Total Funding | $1,000,000 | 100.0% |
Care Management | $100,000 | 10.0% |
Utilised Funds | $855,000 | 85.5% |
Trilogy Care Loading | $77,727 | 7.8% |
Coordinator Loading | $129,545 | 13.0% |
Supplier Price | $647,727 | 64.8% |
Calculation Logic
- • Care Management: Total Funding × 10%
- • Utilised Funds: (Total Funding - Care Management) × Activated Care Rate
- • Trilogy Care Loading: Utilised Funds × 10 ÷ 110
- • Coordinator Loading: (Utilised Funds - Trilogy Care Loading) × (Coordination % ÷ (100 + Coordination %))
- • Supplier Price: Utilised Funds - Coordinator Loading - Trilogy Care Loading
Total Coordination Revenue
$0
Additional Funding Streams
$0$3.75K$7.5K$11.25K$15K
$0
$0$3.75K$7.5K$11.25K$15K
$0
| Funding Stream | Funding Amount | Coordination Loading |
|---|---|---|
| Assistive Technology | $0 | $0 |
| Home Modifications | $0 | $0 |
| Total Additional | $0 | $0 |
Calculation Logic
Assistive Technology Coordination Loading:
The lower amount of 5% of the total Assistive Technology funding OR $250 per client (multiplied by the number of clients)
The lower amount of 5% of the total Assistive Technology funding OR $250 per client (multiplied by the number of clients)
Home Modification Coordination Loading:
The lower amount of 5% of the total Home Modification funding OR $500 per client (multiplied by the number of clients)
The lower amount of 5% of the total Home Modification funding OR $500 per client (multiplied by the number of clients)
Example:
For 10 clients with $10,000 Assistive Technology funding each:
• Total funding: $10,000 × 10 = $100,000
• 5% of total funding: $100,000 × 0.05 = $5,000
• Fixed amount per client: $250 × 10 = $2,500
• Coordination Loading: Lower of $5,000 or $2,500 = $2,500
For 10 clients with $10,000 Assistive Technology funding each:
• Total funding: $10,000 × 10 = $100,000
• 5% of total funding: $100,000 × 0.05 = $5,000
• Fixed amount per client: $250 × 10 = $2,500
• Coordination Loading: Lower of $5,000 or $2,500 = $2,500