Development Dashboard

Giving Assumptions:

• Individual Giving $175,000 includes matches

• Event Sponsorships $10,000

• Spring Ahead In-Kind $32,000

• General In-Kind $12,500 includes farm contributions

• Comm/Foundation Grants $147,000

• Government Grants $150,000

Total $482,000

Financial Summary

Total Revenues $176,250

Direct Expense $197,901 ($21,651)
Total Operating Expense $292,510 ($116,260) includes overhead

Red indicates Unmet Need: the gap between revenues and expenses

School Breakdown

Using contract value as a proxy, each school represents the following portion of expense/need. Numbers are rounded to the nearest half thousand for ease of calculations.

School % of Program Revenues Operating Expense Unmet Need

Hatch 27% 47,500 79,000 (31,500)
El Granada 13% 23,000 38,000 (15,000)
Farallone View 7% 12,500 20,500 (8,000)
Kings Mountain 4% 6,000 11,700 (5,700)

Baywood 20% 35,000 58,500 (23,500)
Ortega 16% 28,500 47,000 (18,500)
Garden Village 13% 22,500 38,000 (15,500)

Red indicates Unmet Need: the gap between revenues and expenses

KPIs

Weeks Delivered: 182
Cost Per Week $1,600

Students Reached (CUSD) 175 (estimated)
Cost Per Student (CUSD) $850

Students Reached (Other) 600 (estimated)
Cost Per Student (Other) $240

Cost/Hour of Education (CUSD) $33.00
Cost/Hour of Education (Other) $36.00

Financial Summary & KPIs

Direct Expense $225,322
Total Operating Expense $313,623 includes overhead

Cost/Week $6,000
Cost/Day $1,000 (if we operate 6 days/week)

Financial Summary

Earned Revenues $65,205
Committed Grants $216,000 includes Atkinson, PHCD, MROSD, and SMC
In-Kind Revenues $26,000
Produce Sales $27,500
Miscellaneous Programs $20,000

Total Revenues $354,705

Direct Expense $180,356 (Met)
Total Operating Expense $472,512 ($117,108) includes farm expenses and organizational overhead

Red indicates Unmet Need: the gap between revenues and expenses

KPIs

Trips Anticipated: 175
True Cost Per Trip $2,700
True Cost Per Student $90
True Cost/Hour of Education $30

The "True Cost Per Trip" KPI is somewhat skewed because the "total operating expense" include a portion of the farm, but there are other things that can contribute to running that other than field trips and camps. For example: produce sales, corporate programs, sponsorships, etc. However, it gets us a really solid Cost/Hour of Education.

In the Farm Business Model, we consider all those ancillary revenues first (including camp profits) and then allocate the remaining costs of the farm across field trips programs. From that, we get the following, more defensible number, which we use for grant allocations:

Fully Loaded Cost Per Trip $1,350
Cost Per Student (est.) $45
Cost/Hour of Education $15

Another useful statistic, from the Unmet Need calculations:

Unfunded Need Per Trip ($669)
Unfunded Need Per Student ($22)