Spreadsheet: 8ab1a912-acb5-4d3a-83ed-145611da6054
Sheet: Sheet1

Calculation of Animal Inventories & Productivity | Unnamed: 1 | Page 1 | Unnamed: 3 | Column B | Column B.1 | Column B.2 | Column B.3 | Column B.4 | Column B.5 | Column B.6 | Column B.7 | Column B.8 | Column B.9 | Column B.10 | Column B.11 | Column B.12 | Column B.13 | [NAME] | Column B.15 | [NAME]
 |  |  |  | Far rate | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 | Wk 14 | Wk 15 | Wk 16
*******************INPUT DATA************************ | Scenario 1 | Scenario 2 |  | 0.6 | 1 | 0.998 | 0.946 | 0.84 | 0.82 | 0.78 | 0.76 | 0.74 | 0.72 | 0.71 | 0.69 | 0.67 | 0.66 | 0.64 | 0.62 | 0.6
 | On-Farm | Coop |  | 0.65 | 1 | 0.998 | 0.956 | 0.86 | 0.84 | 0.8 | 0.78 | 0.76 | 0.74 | 0.72 | 0.7 | 0.69 | 0.68 | 0.67 | 0.66 | 0.65
 | Semen | Semen |  | 0.7 | 1 | 0.991 | 0.915 | 0.821 | 0.779 | 0.764 | 0.748 | 0.748 | 0.748 | 0.744 | 0.738 | 0.738 | 0.738 | 0.722 | 0.71 | 0.706
Length of production period analyzed, days | 365 | 365 |  | 0.75 | 1 | 0.998 | 0.9 | 0.88 | 0.86 | 0.85 | 0.84 | 0.83 | 0.82 | 0.81 | 0.8 | 0.79 | 0.78 | 0.77 | 0.76 | 0.75
 |  |  |  | 0.835 | 1 | 1 | 0.985 | 0.97 | 0.925 | 0.925 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
Biological Parameters |  |  |  | 0.847 | 1 | 0.998 | 0.98 | 0.87 | 0.86 | 0.86 | 0.86 | 0.86 | 0.86 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.847
Average Number of Pigs Born Live per Litter |  |  |  | 0.9 | 1 | 1 | 0.98 | 0.97 | 0.96 | 0.95 | 0.94 | 0.93 | 0.92 | 0.91 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9
Normal weaned sows before pigs transferred in | 10.5 | 10.5
Early weaned/problem sows before pigs transferred out | 9 | 9 |  | Column C | Column C | Column C | Column C | Column C | Column C | Column C | Column C | Column C | Column C | Column C | Column C | Column C | Column C | Column C | Column C | Column C
Proportion of farrowing that are early weaned/problem sows | 0.04 | 0.04 |  | Far rate | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 | Wk 14 | Wk 15 | Wk 16
Preweaning survival, % | 0.91 | 0.91 |  | 0.6 | 1 | 0.998 | 0.946 | 0.84 | 0.82 | 0.78 | 0.76 | 0.74 | 0.72 | 0.71 | 0.69 | 0.67 | 0.66 | 0.64 | 0.62 | 0.6
Weaning to slaughter survival, % | 0.975 | 0.975 |  | 0.65 | 1 | 0.998 | 0.956 | 0.86 | 0.84 | 0.8 | 0.78 | 0.76 | 0.74 | 0.72 | 0.7 | 0.69 | 0.68 | 0.67 | 0.66 | 0.65
Gestation Length, days | 114 | 114 |  | 0.7 | 1 | 0.998 | 0.946 | 0.85 | 0.811 | 0.8 | 0.79 | 0.78 | 0.77 | 0.76 | 0.75 | 0.74 | 0.73 | 0.72 | 0.71 | 0.7
Average Weaning-to-Service Interval, days | 4 | 4 |  | 0.75 | 1 | 0.998 | 0.9 | 0.88 | 0.86 | 0.85 | 0.84 | 0.83 | 0.82 | 0.81 | 0.8 | 0.79 | 0.78 | 0.77 | 0.76 | 0.75
Estimated Farrowing Rate, % | 0.835 | 0.835 |  | 0.835 | 1 | 1 | 0.985 | 0.97 | 0.925 | 0.925 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
Annual Replacement Rate, % | 0.4 | 0.4 |  | 0.847 | 1 | 0.998 | 0.98 | 0.87 | 0.86 | 0.86 | 0.86 | 0.86 | 0.86 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.85 | 0.847
 |  |  |  | 0.9 | 1 | 1 | 0.98 | 0.97 | 0.96 | 0.95 | 0.94 | 0.93 | 0.92 | 0.91 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9
