Spreadsheet: 064e61be-8421-4bf2-add8-e49315035b3f
Sheet: Sheet1

Unnamed: 0 | Comparing Marketing Alternatives | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | Number of Lambs/Goats |  |  |  | 20
 |  | On-Farm Weight |  |  |  | 100
OPTION 1:  ON-FARM SLAUGHTER SALE |  |  |  |  | OPTION 2:  SELL TO LOCAL AUCTION
 |  | Per Lamb | Total |  |  |  | Per Lamb | Total |  | SUMMARY | Gross price | Net Price
Shrink Loss |  |  |  |  | Shrink Loss
On-farm weight |  | 100 | 2000 |  | On-farm weight |  | 100 | 2000 |  | On-farm sale | 1 | 0.992
Shrink | 0 | 0 | 0 |  | Shrink | 0.04 | 4 | 80 |  | Local Auction | 1 | 0.9000999999999999
Selling weight |  | 100 | 2000 |  | Selling weight |  | 96 | 1920 |  | Regional Auction | 1 | 0.8343
Income per lamb | 1 | 100 | 2000 |  | Income per lamb | 1 | 96 | 1920 |  | Middleman | 1 | 0.9551999999999999
Selling Fees |  |  |  |  | Selling Fees |  |  |  |  | by [NAME]
Sales Commission | 0 | 0 | 0 |  | Sales Commission | 3 | 3 | 60
Yardage | 0 | 0 | 0 |  | Yardage | 1 | 1 | 20 |  | To compare marketing options, you need to determine
Insurance | 0 | 0 | 0 |  | Insurance | 1 | 1 | 20 |  | the net price offered by each option.  Prices need to
Check-off (live) | 0.005 | 0.5 | 10 |  | Check-off (live) | 0.005 | 0.48 | 9.6 |  | be adjusted for shrinkage, selling fees, check-off fees,
Check-off (carcass) | 0.3 | 0.3 | 6 |  | Check-off (carcass) | 0 | 0 | 0 |  | transportion, and other costs -- which vary for each option.
Total deductions |  | 0.8 | 16 |  | Total deductions |  | 5.48 | 109.6
Income - deductions |  | 99.2 | 1984 |  | Income - deductions |  | 90.52 | 1810.4
Hauling and other expenses |  |  |  |  | Hauling and other expenses
Round trip mileage | 0 | * | * |  | Round trip mileage | 30 | * | *
Mileage rate | 0.34 | 0 | 0 |  | Mileage rate | 0.34 | 0.51 | 10.2
Other Expenses | 0 | 0 | 0 |  | Other Expenses | 0 | 0 | 0
Total |  | 0 | 0 |  | Total |  | 0.51 | 10.2
Income - other costs |  | 99.2 | 1984 |  | Income - other costs |  | 90.00999999999999 | 1800.2
NET PRICE PER POUND |  | 0.992 | 0.992 |  | NET PRICE PER POUND |  | 0.9000999999999999 | 0.9001
OPTION 3:  SELL TO REGIONAL AUCTION |  |  |  |  | OPTION 4:  SELL TO MIDDLEMAN
 |  | Per Lamb | Total |  |  |  | Per Lamb | Total
Shrink Loss |  |  |  |  | Shrink Loss
On-farm weight |  | 100 | 2000 |  | On-farm weight |  | 100 | 2000
Shrink | 0.06 | 6 | 120 |  | Shrink | 0.04 | 4 | 80
Selling weight |  | 94 | 1880 |  | Selling weight |  | 96 | 1920
Income per lamb | 1 | 94 | 1880 |  | Income per lamb | 1 | 96 | 1920
Selling Fees |  |  |  |  | Selling Fees
Sales Commission | 3 | 3 | 60 |  | Sales Commission | 0 | 0 | 0
Yardage | 1 | 1 | 20 |  | Yardage | 0 | 0 | 0
Insurance | 1 | 1 | 20 |  | Insurance | 0 | 0 | 0
Check-off (live) | 0.005 | 0.47 | 9.4 |  | Check-off (live) | 0.005 | 0.48 | 9.6
Check-off (carcass) | 0 | 0 | 0 |  | Check-off (carcass) | 0 | 0 | 0
Total deductions |  | 5.47 | 109.4 |  | Total deductions |  | 0.48 | 9.6
Income - deductions |  | 88.53 | 1770.6 |  | Income - deductions |  | 95.52 | 1910.4
Hauling and other expenses |  |  |  |  | Hauling and other expenses
Round trip mileage | 300 | * | * |  | Round trip mileage | 0 | * | *
Mileage rate | 0.34 | 5.100000000000001 | 102 |  | Mileage rate | 0 | 0 | 0
Other Expenses | 0 | 0 | 0 |  | Other Expenses | 0 | 0 | 0
Total |  | 5.100000000000001 | 102 |  | Total |  | 0 | 0
Income - other costs |  | 83.43 | 1668.6 |  | Income - other costs |  | 95.52 | 1910.4
NET PRICE PER POUND |  | 0.8343 | 0.8342999999999999 |  | NET PRICE PER POUND |  | 0.9551999999999999 | 0.9552