Estimate Template Excel 40798 | 2019 Bc Cow Calf Cop Budget V01

Partial file snippet.

Sheet 1: Objectives & Assumptions

	
	
	
	
		Study Objectives
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		The objective of the Planning for Profit Budget series is to provide information to assist producers in projecting direct costs, returns and most-likely contribution margin for British Columbia farm enterprises. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		This information is provided as one piece of the overall financial planning process to assist with decision making, monitoring and reviewing the whole ranch business. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		This information is only a guide and is not intended as an in-depth study of the cost of production for this industry.  
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		This budget is based on prevailing costs and prices at time of publication and will be different for each farm. It is intended to enable ranchers to estimate:
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		(1) the direct costs of equipment, materials, supplies, and labor required to raise calves on a well-managed ranch; and 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		(2) the ranges of revenues and production levels which would provide a positive contribution to indirect and overhead costs.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		The data used in this study was gathered from a group of experienced ranchers in the British Columbia Interior using modern management practices.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Their production practices and input requirements form the assumptions that were used to develop the enterprise budget.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Other individuals involved in the preparation of this study include government extension staff and industry professionals. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Additionally, the data represents what growers can expect the average costs and returns will be if
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		 no unforeseen failures occur such as adverse weather, predators, diseases etc.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		This publication does not necessarily represent any particular operation and is not intended to be a definitive guide to production practices.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		However, it describes current industry trends and, as such, can be helpful in estimating the physical and financial requirements of comparable ranches.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		It is important to note that this report uses a contribution margin approach and calculates the most-likely margin to cover direct expenses.   
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Indirect and overhead expenses such as: 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		depreciation, capital payments, interest, office expenses, general utilities, accounting, insurance, operator living expenses, etc. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		These expenses have not been included as they vary greatly from ranch to ranch. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Ranchers will need to develop their own budget that will include these costs to assess their overall financial profitability. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Given that there are many factors that can affect production costs and returns, individual ranchers can use this Excel Workbook to estimate their own costs and returns.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Additional financial planning information and farm enterprise budgets can be found online or from a local B.C. Ministry of Agriculture office.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Disclaimer: The Governments of Canada and British Columbia, and their directors, agents, employees, or contractors 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		will not be liable for any claims, damages, or losses of any kind whatsoever arising out of the use of, or reliance upon, this information.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Budget Assumptions
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		The following assumptions were used to provide a basis for the analysis:
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Cow Herd
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The ranch is located in the Southern Interior of British Columbia.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The ranch has a herd of 300 cows. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The cow to bull ratio is 20 to one.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The herd replacement rate is 15%.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Fifty-three heifer calves are kept for replacements: This is the combination of heifers required for herd replacement, plus the number of yearling heifers culled.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The cows commence calving on March 15th. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The weaning percentage expressed as the number of calves weaned as a percentage of cows overwintered was 92%. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Calves are sold in the fall (mid-October).
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The sale weight in 2018 for steers calves was 600 pounds and for heifers 550 pounds.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The average weight of the weaned heifers sold is based on the difference of 50 pounds between steers and heifers. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The heifers retained as replacements are assumed to weigh as much as the average weight of the steers.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The average selling prices for the fall of 2019 were $2.00 per pound for steers and $1.75 per pound for heifers. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The weaning percentage expressed as the number of calves weaned as a percentage of cows overwintered was 92%. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The ranch sells the animals through the local auction market.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Winter Feeding
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Winter feeding begins December 1 st and the last day of feeding is May 1st for a total feeding period of 151 days.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The total winter feed requirement for the herd is 864 tons of hay.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		On a per cow basis the winter feed requirement is 2.88 tons per cow.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Winter Feed Production
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The ranch has 275 acres of hay land. Of this, acreage 225 acres are in full production and 50 acres are in the establishment year. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		These hay stands are an alfalfa grass mix and the average yield is 3.5 tons per acre on the established stands and  
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		2.5 tons per acre on the new seedings.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The total hay produced on the ranch is 913 tons.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		A total of 900 tons of hay are required for feeding the herd and the remaining is carryover for next year. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		The hay land also provides aftermath grazing in the fall.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		This program is funded through the governments of Canada and British Columbia as part of the Canadian Agricultural Partnership, 
a five-year, $3-billion investment by federal, provincial and territorial governments to strengthen the agriculture and agri-food sector.
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		
 
		
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		
 
		
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		15)  The value of the land is not included.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

 


