Breedcow+ Huscosts - Revision history

Lara: /* Step 4 - Complete the Breedcow+ Huscosts worksheet */

2020-12-17T22:37:04Z

Step 4 - Complete the Breedcow+ Huscosts worksheet

Lara at 04:39, 25 August 2020

2020-08-25T04:39:35Z

Lara: /* Step 4 - Entering data in the Breedcow+ Huscosts worksheet */

2020-08-25T03:01:31Z

Step 4 - Entering data in the Breedcow+ Huscosts worksheet

Lara at 02:58, 25 August 2020

2020-08-25T02:58:39Z

Lara: /* Step 4. Entering data in the Breedcow+ Huscosts worksheet */

2020-08-25T02:56:42Z

Step 4. Entering data in the Breedcow+ Huscosts worksheet

Lara: /* Step 4. Entering data in the Breedcow+ Huscosts worksheet */

2020-08-12T22:09:26Z

Step 4. Entering data in the Breedcow+ Huscosts worksheet

Lara at 22:09, 12 August 2020

2020-08-12T22:09:01Z

Lara at 22:02, 12 August 2020

2020-08-12T22:02:53Z

Lara at 04:54, 12 August 2020

2020-08-12T04:54:42Z

Lara at 22:58, 10 August 2020

2020-08-10T22:58:04Z

@@ Line 3: / Line 3: @@
 Open the Huscosts sheet in Breedcow+. ''Note that data can only be entered in the cells with a yellow background.''
-[[file:Breedcow+_Huscosts.PNG|thumb|1300px|center|The Huscosts worksheet from Breedcow+]]
+[[file:Breedcow_Huscosts.PNG|thumb|1300px|center|The Huscosts worksheet from Breedcow+]]
 Huscosts (husbandry costs calculator) is a worksheet similar in intent to [[Breedcow+ AE Calc|AECalc]] and [[Breedcow+ Prices|Prices]]. It is used to spell out husbandry costs in more detail and has a summary table at the bottom that is linked to the Breedcow worksheet.

← Older revision		Revision as of 04:39, 25 August 2020
Line 26:		Line 26:
	#The method of calculating the cost per head of drought feeding has been detailed in the note pad at the bottom of the worksheet as a reminder.		#The method of calculating the cost per head of drought feeding has been detailed in the note pad at the bottom of the worksheet as a reminder.
	#The summary table at the bottom of the Huscosts worksheet indicates costs being incurred for steers, heifers and cows.		#The summary table at the bottom of the Huscosts worksheet indicates costs being incurred for steers, heifers and cows.
		+	----
		+
		+	Once the Prices worksheet has been completed move onto the [[Breedcow+ Breedcow\|Breedcow]] worksheet.
		+
		+	----

@@ Line 1: / Line 1: @@
-==Step 4 - Entering data in the Breedcow+ Huscosts worksheet==
+==Step 4 - Complete the Breedcow+ Huscosts worksheet==
 Open the Huscosts sheet in Breedcow+. ''Note that data can only be entered in the cells with a yellow background.''
@@ Line 12: / Line 12: @@
 The weaner age group is split into heifers and steers, making it easier to deal with sex-specific costs such as the application of a growth promotant.
-The compilation of some classes of husbandry costs (especially supplements), often requires some calculation based on daily consumption, time fed and cost of the supplement (a calculator button on the toolbar opens Microsoft calculator). These calculations and other explanations of the variable cost entries can be shown in the Note Pad section beneath the Summary area. Having these notes will help later if assumptions on husbandry inputs are changed as part of the options analysis process.
+The compilation of some classes of husbandry costs (especially supplements), often requires some calculation based on daily consumption, time fed and cost of the supplement. These calculations and other explanations of the variable cost entries can be shown in the Note Pad section beneath the Summary area. Having these notes will help later if assumptions on husbandry inputs are changed as part of the options analysis process.
 Quite often the husbandry costs incurred by sale cattle and retained cattle in the same age group can be quite different. In the Huscosts worksheet there are separate columns for husbandry costs incurred on sale cattle and husbandry costs incurred on kept cattle to allow separate costs to be entered for each group of cattle. '''Note: the costs of sale cattle should not include the costs of selling that have previously been entered in the Prices worksheet.'''
