Milk Powder production cost estimation - MILK POWDER PRODUCERS
Input into the yellow cells: Complete ALL inputs and click submit button at the base of the column
This spreadsheet should be used to visualise the effect of volume, SNF, Fat content, milk price, selling price and solids recovery etc
Entering accurate data will give you a good indication for profit / loss on skimmed milk powder and cream manufacturing
This calculator is for indication only and you should establish your own costs and yields
 
If you see any errors or ommissions we would be pleased to have your feedback
   
Profit  / loss
Margin on operation
Raw Milk KG per annum (eg 100,000,000kg)
kg
     
Raw Milk Fat % (eg 3.92%)
% Fat
     
Raw Milk Solids Not Fat % (eg 8.65%)
% SNF
     
Raw milk price / kg milk (eg 30.12 euro cents)
Cents
     
Skim Milk Powder Market Price eg €3000 / tonne
Tonne
     
Cream market price/kg (eg €1.01 /kg at Fat % entered below as Target Cream Fat %)
Euros
% Fat  
Skimmed Milk Powder moisture (eg 3.5%)
%
     
Process losses estimate (e.g. Excellent 0.5% Bad 5%)
%
     
Est Total Solids Recovery / Yield
       
Cream total kg recovered
kg
% Fat  
Cream Selling Price / 1% fat
Euro
     
Liquid Skimmed milk Fat % (e.g. 0.05)
% Fat
     
Target Cream Fat %
% Fat
     
Liquid Skimmed Milk kg recovered
kg
     
Total solids available;
kg
     
Total Skimmed Milk Powder produced
kg
% Moisture  
TOTAL Skimmed milk powder sales value
       
TOTAL cream sales value
       
Total Sales Value of SMP + Cream
       
TOTAL Raw Milk cost
  Milk cost as % of sales value
Margin on milk
  Margin on milk cost
Fixed Cost (enter annual overhead est eg €2,500,000)
       
Variable cost % (enter % based on activity level, eg. 5% to 10% of annual sales value)
% The higher the activity generally the lower the variable cost expressed as a % of Total Sales
MILK POWDER PRODUCERS
Contact John Watson

John Watson
Office: +44 1224 861 507
Mobile: +44 7931 776 499
jw@dairyconsultant.co.uk

Testimonials

We are a longstanding member of the Society of Dairy Technology and have Fellowship of the Institute of Food Science and Technology.

 

Dairy Consultant Locations
Copyright © 2017 - JWC Services Limited Registered in Scotland No. SC246124