Spreadsheet: 4b79d690-ac9e-4b23-9a39-e03d08d009c8
Sheet: Sheet1

Input Values | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  |  |  |  |  | Difference
On-Farm AI |  |  |  |  |  |  | Commercial | (CS-OnFS)
365 | Number of days in period of analysis |  |  |  |  |  | 365 | 0
 | Farrowing Facility & Productivity Factors
35 | Interval between farrowings, days |  |  |  |  |  | 35 | 0
20 | Number of farrowing crates per group bred |  |  |  |  |  | 20 | 0
0.835 | Estimated farrowing rate to be sure farrowing crates are full, % |  |  |  |  |  | 0.835 | 0
0.835 | Actual farrowing rate, % |  |  |  |  |  | 0.87 | 0.03500000000000003
 | Average number of [NAME] per Litter
10.5 | Normal weaned sows before pigs transferred in |  |  |  |  |  | 11 | 0.5
9 | Early weaned/problem sows before pigs transferred out |  |  |  |  |  | 9.2 | 0.1999999999999993
0.04 | Proportion of farrowing that are early weaned/problem sows |  |  |  |  |  | 0.03 | -0.01
0.91 | Preweaning survival, % |  |  |  |  |  | 0.91 | 0
10 | Initial weight of pig, lbs |  |  |  |  |  | 10 | 0
0.975 | Survival rate weaning to market, % |  |  |  |  |  | 0.975 | 0
 | Boar Isolation Phase for On-Farm AI Boars
60 | Number of days in isolation |  |  |  |  |  | 0
0.4 | Labor for care of animals (hours per day) |  |  |  |  |  | 0
8.75 | Labor for training boars to mount dummy (total hours per boar) |  |  |  |  |  | 0
10 | Rate of pay for labor ($ per hour) |  |  |  |  |  | 0
0.05 | Feed cost ($ per pound) |  |  |  |  |  | 0
6.5 | Boar feed (pounds per head per day) |  |  |  |  |  | 0
0.5 | Boar housing ($ per day) |  |  |  |  |  | 0
120 | Veterinary fees per boar |  |  |  |  |  | 0
 | Number of Boars & Breeding Facility Management Factors
2 | Number of On-Farm AI boars |  |  |  |  |  | 0 | -2
16 | Useful life span of On-Farm AI boars, months
1 | Number of heat-checking boars |  |  |  |  |  | 1 | 0
12 | Useful life span of heat-check boars, months |  |  |  |  |  | 12 | 0
1500 | Average purchase price of On-Farm AI boars, $ |  |  |  |  |  | 0 | -1500
100 | Cull value of on-farm AI boars, $ |  |  |  |  |  | 0
180 | Average purchase price of heat-check boars, $ |  |  |  |  |  | 180 | 0
80 | Cull value of heat-check boars, $ |  |  |  |  |  | 80 | 0
2 | Average number of inseminations per female per estrus |  |  |  |  |  | 2 | 0
6 | Pounds of feed per On-Farm AI boar per day |  |  |  |  |  | 0 | -6
0.06 | Cost per pound of feed for AI boars |  |  |  |  |  | 0 | -0.06
5 | Pounds of feed per heat-check boar per day |  |  |  |  |  | 5 | 0
0.05 | Cost per pound of feed for heat-check boars, $ |  |  |  |  |  | 0.05 | 0
2 | Animal husbandry labor for On-Farm AI boars, min/hd/day |  |  |  |  |  | 0 | -2
10 | Rate of pay for animal husbandry labor, $/hour |  |  |  |  |  | 10 | 0
0.5 | Daily cost of housing structure for heat-check boars, $ |  |  |  |  |  | 0.5 | 0
1000 | Cost of "structure" for AI boars, collection area & laboratory, $ |  |  |  |  |  | 0 | -1000
7 | Useful life span of structure, years |  |  |  |  |  | 0
0.8 | Percent of construction cost financed |  |  |  |  |  | 0
0.08 | Interest rate, % |  |  |  |  |  | 0
7 | Number of payment periods |  |  |  |  |  | 0
0.005 | Yearly taxes (% of total investment) |  |  |  |  |  | 0
0.01 | Yearly insurance (% of total investment) |  |  |  |  |  | 0
 | Semen Processing Aspects
15 | Average number of doses per collection |  |  |  |  |  | 0 | -15
30 | Average number of doses per boar per week |  |  |  |  |  | 0 | -30
10 | Labor to collect boars (min/collection) |  |  |  |  |  | 0 | -10
10 | Labor to process semen (min/collection) |  |  |  |  |  | 0 | -10
20 | Labor to clean laboratory (min/day of use) |  |  |  |  |  | 0 | -20
3.2 | Number of collections per week (group) |  |  |  |  |  | 0 | -3.2
2 | Number of days per week semen is collected
10 | Rate of pay for labor ($ per hour) |  |  |  |  |  | 0 | -10
1208 | Cost of nonconsumable AI equipment, $ |  |  |  |  |  | 159 | -1049
724 | Cost of consumable AI equipment, $ |  |  |  |  |  | 724 | 0
Input Values
 |  |  |  |  |  |  |  | Difference