@@ Line 18: / Line 18: @@
 The separation of husbandry costs on sale cattle from the husbandry costs on kept cattle enables users to determine how much of the kept cattle cost will be incurred by sale cattle before they are sold, and whether there are any additional costs on sale cattle such as extra supplementation. Husbandry costs on sale cattle will depend in part on when they are sold, e.g. cattle sold at the end of the wet season may have had the wet season phosphorus lick, but not the dry season urea lick. Pregnancy testing costs should apply equally to the cows kept and the cows sold. Weaning costs (hay, NLIS tag etc.) usually apply equally to weaners kept and weaners sold.
-===Breedcow+ Huscosts Notes===
+==The Huscosts Example==
 Points to note:
-.	The husbandry costs expected to be incurred by the herd include the normal preventative vaccines for weaners and breeding cows as well as more localised vaccines such as a vaccine to prevent losses due to botulism.
+#The husbandry costs expected to be incurred by the herd include the normal preventative vaccines for weaners and breeding cows as well as more localised vaccines such as a vaccine to prevent losses due to botulism.
+#The cost per head incurred by each class of livestock has been entered in the relevant column against the item listed. For example, the cost of drought feeding will only be incurred by females that are kept in the breeding herd and not sold.
-.	The cost per head incurred by each class of livestock has been entered in the relevant column against the item listed. For example, the cost of drought feeding will only be incurred by females that are kept in the breeding herd and not sold.
+#The method of calculating the cost per head of drought feeding has been detailed in the note pad at the bottom of the worksheet as a reminder.
+#The summary table at the bottom of the Huscosts worksheet indicates costs being incurred for steers, heifers and cows.

← Older revision		Revision as of 02:58, 25 August 2020
Line 1:		Line 1:
	==Step 4 - Entering data in the Breedcow+ Huscosts worksheet==		==Step 4 - Entering data in the Breedcow+ Huscosts worksheet==
		+
		+	Open the Huscosts sheet in Breedcow+. ''Note that data can only be entered in the cells with a yellow background.''
		+
		+	[[file:Breedcow+_Huscosts.PNG\|thumb\|1300px\|center\|The Huscosts worksheet from Breedcow+]]

	Huscosts (husbandry costs calculator) is a worksheet similar in intent to [[Breedcow+ AE Calc\|AECalc]] and [[Breedcow+ Prices\|Prices]]. It is used to spell out husbandry costs in more detail and has a summary table at the bottom that is linked to the Breedcow worksheet.		Huscosts (husbandry costs calculator) is a worksheet similar in intent to [[Breedcow+ AE Calc\|AECalc]] and [[Breedcow+ Prices\|Prices]]. It is used to spell out husbandry costs in more detail and has a summary table at the bottom that is linked to the Breedcow worksheet.

← Older revision		Revision as of 02:56, 25 August 2020
Line 1:		Line 1:
−	===Step 4. Entering data in the Breedcow+ Huscosts worksheet===	+	==Step 4 - Entering data in the Breedcow+ Huscosts worksheet==

	Huscosts (husbandry costs calculator) is a worksheet similar in intent to [[Breedcow+ AE Calc\|AECalc]] and [[Breedcow+ Prices\|Prices]]. It is used to spell out husbandry costs in more detail and has a summary table at the bottom that is linked to the Breedcow worksheet.		Huscosts (husbandry costs calculator) is a worksheet similar in intent to [[Breedcow+ AE Calc\|AECalc]] and [[Breedcow+ Prices\|Prices]]. It is used to spell out husbandry costs in more detail and has a summary table at the bottom that is linked to the Breedcow worksheet.

@@ Line 1: / Line 1: @@
 ===Step 4. Entering data in the Breedcow+ Huscosts worksheet===
-Huscosts (husbandry costs calculator) is a worksheet similar in intent to AECalc and Prices. It is used to spell out husbandry costs in more detail and has a summary table at the bottom that is linked to the Breedcow worksheet.
+Huscosts (husbandry costs calculator) is a worksheet similar in intent to [[Breedcow+ AE Calc|AECalc]] and [[Breedcow+ Prices|Prices]]. It is used to spell out husbandry costs in more detail and has a summary table at the bottom that is linked to the Breedcow worksheet.
 It is important to complete the Huscosts worksheet so the treatments and other costs incurred by each herd management strategy modelled are not lost or forgotten. '''Note: for reasons of consistency, it is better to enter selling costs in the Prices worksheet and not the Huscosts worksheet.'''

