Tools & Resources

Dairy Management Spreadsheets 

• Dairy Trends.pdf

  Western Dairy Accounts Dec. 2010

• AnnCost.xls

  Calculates Annual Cost of Machinery/Equipment for n years

• BudgCS.xls

  Corn Silage Budget from Extension Service

• BudgCow.xls

  Dairy Budget from Extension Service - 1 year, cash flow, ration feeds

• BudgGraze.xls

  Dairy Grazing Budget - Extension Service, cash flow

• BudgHeif.xls

  Dairy Calf / Heifer Budget - Extension Service, cash flow

• BudgHeifByAge.xls

  Dairy Calf / Heifer Budget - Extension Service, cash flow, by ages

• BudgPast.xls

  Pasture Budget - Extension Service

• BudgCowNC2011.xls

  Cash Flow Budget for North Carolina 2011

• BudgWest.xls

  Cow Enterprise Profit-Loss - accounting firm format, multiple years

• BudgWisc.xls

  Dairy Cow Profit-Loss - by enterprises, by herd, cow, and cwt milk

• Concrete.xls

  Estimate cost of concrete

• CropNPk.xls

  Compute manure nutrients and crop acreage to utilize them

• DecChart.xls

  Score and weight decision alternatives (goals)

• Decal.xls

  Decision Analysis - Time value conversions and business measures

• Decal2010.xls

  Decal with Rate of Return macro for Excel 2007 or later

• FinStmts.xls

  Financial Statements: Cash Flow, Profit-Loss, Networth

• LeaseBuy.xls

  Compare lease to buy based on net cost

• LoanTax.xls
  Amortize and evaluate loans, w/ tax deductions (annual/monthly)

• MilkCommissionBase.xls  |  article
  A Decision Making Tool to Determine the Feasibiliy of Purchasing Virginia Milk Commission Base
  

• ParlorComparisons.xls
  Size a parlor, change herd size, compare effic and costs including milking labor

• Pbudget.xls

  Five or 10-year partial budget for changes (cash flow and net worth)

• PlanCash.xls

  5 years of cash flow and profit-loss along with a herdsize sheet for planning

• PlanHerdSize.xls

  Herdsize calculations for new, continuing or expanded herd

• PlanOptimumGroups.xls

  Plan group sizes for optimum parlor use and net income

• PlanWaste.xls

  Estimate volume of manure and waste water and necessary storage

• PropBuy.xls

  Projected costs of purchasing property with a mortgage

• PropBuy2010.xlsm

  PropBuy with macros for Excel 2007 and more recent

• Refinance.xls

  Compares a loan to a refinanced loan

• SiloCap.xls

  Capacities of silos and bags for various feeds (includes cost/T dry matter)

• TaxDepr.xls

  Calculation and value of depreciation for income taxes

  For MORE budget spreadsheets and information, visit
  https://pubs.ext.vt.edu/446/446-048/446-048.html

American Registry of Professional Animal Scientists

Animal Improvement Programs Laboratory

Dairy Commodities

Dairy Farming Today

Mid-Atlantic Water Program

Natural Resources Conservation Service

Natural Resource, Agriculture, and Engineering Service

Dairy Calf and Heifer Association (formerly PDHGA)

Searchable Proceedings of Animal Conferences

Southeast Quality Milk Initiative (SQMI)

Southeast United Dairy Industry Association, Inc.

USDA

USDA Agricultural Marketing Service

USDA Dairy Industry Data

USDA Economic Research Service

USDA National Agricultural Library

Virginia Department of Conservation & Recreation

Virginia Department of Agriculture and Consumer Services

Virginia Milk Commission

Waste Solutions Forum

Preventing silage-related injuries and fatalities among farm workers

Winter Crops as a Feed Source for Dairy Cattle

Determining Harvesting Time for Corn Silage

Management of compost-bedded pack barns

Manejo del becerro recién nacido - Newborn calf management

In the spring of 2020, we hosted short calls at noon each Friday to update dairy producers in Virginia on current topics.  Available recordings for those calls are linked below.

April 24: Jeremy Daubert, VCE, "What can extension do for you?

May 1: Elizabeth Moretz, The Dairy Alliance, "Dairy Promotion"

May 8: Eric Paulson, Virginia State Dairymans Association, "Dairy Policy Updates"

May 15: Christinia Petersson-Wolfe, Virginia Tech, "Mastitis Reduction Tips"

May 22: Gonzalo Ferriera, Virginia Tech, "Forage Quality"

May 29: Dave Winston, Virginia Tech, "Dairy Records Key Indicators"

June 12: Jeff Bewley, Alltech, "Lean Dairy Management"

June 19: Christine Brodeur, DFA, "Milk Contracting Basics"

June 26: Jeremy Daubert, VCE, "Heat Stress Strategies"

July 3: Michele Payn, Cause Matters, "Communicating Science to the Public"

July 10: Joe Dalton, University of Idaho, "Strategies for using Beef on Dairy"