On-Farm AI | Distibution of feed (weaning to slaughter weight) |  |  |  |  |  | Commercial | (CS-OnFS)
3 | Starter 1 (lbs per pig; 8 to 13 lbs body weight) |  |  |  |  |  | 3 | 0
15 | Starter 2 (lbs per pig; 13 to 25 lbs body weight) |  |  |  |  |  | 15 | 0
50 | Starter 3 (lbs per pig; 25 to 45 lbs body weight) |  |  |  |  |  | 47 | -3
87 | Grower 1 (lbs per pig; 45 to 80 lbs) |  |  |  |  |  | 82 | -5
149 | Grower 2 (lbs per pig; 80 to 130 lbs body weight) |  |  |  |  |  | 144 | -5
190 | Finisher 1 (lbs per pig; 130 to 190 lbs body weight) |  |  |  |  |  | 185 | -5
228 | [NAME] (lbs per pig; 190 to 250 lbs body weight) |  |  |  |  |  | 216 | -12
722 | Calculated total pounds of feed |  |  |  |  |  | 692 | -30
3.008333333333333 | Calculated feed efficiency |  |  |  |  |  | 2.883333333333333 | -0.125
 | Price of feed, $/lb
0.12 | Starter 1 |  |  |  |  |  | 0.12 | 0
0.117 | Starter 2 |  |  |  |  |  | 0.117 | 0
0.076 | Starter 3 |  |  |  |  |  | 0.076 | 0
0.064 | Grower 1 |  |  |  |  |  | 0.064 | 0
0.056 | Grower 2 |  |  |  |  |  | 0.056 | 0
0.054 | Finisher 1 |  |  |  |  |  | 0.054 | 0
0.051 | Finisher 2 |  |  |  |  |  | 0.051 | 0
 | Carcass premium
0.3876 | Base price per head liveweight ($ per lb) |  |  |  |  |  | 0.3876 | 0
0 | Increase in base price per head liveweight ($ per lb) |  |  |  |  |  | 0.0102 | 0.0102
4 | Average carcass premium ($ per head) |  |  |  |  |  | 7.21 | 3.21
On-Farm AI | Commercial Semen |  |  |  |  |  | Commercial | (CS-OnFS)
0 | Cost per dose of commercial semen, $ |  |  |  |  |  | 6.5 | 6.5
0 | Number of semen deliveries per group bred |  |  |  |  |  | 2 | 2
0 | Cost for overnight freight per delivery |  |  |  |  |  | 40 | 40
 | Market weight and price
250 | Weight of pigs at slaughter, lbs |  |  |  |  |  | 250 | 0
0.28 | Price received at slaughter, $/lb |  |  |  |  |  | 0.28 | 0
 | Miscellaneous items
0.0045 | National Legislative Pork Check-Off, $ per gross dollar value |  |  |  |  |  | 0.0045 | 0
0.0021 | Freight insurance on slaughter pigs, $/lb of liveweight |  |  |  |  |  | 0.0021 | 0
Calculated Values
 | Isolation Facility Aspects |  |  |  |  |  |  | (CS-OnFS)
60 | Isolation costs for On-Farm AI boars (housing), $ |  |  |  |  |  | 0 | -60
39 | Isolation costs for On-Farm AI boars (feed), $ |  |  |  |  |  | 0 | -39
240 | Isolation costs for On-Farm AI boars (veterinary fees), $ |  |  |  |  |  | 0 | -240
240 | Isolation costs for On-Farm AI boars (labor for animal care), $ |  |  |  |  |  | 0 | -240
175 | Isolation costs for On-Farm AI boars (labor for training boars), $ |  |  |  |  |  | 0 | -175
 | Breeding Facility Aspects
