Spreadsheet: 15a6a392-54e8-479c-b0b9-0a51f8e9561e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | Number in |  | Silage |  | Total Forage
 | Herd | Silage DM | Hay Ratio | Corn Ratio | Must Equal 100
 |  | (Lbs DM/animal/day) | in the ration       (%) | (%) | (%) |  | Determining Value of Improved Silage Management
Milking Cows | 85 | 26 | 40 | 60 | 100 |  | [NAME] |  |  | Modified: May 19, 2011
Dry Cows | 15 | 21 | 60 | 40 | 100 |  | Professor and Extension Specialist
[NAME] | 84 | 14 | 50 | 50 | 100 |  | Biological Systems Engineering Dept. |  |  |  | Yellow cells are user changeable
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME], WI 53706
[NAME] (Lbs DM/day) | 1661 |  |  | Good | Not So Good |  | [PHONE]
Herd Corn Silage Consumed (Lbs DM/day) | 2040 |  |  | Management | Management |  | [EMAIL]
Herd Daily Total DMI (lbs/day) | 3701 |  | Unavailable TDN (%) = | 1 | 5
 |  |  | Price of Corn ($/Bu)= | 6 | 6
Hay Value ($/T DM) | 150 |  | Value of TDN ($/lb DM) = | 0.121255 | 0.121255
Corn Silage ($/T DM) | 125 |  | Value of Unavailable TDN per
 |  |  | Ton of Forage Dry Matter ($/T DM)= | 2.4251 | 12.1255
 | Herd Annual |  | Identify Below Where Heating Occurred by selectiog Only One "Yes" for Each Column E and F
 | Consumption |  | Feeding Loss | No | No |  |  |  |  |  |  |  | No
 | (T DM/yr) | Ratio (%) | Storage Feed Out Loss | No | Yes |  | 1 |  |  |  |  |  | Yes
Herd Annual Hay Consumption | 303.1325 | 44.87976222642529 | Storage Loss | Yes | No | 1
Herd Annual Corn Silage Consumption | 372.3 | 55.12023777357471
Herd Annual Total Forage Consumption | 675.4325 | 100 |  |  |  | 1 | 1
 |  | Quantity | Quantity | Value |  |  | Quantity | Quantity | Value
Good Management |  | Before | Lost | Lost |  |  | Before | Lost | Lost
 | Hay Silage | Operation |  |  |  | Corn Silage | Operation
Operation | (%) | (T DM/yr) | (T DM/yr) | ($/yr) |  | (%) | (T DM/yr) | (T DM/yr) | ($/yr)
Feeding Loss | 5 | 319.0868421052631 | 15.95434210526315 | 2393.151315789473 |  | 5 | 391.8947368421053 | 19.59473684210531 | 2449.342105263163
Storage Feed Out Loss | 3 | 328.9555073250136 | 9.868665219750426 | 1480.299782962564 |  | 3 | 404.0151926207271 | 12.12045577862182 | 1515.056972327727
Storage Loss | 10 | 365.506119250015 | 36.55061192500148 | 6280.341789564112 |  | 10 | 448.9057695785857 | 44.89057695785857 | 6591.099363356846
Filling Loss | 1 | 369.1981002525404 | 3.691981002525381 | 553.7971503788071 |  | 1 | 453.4401712915007 | 4.534401712914985 | 566.8002141143731
Harvest Loss | 6 | 392.7639364388728 | 23.56583618633238 | 3534.875427949856 |  | 1 | 458.0203750419199 | 4.58020375041923 | 572.5254688024038
 |  |  |  |  |  |  |  |  |  |  | Total Loss
 |  |  |  |  |  |  |  |  |  |  | ($/yr)
Total (Sum of Individual Losses) |  |  | 89.63143643887281 | 14242.46546664481 | /yr |  |  | 85.72037504191991 | 11694.82412386451 | /yr | 25937.28959050932 | /yr
Total (Cumulative Losses, %) | 22.82068899999999 | % |  |  |  | 18.71540650000001 | %
 |  | Quantity | Quantity | Value |  |  | Quantity | Quantity | Value
Not So Good Management |  | Before | Lost | Lost |  |  | Before | Lost | Lost
 | Hay Silage | Operation |  |  |  | Corn Silage | Operation
Operation | (%) | (T DM/yr) | (T DM/yr) | ($/yr) |  | (%) | (T DM/yr) | (T DM/yr) | ($/yr)
Feeding Loss | 7 | 325.9489247311828 | 22.81642473118279 | 3422.463709677419 |  | 7 | 400.3225806451613 | 28.02258064516133 | 3502.822580645166
Storage Feed Out Loss | 5 | 343.1041312959819 | 17.15520656479913 | 6525.574671547825 |  | 5 | 421.3921901528014 | 21.06960950764011 | 7487.812640067918
Storage Loss | 15 | 403.6519191717434 | 60.54778787576151 | 9082.168181364228 |  | 15 | 495.7555178268253 | 74.36332767402382 | 9295.415959252978
Filling Loss | 3 | 416.1359991461272 | 12.4840799743838 | 1872.611996157571 |  | 3 | 511.0881627080673 | 15.33264488124206 | 1916.580610155258
Harvest Loss | 8 | 452.3217382023122 | 36.18573905618496 | 5427.860858427744 |  | 2 | 521.518533375579 | 10.43037066751162 | 1303.796333438953
 |  |  |  |  |  |  |  |  |  |  | Total Loss
 |  |  |  |  |  |  |  |  |  |  | ($/yr)
Total (Sum of Individual Losses) |  |  | 149.1892382023122 | 26330.67941717479 | /yr |  |  | 149.2185333755789 | 23506.42812356027 | /yr | 49837.10754073506 | /yr
Total (Cumulative Losses, %) | 32.982991 | % |  |  |  | 28.61231650000003 | %
Move From Not So Good
Management to Good Management | Change in |  | Reduction | Reduction |  | Change in |  | Reduction | Reduction
 | Percentage |  | of Quantity | of Value |  | Percentage |  | of Quantity | of Value
 | Hay Lost |  | Lost | Lost |  | Corn Silage |  | Lost | Lost
 |  |  |  |  |  | Lost
 | (%) |  | (T DM/yr) | ($/yr) |  | (%) |  | (T DM/yr) | ($/yr) |  | Total Reduction of
 |  |  |  |  |  |  |  |  |  |  | Value Lost ($/yr)
Change "Not so good to good management" | 10.162302 | % | 59.55780176343939 | 12088.21395052997 | /yr | 9.89691000000002 | % | 63.49815833365903 | 11811.60399969576 | /yr | 23899.81795022573 | /yr