Pig Production Environmental Footprint Calculator Input Entry Worksheet

Data needed to run the calculator is information you know or have available in your farm records. This worksheet will help you assemble the information so it is readily available as you use the calculator.

Farm location

-State ______County ______

-Premises ID ______

Water Sources

-The percentage of source water that comes from:

  • on-farm wells ______%
  • on-farm surface water sources ______%
  • piped in from off-farm sources (municipal/rural water) ______%

-If a well is used, the well depth ______Ft

-Distribution pump horsepower ______HP

-Distribution pump maximum flow rate in gallons per minute ______GPM

Farm Inputs

-Feed delivered to the farm

  • one-way distance from feed mill supplying feed to the farm ______Miles
  • amount of feed delivered per load in pounds ______Lbs

-Manure transport to fields

  • hauled (trucks/tankers/wagons) or pumped(pipe/hose) ______
  • percent solids content of manure ______%

-If manure is hauled to fields

  • average distance from farm to application fields in miles ______Miles
  • average amount of manure hauled per load in pounds ______Lbs

-If manure pumped to fields

  • pumping rate in gallons per minute ______GPM
  • pump horsepower ______HP
  • pump type (gas/diesel/electric) ______

-If on-farm solar panels are used to supply power to all or portions of the barns

  • total square feet of solar panels on-farm ______Sq. Ft.
  • rated percent solar panel efficiency ______%

-Management of dead animals (rendering/compost/incineration) ______

Barn Inputs

-Barn dimensions in feet

  • length ______
  • width ______
  • ceiling height ______

-Animals

  • For nursery/wean to finish/grow to finish/finish barns
  • number of pigs entering barn each cycle ______
  • average weight pigs entering barn ______Lbs
  • average weight pigs leaving barn ______Lbs
  • average death loss per cycle (number of mortalities) ______
  • percent of pigs each cycle that leave the farm ______%
  • percent of pigs each cycle that enter another barn on-farm ______%
  • days for barn cleaning between cycles ______
  • For sow/gestation/farrowing barns
  • number of adult pigs kept in barn ______
  • number of gilts added to barn each year ______
  • average age of adult pigs added to barn ______days
  • average weight of adult pigs added to barn ______Lbs
  • average days elapsed between delivery of adult pigs to barn ______days
  • average days fromadult pigs entering barn to insemination ______days
  • average number of adult pigs that die in barn each year ______
  • average number of adult pigs culled from barn each year ______
  • number of days lapsed between culling of sows ______days
  • average number of piglets per litter that survive to weaning______
  • average number of piglets per litter that do not survive to weaning______
  • average age of piglets removed from barn ______days
  • average days frompiglet removal to re-insemination of sows ______
  • percent of pigs each cycle leaving the farm ______%
  • percent of pigs each cycle entering another barn on-farm ______%

-Feeds

  • number of feed phases ______
  • feed composition of each phase by percent of total feed

-NOTE: The feed section allows a user the ability to enter a set value for Average Daily Gain (ADG) and Feed Conversion Rate (FCR).Users are encouraged to first run the model without setting these values to allow the model to predict ADG and FCR values which can then be compared to known or target values.IF a user sets ADG and FCR values the model will perform up to 50 separate runs for each barn to come as close as possible to achieving the entered ADG and FCR values. Depending on the number of barns on-farm this may require a significantly greater run time than if the ADG and FCR values were allowed to be calculated by the model.

-Heating/Cooling/Lighting

  • Insulation R values for walls/curtains and ceiling of barn ______
  • Ventilation
  • number of fans ______throughput CFM ______fanwatts ______
  • number of fans ______throughput CFM ______fan watts ______
  • number of fans ______throughput CFM ______fan watts ______
  • Barn heater rating BTU/HR ______
  • Lighting sources watts (total of number of bulbs x bulb wattage)
  • watts of lights left on 24Hr/day ______
  • watts of other lights used ______Hr/day used______

Setting Prices

For both the on-farm and feed ingredient prices you will have the option ofeither having the calculator load average prices for the area where the farm is located or entering your farm-specific prices. You may load the average prices and change selected values to your known farm-specific prices where you have that information available.

1