GBAZ
Template by Goat Breeders Association of Zimbabwe

Mortality and Cull Record

Every death, cull, theft or loss in one place with cause, age, whether it was reported to the veterinary office and the value lost. The sheet calculates mortality percentage against your average flock size and summarises losses by cause.

Mortality and Cull Record
What you get

2 files to download

  • XLSXExcel workbook (.xlsx)
  • PDFPrint-ready PDF (A4)

Downloads unlock on your private order page as soon as payment is confirmed, and a link is emailed to you.

Every death, cull, theft or loss in one place with cause, age, whether it was reported to the veterinary office and the value lost. The sheet calculates mortality percentage against your average flock size and summarises losses by cause.

What is included

  • Excel workbook (.xlsx) with 2 data sheets (Mortality and Culls, Losses by Cause), an Instructions sheet and a Lists sheet that feeds the drop-downs. Opens in Excel 2010 or later, LibreOffice and Google Sheets.
  • Print-ready A4 PDF (landscape) with GBAZ branding, ruled rows, an instructions panel and a notes box on every page.
  • Farm details block, yellow input cells, drop-down lists, data validation, frozen headers, filters and print titles on every sheet.

Mortality and Culls

Record each animal that leaves the flock through death, culling, theft or loss. Give the date of birth so the age at loss is calculated. Type your average flock size for the year in the yellow cell to get the mortality percentage. Report sudden deaths, abortions and suspected notifiable diseases (anthrax, rabies, foot and mouth) to the Department of Veterinary Services and record that you did.

Columns: Date, Tag ID, Class, Breed, Date of birth, Type of loss, Cause of death, Cull reason, Post-mortem done?, Reported to DVS?, Value lost (USD), Cull income (USD), Signs seen, carcass disposal, notes. Calculated: Age (months).

Summary cells: Average flock size (you enter); Deaths; Culls; Stolen or lost; Mortality % (deaths per average flock); Kid deaths (under 6 months); Value lost (USD); Cull income (USD).

Losses by Cause

This table fills itself from the Mortality and Culls sheet. Use it with your veterinarian or extension officer to decide where to act first: the top one or two causes usually account for most losses.

Columns: Cause of death. Calculated: Deaths, Share of deaths, Value lost.

Formulas

Age at loss uses DATEDIF(date of birth, date, "m"); deaths, culls and losses use COUNTIF; kid deaths use COUNTIFS; mortality % = deaths / average flock size; value lost and cull income use SUM; the Losses by Cause sheet uses COUNTIF and SUMIFS.

Benchmarks and good practice

  • A well-managed flock loses under 5 percent of adults and under 15 percent of kids a year. Communal flocks in Zimbabwe often lose 20 to 40 percent of kids: most deaths are preventable (pulpy kidney, heartwater, worms, pneumonia, poor kidding pens).
  • Mortality % = deaths in the period divided by the average number of goats in the period. Calculate it separately for kids and adults when you can.
  • Have a post-mortem done on sudden deaths: the cause changes the action (vaccinate, dip, drench or change feeding).
  • Cull on records, not sentiment: does that fail to kid twice, lose kids twice, or need dosing at every FAMACHA check.

Layouts follow the record books recommended by extension services (FAO, ILRI, Heifer International Zimbabwe, Cornell Small Farms, Uganda MAAIF and WormBoss guidance), adapted for Zimbabwean goat breeders by GBAZ.

Seller

Goat Breeders Association of Zimbabwe

Sold on the GBAZ platform on behalf of Goat Breeders Association of Zimbabwe, who delivers the product.

More from the shop

WhatsApp support