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. |