← Back to Projects
DDL Case Study · Analytics Engine

GrantTracker

Grant intelligence for animal welfare clinics — real-time fund balances, burn rate monitoring, compliance deadlines, and cost-per-procedure analytics from data clinics already have.

Problem

Low-cost spay/neuter clinics juggle 5–8 active grants from different funders, each with unique reporting schedules, eligible expense categories, and burn rate concerns — tracked in disconnected spreadsheets with no unified view.

Approach

DDL's grant intelligence engine: every expenditure is a fact row with grant, category, procedure, and period dimensions — enabling real-time fund balance tracking, burn rate alerts, compliance calendars, and cost-per-procedure analytics that funders care about.

Deliverable

Grant operations dashboard — portfolio KPIs, fund balance table with burn rate visualizations, spend-by-category breakdowns, compliance deadline calendar, procedure metrics by type, and assumption documentation for client validation.

Key Metrics
Active Grants
6
across 5 funders
+ 1 new this quarter
Total Awarded
$345K
active grant portfolio
↑ $25K from Q3
Total Spent
$187K
year-to-date
54.2% burn rate
Remaining Funds
$158K
across all active grants
Procedures YTD
2,847
spay/neuter completed
↑ 12% vs prior year
Cost / Procedure
$65.70
blended average
↓ $3.20 from Q3
Grant Status

Fund Balances & Burn Rates

GrantFunderAwardSpentRemainingBurn RateNext ReportStatus
Community GrantNational Animal Welfare Org$75,000$42,180$32,820
56%		Mar 3139 days
Spay/Neuter FundPet Retail Foundation$50,000$31,450$18,550
63%		Mar 3139 days
Animal Care GrantState Agency$120,000$89,200$30,800
74%		Feb 288 days
Community ImpactCorporate Charity$35,000$12,600$22,400
36%		May 31100 days
Spay/Neuter InitiativeCounty Government$25,000$4,800$20,200
19%		Mar 3139 days
Animal Welfare FundCommunity Foundation$40,000$6,950$33,050
17%		Jul 31161 days
Veterinary CareVeterinary Foundation$15,000$15,000$0
100%		ClosedComplete
Spend by Category
Labor / Staffing
31%$57,970
Surgical Supplies
24%$44,880
Medications
19%$35,530
Facility Costs
11%$20,570
Equipment
8%$14,960
Outreach
5%$9,350
Administrative
2%$3,740
Compliance Calendar
State Agency Animal Care
Monthly Report
Feb 288 daysDue Soon
National Org Community Grant
Quarterly Report
Mar 3139 daysUpcoming
Pet Retail Spay/Neuter
Semi-Annual Report
Mar 3139 daysUpcoming
County Initiative
Quarterly Report
Mar 3139 daysUpcoming
Corporate Charity Impact
Quarterly Report
May 31100 daysOn Track
Community Foundation
Semi-Annual Report
Jul 31161 daysOn Track
Procedure Intelligence

Impact by the Numbers

🐱
Feline Spay
842
$54,730 total · $65/avg
🐱
Feline Neuter
614
$27,630 total · $45/avg
🐕
Canine Spay
523
$57,530 total · $110/avg
🐕
Canine Neuter
389
$33,540 total · $86/avg
✂️
Feral Cat TNR
312
$10,920 total · $35/avg
💉
Vaccine Add-On
167
$4,175 total · $25/avg
Built on These Assumptions

This was made on the assumptions that...

→A typical clinic manages 5–8 active grants from a mix of federal, state, foundation, and corporate sources
→Grant awards range from $5,000 to $150,000 with 6–24 month terms
→Primary eligible expenses: surgical supplies, medications, labor, facility costs, outreach, equipment
→Reporting frequency varies by funder — monthly, quarterly, semi-annual, or at close-out
→Cost-per-procedure is the #1 metric funders care about
→The people entering data are veterinarians and clinic managers — not accountants

Tell us where we’re wrong. The engine adjusts — that’s the whole point.

GrantTracker Engine · v1.0 · Grant Intelligence for Clinics That Care · Built by DDL · 2026