Manure Distance Worksheet
Step 1 Factors Needed to Complete Worksheet
I. Manure Test Information
Solid/Semi Solid Manure lbs. Per Ton
Nitrogen
Phosphorus
Potassium
II. Input Values / Costs Cost per lb.
Nitrogen
Phosphorus
Potassium
Tractor Size in Horsepower (that pulls manure spreader)
Average road speed traveling to and from field (in mph)
Capacity of manure spreader in tons or gallons
Fuel Cost per Gallon
Labor cost per hour
Step 2: N, P & K Amount and Value per Spreader Load
N, P & K Amounts
Tons per Spreader Load 0
lbs. Nitrogen per load 0
lbs. Phosphorus per load 0
lbs. Potassium per load 0
Step 3: Fertilizer Value of a Spreader Load
N, P & K Value
Nitrogen value per load $0.00
Phosphorus value per load $0.00
Potassium value per load $0.00
Total Value per Load $0.00
Step 4: Calculate Operating Costs
Cost of Operating Tractor for 1 hour
(source MSU Extension) or use other worksheet
Step 5: Calculating Breakeven Distance for Hauling Manure
Cost of tractor and spreader for 1 hour* $ -
Cost of tractor and spreader per mile #DIV/0!
Breakeven miles manure can be hauled #DIV/0!
Distance can travel one way #DIV/0!
*Input from MSU Custom Rate Bulletin
MSU Agricultural Economics Report No. 613
Custom Machine Work Rates, May 2002 Average Rate
Manure Handling
Solid Manure Spreading Only $36.00
Solid Manure Loading and Spreading $43.15
Liquid Manure Hauling and Spreading $109.60
Manure Distance Worksheet
Step 1 Factors Needed to Complete Worksheet
I. Manure Test Information
Liquid Manure lbs. Per 1,000 Gallons
Nitrogen
Phosphorus
Potassium
II. Input Values / Costs Cost per lb.
Nitrogen
Phosphorus
Potassium
Tractor Size in Horsepower (that pulls manure spreader)
Average road speed traveling to and from field (in mph)
Capacity of manure spreader in tons or gallons
Fuel Cost per Gallon
Labor cost per hour
Step 2: N, P & K and Value Per Spreader Load
N, P & K Amounts
Gallons per Spreader Load 0
lbs. Nitrogen per load 0
lbs. Phosphorus per load 0
lbs. Potassium per load 0
N, P & K Value
Nitrogen value per load $0.00
Phosphorus value per load $0.00
Potassium value per load $0.00
$0.00
Step 4: Calculate Operating Costs
Cost of Operating Tractor for 1 hour $ 25.00
(source MSU Extension) or use other worksheet
Step 5: Calculating Breakeven Distance for Hauling Manure
Cost of tractor and spreader for 1 hour $ 25.00
Cost of tractor and spreader per mile #DIV/0!
Breakeven miles manure can be hauled #DIV/0!
Distance can travel one way #DIV/0!
MSU Agricultural Economics Report No. 613 Average
Custom Machine Work Rates, May 2002 Rate
Manure Handling
Solid Manure Spreading Only $36.00
Solid Manure Loading and Spreading $43.15
Liquid Manure Hauling and Spreading $109.60
Manure Distance Worksheet
How Far Can You Afford to Haul?
Customer____________________________ Prepared by_________________________
Date________________________________
Step 1 Factors Needed to Complete Worksheet
I. Manure Test Information Liquid Solid
Liquid or Solid lbs. Per 1,000 lbs. Per Ton
Nitrogen
Phosphorus
Potassium
II. Input Values / Costs Cost per lb.
Nitrogen
Phosphorus
Potassium
Average road speed traveling to and from field (in mph)
Capacity of manure spreader in tons or gallons
Step 2: N, P & K and Value Per Spreader Load
N, P & K Amounts
Tons/Gallons per Spreader Load
Formula to Use: tons or gallons in spreader X nutrient per ton or per 1,000 gal. = lbs. Nutrient per load
lbs. Nitrogen per load
lbs. Phosphorus per load
lbs. Potassium per load
N, P & K Value
Formula to Use: Nutrient cost X lbs. Nutrient = Nutrient Value per load
Nitrogen value per load
Phosphorus value per load
Potassium value per load
Sum of values for total value per load
Step 4: Calculate Operating Costs
Cost of Operating Tractor for 1 hour
MSU Agricultural Economics Report No. 613 Average
Custom Machine Work Rates, May 2002 Rate
Manure Handling
Solid Manure Spreading Only $36.00
Solid Manure Loading and Spreading $43.15
Liquid Manure Hauling and Spreading $109.60
Step 5: Calculating Breakeven Distance for Hauling Manure
Cost of tractor and spreader for 1 hour From Step 4
Cost of tractor and spreader per mile
Formula: Cost of tractor operation per hour divided by mph
Breakeven miles manure can be hauled
Formula: total fertilizer value (step 3) divided by cost per mile
Distance can travel one way
Formula: breakeven miles divided by 2
Manure Distance Worksheet
Example of Computer Printout
Customer__Dairy Liquid__________________ Prepared by_______________
Date______________________
input data in the shaded areas
Step 1 Factors Needed to Complete Worksheet
I. Manure Test Information
Liquid Manure lbs. Per 1,000 Gallons
Nitrogen 20
Phosphorus 10
Potassium 17
II. Input Values / Costs Cost per lb.
Nitrogen 0.11
Phosphorus 0.12
Potassium 0.12
Tractor Size in Horsepower (that pulls manure spreader) 110
Average road speed traveling to and from field (in mph) 4
Capacity of manure spreader in tons or gallons 4000
Fuel Cost per Gallon 1.5
Labor cost per hour 15
Step 2: N, P & K and Value Per Spreader Load
N, P & K Amounts
Gallons per Spreader Load 4000
lbs. Nitrogen per load 80
lbs. Phosphorus per load 40
lbs. Potassium per load 68
N, P & K Value
Nitrogen value per load $8.80
Phosphorus value per load $4.80
Potassium value per load $8.16
$21.76
Step 4: Calculate Operating Costs
Cost of Operating Tractor for 1 hour $ 109.60
(source MSU) or use other worksheet
Step 5: Calculating Breakeven Distance for Hauling Manure
Cost of tractor and spreader for 1 hour $ 109.60
Cost of tractor and spreader per mile $ 27.40
Breakeven miles manure can be hauled 0.8
Distance can travel one way 0.4
MSU Agricultural Economics Report No. 613 Average
Custom Machine Work Rates, May 2002 Rate
Manure Handling
Solid Manure Spreading Only $36.00
Solid Manure Loading and Spreading $43.15
Liquid Manure Hauling and Spreading $109.60
Manure Distance Worksheet
Example of Computer Printout