Cost Sheet Format In Excel 42179 | Machinery Costing Calculator (ahdb)

Partial file snippet.

Sheet 1: Hectare

	
	
	
	
	
	
		Machinery costing calculator:
Machinery costs calculation (per hectare)
Note: Edit blue cells only* 
		
		
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		£
		

	
	
		

		

		

		

		

	
	
		Purchase price
		

		

		
		Enter the cost of purchase

		126,000
		

	
	
		Selling price after
		
		Number of years you will keep before replacing
		8
		Years
		
		Projected resale value 

		34,000
		

	
	
		Hectares worked annually
		

		

		
		Hectares covered annually


		1,200
		

	
	
		

		

		

		

		

	
	
		Fixed costs 
		

		

		

		

	
	
		Average value per year owned
		

		

		80,000
		

	
	
		Interest
		
		purchase or you would receive on the funds if you did not spend it

		2
		% rate
		1,600
		

	
	
		Annual depreciation
		

		

		11,500
		

	
	
		Insurance
		
		Cost of insuring the macheinery as a % of purchase price (0.5-3%)
		2
		% of purchase price
		2,520
		

	
	
		Building/storage cost
		
		Cost of storing the macheinery while not in use (under cover or not) (0-3% of purchase cost)

		1
		% of purchase price
		1,260
		

	
	
		

		

		

		

		

	
	
		Total annual fixed cost
		

		

		16,880
		

	
	
		

		

		

		

		

	
	
		Fixed cost per hectare
		

		

		14.07
		

	
	
		

		

		

		

		

	
	
		Operating costs
		

		

		

		

	
	
		Ha covered/worked
		
		number of Ha that can be worked/covered in an hour

		4
		Per Hr
		

		

	
	
		Labour cost
		
		Labour cost per hour for macheinery opporation 
		14
		£/Hr
		

		

	
	
		Labour per Ha
		

		

		£3.50
		

	
	
		Fuel price (click for price data)
		
		Average price of fuel

		0.53
		£/L
		

		

	
	
		Fuel consumption (click for typical figures, see page 12)
		
		litres of fuel used. For general figures use the link. 
		20.00
		L/Ha
		

		

	
	
		Cost of fuel per Ha
		

		

		£10.60
		

	
	
		Spares and repairs
		
		Cost as a % of purchased price - for budget purposes. Refere to 'Repair costs' tab.
		2
		% of purchase price
		£2.10
		

	
	
		

		

		

		

		

	
	
		Total cost per Ha
		

		

		£30.27
		

	
	
		

		

		

		

		

	
	
		Contractors/machinery ring charge per Ha
		

		

		
		Price that would have to be paid to contractor/machinery ring per ha

		£76.00
		

	
	
		(Click for typical contractor charges)
		

		

		

		

	
	
		

		

		

		

		

	
	
		Annual savings by using contractor and not purchasing
		

		

		-£54,880 
		

	
	
		 -£ would suggest you may be better purchasing
		

		

		

		

	
	
		

		

		

		

		

	
	
		*Note: Blue cells pre-populated for illustrative purposes only
		
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	



Sheet 2: Hour

	
	
	
	
	
		Machinery costing calculator:
Machinery costs calculation (per hour)
Note: Edit blue cells only* 
		
		
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		£
		

	
	
		

		

		

		

		

	
	
		Purchase price
		

		

		
		Enter the cost of purchase
 

		92,751
		

	
	
		Selling price after
		
		Number of years you will keep before replacing
		7
		Years
		
		Projected resale value 

		40,000
		

	
	
		Hours worked annually
		

		

		
		Hectares covered annually


		700
		

	
	
		

		

		

		

		

	
	
		Fixed costs 
		

		

		

		

	
	
		Average value per year owned
		

		

		66,376
		

	
	
		Interest
		
		purchase or you would receive on the funds if you did not spend it

		2
		% rate
		1,328
		

	
	
		Actual annual depreciation
		

		

		7,536
		

	
	
		Insurance
		
		Cost of insuring the macheinery as a % of purchase price (0.5-3%)

		2
		% of purchase price
		1,855
		

	
	
		Building /storage cost
		
		Cost of storing the macheinery while not in use (under cover or not) (0-3% of purchase cost)

		1
		% of purchase price
		928
		

	
	
		

		

		

		

		

	
	
		Total annual fixed cost
		

		

		11,646
		

	
	
		

		

		

		

		

	
	
		Fixed cost per hour
		

		

		17
		

	
	
		

		

		

		

		

	
	
		Operating costs
		

		

		

		

	
	
		Ha covered/worked per hour
		
		number of Ha that can be worked/covered in an hour

		4
		Per Hr
		

		

	
	
		Fuel price (click for price data)
		
		Consumption of fuel litres per ha for the macheinery opporation. 

		14
		£/Hr
		

		

	
	
		Fuel consumption (click for typical figures, see page 12)
		
		Average price of fuel

		0.6
		£/Lt
		

		

	
	
		Cost of fuel per hour
		

		

		34
		

	
	
		Spares and repairs
		
		Cost as a % of purchased price - see tab 'Repair Costs' for relivent %

		1
		% of purchase price
		1
		

	
	
		Labour cost per hour
		

		

		
		Labour cost per hour for machinery opporation  

		14
		

	
	
		

		

		

		

		

	
	
		Total cost per hour
		

		

		66
		

	
	
		

		

		

		

		

	
	
		Contractors/machinery ring charge per hour
		

		

		
		Price that would have to be paid to contractor/machinery ring per hour

		45
		

	
	
		(Click for typical contractor charges)
		

		

		

		

	
	
		

		

		

		

		

	
	
		Annual savings by using contractor and not purchasing
		

		

		£14,393
		

	
	
		 -£ would suggest you may be better purchasing
		

		

		

		

	
	
		

		

		

		

		

	
	
		*Note: Blue cells pre-populated for illustrative purposes only
		
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	
	
		

		

		

		

		

	



Sheet 3: Workrate

	
	
	
	
	
		Machinery costing calculator:
Workrate (compare between to machines)
Note: Edit blue cells only* 
		
		
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		Model
		Model
		

	
	
		

		A
		B
		

	
	
		Input
		

		

		

	
	
		Implement width (m)
		4
		30
		

	
	
		
		If not appliying anything set to zero. 

		Capacity (kg or L)
		800
		2000
		

	
	
		Forward speed (km/Hr)
		6
		12
		

	
	
		
		If not appliying anything set to zero. 

		Application rate
		180
		250
		

	
	
		
		If not leaving the field to re-fill, set to zero
		Transport time, one way (min)
		5
		5
		

	
	
		
		If not re-filling set to zero
		Filling time (min)
		10
		10
		

	
	
		
		Gap between spot rate output and actual time spent in field completing task.  
		Field efficiency (%)
		65
		75
		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		Output
		

		

		

	
	
		Area covered per load (ha)
		4.44
		5.00
		

	
	
		Filling rate (kg/min or L/min)
		80.00
		200.00
		

	
	
		Spot work rate (Ha/Hr)
		2.40
		36.00
		

	
	
		Total time per load (min)
		190.94
		31.11
		

	
	
		Overall work rate (Ha/Hr)
		1.40
		9.64
		

	
	
		Overall efficiency (%)
		58.19
		26.79
		

	
	
		

		

		

		

	
	
		Components
		

		

		

	
	
		Application time per load (min)
		170.94
		11.11
		

	
	
		Application time (%)
		89.53
		35.71
		

	
	
		Filling time per load (min)
		10.00
		10.00
		

	
	
		Filling time (%)
		5.24
		32.14
		

	
	
		Transport time per load (min)
		10.00
		10.00
		

	
	
		Transport time (%)
		5.24
		32.14
		

	
	
		

		

		

		

	
	
		*Note: Blue cells pre-populated for illustrative purposes only

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

...Sheet hectare machinery costing calculatormachinery costs calculation per note edit blue cells only pound purchase price enter the cost of selling after number years you will keep before replacing projected resale value hectares worked annually covered fixed average year owned interest or would receive on funds if did not spend it rate annual depreciation insurance insuring macheinery as a buildingstorage storing while in use under cover total operating ha coveredworked that can be workedcovered an hour hr labour for opporation fuel click data l consumption typical figures see page litres used general link lha spares and repairs purchased budget purposes refere to repair tab contractorsmachinery ring charge have paid contractormachinery contractor charges savings by using purchasing suggest may better prepopulated illustrative hours actual building storage lt relivent workrate calculatorworkrate compare between machines model b input implement width m appliying anything set zero capaci...

Related files

Share

Help

Machinery costing calculator: Machinery costs calculation (per hectare) Note: Edit blue cells only*


			£