Sheet 2: Workbook Instructions

	
	
	
	
	
	
	
	
	
	
		Instructions for Using this Excel Workbook
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		1
		Individual ranches can use this Excel Workbook to estimate their own direct costs, returns and most-likely contribution margin. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		2
		This can be done by entering values that best reflect your situation in the green shaded cells of the Your Ranch column adjacent to the Budget 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		  column in the Your Ranch Input Tab and in the Hay and Pasture worksheets.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		3
		Initial default value in the Your Ranch column is the same as the data in the Budget column and can be changed.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		3
		This can be done by entering values that best reflect your situation in the green shaded cells of the Your Ranch column adjacent to the Budget column.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		4
		The revised value entered in the Your Ranch column of the Your Ranch Input Tab will then be recorded in the Your Ranch column of the 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		  Cow Calf Budget Summary Tab and will be used to calculate a revised contribution margin for Your Ranch.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Example: Your Ranch Input
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Budget
		Your Ranch
		

		

		Budget
		Your Ranch
		

		

		

		

		

		

		

		

		

		

	
	
		

		Average Weight (lbs.)
		 1,800 
		 1,800 
		

		Average Weight (lbs.)
		 1,800 
		 1,800 
		

		

		

		

		

		

		

		

		

		

	
	
		

		$ / lb.
		$1.00
		$1.00
		

		$ / lb.
		$1.00
		$1.25
		

		

		

		

		

		

		

		

		

		

	
	
		

		$ / Cull Bull
		$1,800
		$1,800
		

		$ / Cull Bull
		$1,800
		$2,250
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		5
		Values in the cells not shaded green cannot be changed.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		6
		The Hay & Pasture Required Worksheet Tab is provided to assist ranchers to calculate the costs of their Individual hay and Pasture calculations. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		The information developed for your ranch on this worksheet needs to be manually inputted in the Your Ranch Input Tab.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		7
		The Hay Production Worksheet Tab is provided to assist ranchers to calculate the costs of their Individual hay and Pasture calculations. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		The information developed for your ranch on this worksheet needs to be manually inputted in the Your Ranch Input Tab.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	



