Docstoc

swine farm enterprise budget calculator - Excel

Document Sample
swine farm enterprise budget calculator - Excel Powered By Docstoc
					Swine Grower-Finisher Budget
Numbers in blue can be edited/changed for individual producers. Market Information
Market Pig Price ($/ckg, 100 index) Market Pig Index Market Pig Dressed Weight (kg) Grid Premium ($/pig) # of Feeder Pigs Purchased/Placed on Feed Feeder Pig Price ($/kg) Feeder Pig Weight (kg) $ $ $ 188.74 108.8 89.6 1.00 6,700 2.81 27 Feeder Pig Value ($/pig)

Revised:

Aug '04

Live Weight (kg) @ 80% dressing %age Market Pig Value ($/pig) $

112 184.96

$

75.87

Grower-Finisher Barn Performance
Number of Pig Spaces Number of Weeks per Turn Grower-Finisher Death Loss & Culls (%) Number of Days to Market Weight Feed Conversion Feed Cost per Tonne $ 2,000 16 3.0 98 2.80 258 Number of Turns per Pig Space per Year Pig Space Utilization Number of Market Pigs Sold Average Daily Gain (grams per day) Feed per Pig (kg) Feed Cost per Pig Sold or or $ $ $ 3.25 100% 6,499 867 242 62.33

Other Variable Costs
Health Marketing & Trucking Custom Work (i.e.. Manure Handling) Labour (Wages, Benefits, Salaries) Building & Equipment Repair Utilities (Hydro & Gas & Telephone) Other (Supplies, Deadstock, Vehicle, Office, etc.) Operating Loan Interest

$/Pig Sold
$ $ $ $ $ $ $ $ -

$/Year
14,600 2,700 29,250 3,300 8,100 3,250 7,500 $ $ $ $ $ $ $ $

$/Pig Sold
2.25 2.47 0.42 4.50 0.51 1.25 0.50 1.15 $ $ $ $ $ $ $ $

Total $
14,600 16,020 2,700 29,250 3,300 8,100 3,250 7,500

2.47 or -

or $ or $ or $ or $ or $ or $ or or $ or $ or $

Fixed Costs
Depreciation on Buildings and Equipment Long Term Interest Property Taxes & Insurance

$/Pig Sold
$ $ $ -

$/Year
26,300 37,200 6,600 $/pig Sold $ $ $ $ $ $ $ $ 164.37 184.96 78.22 62.33 13.04 31.38 10.79 20.59 $ $ $ $

$/Pig Sold
4.05 5.72 1.02 $ $ $

Total $
26,300 37,200 6,600

Summary
Income less Feeder Pig Cost less Feed Cost less Other Variable Costs Operating Margin less Fixed Costs Net Return Breakeven $ 167.61

$/ckg, 100 index $ $ $ $ $ $ $ 189.77 80.25 63.95 13.37 32.19 11.07 21.13

Total
$ $ $ $ $ $ $ 1,068,232 1,202,055 508,329 405,083 84,720 203,923 70,100 133,823 Total

$/ckg, 100 index

$/pig Sold

plus premium of $1 per pig

Swine Grower-Finisher Budget Risk Analysis
Expected returns are subject to the risk of fluctuations in both revenue and costs.

Revised:

Aug '04

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): Market Price ($/ckg, 100 index) Feeder Pig Price ($/kg) Feed Cost ($/ tonne) Feed Conversion Death Loss & Culls (%) Number of Weeks per Turn Expected Outcomes Income less Feeder Pig Cost less Feed Cost less Other Variable Costs Operating Margin less Fixed Costs Net Return Breakeven $ $ $ Key Grower-Finisher Risk Variables: 189 Market Price ($/ckg, 100 index) 2.81 Feeder Pig Price ($/kg) 258 Feed Cost ($/ tonne) 2.80 Feed Conversion 3.0 Death Loss & Culls (%) 16.0 Number of Weeks per Turn $/pig sold $ 184.96 $ $ $ $ $ $ 78.22 62.33 13.04 31.38 10.79 20.59 $ $ $ Results of the change: 174 Feeder Pigs Purchased 2.70 Market Pigs Sold 245 2.80 Feed per Pig (kg) 3.00 Turns per Pig Space/Year 16.0 New Outcomes Income less Feeder Pig Cost less Feed Cost less Other Variable Costs Operating Margin less Fixed Costs Net Return Breakeven $ $ $ $ $ $ $ $ $/pig sold 170.59 75.15 59.18 13.04 23.22 10.79 12.43 158.16 $ $ $ $ $ $ $ $ Change (14.37) (3.06) (3.15) (8.16) (8.16) (6.21) 242 3.25 no change no change original 6,700 6,499 changed to no change no change

$ 164.37

Breakeven Price ($/ckg, 100 index) Net Return

$ 167.61 $ 20.59

Breakeven Price ($/ckg, 100 index) Net Return

$ $

161.24 12.43 $

Change (8)

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

changed to no change no change

no change no change

Change

Change $ (8)

Information Contact Centre

1-877-424-1300

nfo@omaf.gov.on.ca

ww.omaf.gov.on.ca


				
DOCUMENT INFO
Shared By:
Stats:
views:2182
posted:2/9/2008
language:English
pages:2