The Arc of Benton County Analytics Demo
Sample data — illustrative only October 2025

Monthly Financial Dashboard

Revenue, expense, and net position tracked against budget at the program level.

View
Revenue
$1.42M
+2.9% vs. budget
Expense
$1.31M
−3.0% vs. budget
Net Position
+$108K
vs. +$30K budget
Months Cash
4.2
operating reserve

Spend by Program

Click a bar to see monthly trend
Monthly trend for

Revenue Mix

$1.42M YTD

Grant Tracking

Restricted-fund spend-down with compliance flags and upcoming deadlines.

Filter
Active Grants
6
$738K total awarded
YTD Spent
$516K
70% of awarded
At Risk
2
underspend or expiring
Upcoming Reports
3
due in next 30 days

Awarded vs. Spent

Hover for detail

Action Items

5 items
!
Holiday Program closes Oct 31
$1K unspent — submit reimbursement by 10/28
!
Family Caregiver underspending
Only 40% spent at 67% time elapsed
DD Services on track
68% spent at 75% time elapsed
i
Q4 reports due 11/15
DD Services, Community Integration
i
Renewal apps in pipeline
Employment First (due 12/01)

Grant Detail

Grant Source Awarded Spent % Spent Status
DD Services State $320K $218K 68% On track
Community Integration Federal $185K $167K 90% Overspend
Family Caregiver County $95K $38K 40% Underspend
Employment First Foundation $75K $64K 85% On track
Tech Access Private $45K $12K 27% On track
Holiday Program Local $18K $17K 94% At risk

Program Metrics

Participants, service hours, and unit cost across program areas.

Program
People Served
342
+12 vs. last quarter
Service Hours
18,450
YTD across all programs
Avg Cost / Hour
$71
−$3 vs. last quarter
Satisfaction
4.6/5
n=128 surveys

Participants Over Time

YTD, stacked by program

Service Hours Mix

18,450 hrs YTD

Cost per Participant (Annualized)

Hover for detail

Executive Summary

Board packet view — top-line financials, program performance, and asks.

YTD Net
+$108K
vs. +$30K budget
Cash on Hand
$465K
4.2 months operating
People Served
342
+8% year-over-year
Grant Pipeline
$680K
5 applications in review

Net Position vs. Budget

YTD trend

October Highlights

Financial
Operating surplus running $78K ahead of budget; driven by lower-than-planned admin spend and a one-time tech grant.
Programs
Day Programs at capacity; waitlist of 14. Considering pilot evening cohort in Q1.
Grants
Employment First renewal due 12/01; draft underway. Holiday Program closes 10/31 with $1K unspent.
Risks
Family Caregiver grant underspending — risk of clawback if pace does not pick up by December.
Asks of Board
Approve evening cohort pilot scope and $18K startup budget.

Program Scorecard

Program Served Budget Variance Status
Employment Services54+4.6%On track
Day Programs102−4.4%At capacity
Family Support70+3.6%On track
Recreation96−5.3%Under
Advocacy20−7.4%On track

Cash Flow & Runway

12-month rolling projection with reserve targets and minimum floor.

Scenario
Cash on Hand
$465K
as of Oct 31
Months Runway
4.2
at current burn rate
Reserve Target
$575K
5 months (board policy)
Gap to Target
−$110K
shortfall to goal

12-Month Cash Projection

Toggle scenarios above

Thrift Store Operations

Revenue, expense, and net contribution to programs across locations.

Store
Net Contribution
+$84K
to programs YTD
Revenue
$412K
across both stores
Operating Margin
20.4%
+2.1 pts vs. prior YTD
Donated Goods
$680K
est. fair-market value

Monthly Revenue vs. Expense

Both stores combined

Expense Breakdown

$328K YTD

Performance by Store

Store Revenue Expense Net Margin
Corvallis$268K$212K+$56K21%
Philomath$144K$116K+$28K19%
Total$412K$328K+$84K20.4%