Farrowing Facility & Management Parameters
Length of breeding period, days | 7 | 7
Farrowing Crate Tie-up before farrowing, days | 4 | 3 |  | Column B
Longest Lactation Length, days | 23 | 23 |  | Number of | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk13 | Wk 14 | Wk 15 | Wk 16
Farrowing Crate "down time" (cleaning, idle, etc.), days | 8 | 2 |  | Gest units | Row 77 | Row 78 | Row 79 | Row 80 | Row 81 | Row 82 | Row 83 | Row 84 | Row 85 | Row 86 | Row 87 | Row 88 | Row 89 | Row 90 | Row 91 | Row 92
Total Number of Farrowing Crates | 20 | 960 |  | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interval Between Farrowing Groups, days | 35 | 7 |  | 3 | 1 | 0 | 0 | 0 | 0.925 | 0 | 0 | 0 | 0 | 0.895 | 0 | 0 | 0 | 0 | 0 | 0
Number of Farrowing Units (calculated value) | 1 | 4 |  | 4 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Expected Farrowing Crate Utilization, % | 1 | 1 |  | 5 | 1 | 0 | 0.985 | 0 | 0 | 0.925 | 0 | 0 | 0.895 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Actual Farrowing Crate Utilization, % | 1 | 1 |  | 6 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 7 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0.87 | 0 | 0 | 0
Management Parameters |  |  |  | 8 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0.87 | 0 | 0.84 | 0
Number of Matings Per Female Per Service |  |  |  | 9 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0.91 | 0 | 0 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0
Natural matings with boars | 0 | 0 |  | 10 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0.91 | 0 | 0 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
Artificial matings with "on-farm" collected semen | 2 | 0 |  | 11 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0.91 | 0 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
Artificial matings with "Off-Farm" semen | 0 | 2 |  | 13 | 1 | 0 | 0 | 0.97 | 0 | 0.925 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
Number of Natural Matings Per Boar Per Unit of Time | 5 | 5 |  | 14 | 1 | 0 | 0 | 0.97 | 0.925 | 0.925 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
% Active Boars for natural matings | 0.9 | 0.9 |  | 15 | 1 | 0 | 0.985 | 0.97 | 0.925 | 0.925 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
Number of times each boar is collected per group bred | 2 | 2 |  | 16 | 1 | 1 | 0.985 | 0.97 | 0.925 | 0.925 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
Average number of doses per boar per collection | 15 | 15
Proportion of collections discarded due to semen quality | 0.05 | 0.05
Number of sows per heat-check boar:
When artificially inseminating sows | 50 | 50 |  | Column C
When heat-checking gestation sows | 200 | 200 |  | Number of | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk13 | Wk 14 | Wk 15 | Wk 16
Acclimation Days for Gilts | 60 | 60 |  | Gest units | Row 77 | Row 78 | Row 79 | Row 80 | Row 81 | Row 82 | Row 83 | Row 84 | Row 85 | Row 86 | Row 87 | Row 88 | Row 89 | Row 90 | Row 91 | Row 92
Days between Delivery of Gilts | 60 | 60 |  | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 3 | 1 | 0 | 0 | 0 | 0.925 | 0 | 0 | 0 | 0 | 0.895 | 0 | 0 | 0 | 0 | 0 | 0
Number of sow groups gestating (calculated value) | 3 | 16 |  | 4 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
 |  |  |  | 5 | 1 | 0 | 0.985 | 0 | 0 | 0.925 | 0 | 0 | 0.895 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Additional Space in Breeding Facility |  |  |  | 6 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0 | 0 | 0 | 0
Late cycling, noncycling, early weaned, etc. |  |  |  | 7 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0.87 | 0 | 0 | 0
(Entered as a percentage of group weaned) | 0.5 | 0.5 |  | 8 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0.87 | 0 | 0.84 | 0
 |  |  |  | 9 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0.91 | 0 | 0 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0
Calculation of Animal Inventories & Productivity |  | Page 2 |  | 10 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0.91 | 0 | 0 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
 |  |  |  | 11 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0.91 | 0 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
*****'*********CALCULATED OUTPUT*************** | Scenario 1 | Scenario 2 |  | 12 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
 | On-Farm | Coop |  | 13 | 1 | 0 | 0 | 0.97 | 0 | 0.925 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
 | Semen | Semen |  | 14 | 1 | 0 | 0 | 0.97 | 0.925 | 0.925 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
 |  |  |  | 15 | 1 | 0 | 0.985 | 0.97 | 0.925 | 0.925 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
