1
Trend · last 12 months
Milk per cow per day, actual vs weather-adjusted
Heat penalty removed above THI 68 so the herd's real trend is visible under a Panhandle summer
Actual lb/cow/dayWeather-adjustedBudget 80 lbTemperature-humidity index (THI)
2
What this board answers
Three questions from the discovery call
Signature view · site coverage
Dairies and irrigated farm ground across Texas, New Mexico and Kansas
Marker size = milking cows · fill = cost per cwt vs budget · each pivot circle ≈ 1,000 acres of feed ground · click a dairy to filter
At or under budgetOver budget cost/cwtNot in baseline (heifer yard · Twin Circle KS ramping · Westland NM · management)Pivot (~1,000 ac)
3
Input costs vs budget
Cost per cwt by category
Feed, labour, fuel & energy, repairs, crop inputs, other — actual against the $19.00 plan
Actual under budgetActual over budgetBudget
4
Ranking · by dairy
Cost per cwt and milk per cow, best to worst
| Dairy | Cows | lb/cow/d | Feed $/cwt | Total $/cwt | vs $19.00 budget |
|---|
5
Farming units · feed grown
Harvest by crop and days of feed on hand
Corn & sorghum silage, alfalfa, triticale/wheat, haygrazer from the farms supplying the selected dairies
| Crop | Acres | t/acre | Tons in period | Share of harvest |
|---|
6
Data capture · replaces the spreadsheet
Daily parlor log, submitted from a phone
A Power Apps / Microsoft Forms tile the herdsman fills at end of shift; it lands in the model directly
Parlor log · PM shiftAuto-synced
High Plains Dairy
Sat 5 Sep 2026
4,790
386,240
168
132.4
Pen 7 fans out 40 min — maintenance ticket raised
Submit log
Phone form→Dataverse→Power BI model→This board, 06:00 daily
7
Ask the data · AI layer
Plain-English questions over the same model
A typed question, answered with figures and a pointer to the panel that proves it
Which dairy had the highest feed cost per cwt this summer, and what drove it?
8
