Dynama+ Prices - Revision history

FinlayV: /* Step 2 – Complete the Prices worksheet */

2020-08-26T03:53:40Z

Step 2 – Complete the Prices worksheet

FinlayV at 04:47, 18 August 2020

2020-08-18T04:47:16Z

FinlayV: Created page with "==Step 2 – Complete the Prices worksheet== The Prices worksheet logically follows on from the entry of sale weight information in the AECalc worksheet. Selling prices and c..."

2020-08-10T05:55:14Z

Created page with "==Step 2 – Complete the Prices worksheet== The Prices worksheet logically follows on from the entry of sale weight information in the AECalc worksheet. Selling prices and c..."

New page

==Step 2 – Complete the Prices worksheet==

The Prices worksheet logically follows on from the entry of sale weight information in the AECalc worksheet. Selling prices and costs can be recorded and varied for up to ten years into the future for each class of cattle on the property. Purchase prices for any classes of cattle purchased are entered in Table 4 of the Dynama worksheet.

It is important to record all of the assumptions underlying the inputs in the prices sheet through the use of notes in the spaces provided.

There is a separate section in the Prices worksheet to enter the sale prices and sale weights for females spayed or set aside from the breeding herd. As a default value, these set aside females use the weights allocated to the female herd in the AECalc worksheet but they can be overridden if the sale price and weight are expected to be different to the remainder of the breeding herd.

Whilst the weights transferred from AECalc are live weights, which would require entries in the Prices worksheet to be inserted as price per kilogram live, it is possible to overwrite the weights shown in the Prices worksheet to show expected dressed weights and enter prices on a per kilogram dressed basis. Overwriting the weights in Prices will of course break the link with AECalc, preventing any subsequent AECalc weight edits from flowing through to Prices.

The Prices worksheet calculates net sale prices by multiplying sale weights by price per kilogram, then deducting all selling costs including freight. As long as sale weights and sale prices are entered consistently as either live weight or dressed weight, there should be no error in the final value per head used in the Dynama worksheet. If values per head shown in the summary tables of the Prices worksheet appear to be either overstated or understated, please check that the sale weights and sale values have been entered on the same basis.

Selling costs are divided into three tables in the Prices worksheet. The first table collects those selling costs that are levied as a percentage of total value. This table is labelled as “sales commission - of value” and can include value-based insurance as well. The next table collects those selling costs that are levied on a per head basis. Freight costs associated with selling livestock are also entered on a per head basis but are dealt with in a third table. Each table can have values entered for up to ten years. Over riding the formulas allows changes to be made to the expected selling costs over time.

A calculator is provided at the bottom of the Prices worksheet to assist with the calculation of the expected costs of freight to different destinations. To assist estimating the number of head per deck for each group, a table based on weights is provided beside the freight cost calculator.

← Older revision		Revision as of 03:53, 26 August 2020
Line 1:		Line 1:
−	==Step 2 – Complete the Prices worksheet==	+	==Step 3 – Complete the Prices worksheet==

	The Prices worksheet logically follows on from the entry of sale weight information in the AECalc worksheet. Selling prices and costs can be recorded and varied for up to ten years into the future for each class of cattle on the property. Purchase prices for any classes of cattle purchased are entered in Table 4 of the Dynama worksheet.		The Prices worksheet logically follows on from the entry of sale weight information in the AECalc worksheet. Selling prices and costs can be recorded and varied for up to ten years into the future for each class of cattle on the property. Purchase prices for any classes of cattle purchased are entered in Table 4 of the Dynama worksheet.

← Older revision		Revision as of 04:47, 18 August 2020
Line 14:		Line 14:

	A calculator is provided at the bottom of the Prices worksheet to assist with the calculation of the expected costs of freight to different destinations. To assist estimating the number of head per deck for each group, a table based on weights is provided beside the freight cost calculator.		A calculator is provided at the bottom of the Prices worksheet to assist with the calculation of the expected costs of freight to different destinations. To assist estimating the number of head per deck for each group, a table based on weights is provided beside the freight cost calculator.
		+
		+	==The Prices worksheet example==
		+
		+	The prices and selling costs entered in the example Prices worksheet reflect that all sales are expected to occur via liveweight auction at the Roma saleyards or the Dinmore abattoirs. All sale values were those achieved at that selling centre for each class of livestock on average for the five years up until the end of 2015.
		+
		+	The costs incurred through selling at such fat and store cattle sales can include fees for handling, weighing, NLIS reading and yard dues.
		+
		+	The freight cost column indicates the costs per head for transporting the various classes of livestock to sale. Each figure was calculated using the freight cost calculator at the bottom of the worksheet.
		+
		+	As the manager expects the average sale values and weights for set aside (spayed) females and breeding herd females to be similar, the sale prices and costs for all female livestock sales are the same.
		+	The net values shown in Table 8 of the Prices worksheet are the ones transferred to Tables 5A and 6A of the Dynama worksheet.
		+
		+	----
		+	Once the Prices worksheet has been completed move onto the [[Dynama+_Huscosts\|Huscosts]] worksheet.
		+	----