These Microsoft Excel Workbooks are designed to assist in the calculation of the Federal Order Prices, your milk check pay price, futures and options positions, MILCX payments.  Each workbook contains a set of basic set of instructions on its use however an intermediate knowledge of how to use a spreadsheet and in particular the product Microsoft Excel is assumed.  The user assumes all liability and responsibility for the use of these workbooks.  By downloading these files you are assuming all liability of use.  Each file is provided both as Microsoft Excel 1997-2003 and Microsoft Excel 2007 format.
 

Class 3 Price Database (Excel 2003) This MS Excel Workbook contains a historical Class 3 data series.	Class 3 Price Database (Excel 2007) This MS Excel Workbook contains a historical Class 3 data series.
Livestock Gross Margin - Dairy Calculator Version 1.0 (Excel 2003) This MS Workbook calculates the Livestock Gross Margin Insurance product for a dairy.  Calculations are included for margin, prices, estimated premium.	Livestock Gross Margin - Dairy Calculator Version 1.0 (Excel 2007) This MS Workbook calculates the Livestock Gross Margin Insurance product for a dairy.  Calculations are included for margin, prices, estimated premium.
MILC 2008 Payment Calculator Version 1.0 (Excel 2003) Wish to anticipate your MILC 2008 payment rate and revenue?  This MS Excel Workbook will help you forecast these numbers.	MILC 2008 Payment Calculator Version 1.0 (Excel 2007) Wish to anticipate your MILC 2008 payment rate and revenue?  This MS Excel Workbook will help you forecast these numbers.
What_IF_Futures&Options Calculator (Excel 2003) This MS Excel workbook calculates the potential outcomes for basic futures and options positions.	What_IF_Futures&Options Calculator (Excel 2007) This MS Excel workbook calculates the potential outcomes for basic futures and options positions.
Federal Order to Milk Check Calculator Version 2.0 This MS Workbook calculates the anticipated monthly milk check value or payment for a calendar year.  Input data requirements are (1) Milk Volume, (2) component percentages, (3) anticipated milk component prices, (4) somatic cell counts, (5) premiums, discounts, hauling charges.	Federal Order to Milk Check Calculator Version 2.0 This MS Workbook calculates the anticipated monthly milk check value or payment for a calendar year.  Input data requirements are (1) Milk Volume, (2) component percentages, (3) anticipated milk component prices, (4) somatic cell counts, (5) premiums, discounts, hauling charges.

**** DISCLAIMER *****

All workbooks are carefully checked for errors and omissions.  However, the author, nor The Ohio State University, provides any warranty as to the final accuracy of the workbooks and does not provide any warranty as to the final use of these workbooks.  All workbooks are subject to modification, change, or withdrawal without notice.