jagomart
digital resources
picture1_Machcost06


 161x       Filetype XLS       File size 0.11 MB       Source: fyi.extension.wisc.edu


File: Machcost06
sheet 1 machcost machinery costs worksheet see cells i21i36 for useful comments 1 4557 5119 5792 5461 to print this table and guide print area y1ab36 see estimating agricultural field ...

icon picture XLS Filetype Excel XLS | Posted on 17 Aug 2022 | 3 years ago
Partial file snippet. 
Sheet 1: MACHCOST


	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	

		 
		MACHINERY COSTS WORKSHEET
		See cells I21-I36 for useful comments
		

		

		

		

		1
		45.57 
		51.19 
		57.92 
		54.61 
		

		

		

		

		

		

		

		

		

		

		

		

		

		To print this table and guide, print area Y1..AB36
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		See Estimating Agricultural Field Machinery Costs for details from rschuler@wisc.edu
		

		

		

		

		

		2
		28.29 
		31.52 
		34.14 
		32.88 
		

		

		

		

		

		

		

		

		

		

		

		

		

		Strike the "Home" key to get to the start of this program.
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Type of Tractor (1 or 2)
		

		

		

		

		

		

		3
		22.24 
		24.51 
		25.82 
		25.21 
		

		

		

		

		

		

		

		

		

		

		

		

		

		Machine
		 Code
		

		

		

		

		

		

		Timeliness
		Hours
		% of Price
		RF1
		RF2
	

	

		1
		2 Wheel Drive
		

		

		

		

		

		4
		19.01 
		20.70 
		21.40 
		21.08 
		

		

		

		

		

		

		

		

		

		

		

		

		1
		Tractor, 2 wheel drive
		=
		1
		1
		N.A.
		N.A.
		N.A.
		N.A.
		0
		12000
		100
		0.007
		2
	

	

		$31,400 
		Purchase price or ATB (adjusted tax basis)
		

		

		

		

		

		5
		16.92 
		18.21 
		18.56 
		18.41 
		

		

		

		

		

		

		

		

		

		

		

		

		2
		Tractor, 4 wheel drive
		=
		2
		1
		N.A.
		N.A.
		N.A.
		N.A.
		0
		16000
		80
		0.003
		2
	

	

		0
		---------Machine's Age--------
		0
		Hours previously used
		

		

		

		6
		15.41 
		16.38 
		16.52 
		16.47 
		

		

		

		

		

		

		

		

		

		

		

		

		3
		Moldboard plow
		=
		3
		4
		70 - 90
		85
		3.0 - 6.0
		4.5
		0
		2000
		100
		0.29
		1.8
	

	

		10
		Expected years of Ownership
		

		

		

		

		

		7
		14.25 
		14.96 
		14.97 
		14.98 
		

		

		

		

		

		

		

		

		

		

		

		

		4
		Heavy Duty Disk
		=
		4
		4
		70 - 90
		85
		3.5 - 6.0
		4.5
		0
		2000
		60
		0.18
		1.7
	

	

		75
		H.P. of Tractor or H.P. of engine on sell-propelled machine
		

		

		

		

		

		8
		13.30 
		13.80 
		13.72 
		13.77 
		

		

		

		

		

		

		

		

		

		

		

		

		5
		Tandem Disk Harrow
		=
		5
		4
		70 - 90
		80
		4.0 - 7.0
		6
		0
		2000
		60
		0.18
		1.7
	

	

		D
		D=diesel, G=gas
		

		

		

		

		

		9
		12.51 
		12.83 
		12.68 
		12.76 
		

		

		

		

		

		

		

		

		

		

		

		

		6
		Chisel Plows
		=
		6
		4
		70 - 90
		85
		4.0 - 6.5
		5
		0
		2000
		75
		0.28
		1.4
	

	

		$2.20 
		Fuel ($/gallon)
		

		

		

		

		

		10
		11.82 
		11.99 
		11.81 
		11.90 
		

		

		

		

		

		

		

		

		

		

		

		

		7
		Subsoiler
		=
		7
		4
		70 - 90
		85
		4.0 - 6.5
		5
		0
		2000
		75
		0.28
		1.4
	

	

		400
		Estimated Hours Use/Year
		

		

		

		

		

		11
		11.22 
		11.26 
		11.05 
		11.16 
		

		

		

		

		

		

		

		

		

		

		

		

		8
		Field Cultivator
		=
		8
		4
		70 - 90
		85
		5.0 - 8.0
		7
		0
		2000
		70
		0.27
		1.4
	

	

		 
		

		

		

		

		

		

		12
		10.68 
		10.61 
		10.38 
		10.50 
		

		

		

		

		

		

		

		

		

		

		

		

		9
		Spring Tooth Harrow
		=
		9
		4
		70 - 90
		85
		5.0 - 8.0
		7
		0
		2000
		70
		0.27
		1.4
	

	

		

		

		 
		

		

		

		

		13
		10.20 
		10.04 
		9.79 
		9.91 
		

		

		

		

		

		

		

		

		

		

		

		

		10
		Roller-packer
		=
		10
		4
		70 - 90
		85
		4.5 - 7.5
		6
		0
		2000
		40
		0.16
		1.3
	

	

		

		

		

		

		

		

		

		14
		9.76 
		9.51 
		9.26 
		9.38 
		

		

		

		

		

		

		

		

		

		

		

		

		11
		Mulcher-packers
		=
		11
		4
		70 - 90
		80
		4.0 - 6.0
		5
		0
		2000
		40
		0.16
		1.3
	

	

		Type of Implement (3 through 31)
		

		

		

		

		

		

		15
		9.36 
		9.04 
		8.79 
		8.91 
		

		

		

		

		

		

		

		

		

		

		

		

		12
		Rotary Hoe
		=
		12
		4
		70 - 85
		80
		5.0 -14.0
		12
		0.028
		2000
		60
		0.23
		1.4
	

	

		22
		Mower-conditioner-rotary
		

		See Y1..AB36 for code table
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		13
		Row Crop Cultivators
		=
		13
		4
		70 - 90
		80
		3.0 - 7.0
		5
		0.011
		2000
		80
		0.17
		2.2
	

	

		$23,111 
		Purchase price or ATB (adjusted tax basis)
		

		

		

		

		

		Table 4 (annual average fixed costs)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		14
		Rotary Tiller
		=
		14
		4
		70 - 90
		85
		1.0 - 4.5
		3
		0.011
		1500
		80
		0.36
		2
	

	

		0
		---------Machine's Age--------
		0
		Hours previously used
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		15
		Row Crop Planter (No-till)
		=
		15
		4
		50 - 75
		65
		4.0 - 7.0
		5.5
		0.005
		1500
		75
		0.32
		2.1
	

	

		20
		Expected years of Ownership
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		16
		Row Crop Planter (conventional)
		=
		16
		4
		50 - 80
		70
		4.0 - 7.0
		5
		0.005
		1500
		75
		0.32
		2.1
	

	

		12
		Width in feet
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		17
		Grain Drill
		=
		17
		4
		55 - 80
		70
		4.0 - 7.0
		5
		0.012
		1500
		75
		0.32
		2.1
	

	

		233
		Acres used on
		

		

		

		

		

		

		COMMENTS:
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		18
		Corn Picker or Sheller
		=
		18
		3
		60 - 75
		65
		2.0 - 5.0
		2.5
		0.003
		2000
		70
		0.14
		2.3
	

	

		3
		Times over
		

		"Range"
		    "Typical"
		

		

		

		1. The most recent (2005) machinery data from the American Society of Agricultural Engineer
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		19
		Combines (pull-type)
		=
		19
		2
		60 - 75
		65
		2.0 - 5.0
		5
		0.003
		2000
		60
		0.12
		2.3
	

	

		85
		Field efficiency (percent) ----------
		

		75 - 90
		80
		

		

		

		(as of July,2005 it is called American Society of Agricultural and Biological Engineers)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		20
		Combine (self-propelled)
		=
		20
		2
		65 - 80
		70
		2.0 - 5.0
		3
		0.003
		3000
		40
		0.04
		2.1
	

	

		7
		Speed (MPH) -------------------------
		

		5.0 - 8.0
		7
		

		

		

		2.User can taylor the analysis to their situation inputting many data values i.e. fuel price,
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		21
		Mower-conditioner-sickle
		=
		21
		4
		75 - 85
		80
		3.0 - 6.0
		5
		0.018
		2500
		80
		0.18
		1.6
	

	

		 
		

		

		

		

		

		

		

		equipment purchase price, acres, and forward speed.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		22
		Mower-conditioner-rotary
		=
		22
		4
		75 - 90
		80
		5.0 - 8.0
		7
		0.018
		2500
		100
		0.16
		2
	

	

		 
		

		

		

		

		

		

		

		3. If a tractor is used for multiple purposes, the hourly tractor costs are calculated and
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		23
		Mower-conditioner (self-propelled)
		=
		23
		2
		70 - 85
		80
		3.0 - 8.0
		5
		0.018
		3000
		55
		0.06
		2
	

	

		

		

		

		

		

		

		

		

		the tractor costs for a tractor powered machine is determined for the number of hours
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		24
		Side Delivery Rake
		=
		24
		3
		70 - 90
		80
		6.5 - 13.0
		10
		0.018
		2500
		60
		0.17
		1.4
	

	

		Other input values needed:
		

		

		

		

		

		

		

		used for the operation times the hourly tractor costs.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		25
		Sm. Rect.Baler
		=
		25
		3
		60 - 85
		75
		2.5 - 6.0
		4
		0.018
		2000
		80
		0.23
		1.8
	

	

		$11.00 
		Labor cost ($/hour)
		

		

		

		

		

		

		4. The cost results are located in cells A1... F60. This print area has already been
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		26
		Big Bale Rect Baler
		=
		26
		3
		70 - 90
		80
		5.0 - 8.0
		5
		0.018
		3000
		75
		0.1
		1.8
	

	

		

		"Crop's Value"                       =
		

		$72.00 
		per acre
		

		

		

		established for getting a hard copy of results.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		27
		Large Round Baler
		=
		27
		3
		55 - 75
		65
		3.0 - 8.0
		5
		0.018
		1500
		90
		0.43
		1.8
	

	

		$72.00 
		Price/unit ($/bushel, $/ton, etc)
		

		

		

		

		

		

		5. The machinery code numbers are located in area Y1....AB36, also noted in the
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		28
		Forage Chopper (pull-type)
		=
		28
		3
		60 - 85
		70
		1.5 - 5.0
		3
		0.018
		2500
		65
		0.15
		1.6
	

	

		1.00 
		Production per acre (bushels, tons, etc)
		

		

		

		

		

		

		spreadsheet in line 16 of results.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		29
		Forage Chopper (Self- propelled)
		=
		29
		2
		60 - 85
		70
		1.5 - 6.0
		3.5
		0.018
		4000
		50
		0.03
		2
	

	

		Average hours per day that this machine is normally used.
		

		

		

		

		

		

		

		6. If you use a machine that has been used beyond the wear-out life, you will get a
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		30
		Fertilizer Spreader
		=
		30
		3
		60 - 80
		70
		5.0 - 10.0
		7
		0.018
		1200
		80
		0.63
		1.3
	

	

		6
		Hour/day used
		

		

		

		

		

		

		warning and machine costs will be large because the repair costs are determined
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		31
		Boom Sprayers
		=
		31
		3
		50 - 80
		65
		3.0 - 7.0
		6.5
		0.011
		1500
		70
		0.41
		1.3
	

	

		

		

		

		

		

		

		

		

		using a formula with a exponential term. Hours will need to be adjusted to get realistic values.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		32
		Blower, forage
		=
		32
		3
		N.A.
		

		N.A.
		

		0
		1500
		45
		0.22
		1.8
	

	

		*
		

		"Implement's Use Values"
		

		

		

		

		

		7. For self propelled equipment use a tractor purchase price of zero.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		33
		Wagons
		=
		33
		3
		N.A.
		

		N.A.
		

		0
		2000
		50
		0.16
		1.3
	

	

		*
		  Implement's capacity (acres per hour)
		

		8.65 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		*
		       Implement's use (hours per year)
		

		80.77 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		RESULTS
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		*
		

		"Machinery Costs"
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		*
		

		Implement
		Tractor
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		*
		Annual fixed costs
		$2,059 
		$3,712 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		     After striking the <Home> key, enter the values associated with
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		Repair costs
		$482 
		$352 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		your tractor and/or machine in the cells that are brighter.  You can not
		

		

		 
		

		

		

		

		

		

		

		

		

	

	

		

		Fuel costs
		$586 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		not enter values in the other cells.  The program will not let you.
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		Lubricant costs
		$88 
		

		Total tractor costs
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		Labor costs
		$888 
		

		$4,064 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		 
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		        Using this implement
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		 
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		Total implement costs
		$4,104 
		

		$821 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		 
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		Per hour
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		The results start on line 36.  You can study them and the print
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		$10.16 
		 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		those results (using Alt R) or change the values entered to get 
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		      "Total Costs Per"
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		another analysis; or both.  Remember:  to get to the start of the
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Tractor and Implement Costs
		

		Time Over
		Acre
		Hour
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		program just strike the <Home> key.
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		$4,924 
		Machine
		$5.87 
		$17.61 
		$50.81 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		Tractor
		$1.17 
		$3.52 
		$10.16 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Timeliness Cost
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		$339 
		Sub-Total
		$7.04 
		$21.13 
		$60.97 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		   Timeliness Cost
		$0.48 
		$1.45 
		$4.19 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Total Costs
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		$5,263 
		Total
		$7.53 
		$22.59 
		$65.16 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		\G
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		/pprlist~gpq
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		\R
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		/pprresults~gq
		

		

		

		

		

		

		

		

		

		

		

		

	

	

		11.8215487248145
		tractor fixed cost factor
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		8.90797700509622
		machine fixed cost factor
		RF1
		RF2
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		tractor repair cost factors
		0.007
		2
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		machine repair cost factors
		0.16
		2
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		1
		tractor fixed cost column
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		4
		machine fixed cost column
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		0.044
		tractor fuel cost factor
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		For calculating repair costs of used equipment
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		$31,400 
		tractor's value new (estimate)
		

		1
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		$23,111 
		machine's value new (estimate)
		

		1
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		    Annual fixed costs in per cent of list price by machine catagory
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Table 3
		

		     Combines
		

		 Forage Choppers
		

		     Mowers
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Age
		       Tractors
		  S.P. Windrowers
		

		 Balers, blowers
		

		     Tillage
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		-
		-
		-
		-
		-
		-
		-
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		1
		45.57 
		51.19 
		

		57.92 
		

		54.61 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		2
		11.01 
		11.85 
		

		10.37 
		

		11.15 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		3
		10.13 
		10.49 
		

		9.18 
		

		9.86 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		4
		9.32 
		9.28 
		

		8.12 
		

		8.71 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		5
		8.57 
		8.22 
		

		7.19 
		

		7.70 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		6
		7.89 
		7.27 
		

		6.36 
		

		6.81 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		7
		7.26 
		6.43 
		

		5.63 
		

		6.02 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		8
		6.68 
		5.69 
		

		4.98 
		

		5.32 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		9
		6.14 
		5.04 
		

		4.41 
		

		4.70 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		10
		5.65 
		4.46 
		

		3.90 
		

		4.16 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		11
		5.20 
		3.95 
		

		3.45 
		

		3.68 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		12
		4.78 
		3.49 
		

		3.06 
		

		3.25 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		13
		4.40 
		3.09 
		

		2.71 
		

		2.87 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		14
		4.05 
		2.74 
		

		2.39 
		

		2.54 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		15
		3.72 
		2.42 
		

		2.12 
		

		2.24 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		8
		Interest rate (percent)
		2
		percent for housing, ins, etc
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		100.00 
		

		100.00 
		

		100.00 
		

		100.00 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		0
		62.56 
		

		56.64 
		

		49.56 
		

		53.04 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		0
		57.56 
		

		50.13 
		

		43.86 
		

		46.89 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		52.95 
		

		44.36 
		

		38.82 
		

		41.45 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Table 1
		48.71 
		

		39.26 
		

		34.35 
		

		36.64 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		44.82 
		

		34.75 
		

		30.40 
		

		32.39 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		41.23 
		

		30.75 
		

		26.91 
		

		28.63 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		37.93 
		

		27.21 
		

		23.81 
		

		25.31 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		34.90 
		

		24.08 
		

		21.07 
		

		22.38 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		32.11 
		

		21.31 
		

		18.65 
		

		19.78 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		29.54 
		

		18.86 
		

		16.51 
		

		17.49 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		27.18 
		

		16.69 
		

		14.61 
		

		15.46 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		25.00 
		

		14.77 
		

		12.93 
		

		13.66 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		23.00 
		

		13.08 
		

		11.44 
		

		12.08 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		21.16 
		

		11.57 
		

		10.12 
		

		10.68 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		19.47 
		

		10.24 
		

		8.96 
		

		9.44 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		0
		0
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		1
		5
		1
		5
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		2
		9
		2
		9
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		3
		12
		3
		12
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		4
		14
		4
		14
		Used equipment
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		5
		15
		5
		15
		adjustment factors
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		6
		16
		6
		16
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		7
		17
		7
		17
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		8
		18
		8
		18
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		9
		19
		9
		19
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		10
		20
		10
		20
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		11
		21
		11
		21
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		12
		22
		12
		22
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		13
		23
		13
		23
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		14
		24
		14
		24
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		15
		25
		15
		25
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		16
		26
		16
		26
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		17
		27
		17
		27
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		18
		28
		18
		28
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		19
		29
		19
		29
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		20
		30
		20
		30
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	