Sheet 3: Your Ranch Input

	
	
	
	
	
	
	
	
		

		300 Cow-Calf Ranch
		

		

	
	
		

		BC SOUTHERN INTERIOR
		

		

	
	
		

		

		

		Budget
		Your Ranch
		

		

	
	
		

		Cow Herd Information
		Number of Cows
		300
		300
		Required format for dates is month-day-year eg.:
		

	
	
		

		Cow Herd Information
		Weaning Percentage
		92.0%
		
		The percentage of calves which are weaned as a percent of the cows overwintered.
		92.0%
		With numbers for month, day and year
		

	
	
		

		Cow Herd Information
		Start Calving Date
		Mar-15-18
		
		The average calving date for the majority of the cows. This date has two purposes 1) to estimate the weight of calves t weaning time and 2) to establish the times for the rations to change to meet the needs of the cow at the different periods of gestation
		Mar-15-18
		Mar-15-2018 must be entered as 2018-03-15
		

	
	
		

		Cow Herd Information
		Weaning Date
		Oct-15-18
		
		The average weaning date. This date is used to estimate the weight of the weaned steers.
		Oct-15-18
		

		

	
	
		

		Cow Herd Information
		First Day of Feeding
		Dec-01-18
		Dec-01-18
		

		

	
	
		

		Cow Herd Information
		Last day of Feeding
		May-01-19
		May-01-19
		

		

	
	
		

		Cow Herd Information
		First day grazing
		May-01-19
		May-01-19
		

		

	
	
		

		Cow Herd Information
		Last Day grazing
		Dec-01-19
		Dec-01-19
		

		

	
	
		

		Cow Herd Information
		Days on Pasture
		214
		214
		

		

	
	
		

		Cow Herd Information
		Winter Feeding Period
		151
		151
		

		

	
	
		

		Cow Herd Information
		Herd Replacement
		15.0%
		
		The percentage of the cows which are culled
 each year. 
		15.0%
		

		

	
	
		

		Cow Herd Information
		Replacement Heifers Retained
		53
		53
		

		

	
	
		

		Cow Herd Information
		Heifer retention Rate
		85.0%
		85.0%
		

		

	
	
		

		Cow Herd Information
		Cow Death Loss %
		1.50%
		1.50%
		

		

	
	
		

		Cow Herd Information
		Cow Death Loss Head
		5
		5
		

		

	
	
		

		Cow Herd Information
		Cow Death Loss $
		$6,175
		$6,175
		

		

	
	
		

		Cow Herd Information
		Cow Bull Ratio
		20
		20
		

		

	
	
		

		Cow Herd Information
		Total Cow Breeding Herd
		353
		353
		

		

	
	
		

		Cow Herd Information
		Total Bull Breeding Herd
		18
		18
		

		

	
	
		

		Revenue Livestock
		Steers Sold
		138
		138
		

		

	
	
		

		Revenue Livestock
		Average Weight (lbs.)
		600
		600
		

		

	
	
		

		Revenue Livestock
		$ / lb.
		$2.00
		$2.00
		

		

	
	
		

		Revenue Livestock
		$ / Steer
		$1,200
		$1,200
		

		

	
	
		

		Revenue Livestock
		Total revenue from steers
		$165,600 
		$165,600 
		

		

	
	
		

		Revenue Livestock
		Heifers Calves Sold
		85
		85
		

		

	
	
		

		Revenue Livestock
		Average Weight (lbs.)
		550
		550
		

		

	
	
		

		Revenue Livestock
		$ / lb.
		$1.75
		$1.75
		

		

	
	
		

		Revenue Livestock
		$ / Heifer
		$963
		$963
		

		

	
	
		

		Revenue Livestock
		Total revenue from heifers
		$81,813 
		$81,813 
		

		

	
	
		

		Revenue Livestock
		Total/Cow
		$272.71 
		$272.71 
		

		

	
	
		

		Revenue Livestock
		Cull Yearling Heifers Sold
		8
		8
		

		

	
	
		

		Revenue Livestock
		Average Weight (lbs.)
		950
		950
		

		

	
	
		

		Revenue Livestock
		$ / lb.
		$1.65
		$1.65
		

		

	
	
		

		Revenue Livestock
		$ / Cull heifer
		$1,568
		$1,568
		

		

	
	
		

		Revenue Livestock
		Total revenue from cull heifers
		$12,540 
		$12,540 
		

		

	
	
		

		Revenue Livestock
		Total/Cow
		$41.80 
		$41.80 
		

		

	
	
		

		Revenue Livestock
		Cull Cows Sold
		40
		40
		

		

	
	
		

		Revenue Livestock
		Average Weight (lbs.)
		 1,300 
		 1,300 
		

		

	
	
		

		Revenue Livestock
		$ / lb.
		$0.95
		$0.95
		

		

	
	
		

		Revenue Livestock
		$ / Cull Cow
		$1,235
		$1,235
		

		

	
	
		

		Revenue Livestock
		Total revenue from cull cows
		$49,400 
		$49,400 
		

		

	
	
		

		Revenue Livestock
		Total/Cow
		$164.67 
		$164.67 
		

		

	
	
		

		Revenue Livestock
		Cull Bulls Sold
		6
		6
		

		

	
	
		

		Revenue Livestock
		Average Weight (lbs.)
		 1,800 
		 1,800 
		

		

	
	
		

		Revenue Livestock
		$ / lb.
		$1.00
		$1.00
		

		

	
	
		

		Revenue Livestock
		$ / Cull Bull
		$1,800
		$1,800
		

		

	
	
		

		Revenue Livestock
		Total revenue from cull bulls
		$10,800 
		$10,800 
		

		

	
	
		

		Revenue
		Total/Cow
		$36.00 
		$36.00 
		

		

	
	
		

		Revenue Livestock
		Total Livestock Sales
		$320,153 
		$320,153 
		

		

	
	
		

		Revenue Other
		Livestock
		$0.00
		$0.00
		

		

	
	
		

		Revenue Other
		Crop & Hay
		$0.00
		$0.00
		

		

	
	
		

		Expenses Livestock
		Bulls Purchased (Head)
		$6.00 
		$6.00 
		

		

	
	
		

		Expenses Livestock
		Average Price ($/Bull)
		$4,000
		$4,000
		

		

	
	
		

		Expenses Livestock
		Total Cost $ Bulls purchased
		$24,000 
		$24,000 
		

		

	
	
		

		Expenses Livestock
		Total/Cow
		$80.00 
		$80.00 
		

		

	
	
		

		Expenses Livestock
		Other Breeding Stock Purchases
		

		

		

		

	
	
		

		Expenses Livestock
		Total/Cow
		$0.00 
		$0.00 
		

		

	
	
		

		Expenses Livestock
		Commission Calves
		$18.00
		$18.00
		

		

	
	
		

		Expenses Livestock
		Comission Cull Yearlings 
		$18.00
		$18.00
		

		

	
	
		

		Expenses Livestock
		Commission Cull Cows
		$25.00
		$25.00
		

		

	
	
		

		Expenses Livestock
		Commission Cull Bulls  
		$25.00
		$25.00
		

		

	
	
		

		Expenses Livestock
		Total Commission
		$5,308
		$5,308
		

		

	
	
		

		Expenses Livestock
		Fees Calves 
		$5.00
		$5.00
		

		

	
	
		

		Expenses Livestock
		Fees Cull Yearlings 
		$5.00
		$5.00
		

		

	
	
		

		Expenses Livestock
		Fees Cull Cows 
		$5.00
		$5.00
		

		

	
	
		

		Expenses Livestock
		Fees Cull Bulls  
		$5.00
		$5.00
		

		

	
	
		

		Expenses Livestock
		Total Fees
		$1,385
		
		Locked cell 

		$1,385
		

		

	
	
		

		Expenses Livestock
		Trucking Calves 
		$5.00
		$5.00
		

		

	
	
		

		Expenses Livestock
		Trucking Cull Yearlings
		$10.00
		$10.00
		

		

	
	
		

		Expenses Livestock
		Trucking Cull Cows
		$15.00
		$15.00
		

		

	
	
		

		Expenses Livestock
		Trucking Cull Bulls
		$15.00
		$15.00
		

		

	
	
		

		Expenses Livestock
		Total Trucking
		$1,885
		$1,885
		

		

	
	
		

		Expenses Livestock
		Total Marketing and Trucking
		$8,578 
		$8,578 
		

		

	
	
		

		Expenses Livestock
		Total Marketing and Trucking/Cow
		$28.59
		$28.59
		

		

	
	
		

		Expenses Other
		Seed           
		$3,680
		$3,680
		

		

	
	
		

		Expenses Other
		Soil Testing
		$413
		$413
		

		

	
	
		

		Expenses Other
		Fertilizer & Chemicals
		$22,846
		$22,846
		

		

	
	
		

		Expenses Other
		Twine/Tarps
		$2,540
		$2,540
		

		

	
	
		

		Expenses Other
		Crop & Price Insurance
		$10,000
		$10,000
		

		

	
	
		

		Expenses Other
		Custom Fertilizing
		$3,310
		$3,310
		

		

	
	
		

		Expenses Other
		Irrigation
		$11,000
		$11,000
		

		

	
	
		

		Expenses Other
		Feed Supplement/Mineral & Salt
		$3,600
		$3,600
		

		

	
	
		

		Expenses Other
		Feed Purchases
		$0
		$0
		

		

	
	
		

		Expenses Other
		Land Rental (Crop & Hay)
		$0
		$0
		

		

	
	
		

		Expenses Other
		Grazing Fees (Crown)
		$5,607
		$5,607
		

		

	
	
		

		Expenses Other
		Pasture Fees (Private)
		$8,520
		$8,520
		

		

	
	
		

		Expenses Other
		Hay Purchases
		$0
		$0
		

		

	
	
		

		Expenses Other
		Other Livestock/Feed Purchases
		$0
		$0
		

		

	
	
		

		Expenses Other
		Trucking (Hay & Cattle)
		$1,561
		$1,561
		

		

	
	
		

		Expenses Other
		Livestock & Other Supplies
		$2,000
		$2,000
		

		

	
	
		

		Expenses Other
		Vet & Medicine/Breeding Fees
		$9,000
		$9,000
		

		

	
	
		

		Expenses Other
		Equipment Operating & Repair Hay
		$25,667
		$25,667
		

		

	
	
		

		Expenses Other
		Equipment Operating & Repair Other
		$8,556
		$8,556
		

		

	
	
		

		TOTAL DIRECT EXPENSES
		

		$118,299
		$118,299
		

		

	
	
		

		

		

		

		

		

		

	
	
		

		Indirect Expenses for Net Income Calculation 1.
		

		

		

		

		

	
	
		

		Indirect Expenses
		Depreciation* 
		

		

		* 
		E.g., buildings & equipment
	
	
		

		Indirect Expenses
		Interest *
		

		

		* 
		E.g., buildings & equipment
	
	
		

		Indirect Expenses
		Other Indirect Expenses**
		

		

		**
		E.g., operator labour, office expenses, accounting etc.
	
	
		

		

		

		

		

		

		

	
	
		

		1. Used to Calculate Projected Net Income on Cow Calf Budget Summary Tab 
		

		

		

		

		

	
	
		

		To assess net income, indirect expenses must be subtracted
		

		

		

		

		

	
	
		

		from income. Indirect expenses do not vary with the level of 
		

		

		

		

		

	
	
		

		output and are typically associated with inputs used in more
		

		

		

		

		

	
	
		

		than one enterprise and must be allocated appropriately
		

		

		

		

		

	
	
		

		(prorated) between uses.

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet objectives amp assumptions study the objective of planning for profit budget series is to provide information assist producers in projecting direct costs returns and mostlikely contribution margin british columbia farm enterprises this provided as one piece overall financial process with decision making monitoring reviewing whole ranch business only a guide not intended an indepth cost production industry based on prevailing prices at time publication will be different each it enable ranchers estimate equipment materials supplies labor required raise calves wellmanaged ranges revenues levels which would positive indirect overhead data used was gathered from group experienced interior using modern management practices their input requirements form that were develop enterprise other individuals involved preparation include government extension staff professionals additionally represents what growers can expect average if no unforeseen failures occur such adverse weather predators d...

