Calf Milk Pasteurization Evaluator
Excel spreadsheet that calculates the cost of owning and operating a calf milk pasteurizer as well as costs to feed milk replacer or whole, saleable milk. The spreadsheet also provides a comparison of the nutrients provided by milk replacer, waste milk, and whole milk. All nutrient values can be edited to compare a variety of feeding programs. The cost of each feed is expressed on a crude protein basis for comparison of cost-to-value. Additionally, the spreadsheet offers tables that compare the costs of alternatives to feeding pasteurized milk when the supply of waste milk is not adequate to feed all calves. The final components of the spreadsheet are two simple calculators that estimate the supply of and demand for waste milk and calculate the amount of powder to add to waste milk to increase solids or volume. The spreadsheet was updated July 1, 2009 to include a total solids estimation equation for Brix refractometers.
pasteurizer.xls
—
Microsoft Excel spreadsheet,
629 kB (644096 bytes)