Sheet 2: Comments


	
	

		COMMENTS:
	

	

		1. The most recent (2005) machinery data from the American Society of Agricultural Engineer
	

	

		(as of July,2005 it is called American Society of Agricultural and Biological Engineers)
	

	

		2.User can taylor the analysis to their situation inputting many data values i.e. fuel price,
	

	

		equipment purchase price, acres, and forward speed.
	

	

		3. If a tractor is used for multiple purposes, the hourly tractor costs are calculated and
	

	

		the tractor costs for a tractor powered machine is determined for the number of hours
	

	

		used for the operation times the hourly tractor costs.
	

	

		4. The cost results are located in cells A1... F60. This print area has already been
	

	

		established for getting a hard copy of results.
	

	

		5. The machinery code numbers are located in area Y1....AB36, also noted in the
	

	

		spreadsheet in line 16 of results.
	

	

		6. If you use a machine that has been used beyond the wear-out life, you will get a
	

	

		warning and machine costs will be large because the repair costs are determined
	

	

		using a formula with a exponential term. Hours will need to be adjusted to get realistic values.
	

	

		7. For self propelled equipment use a tractor purchase price of zero.
The words contained in this file might help you see if this file matches what you are looking for:

...Sheet machcost machinery costs worksheet see cells ii for useful comments to print this table and guide area yab estimating agricultural field details from rschuler wiscedu strike the quot home key get start of program type tractor or machine code timeliness hours price rf wheel drive na purchase atb adjusted tax basis s age previously used moldboard plow expected years ownership heavy duty disk hp engine on sellpropelled tandem harrow d ddiesel ggas chisel plows fuel gallon subsoiler estimated useyear cultivator spring tooth rollerpacker mulcherpackers implement through rotary hoe mowerconditionerrotary row crop cultivators annual average fixed tiller planter notill conventional width in feet grain drill acres corn picker sheller times over range typical most recent data american society engineer combines pulltype efficiency percent as july it is called biological engineers combine selfpropelled speed mph user can taylor analysis their situation inputting many values ie mowercondition...

Share

https://contohmemo.jagomart.net/item/49322/machcost06

no reviews yet
Please Login to review.

Category: Uncategorized / Uncategorized
Posted on: 17 Aug 2022 | 3 years ago
Tag: download xls, machcost06,
Filetype: XLS
File size: 0.11 MB
Views: 161x
Link recommended: filekonstruksi.com