24 | Number of females bred per group |  |  |  |  |  | 24 | 0
48 | Total number of inseminations per group bred |  |  |  |  |  | 48 | 0
250 | Total number of females bred in period of analysis |  |  |  |  |  | 250 | 0
500 | Total number of services in period of analysis |  |  |  |  |  | 500 | 0
1.6 | Minimum number of boars needed for sperm production |  |  |  |  |  | 0 | -1.6
2101.151315789474 | Investment in On-Farm AI boars (minus cull value), $ |  |  |  |  |  | 0 | -2101.151315789474
80.04385964912281 | Investment in heat-check boars (minus cull value), $ |  |  |  |  |  | 80.04385964912281 | 0
262.8 | Cost of On-Farm AI boar feed, $ |  |  |  |  |  | 0 | -262.8
91.25 | Cost of heat-check boar feed,$ |  |  |  |  |  | 91.25 | 0
182.5 | Cost of housing structure for heat-check boars, $ |  |  |  |  |  | 182.5 | 0
243.3333333333333 | Total cost of animal husbandry labor for On-Farm AI boars, $ |  |  |  |  |  | 0 | -243.3333333333333
800 | Total dollars borrowed for AI "structure" |  |  |  |  |  | 0 | -800
153.6579211427284 | Amortized prinicipal and interest payment per year |  |  |  |  |  | 0 | -153.6579211427284
28.57142857142857 | Nonfinanced dollars spread over useful life span of structure |  |  |  |  |  | 0 | -28.57142857142857
33.12 | Taxes and insurance (yearly cost) |  |  |  |  |  | 0 | -33.12
215.3493497141569 | Total cost of AI structure for period analyzed |  |  |  |  |  | 0 | -215.3493497141569
Calculated Values
On-Farm AI | Farrowing Facility Aspects |  |  |  |  |  | Commercial | (CS-OnFS)
10.42857142857143 | Total number of groups bred in period of analysis |  |  |  |  |  | 10.42857142857143 | 0
208.75 | Total number of sows farrowed during period of analysis |  |  |  |  |  | 217 | 8.25
208.8 | Average number pigs born alive per group |  |  |  |  |  | 218.92 | 10.12
10.44 | Avg number of PIGS BORN ALIVE/sow farrowed/group |  |  |  |  |  | 10.946 | 0.5060000000000002
1981 | Total number of pigs weaned during period of analysis |  |  |  |  |  | 2077 | 96
1931 | Total number of slaughter pigs sold |  |  |  |  |  | 2025.075 | 94.07500000000005
 | Semen Processing Aspects
33.37142857142857 | Total number of collections per period of analysis |  |  |  |  |  | 0 | -33.37142857142857
55.61904761904762 | Cost of labor to collect boars in period of analysis, $ |  |  |  |  |  | 0 | -55.61904761904762
55.61904761904762 | Cost of labor to process semen in period of analysis, $ |  |  |  |  |  | 0 | -55.61904761904762
69.52380952380952 | Cost of labor to clean laboratory in period of analysis, $ |  |  |  |  |  | 0 | -69.52380952380952
On-Farm AI | Artificial Insemination Costs |  |  |  |  |  | Commercial | (CS-OnFS)
6043.189763247991 | On-Farm expenses for AI |  |  |  |  |  | 1236.793859649123 | -4806.395903598868
0 | Cost for doses of commercial semen |  |  |  |  |  | 3250 | 3250
0 | Freight to deliver semen |  |  |  |  |  | 834.2857142857143 | 834.2857142857143
6043.189763247991 | Total expense for AI semen |  |  |  |  |  | 5321.079573934838 | -722.1101893131536
 | No improvement in farrowing rate, litter size, feed to gain or carcass quality
