Spreadsheet: 5b9c4b62-f6da-46fa-bf9e-b3f999291a6c
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
 | 4 groups | 5 groups |  | 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
 | of sows | of sows |  | 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 sold or 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 | 6 |  | 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 | 10
Farrowing Crate Tie-up before farrowing, days | 4 | 3 |  | Column B
Oldest 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 | 2 | 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 | 20 |  | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interval Between Farrowing Groups, days | 35 | 28 |  | 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 | 1 |  | 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 | 2 | 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
Artificial matings with "on-farm" collected semen | 0 | 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 | 0 |  | 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
Isolation & Acclimation Days for Gilts | 45 | 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 | 45 | 104 |  | 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 | 3 | 4 |  | 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
 | 4 groups | 5 groups |  | 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
 | of sows | of sows |  | 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 | 20 |  | 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 | 5
Inventory of Boars to Produce Semen
Number of Female Services by Boars Per Unit of Time | 47.90419161676647 | 47.90419161676647
Number of Female Services by "On-farm" AI semen | 0 | 0
Number of Female Services by "Off-Farm" AI semen | 0 | 0
Number of boars needed for natural matings | 10.64537591483699 | 10.64537591483699
Minimum number of boars needed for "On-farm" semen | 0 | 0
Minimum number of boars needed for "Off-Farm" semen | 0 | 0
INVENTORY OF BOARS TO PRODUCE SEMEN | 10.64537591483699 | 10.64537591483699
Inventory of Boars to Heat-Check Sows
Number of boars needed (inseminating sows) | 0 | 0
Number of boars needed (gestation sows) | 0.3377245508982036 | 0.4502994011976048
Total | 0.3377245508982036 | 0.4502994011976048
Calculating Number of Females in Breeding-Gestation Area
Number of females to bred per group: | 23.95209580838323 | 23.95209580838323
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 | 90.05988023952096
Space for recently weaned sows: | 20 | 20
Additional space for "problem" females | 10 | 10
Females in breeding & gestation (without gilts): | 97.54491017964072 | 120.059880239521
Number of Gilts to be Served Per Group | 3.741448609630055 | 3.684029201870232
Gilts in Estrus Per Farrowing Group , % | 0.3333333333333333 | 0.4761904761904762
Required number of ELIGIBLE gilts | 11.22434582889016 | 7.736461323927489
Females in breeding & gestation with gilts: | 108.7692560085309 | 127.7963415634485
Females in farrowing houses: | 0 | 0
Total Females in farrowing, breeding & gestation | 108.7692560085309 | 127.7963415634485
Number of Gilts Per Delivery Group (in isolation/acclimation) | 4.810433926667214 | 13.68353703551801
TOTAL FEMALE INVENTORY FOR ENTERPRISE: | 113.5796899351981 | 141.4798785989665
Calculation of Animal Inventories & Productivity |  | Page 3
 | Scenario 1 | Scenario 2
 | 4 groups | 5 groups
 | of sows | of sows
Key Targets
Level of Production for Period Analyzed
Number of ACTIVE groups | 4 | 5
Required number of ELIGIBLE gilts Per Group | 11.22434582889016 | 7.736461323927489
Number of FEMALES to be Served Per Group:
Number of GILTS to be Served (maiden) | 3.741448609630055 | 3.684029201870232
Number of SOWS to be Served (weaners + rebreeds) | 20.21064719875318 | 20.268066606513
Total Number of Females Bred | 23.95209580838323 | 23.95209580838323
Total number of females bred for period analyzed | 249.7861420017109 | 312.2326775021386
Total number of females bred by boars | 249.7861420017109 | 312.2326775021386
Total number of females bred by on-farm semen | 0 | 0
Total number of females bred by off-farm semen | 0 | 0
Total number of insemination during period of analysis | 0 | 0
Number of FEMALES FARROWING Per Group | 20 | 20
Total number of females farrowed for period analyzed | 208.5714285714286 | 260.7142857142857
Total Number of Pigs BORN LIVE per Group | 208.8 | 208.8
Avg number of PIGS BORN LIVE/Sow Farrowed/Group | 10.44 | 10.44
Total Number of PIGS WEANED Per Group | 190.008 | 190.008
Avg number of PIGS WEANED/Sow Farrowed/Group | 9.500399999999999 | 9.500399999999999
Number days farrowing crate is tied up | 29 | 28
Number of LITTERS PER FARROWING CRATE | 12.58620689655172 | 13.03571428571429
Total number of LITTERS | 208.5714285714286 | 260.7142857142857
Total number of PIGS WEANED | 1981 | 2476
Total number of slaughter pigs sold | 1931 | 2414
Level of Production on a Yearly Basis
Number of LITTERS PER FARROWING CRATE/Year | 12.58620689655172 | 13.03571428571429
Total number of LITTERS per year | 208.5714285714286 | 260.7142857142857
Total number of PIGS WEANED per year | 1981.512 | 2476.89
Number of PIGS WEANED PER CRATE per year | 99.0756 | 123.8445
Total number of replacement gilts per year | 39.01796407185629 | 48.02395209580839
Avg Number of Pigs Weaned/Inventoried Female/Year
"Without" gilts in isolation unit | 18.21757427341958 | 19.38154073659668
"With" gilts in isolation unit | 17.44600642183945 | 17.50701247787255
Avg Number of Litters per Inventoried Female/Year
"Without" gilts in isolation unit | 1.91755865789015 | 2.040076284850815
"With" gilts in isolation unit | 1.836344408850096 | 1.842765828583276
Template developed by [NAME], University of Nebraska (as of March 1999)