swine farm enterprise budget calculator

Swine Grower-Finisher Budget Revised: Aug '04 Numbers in blue can be edited/changed for individual producers. Market Information Market Pig Price ($/ckg, 100 index) 188.74 $ Market Pig Index 108.8 Live Weight (kg) @80% dressing %age 112 Market Pig Dressed Weight (kg) 89.6 Market Pig Value ($/pig) 184.96 $ Grid Premium ($/pig) 1.00 $ # of Feeder Pigs Purchased/Placed on Feed 6,700 Feeder Pig Price ($/kg) 2.81 $ Feeder Pig Value ($/pig) 75.87 $ Feeder Pig Weight (kg) 27 Grower-Finisher Barn Performance Number of Pig Spaces 2,000 Number of Turns per Pig Space per Year 3.25 Number of Weeks per Turn 16 Pig Space Utilization 100% Grower-Finisher Death Loss & Culls (%) 3.0 Number of Market Pigs Sold 6,499 Number of Days to Market Weight 98 Average Daily Gain (grams per day) 867 Feed Conversion 2.80 Feed per Pig (kg) 242 Feed Cost per Tonne 258 $ Feed Cost per Pig Sold 62.33 $ Other Variable Costs $/Pig Sold or $/Year $/Pig Sold Total $ Health -$ or 14,600 $ 2.25 $ 14,600 $ Marketing & Trucking 2.47 $ or -$ 2.47 $ 16,020 $ Custom Work (i.e.. Manure Handling) -$ or 2,700 $ 0.42 $ 2,700 $ Labour (Wages, Benefits, Salaries) -$ or 29,250 $ 4.50 $ 29,250 $ Building & Equipment Repair -$ or 3,300 $ 0.51 $ 3,300 $ Utilities (Hydro & Gas & Telephone) -$ or 8,100 $ 1.25 $ 8,100 $ Other (Supplies, Deadstock, Vehicle, Office, etc.) -$ or 3,250 $ 0.50 $ 3,250 $ Operating Loan Interest -$ or 7,500 $ 1.15 $ 7,500 $ Fixed Costs $/Pig Sold or $/Year $/Pig Sold Total $ Depreciation on Buildings and Equipment -$ or 26,300 $ 4.05 $ 26,300 $ Long Term Interest -$ or 37,200 $ 5.72 $ 37,200 $ Property Taxes & Insurance -$ or 6,600 $ 1.02 $ 6,600 $ Summary $/pig Sold Total Income 184.96 $ 1,202,055 $ less Feeder Pig Cost 78.22 $ 508,329 $ less Feed Cost 62.33 $ 405,083 $ less Other Variable Costs 13.04 $ 84,720 $ Operating Margin 31.38 $ 203,923 $ less Fixed Costs 10.79 $ 70,100 $ Net Return 20.59 $ 133,823 $ Breakeven 167.61 $ 164.37 $ $/pig Sold 1,068,232 $ Total 32.19 $ 11.07 $ 21.13 $ 80.25 $ 63.95 $ $/ckg, 100 index 189.77 $ 13.37 $ plus premium of $1 per pig $/ckg, 100 indexSwine Grower-Finisher Budget Revised: Aug '04 Risk Analysis Expected returns are subject to the risk of fluctuations in both revenue and costs. Increases in market prices, decreases in feeder prices and decreases to your cost of production will have positive impacts on your net return. Conversely, market price decreases, increases in feeder prices and increases to your cost of production will have negative impacts on your net return. The expected values that you inputted above for the key grower-finisher risk variables are displayed below on the left. Change the key risk variables identified for the grower-finisher enterprise in the cells provided to see how they will affect your outcomes. The boxes shaded in yellow are your original numbers from the budget; the blue shaded boxes display the results of your changes made to the risk variables. Change Expected values (from above): Key Grower-Finisher Risk Variables: Results of the change: original Market Price ($/ckg, 100 index) 189 $ Market Price ($/ckg, 100 index) 174 $ Feeder Pigs Purchased 6,700 Feeder Pig Price ($/kg) 2.81 $ Feeder Pig Price ($/kg) 2.70 $ Market Pigs Sold 6,499 Feed Cost ($/tonne) 258 $ Feed Cost ($/tonne) 245 $ Feed Conversion 2.80 Feed Conversion 2.80 Feed per Pig (kg) 242 Death Loss & Culls (%) 3.0 Death Loss & Culls (%) 3.00 Turns per Pig Space/Year 3.25 Number of Weeks per Turn 16.0 Number of Weeks per Turn 16.0 Expected Outcomes $/pig sold New Outcomes $/pig sold Income 184.96 $ Income 170.59 $ (14.37) $ less Feeder Pig Cost 78.22 $ less Feeder Pig Cost 75.15 $ (3.06) $ less Feed Cost 62.33 $ less Feed Cost 59.18 $ (3.15) $ less Other Variable Costs 13.04 $ less Other Variable Costs 13.04 $ -$ Operating Margin 31.38 $ Operating Margin 23.22 $ (8.16) $ less Fixed Costs 10.79 $ less Fixed Costs 10.79 $ -$ Net Return 20.59 $ Net Return 12.43 $ (8.16) $ Breakeven 164.37 $ Breakeven 158.16 $ (6.21) $ Breakeven Price ($/ckg, 100 index) 167.61 $ Breakeven Price ($/ckg, 100 index) 161.24 $ Net Return 20.59 $ Net Return 12.43 $ Developed by: John Bancroft, Swine Specialist, Grower-Finisher John Molenhuis, Business Analysis and Cost of Production Program Lead For more information contact: Agricultural Information Contact Centre 1-877-424-1300 ag.info@omaf.gov.on.ca www.omaf.gov.on.ca Change (8) $ Change no change no change no change no change changed to