Purchase price			Enter the cost of purchase 126,000
Selling price after	Number of years you will keep before replacing 8	Years	Projected resale value 34,000
Hectares worked annually			Hectares covered annually 1,200

Fixed costs
Average value per year owned			80,000
Interest	purchase or you would receive on the funds if you did not spend it 2	% rate	1,600
Annual depreciation			11,500
Insurance	Cost of insuring the macheinery as a % of purchase price (0.5-3%) 2	% of purchase price	2,520
Building/storage cost	Cost of storing the macheinery while not in use (under cover or not) (0-3% of purchase cost) 1	% of purchase price	1,260

Total annual fixed cost			16,880

Fixed cost per hectare			14.07

Operating costs
Ha covered/worked	number of Ha that can be worked/covered in an hour 4	Per Hr
Labour cost	Labour cost per hour for macheinery opporation 14	£/Hr
Labour per Ha			£3.50
Fuel price (click for price data)	Average price of fuel 0.53	£/L
Fuel consumption (click for typical figures, see page 12)	litres of fuel used. For general figures use the link. 20.00	L/Ha
Cost of fuel per Ha			£10.60
Spares and repairs	Cost as a % of purchased price - for budget purposes. Refere to 'Repair costs' tab. 2	% of purchase price	£2.10

Total cost per Ha			£30.27

Contractors/machinery ring charge per Ha			Price that would have to be paid to contractor/machinery ring per ha £76.00
(Click for typical contractor charges)

Annual savings by using contractor and not purchasing			-£54,880
-£ would suggest you may be better purchasing

*Note: Blue cells pre-populated for illustrative purposes only

Machinery costing calculator: Machinery costs calculation (per hour) Note: Edit blue cells only*


			£

Purchase price			Enter the cost of purchase 92,751
Selling price after	Number of years you will keep before replacing 7	Years	Projected resale value 40,000
Hours worked annually			Hectares covered annually 700

Fixed costs
Average value per year owned			66,376
Interest	purchase or you would receive on the funds if you did not spend it 2	% rate	1,328
Actual annual depreciation			7,536
Insurance	Cost of insuring the macheinery as a % of purchase price (0.5-3%) 2	% of purchase price	1,855
Building /storage cost	Cost of storing the macheinery while not in use (under cover or not) (0-3% of purchase cost) 1	% of purchase price	928

Total annual fixed cost			11,646

Fixed cost per hour			17

Operating costs
Ha covered/worked per hour	number of Ha that can be worked/covered in an hour 4	Per Hr
Fuel price (click for price data)	Consumption of fuel litres per ha for the macheinery opporation. 14	£/Hr
Fuel consumption (click for typical figures, see page 12)	Average price of fuel 0.6	£/Lt
Cost of fuel per hour			34
Spares and repairs	Cost as a % of purchased price - see tab 'Repair Costs' for relivent % 1	% of purchase price	1
Labour cost per hour			Labour cost per hour for machinery opporation 14

Total cost per hour			66

Contractors/machinery ring charge per hour			Price that would have to be paid to contractor/machinery ring per hour 45
(Click for typical contractor charges)

Annual savings by using contractor and not purchasing			£14,393
-£ would suggest you may be better purchasing

*Note: Blue cells pre-populated for illustrative purposes only

Machinery costing calculator: Workrate (compare between to machines) Note: Edit blue cells only*



	Model	Model
	A	B
*Input*
Implement width (m)	4	30
If not appliying anything set to zero. Capacity (kg or L)	800	2000
Forward speed (km/Hr)	6	12
If not appliying anything set to zero. Application rate	180	250
If not leaving the field to re-fill, set to zero Transport time, one way (min)	5	5
If not re-filling set to zero Filling time (min)	10	10
Gap between spot rate output and actual time spent in field completing task. Field efficiency (%)	65	75


*Output*
Area covered per load (ha)	4.44	5.00
Filling rate (kg/min or L/min)	80.00	200.00
Spot work rate (Ha/Hr)	2.40	36.00
Total time per load (min)	190.94	31.11
Overall work rate (Ha/Hr)	1.40	9.64
Overall efficiency (%)	58.19	26.79

*Components*
Application time per load (min)	170.94	11.11
Application time (%)	89.53	35.71
Filling time per load (min)	10.00	10.00
Filling time (%)	5.24	32.14
Transport time per load (min)	10.00	10.00
Transport time (%)	5.24	32.14

*Note: Blue cells pre-populated for illustrative purposes only

Related files

Share

Share to social media

Help

Login Area