Spreadsheet: 0b78c116-02cd-4147-afa8-d63e8f9a8466
Sheet: Input

Price per bushel at local elevator |  | 9 | $/bu
Potential Grain Yield (bu/acre) |  | 150 | bu/A
Dry Matter of Harvested Silage |  | 35 | %
Market price for corn silage from silo |  | 85 | $[NAME]
Cost of P2O5 |  | 0.62 | $/lb
Cost of K2O |  | 0.55 | $/lb
Corn Silage Quality - % of Normal |  | 100 | %
Corn Grain Discount ($ per bushel) |  | 0 | $/bu
 |  |  |  |  |  |  |  |  |  |  |  | Grain Grower's Perspective:
Grain Grower's Perspective |  |  |  |  | Buyer's Perspective |  |  |  |  |  |  | Corn Price | Chopped Corn
(to Net the same amount from selling Standing Corn |  |  |  |  | (to Pay the same as buying corn silage from a silo) |  | Buy Standing Corn |  |  |  |  | $/bushel | $/Ton
as if harvesting [NAME]) |  | Per Acre | Per Bushel |  |  |  | Per Ton
Grower's Gross Income(bu x price) |  |  |  |  | Price of corn silage from silo* |  |  | *includes delivery charge |  |  |  | 4.75
Harvest cost per acre | - |  |  |  | Harvest cost | - |  |  |  |  |  | 5
Grain Hauling (field to mill) | - |  |  |  | Storage Cost | - |  |  |  |  |  | 5.25
Drying Charge | - |  |  |  | Dry Matter Loss | - |  |  |  |  |  | 5.5
Cost of additional P & K removal w/ silage harvest | + |  |  |  | Subtotal | = |  |  |  |  |  | 5.75
Corn Grain Discount ($[NAME]) | - |  |  |  | Corn Silage Quality Discount | - |  |  |  |  |  | 6
Chopped corn price, breakeven with shelled corn net | = |  |  |  |  |  |  |  |  |  |  | 6.25
Potential chopped corn yield ([NAME]/acre)1 |  | 20 |  |  |  |  |  |  |  |  |  | 6.5
 |  |  |  |  |  |  |  |  |  |  |  | 6.75
Price per Ton of Unfermented Chopped Corn needed to Equal Shelled Corn Net | = |  |  |  | Price per Ton of Unfermented Chopped Corn needed to equal Corn silage price delivered from silo | = |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 7.25
 |  |  |  |  |  |  |  |  |  |  |  | 7.5
 |  |  |  |  |  |  |  |  |  |  |  | 7.75
 |  |  |  |  |  |  |  |  |  |  |  | 8
http://www.nass.usda.gov/Statistics_by_State/Pennsylvania/Publications/Machinery_Custom_Rates/CustomRates%202012.pdf |  |  |  |  |  |  |  |  |  |  |  | 8.25
 |  | Your Farm: |  |  | 2012 Machinery Custom Rates: |  |  |  |  |  |  | 8.5
Grain Hauling |  | 0.25 | $/bushel |  | 0.2 | $/bushel (Local) |  |  |  |  |  | 8.75
Drying Charge |  | 0.6 | $/bushel |  | 0.46 | $/bushel |  |  |  |  |  | 9
Corn Combining |  | 40 | $/acre |  | 30.9 | $/acre
Chop/Haul/Fill |  | 10 | $/Ton |  | 9.6 | $/Ton
Silage Delivery Charge |  | 5 | $/Ton |  |  | $/Ton
Dry Matter Loss2 |  | 13 | % |  |  | %
Storage Cost Silage |  | 2 | $/Ton |  |  | $/Ton
1 Man 1 Truck $64.90/hour |  | 64.9 | /hour |  |  |  |  |  |  |  |  |  |  |  |  | P2O5 | K2O
 |  |  | /Ton for 16 Ton Load - 1 Load per Hour |  |  |  |  |  |  |  |  |  |  |  |  | $/lb | $/lb
 |  |  |  |  |  |  |  |  |  |  |  |  | Yield | P2O5 | K2O |  |  | P2O5 | K2O | Nutrient cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  | lb/bu or ton | lb/bu or ton |  |  | $/acre | $/acre | $/acre
 |  |  |  |  |  |  |  |  |  |  |  | Nutrient (P2O5 and K2O) removal (grain) |  | 0.4 | 0.3
 |  |  |  |  |  |  |  |  |  |  |  | Nutrient(P2O5 and K2O) removal (silage) |  | 3.5 | 8
 |  |  |  |  |  |  |  |  |  |  |  | Difference
http://corn.agronomy.wisc.edu/AA/pdfs/A045.pdf