← Older revision		Revision as of 22:09, 12 August 2020
Line 24:		Line 24:
	3. The method of calculating the cost per head of drought feeding has been detailed in the note pad at the bottom of the worksheet as a reminder.		3. The method of calculating the cost per head of drought feeding has been detailed in the note pad at the bottom of the worksheet as a reminder.

−	4. The summary table at the bottom of the Huscosts worksheet indicates costs being incurred for steers, heifers and cows.	+	4. The summary table at the bottom of the Huscosts worksheet indicates costs being incurred for steers, heifers and cows.
−
−	5. The L (Layout) and C (clear) buttons can be used to lock headings and clear headings while data is being entered. Place the cursor where the columns and headings need to be locked and then scroll to the right to allow data entry for females, steers and herd bulls as required.

← Older revision		Revision as of 22:02, 12 August 2020
Line 26:		Line 26:
	4. The summary table at the bottom of the Huscosts worksheet indicates costs being incurred for steers, heifers and cows.		4. The summary table at the bottom of the Huscosts worksheet indicates costs being incurred for steers, heifers and cows.

−	5. The L (Layout) and C (clear) buttons can be used to lock headings and clear headings while data is being entered. Place the cursor where the columns and headings need to be locked and then scroll to the right to allow data entry for females, steers and herd bulls as required.	+	5. The L (Layout) and C (clear) buttons can be used to lock headings and clear headings while data is being entered. Place the cursor where the columns and headings need to be locked and then scroll to the right to allow data entry for females, steers and herd bulls as required.
−
−	~~===Breedcow+ Huscosts Assumptions===~~

← Older revision		Revision as of 04:54, 12 August 2020
Line 1:		Line 1:
−	===Entering data in the Breedcow+ Huscosts worksheet===	+	===Step 4. Entering data in the Breedcow+ Huscosts worksheet===

	Huscosts (husbandry costs calculator) is a worksheet similar in intent to AECalc and Prices. It is used to spell out husbandry costs in more detail and has a summary table at the bottom that is linked to the Breedcow worksheet.		Huscosts (husbandry costs calculator) is a worksheet similar in intent to AECalc and Prices. It is used to spell out husbandry costs in more detail and has a summary table at the bottom that is linked to the Breedcow worksheet.

← Older revision		Revision as of 22:58, 10 August 2020
Line 13:		Line 13:

	The separation of husbandry costs on sale cattle from the husbandry costs on kept cattle enables users to determine how much of the kept cattle cost will be incurred by sale cattle before they are sold, and whether there are any additional costs on sale cattle such as extra supplementation. Husbandry costs on sale cattle will depend in part on when they are sold, e.g. cattle sold at the end of the wet season may have had the wet season phosphorus lick, but not the dry season urea lick. Pregnancy testing costs should apply equally to the cows kept and the cows sold. Weaning costs (hay, NLIS tag etc.) usually apply equally to weaners kept and weaners sold.		The separation of husbandry costs on sale cattle from the husbandry costs on kept cattle enables users to determine how much of the kept cattle cost will be incurred by sale cattle before they are sold, and whether there are any additional costs on sale cattle such as extra supplementation. Husbandry costs on sale cattle will depend in part on when they are sold, e.g. cattle sold at the end of the wet season may have had the wet season phosphorus lick, but not the dry season urea lick. Pregnancy testing costs should apply equally to the cows kept and the cows sold. Weaning costs (hay, NLIS tag etc.) usually apply equally to weaners kept and weaners sold.
		+
		+	===Breedcow+ Huscosts Notes===
		+
		+	Points to note:
		+
		+	1. The husbandry costs expected to be incurred by the herd include the normal preventative vaccines for weaners and breeding cows as well as more localised vaccines such as a vaccine to prevent losses due to botulism.
		+
		+	2. The cost per head incurred by each class of livestock has been entered in the relevant column against the item listed. For example, the cost of drought feeding will only be incurred by females that are kept in the breeding herd and not sold.
		+
		+	3. The method of calculating the cost per head of drought feeding has been detailed in the note pad at the bottom of the worksheet as a reminder.
		+
		+	4. The summary table at the bottom of the Huscosts worksheet indicates costs being incurred for steers, heifers and cows.
		+
		+	5. The L (Layout) and C (clear) buttons can be used to lock headings and clear headings while data is being entered. Place the cursor where the columns and headings need to be locked and then scroll to the right to allow data entry for females, steers and herd bulls as required.

	===Breedcow+ Huscosts Assumptions===		===Breedcow+ Huscosts Assumptions===