Related files

Share

Help

Instructions for Using this Excel Workbook
1	Individual ranches can use this Excel Workbook to estimate their own direct costs, returns and most-likely contribution margin.
2	This can be done by entering values that best reflect your situation in the green shaded cells of the Your Ranch column adjacent to the Budget
	column in the Your Ranch Input Tab and in the Hay and Pasture worksheets.
3	Initial default value in the Your Ranch column is the same as the data in the Budget column and can be changed.
3	This can be done by entering values that best reflect your situation in the green shaded cells of the Your Ranch column adjacent to the Budget column.
4	The revised value entered in the Your Ranch column of the Your Ranch Input Tab will then be recorded in the Your Ranch column of the
	Cow Calf Budget Summary Tab and will be used to calculate a revised contribution margin for Your Ranch.

	Example: Your Ranch Input
		Budget	Your Ranch		Budget	Your Ranch
	Average Weight (lbs.)	1,800	1,800	Average Weight (lbs.)	1,800	1,800
	$ / lb.	$1.00	$1.00	$ / lb.	$1.00	$1.25
	$ / Cull Bull	$1,800	$1,800	$ / Cull Bull	$1,800	$2,250

5	Values in the cells not shaded green cannot be changed.
6	The Hay & Pasture Required Worksheet Tab is provided to assist ranchers to calculate the costs of their Individual hay and Pasture calculations.
	The information developed for your ranch on this worksheet needs to be manually inputted in the Your Ranch Input Tab.