Number of farrowing crates per group | 20 | 240 |  | 16 | 1 | 1 | 0.985 | 0.97 | 0.925 | 0.925 | 0.91 | 0.91 | 0.895 | 0.895 | 0.89 | 0.88 | 0.87 | 0.85 | 0.84 | 0.835
Number of productive groups of sows (rounded down) | 4 | 20
Inventory of Boars to Produce Semen
Number of Females Served by Boars Per Unit of Time | 0 | 0
Number of Female Services by "On-farm" AI semen | 47.90419161676647 | 0
Number of Female Services by "Off-Farm" AI semen | 0 | 574.8502994011976
Number of boars needed for natural matings | 0 | 0
Minimum number of boars needed for "On-farm" semen | 1.680848828658473 | 0
Minimum number of boars needed for "Off-Farm" semen | 0 | 20.17018594390168
INVENTORY OF BOARS TO PRODUCE SEMEN | 1.680848828658473 | 20.17018594390168
Inventory of Boars to Heat-Check Sows
Number of boars needed (inseminating sows) | 0.4790419161676647 | 5.748502994011976
Number of boars needed (gestation sows) | 0.3377245508982036 | 20.95329341317365
Total | 0.8167664670658683 | 26.70179640718563
Calculating Number of Females in Breeding-Gestation Area
Number of females to breed per group: | 23.95209580838323 | 287.4251497005988
Percentage of females pregnant (end of week)
Week 1 of Gestation | 1 | 1
Week 2 of Gestation | 1 | 1
Week 3 of Gestation | 0.985 | 0.985
Week 4 of Gestation | 0.97 | 0.97
Week 5 of Gestation | 0.925 | 0.925
Week 6 of Gestation | 0.925 | 0.925
Week 7 of Gestation | 0.91 | 0.91
Week 8 of Gestation | 0.91 | 0.91
Week 9 of Gestation | 0.895 | 0.895
Week 10 of Gestation | 0.895 | 0.895
Week 11 of Gestation | 0.89 | 0.89
Week 12 of Gestation | 0.88 | 0.88
Week 13 of Gestation | 0.87 | 0.87
Week 14 of Gestation | 0.85 | 0.85
Week 15 of Gestation | 0.84 | 0.84
Week 16 of Gestation | 0.835 | 0.835
Total number of females gestating: | 67.54491017964072 | 4190.658682634731
Space for recently weaned sows: | 20 | 240
Additional space for "problem" females | 10 | 120
Females in breeding & gestation (without gilts): | 97.54491017964072 | 4550.658682634731
Number of Gilts to be Served Per Group | 3.741448609630055 | 40.43245016815684
Gilts in Estrus Per Farrowing Group , % | 0.3333333333333333 | 0.3333333333333333
Required number of ELIGIBLE gilts | 11.22434582889016 | 121.2973505044705
Females in breeding & gestation with gilts: | 108.7692560085309 | 4671.956033139201
Females in farrowing houses: | 0 | 720
Total Females in farrowing, breeding & gestation | 108.7692560085309 | 5391.956033139201
Number of Gilts Per Delivery Group (in isolation/acclimation) | 6.413911902222951 | 346.5638585842015
TOTAL FEMALE INVENTORY FOR ENTERPRISE: | 115.1831679107538 | 5738.519891723403
Calculation of Animal Inventories & Productivity |  | Page 3
 | Scenario 1 | Scenario 2
 | On-Farm | Coop
 | Semen | Semen
Key Targets
Level of Production for Period Analyzed
Number of ACTIVE groups | 4 | 20
Required number of ELIGIBLE gilts Per Group | 11.22434582889016 | 121.2973505044705
Number of FEMALES to be Served Per Group:
Number of GILTS to be Served (maiden) | 3.741448609630055 | 40.43245016815684
Number of SOWS to be Served (weaners + rebreeds) | 20.21064719875318 | 246.992699532442
Total Number of Females Bred | 23.95209580838323 | 287.4251497005988
Total number of females bred for period analyzed | 249.7861420017109 | 14987.16852010265
Total number of females bred by boars | 0 | 0
Total number of females bred by on-farm semen | 249.7861420017109 | 0
Total number of females bred by off-farm semen | 0 | 14987.16852010265
Total number of insemination during period of analysis | 499.5722840034218 | 29974.33704020531
Number of FEMALES FARROWING Per Group | 20 | 240
Total number of females farrowed for period analyzed | 208.5714285714286 | 12514.28571428572
Total Number of Pigs BORN LIVE per Group | 208.8 | 2505.6
Avg number of PIGS BORN LIVE/Sow Farrowed/Group | 10.44 | 10.44
Total Number of PIGS WEANED Per Group | 190.008 | 2280.096
Avg number of PIGS WEANED/Sow Farrowed/Group | 9.500399999999999 | 9.500399999999997
Number days farrowing crate is tied up | 35 | 28
Number of LITTERS PER FARROWING CRATE | 10.42857142857143 | 13.03571428571429
Total number of LITTERS | 208.5714285714286 | 12514.28571428572
Total number of PIGS WEANED | 1981.512 | 118890
Total number of slaughter pigs sold | 1931 | 115917
Level of Production on a Yearly Basis
Number of LITTERS PER FARROWING CRATE/Year | 10.42857142857143 | 13.03571428571429
Total number of LITTERS per year | 208.5714285714286 | 12514.28571428572
Total number of PIGS WEANED per year | 1981.512 | 118890.72
Number of PIGS WEANED PER CRATE per year | 99.0756 | 123.8445
Total number of replacement gilts per year | 39.01796407185629 | 2108.263473053893
Avg Number of Pigs Weaned/Inventoried Female/Year
"Without" gilts in isolation unit | 18.21757427341958 | 22.04964567019692
"With" gilts in isolation unit | 17.20313858302034 | 20.71801130662187
Avg Number of Litters per Inventoried Female/Year
"Without" gilts in isolation unit | 1.91755865789015 | 2.320917610858167
"With" gilts in isolation unit | 1.81078044956216 | 2.180751474319174
Template developed by [NAME], University of Nebraska (as of March 1999)