Free Web Hosting by Netfirms
Web Hosting by Netfirms | Free Domain Names by Netfirms

SHEEP FARMING BUDGET WORKSHEET

 

This worksheet has been compiled to assist farmers with financial planning. A number of assumptions have been made in its construction. The main assumption is that natural increases are based on "opening stock" only. This means that any purchases of breeding ewes will not automatically calculate the production of lambs. We have put this page onto the net as a practice run but will continue to fine tune and make improvements in the future.
Give this one a try by filling in the data boxes showing a zero balance only. Once this has been done, press the calculate button at the bottom of the page. Please contact us if you have any comments or suggestions that may be useful in improving this budget.
STOCK RECONCILIATION
A SIMPLE SHEEP BUDGET FORECAST
 Average Lambing % (survival to sale)
Death Rate % Ewes
 Death Rate % other sheep
 
 
Opening Stock
(A)
Purchases

(B)
Natural Increase

(C)
Deaths

(E)
Sales

(F)
Closing Stock

(G)
 Breeding Ewes
 
 2T Ewes
 
 Ewe Hoggets
 
 Wether Hoggets
 
 Others
 
 Ewe lambs  
 
 
 Wether lambs  
 
 
 Rams
TOTAL  
             
 
The livestock reconciliation must balance to zero after the "calculate" button has been pressed..
A+B+C
 
 
D+E+F
 
   
BALANCE:
 
Financial Analysis          
 Sales:
Number
Price/head
Total
     
 Breeding ewes
     
 2T Ewes
     
 Ewe hoggets
     
 Wether hoggets
     
 Other sheep
     
 Ewe lambs
     
 Wether lambs
     
 Rams
     
 
Total Livestock Sales
  Back to the top  
 WOOL SALES:
Kilos
Price/kg
Total
     
 Main Line
     
 Lambs wool
     
 Seconds etc
     
 
Total wool revenue
     
             
 
TOTAL SALES
     
 Livestock Purchases          
 
Number
Price
Total
     
 Breeding ewes
     
 2T ewes
     
 Ewe hoggets
     
 Wether hoggets
     
 Other sheep
     
 Ewe lambs
     
 Wether lambs
     
 Rams
     
  Total livestock purchases
  Back to the top  
 
GROSS PROFIT
     
 DIRECT COSTS            
 Animal health
         
 Veterinary fees
         
 Shearing Costs
         
 Wages of management
         
 Wages/salaries
       
 Other Costs
         
 Interest
         
TOTAL EXPENDITURE
  Back to the top  
 
SURPLUS/DEFICIT
 
             
 
PLEASE NOTE: The above surplus/deficit may not necessarily reflect the true net profitability of the enterprise. An adjustment may need to be made to take into account possible increase or decrease in livestock numbers and categories. Market value fluctuations may have also changed over the farming period. We are currently working on a new format to take these factors into account.
 
   
 

Click Here!