Contract Rate Analysis & Scenarios
SOW 3.3 — break-even rates, target margins, escalation and the financial impact of proposed increases.
2 contracts under-recovering
Current quarter margin
-$232,444
Reimbursement − burdened cost
Margin at proposed rates
-$195,917
+5% across all contracts
Quarterly revenue uplift
$36,527
Additional reimbursement
Agency subsidy today
$322,812
Cost not recovered
Rate scenario model
Break-even and target rates measured against actual fully burdened cost for the selected quarter.
| Orange City Patrol Services | Municipality Patrol | Hourly Billing Rate | 3,037.0 | $153,160 | $68.50 | $50.43 | $54.82 | $71.93 | $54,875 | $65,276 | $10,402 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Halifax Hospital Security Detail | Hospital Detail | Hourly Billing Rate | 3,020.0 | $148,726 | $61.00 | $49.25 | $53.53 | $64.05 | $35,494 | $44,705 | $9,211 |
| Volusia School Board SRD Agreement | School Board SRD | Cost Share % | 6,549.0 | $318,267 | $21.87 | $48.60 | $52.82 | $22.96 | -$175,047 | -$167,886 | $7,161 |
| Ivy Charter Academy SRD Agreement | Charter School SRD | Cost Share % | 2,170.0 | $130,160 | $59.98 | $59.98 | $65.20 | $62.98 | $0 | $6,508 | $6,508 |
| Speedway Special Security Detail | Special Security Detail | Fixed Fee + OT Passthrough | 4,595.0 | $212,673 | $14.13 | $46.28 | $50.31 | $14.83 | -$147,765 | -$144,520 | $3,245 |
Break-Even Rate = Fully Burdened Cost ÷ billable hours. Rate at target margin = Break-Even ÷ (1 − target margin). Billable hours exclude Holiday Not Worked, per the approved calculation rules in the semantic model.
Multi-year term projection
Proposed rates carried forward with annual escalation to support negotiation.
| Orange City Patrol Services | 2024-10-01 → 2027-09-30 | $832,138 | $873,745 | $899,957 | $926,956 | $204,244 |
|---|---|---|---|---|---|---|
| Halifax Hospital Security Detail | 2025-01-01 → 2026-12-31 | $736,880 | $773,724 | $796,936 | $820,844 | $180,864 |
| Volusia School Board SRD Agreement | 2025-08-01 → 2028-07-31 | $572,881 | $601,525 | $619,571 | $638,158 | $140,611 |
| Ivy Charter Academy SRD Agreement | 2025-08-01 → 2026-07-31 | $520,639 | $546,671 | $563,071 | $579,964 | $127,788 |
| Speedway Special Security Detail | 2025-11-01 → 2026-11-01 | $259,631 | $272,612 | $280,791 | $289,215 | $63,725 |
Negotiation talking points
Generated from the current scenario settings.
- • Orange City Patrol Services: recovery is positive at $54,875 this quarter. Break-even sits at $50.43 per hour against the current effective rate of $68.50.
- • Halifax Hospital Security Detail: recovery is positive at $35,494 this quarter. Break-even sits at $49.25 per hour against the current effective rate of $61.00.
- • Volusia School Board SRD Agreement: the agency is absorbing $175,047 this quarter. A rate of $48.60 per hour reaches break-even; $52.82 delivers the 8% target margin.
- • Ivy Charter Academy SRD Agreement: recovery is positive at $0 this quarter. Break-even sits at $59.98 per hour against the current effective rate of $59.98.
- • Speedway Special Security Detail: the agency is absorbing $147,765 this quarter. A rate of $46.28 per hour reaches break-even; $50.31 delivers the 8% target margin.