7	The Hay Production Worksheet Tab is provided to assist ranchers to calculate the costs of their Individual hay and Pasture calculations.
	The information developed for your ranch on this worksheet needs to be manually inputted in the Your Ranch Input Tab.

300 Cow-Calf Ranch
BC SOUTHERN INTERIOR
		Budget	Your Ranch
Cow Herd Information	Number of Cows	300	300	Required format for dates is month-day-year eg.:
Cow Herd Information	Weaning Percentage	92.0%	The percentage of calves which are weaned as a percent of the cows overwintered. 92.0%	With numbers for month, day and year
Cow Herd Information	Start Calving Date	Mar-15-18	The average calving date for the majority of the cows. This date has two purposes 1) to estimate the weight of calves t weaning time and 2) to establish the times for the rations to change to meet the needs of the cow at the different periods of gestation Mar-15-18	Mar-15-2018 must be entered as 2018-03-15
Cow Herd Information	Weaning Date	Oct-15-18	The average weaning date. This date is used to estimate the weight of the weaned steers. Oct-15-18
Cow Herd Information	First Day of Feeding	Dec-01-18	Dec-01-18
Cow Herd Information	Last day of Feeding	May-01-19	May-01-19
Cow Herd Information	First day grazing	May-01-19	May-01-19
Cow Herd Information	Last Day grazing	Dec-01-19	Dec-01-19
Cow Herd Information	Days on Pasture	214	214
Cow Herd Information	Winter Feeding Period	151	151
Cow Herd Information	Herd Replacement	15.0%	The percentage of the cows which are culled each year. 15.0%
Cow Herd Information	Replacement Heifers Retained	53	53
Cow Herd Information	Heifer retention Rate	85.0%	85.0%
Cow Herd Information	Cow Death Loss %	1.50%	1.50%
Cow Herd Information	Cow Death Loss Head	5	5
Cow Herd Information	Cow Death Loss $	$6,175	$6,175
Cow Herd Information	Cow Bull Ratio	20	20
Cow Herd Information	Total Cow Breeding Herd	353	353
Cow Herd Information	Total Bull Breeding Herd	18	18
Revenue Livestock	Steers Sold	138	138
Revenue Livestock	Average Weight (lbs.)	600	600
Revenue Livestock	$ / lb.	$2.00	$2.00
Revenue Livestock	$ / Steer	$1,200	$1,200
Revenue Livestock	Total revenue from steers	$165,600	$165,600
Revenue Livestock	Heifers Calves Sold	85	85
Revenue Livestock	Average Weight (lbs.)	550	550
Revenue Livestock	$ / lb.	$1.75	$1.75
Revenue Livestock	$ / Heifer	$963	$963
Revenue Livestock	Total revenue from heifers	$81,813	$81,813
Revenue Livestock	Total/Cow	$272.71	$272.71
Revenue Livestock	Cull Yearling Heifers Sold	8	8
Revenue Livestock	Average Weight (lbs.)	950	950
Revenue Livestock	$ / lb.	$1.65	$1.65
Revenue Livestock	$ / Cull heifer	$1,568	$1,568
Revenue Livestock	Total revenue from cull heifers	$12,540	$12,540
Revenue Livestock	Total/Cow	$41.80	$41.80
Revenue Livestock	Cull Cows Sold	40	40
Revenue Livestock	Average Weight (lbs.)	1,300	1,300
Revenue Livestock	$ / lb.	$0.95	$0.95
Revenue Livestock	$ / Cull Cow	$1,235	$1,235
Revenue Livestock	Total revenue from cull cows	$49,400	$49,400
Revenue Livestock	Total/Cow	$164.67	$164.67
Revenue Livestock	Cull Bulls Sold	6	6
Revenue Livestock	Average Weight (lbs.)	1,800	1,800
Revenue Livestock	$ / lb.	$1.00	$1.00
Revenue Livestock	$ / Cull Bull	$1,800	$1,800
Revenue Livestock	Total revenue from cull bulls	$10,800	$10,800
Revenue	Total/Cow	$36.00	$36.00
Revenue Livestock	Total Livestock Sales	$320,153	$320,153
Revenue Other	Livestock	$0.00	$0.00
Revenue Other	Crop & Hay	$0.00	$0.00
Expenses Livestock	Bulls Purchased (Head)	$6.00	$6.00
Expenses Livestock	Average Price ($/Bull)	$4,000	$4,000
Expenses Livestock	Total Cost $ Bulls purchased	$24,000	$24,000
Expenses Livestock	Total/Cow	$80.00	$80.00
Expenses Livestock	Other Breeding Stock Purchases
Expenses Livestock	Total/Cow	$0.00	$0.00
Expenses Livestock	Commission Calves	$18.00	$18.00
Expenses Livestock	Comission Cull Yearlings	$18.00	$18.00
Expenses Livestock	Commission Cull Cows	$25.00	$25.00
Expenses Livestock	Commission Cull Bulls	$25.00	$25.00
Expenses Livestock	Total Commission	$5,308	$5,308
Expenses Livestock	Fees Calves	$5.00	$5.00
Expenses Livestock	Fees Cull Yearlings	$5.00	$5.00
Expenses Livestock	Fees Cull Cows	$5.00	$5.00
Expenses Livestock	Fees Cull Bulls	$5.00	$5.00
Expenses Livestock	Total Fees	$1,385	Locked cell $1,385
Expenses Livestock	Trucking Calves	$5.00	$5.00
Expenses Livestock	Trucking Cull Yearlings	$10.00	$10.00
Expenses Livestock	Trucking Cull Cows	$15.00	$15.00
Expenses Livestock	Trucking Cull Bulls	$15.00	$15.00
Expenses Livestock	Total Trucking	$1,885	$1,885
Expenses Livestock	Total Marketing and Trucking	$8,578	$8,578
Expenses Livestock	Total Marketing and Trucking/Cow	$28.59	$28.59
Expenses Other	Seed	$3,680	$3,680
Expenses Other	Soil Testing	$413	$413
Expenses Other	Fertilizer & Chemicals	$22,846	$22,846
Expenses Other	Twine/Tarps	$2,540	$2,540
Expenses Other	Crop & Price Insurance	$10,000	$10,000
Expenses Other	Custom Fertilizing	$3,310	$3,310
Expenses Other	Irrigation	$11,000	$11,000
Expenses Other	Feed Supplement/Mineral & Salt	$3,600	$3,600
Expenses Other	Feed Purchases	$0	$0
Expenses Other	Land Rental (Crop & Hay)	$0	$0
Expenses Other	Grazing Fees (Crown)	$5,607	$5,607
Expenses Other	Pasture Fees (Private)	$8,520	$8,520
Expenses Other	Hay Purchases	$0	$0
Expenses Other	Other Livestock/Feed Purchases	$0	$0
Expenses Other	Trucking (Hay & Cattle)	$1,561	$1,561
Expenses Other	Livestock & Other Supplies	$2,000	$2,000
Expenses Other	Vet & Medicine/Breeding Fees	$9,000	$9,000
Expenses Other	Equipment Operating & Repair Hay	$25,667	$25,667
Expenses Other	Equipment Operating & Repair Other	$8,556	$8,556
TOTAL DIRECT EXPENSES		$118,299	$118,299

Indirect Expenses for Net Income Calculation 1.
Indirect Expenses	Depreciation*			*	E.g., buildings & equipment
Indirect Expenses	Interest *			*	E.g., buildings & equipment
Indirect Expenses	Other Indirect Expenses**			**	E.g., operator labour, office expenses, accounting etc.

1. Used to Calculate Projected Net Income on Cow Calf Budget Summary Tab
To assess net income, indirect expenses must be subtracted
from income. Indirect expenses do not vary with the level of
output and are typically associated with inputs used in more
than one enterprise and must be allocated appropriately
(prorated) between uses.

Related files

Share

Share to social media

Help

Login Area