AMPE and MCVE calculator

Updated 21 January 2021

This downloadable spreadsheet allows you to create AMPE and MCVE market indicators for your own data.

Whether you’re a farmer looking to see what impact higher butterfat and protein figures might have on the value of your milk to your customer, or a processor wanting to benchmark yourself against our market indicator – our new tool is now available for use.

There are a multitude of assumptions that go into our AMPE and MCVE market indicators, including, but not limited to:

• Compositional quality of the milk,
• Manufacturing costs for each product,
• Market value of each product,
• By-products manufactured,
• Processing losses,
• Lactose standardisation, or not.

Now you can amend these assumptions to create your own unique AMPE or MCVE market indicator.

Enter as many personal parameters as you like, and the model will use our assumptions to fill in any gaps.

You can also include a processing margin and/or the milk haulage cost from farm to factory to create a farm-gate price, if desired. Both of these elements are omitted from our headline prices.

We would welcome your feedback on this spreadsheet, including any suggestions for improving it in the future. So, if you have any comments or questions, please do not hesitate to get in touch.

While AHDB seeks to ensure that the information contained on this webpage is accurate at the time of publication, no warranty is given in respect of the information and data provided. You are responsible for how you use the information. To the maximum extent permitted by law, AHDB accepts no liability for loss, damage or injury howsoever caused or suffered (including that caused by negligence) directly or indirectly in relation to the information or data provided in this publication.

All intellectual property rights in the information and data on this webpage belong to or are licensed by AHDB. You are authorised to use such information for your internal business purposes only and you must not provide this information to any other third parties, including further publication of the information, or for commercial gain in any way whatsoever without the prior written permission of AHDB for each third party disclosure, publication or commercial arrangement. For more information, please see our Terms of Use and Privacy Notice or contact the Director of Corporate Affairs at info@ahdb.org.uk  © Agriculture and Horticulture Development Board. All rights reserved.