My image

Dairy Marketing Tools

Home

Understanding Dairy Markets

Information Center

Login

Register

My image My image

Apply economic theory to quantify a dairy operation with easy-to-use software. Spreadsheet tools are publicly available. Register for free to use interactive online applications with built in data storage, technical support, customization, and printer-friendly graphics.

Note on browser compatibility - We recommend using Google Chrome to access this domain. Most content is available through Mozilla Firefox but some features of some applications will not work correctly. Content is also available via Microsoft Edge but applications are untested.

Applications Requiring Registration

Login

Mailbox Milk Price Forecaster

▼ ▲

Livestock Gross Margin - Dairy Analyzer: New Version

▼ ▲

Feedcost Forecaster - Coming Soon

▼ ▲

Income Forecaster - Coming Soon

▼ ▲

Mailbox Price Forecaster

Using personalized dairy farm data, obtain a mailbox price forecast for the next 12 months from the date of analysis. Enter monthly mailbox prices (required), fat %s (optional) and protein %s (optional). Mailbox price data is the basis of the forecast model. Component %s improve the accuracy of the forecast but are not required for analysis.

The mailbox price data and component %s (optional) are used to quantify the historical relationship between mailbox price and the Announced Class III and IV prices. This relationship is applied to the most recent Class III and Class IV futures market settlement prices to estimate the monthly mailbox prices for the next 12 months. Variability in the dairy market is automatically taken into account to generate realistic forecast models.

Register for free to use the mailbox price predictor. Setting up a confidential account allows for storage and modification of 10+ years of data. Readily export data to personal machines for offline analysis. At least 3 years of mailbox prices is recommended before applying this model to an analysis of your operation. More data points and the use of component %s increases the accuracy of mailbox price forecasts.

Livestock Gross Margin - Dairy Analyzer

The LGM-Analyzer is a software suite developed at the University of Wisconsin that assists in the use of the Livestock Gross Margin for Dairy (LGM-Dairy) insurance program for revenue risk management. The user can evaluate the performance and cost of LGM-Dairy either using historical data or, in anticipation of the upcoming LGM-Dairy contract offering, the cost of a yet-to-be LGM-Dairy offering.

Contracts are user defined in terms of independent month-month coverage and deductible level.

Public Software

No Account Setup Required

Livestock Gross Margin - Dairy Analyzer: Old Version

▼ ▲

Federal Advanced and Announced Prices

▼ ▲

Minimum Mandated Price for Class III Milk

▼ ▲

Value of Milk Used in Cheese Production

▼ ▲

Mailbox Milk Price Forecaster (Lite)

▼ ▲

Tool 6

My image

Tool 7

My image

Tool 8

My image

Livestock Gross Margin - Dairy Analyzer

The LGM-Analyzer is a software suite developed at the University of Wisconsin that assists in the use of the Livestock Gross Margin for Dairy (LGM-Dairy) insurance program for revenue risk management. The user can evaluate the performance and cost of LGM-Dairy either using historical data or, in anticipation of the upcoming LGM-Dairy contract offering, the cost of a yet-to-be LGM-Dairy offering.

Contracts are user defined in terms of independent month-month coverage and deductible level.

This version of the software is depreciated and will soon be taken down. Use the version on this domain linked in the Registered Software section.

Federal Milk Marketing Order: 2000-Present

Excel File Used to Calculate Class I Price Mover, Class II, Class III and Class IV Prices, Advance Pricing Factors and Component Prices. The only information required to estimate either Advanced or Announced prices are the 2-week or monthly product price averages, respectively.

Probability of Obtaining a Minimum Class III Value

This spreadsheet file can be used to obtain an estimate of the probability of obtaining a particular Class III value or greater. With the seasonal model, season specific means and standard deviations are used (Winter = Dec, Jan & Feb; Spring = Mar, Apr & May; Summer = Jun, Jul, & Aug; Fall = Sept, Oct, & Nov)

Determine Value of Milk Used in Cheese Manufacturing

This spreadsheet uses the Van Slyke Cheese yield formula to allocate the value of cheese, whey and other products from cheese manufacturing to fat and protein components of milk.

Mailbox Milk Price Forecaster (Lite)

* This is the spreadsheet version. To use the full online version go to the registered applications section.

Using personalized dairy farm data, obtain a mailbox price forecast for the next 12 months from the date of analysis. Enter monthly mailbox prices (required), fat %s (optional) and protein %s (optional). Mailbox price data is the basis of the forecast model. Component %s improve the accuracy of the forecast but are not required for analysis.

The mailbox price data and component %s (optional) are used to quantify the historical relationship between mailbox price and the Announced Class III and IV prices. This relationship is applied to the most recent Class III and Class IV futures market settlement prices to estimate the monthly mailbox prices for the next 12 months. Variability in the dairy market is automatically taken into account to generate realistic forecast models.

At least 3 years of mailbox prices is recommended before applying this model to an analysis of your operation. More data points and the use of component %s increases the accuracy of mailbox price forecasts.

Tool 6

My image

Description:

Usage:

Requirements:


Tool 7

My image

Description:

Usage:

Requirements:


Tool 8

My image

Description:

Usage:

Requirements:


Brian Gould   Extension Program   University of Wisconsin-Madison   Department of Agriculture and Applied Economics