
define criteria and constraints for the Herd Health Plan, model competing management options with a logistic spreadsheet, and choose among them with a weighted decision matrix.
Phase 4: Build
Do Now. From the Ideate list, the class shortlisted three options: A install wildlife water stations inside the fence; B relocate about 150 elk to another reserve before a forecast drought; C open a fenced corridor to neighboring public land. Which do you favor right now, and why?
Which is a CONSTRAINT rather than a criterion for the herd plan?
Engineers, define success first. Before comparing options, the team fixes measurable criteria (what the plan must achieve) and constraints (limits it must respect). Class criteria (sample targets): keep the herd above 250 elk through a two-year drought; reduce drought deaths by at least half; keep Simpson’s index in grazed plots above 0.6. Constraints: stay within the reserve budget; meet animal-welfare rules for any handling; respect neighbors’ land and livestock.
Prototype = a computational model. For a population plan, the prototype is a spreadsheet that runs the logistic model under each option. Each option changes a different term: water stations raise K in a drought; relocation lowers N; a corridor adds land, which raises K, but lets elk leave.
Worked example 1: one drought year, three options (sample numbers). Use ΔN = rN(1 − N/K) with r = 0.2 per year. The herd is 500 and the drought drops K from 500 to 250.
The spreadsheet repeats this year by year. The model is only as good as its assumptions: the 350 for option A is a guess the team must justify or test.
Worked example 2: a weighted decision matrix. Score each option 1 to 5 on each criterion, multiply by the weight, and add. Weights (team choice): drought survival 0.35, cost 0.20, plant diversity 0.25, neighbor support 0.20.
| Option | Survival (0.35) | Cost (0.20) | Plant diversity (0.25) | Neighbor support (0.20) | Total |
|---|---|---|---|---|---|
| A Water stations | 4 | 3 | 2 | 4 | 3.30 |
| B Relocation | 4 | 2 | 4 | 3 | 3.40 |
| C Corridor | 3 | 4 | 4 | 1 | 3.05 |
Option B leads narrowly. Option A scores low on diversity because more elk around water points may overgraze nearby plants. Close totals mean the team must explain its trade-offs, not hide behind a number.
Energy in the plan. Every plan must show how much producer energy supports the herd. A model of the food web that lists energy at each trophic level lets the board see why the grass, not the elk count, is the real limit.
Build your spreadsheet and matrix with your team.
Version 1 of the plan.
Write your team's version 1 recommendation: the option you chose, its matrix total, your spreadsheet result, and the trade-off the board should know about.
Draw a food-web energy model for the peninsula (grass, elk, one predator, decomposers) with energy values at each level from your calculation, and arrows showing matter returning to the soil.
Version 1 is ready for critique. Next: a gallery walk, a test against our criteria and version 2.
Exit ticket: which number in your plan are you least sure of, and what data would make you more confident?
Materials: devices with a spreadsheet, a starter sheet with columns Year, N, K, ΔN; matrix templates.
Data note: r = 0.2, the drought K values and the matrix scores are sample numbers for teaching; teams may justify different ones.
Listen for: treating the matrix as an answer machine; forgetting constraints; changing weights after scoring to make a favorite win.
Support / stretch: give the spreadsheet formula =B2+0.2*B2*(1-B2/C2). Stretch: add a random drought year with a 1-in-5 chance and run the model 20 times.