12.08637952649598 | AI semen cost per service |  |  |  |  |  | 10.64215914786968 | -1.444220378626307
24.17275905299196 | AI semen cost per female bred |  |  |  |  |  | 21.28431829573935 | -2.888440757252614
3.050575347424529 | AI semen cost per pig weaned |  |  |  |  |  | 2.686057331617788 | -0.3645180158067407
3.129564869626096 | AI semen cost per slaughter pig |  |  |  |  |  | 2.755608272363976 | -0.3739565972621199
188794.710236752 | Gross income minus AI cost |  |  |  |  |  | 129848.9204260652 | -58945.78981068684
On-Farm AI | Influence of "only" improving farrowing rate |  |  |  |  |  | Commercial | (CS-OnFS)
208.75 | Number of females farrowed |  |  |  |  |  | 217 | 8.25
190.008 | Total number of pigs weaned per group |  |  |  |  |  | 190.008 | 0
1981 | Total number of pigs weaned per period of analysis |  |  |  |  |  | 2061.5868 | 80.58680000000004
1931 | Total number of slaughter pigs per period of analysis |  |  |  |  |  | 2010.04713 | 79.04712999999992
194837.9 | Gross income at slaughter weight |  |  |  |  |  | 202813.755417 | 7975.855416999984
188794.710236752 | Income minus AI cost |  |  |  |  |  | 197492.6758430651 | 8697.96560631314
On-Farm AI | Influence of "only" improving litter size born live |  |  |  |  |  | Commercial | (CS-OnFS)
208.75 | Number of females farrowed |  |  |  |  |  | 208.75 | 0
10.44 | Average number of pigs born alive per litter |  |  |  |  |  | 10.946 | 0.5060000000000002
208.8 | Average number of pigs born alive per group |  |  |  |  |  | 218.92 | 10.12
9.500399999999999 | Average number of pigs weaned per litter |  |  |  |  |  | 9.96086 | 0.4604600000000012
189.958904109589 | Average number of pigs weaned per group |  |  |  |  |  | 199.3877626712329 | 9.428858561643835
1981 | Total number of pigs weaned per period of analysis |  |  |  |  |  | 2079.329525 | 98.3295250000001
1931 | Total number of slaughter pigs per period of analysis |  |  |  |  |  | 2027.346286875 | 96.34628687500003
194837.9 | Gross income at slaughter weight |  |  |  |  |  | 204559.2403456875 | 9721.340345687495
188794.710236752 | Income minus AI cost |  |  |  |  |  | 199238.1607717526 | 10443.45053500065
On-Farm AI | Influence of improved farrowing rate & litter size born live |  |  |  |  |  | Commercial | (CS-OnFS)
208.75 | Number of females farrowed |  |  |  |  |  | 217 | 8.25
190.008 | Number of pigs weaned per group |  |  |  |  |  | 199.3877626712329 | 9.379762671232896
1981 | Total number of pigs weaned per period of analysis |  |  |  |  |  | 2163.357224982877 | 182.3572249828767
1931 | Total number of slaughter pigs per period of analysis |  |  |  |  |  | 2109.273294358305 | 178.2732943583046
194837.9 | Gross income at slaughter weight |  |  |  |  |  | 212825.675400753 | 17987.77540075296
188794.710236752 | Income minus AI cost |  |  |  |  |  | 207504.5958268181 | 18709.88559006611
On-Farm AI | Influence of "only" improving feed efficiency |  |  |  |  |  | Commercial | (CS-OnFS)
1931 | Total number of slaughter pigs per period of analysis |  |  |  |  |  | 1931 | 0
722 | Total lbs of feed per pig from weaning to slaughter |  |  |  |  |  | 692 | -30
3.008333333333333 | Feed to gain ratio |  |  |  |  |  | 2.883333333333333 | -0.125
41.715 | Total feed cost from weaning to slaughter, ($/pig) |  |  |  |  |  | 40.005 | -1.709999999999994
80551.665 | Feed cost for pigs from weaning to slaughter |  |  |  |  |  | 77249.655 | -3302.009999999995
108243.045236752 | Gross income minus feed and AI cost |  |  |  |  |  | 112267.1654260652 | 4024.120189313151
On-Farm AI | Influence of "only" improving carcass traits |  |  |  |  |  | Commercial | (CS-OnFS)
1931 | Number of slaughter pigs sold |  |  |  |  |  | 1931 | 0
194837.9 | Gross income with carcass premium |  |  |  |  |  | 205960.46 | 11122.56
188794.710236752 | Gross income minus AI Cost |  |  |  |  |  | 200639.3804260652 | 11844.67018931315
On-Farm AI | Influence of improving farrowing rate, litter size, |  |  |  |  |  | Commercial | (CS-OnFS)
 | feed efficiency and carcass traits
208.75 | Number of females farrowed |  |  |  |  |  | 217 | 8.25
9.497945205479452 | Average number of pigs weaned per litter |  |  |  |  |  | 9.958219178082192 | 0.4602739726027405
190.008 | Number of pigs weaned per group |  |  |  |  |  | 199.2172 | 9.20920000000001
1981 | Total number of pigs weaned per period of analysis |  |  |  |  |  | 2163.357224982877 | 182.3572249828767
1931 | Number of slaughter pigs per period of analysis |  |  |  |  |  | 2109.273294358305 | 178.2732943583046
41.715 | Feed cost from weaning to slaughter, ($/pig) |  |  |  |  |  | 40.005 | -1.709999999999994
80551.665 | Total feed cost for period of analysis |  |  |  |  |  | 84381.47814080399 | 3829.813140803992
194837.9 | Gross income at slaughter weight |  |  |  |  |  | 224975.0895762568 | 30137.18957625676
108243.045236752 | Gross income minus feed and AI cost |  |  |  |  |  | 135272.5318615179 | 27029.48662476592
 | Other expense items
876.77055 | Check-off dollars to National Pork Board |  |  |  |  |  | 1012.387903093155 | 135.6173530931553
1013.775 | Freight insurance of slaughter pigs |  |  |  |  |  | 1107.36847953811 | 93.59347953810982
106352.499686752 | Gross income minus feed and AI cost |  |  |  |  |  | 133152.7754788867 | 26800.27579213466
Template developed by [NAME], University of Nebraska (April 1999)