Spreadsheet: 641a0ba2-0a2d-43cb-9d4c-868517e1768a
Sheet: Sheet1

Name of Producer | Mr. [NAME] | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | 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]
Rural Route, Street, etc. | [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
City/State/Zip Code | Lincoln, NE 68583 |  |  |  |  | 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
Telephone number | 402/472-6445 |  |  |  |  | 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
Date: | August 4, 1998 |  |  |  |  | 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.7
 |  |  |  |  |  | 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
 | Scenario | Scenario | Scenario | Scenario |  | 0.83 | 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.83
Input Values | Natural | On-farm | Off-farm | Commercial |  | 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
Length of production period analyzed, days | 365 | 365 | 365 | 365
Biological Parameters |  |  |  |  |  | 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
Average Number of Pigs Born Live per Litter: |  |  |  |  |  | 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
Normal weaned sows before pigs transferred in | 10.5 | 10 | 10 | 10.5 |  | 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
Early weaned/problem sows before pigs transferred out | 8.5 | 8.5 | 8.5 | 8.5 |  | 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
Proportion of farrowing that are early weaned/problem sows | 0.1 | 0.1 | 0.1 | 0.1 |  | 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
Preweaning survival (birth to weaning), % | 0.905 | 0.905 | 0.905 | 0.905 |  | 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
Gestation Length, days | 114 | 114 | 114 | 114 |  | 0.83 | 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.83
Average Weaning-to-Service Interval, days | 6 | 6 | 6 | 6 |  | 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
Estimated farrowing rate of entire herd, % | 0.847 | 0.75 | 0.75 | 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 | 7 | 7 |  | Column D | Column D | Column D | Column D | Column D | Column D | Column D | Column D | Column D | Column D | Column D | Column D | Column D | Column D | Column D | Column D | Column D
Farrowing Crate Tie-up before farrowing, days | 3 | 3 | 3 | 3 |  | 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
Longest Lactation Length, days | 16 | 16 | 16 | 16 |  | 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
Farrowing Crate "down time" (cleaning, idle, etc.), days | 2 | 2 | 2 | 2 |  | 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
Total Number of Farrowing Crates | 168 | 168 | 168 | 168 |  | 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
Interval Between Farrowing Groups, days | 7 | 7 | 7 | 7 |  | 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
Number of Farrowing Units (calculated value) | 3 | 3 | 3 | 3 |  | 0.83 | 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.83
Expected Farrowing Crate Utilization, % | 1 | 1 | 1 | 1 |  | 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
Actual Farrowing Crate Utilization, % | 1 | 1 | 1 | 1 |  | 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
Management Parameters
Number of Matings Per Female Per Service |  |  |  |  |  | Column E | Column E | Column E | Column E | Column E | Column E | Column E | Column E | Column E | Column E | Column E | Column E | Column E | Column E | Column E | Column E | Column E
Natural matings with boars | 2 | 0 | 0 | 0 |  | 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
Artificial matings with "on-farm" collected semen | 0 | 2 | 0 | 0 |  | 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
Artificial matings with "off-farm" producer owned boars | 0 | 0 | 2 | 0 |  | 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
Artificial matings with "commercial" semen | 0 | 0 | 0 | 2 |  | 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
Cost per dose of "commercial" semen, $ | 0 | 0 | 0 | 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
Fixed & variable cost per dose for processing on-farm semen, $ | 0 | 1.8 | 0 | 0 |  | 0.83 | 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.83
Fixed and variable cost per dose of "off-farm" semen, $ | 0 | 0 | 2.83 | 0 |  | 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
Number of Natural Matings Per Boar Per Unit of Time | 5 | 0 | 0 | 0 |  | 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
% Active Boars for natural matings | 0.9 | 0 | 0 | 0
Natural service boars: |  |  |  |  |  | Column B
Average purchase price per boar, $ | 800 | 0 | 0 | 0 |  | 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
Average useful life per boar, months | 16 | 0 | 0 | 0 |  | Gest units | Row 166 | Row 167 | Row 168 | Row 169 | Row 170 | Row 171 | Row 172 | Row 173 | Row 174 | Row 175 | Row 176 | Row 177 | Row 178 | Row 179 | Row 180 | Row 181
Average cull value per boar, $ | 100 | 0 | 0 | 0 |  | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Artificial insemination boars: |  |  |  |  |  | 3 | 1 | 0 | 0 | 0 | 0.925 | 0 | 0 | 0 | 0 | 0.895 | 0 | 0 | 0 | 0 | 0 | 0
Average purchase price per boar, $ | 0 | 1500 | 1500 | 0 |  | 4 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Average useful life per boar, months | 0 | 16 | 16 | 0 |  | 5 | 1 | 0 | 0.985 | 0 | 0 | 0.925 | 0 | 0 | 0.895 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Average cull value per boar, $ | 0 | 100 | 100 | 0 |  | 6 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0 | 0 | 0 | 0
Number of times each AI boar is collected per group bred | 0 | 2 | 2 | 0 |  | 7 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0.87 | 0 | 0 | 0
Average number of doses per AI boar per collection | 0 | 15 | 15 | 0 |  | 8 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0.87 | 0 | 0.84 | 0
Proportion of AI collections discarded due to semen quality | 0 | 0.05 | 0.05 | 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
Number of sows per heat-check boar: |  |  |  |  |  | 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.83
When artificially inseminating sows | 50 | 50 | 50 | 50 |  | 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.83
When heat-checking gestation sows | 200 | 200 | 200 | 200 |  | 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.83
Number of groups of sows gestating | 16 | 16 | 16 | 16 |  | 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.83
Information for Replacement Gilts |  |  |  |  |  | 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.83
Annualized replacement rate (sows and gilts), % | 0.4 | 0.4 | 0.4 | 0.4 |  | 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.83
Farrowing rate of replacement gilts, % | 0.75 | 0.75 | 0.75 | 0.75
Replacement gilts purchased, % | 1 | 1 | 1 | 1 |  | Column C
Purchase price of replacement gilts, $/head | 100 | 100 | 100 | 100 |  | 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
Average weight of replacement gilts at entry, lbs | 250 | 250 | 250 | 250 |  | Gest units | Row 166 | Row 167 | Row 168 | Row 169 | Row 170 | Row 171 | Row 172 | Row 173 | Row 174 | Row 175 | Row 176 | Row 177 | Row 178 | Row 179 | Row 180 | Row 181
Avg days entry-to-service, gilts | 28 | 28 | 28 | 28 |  | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Number days each group of gilts available for service | 7 | 7 | 7 | 7 |  | 3 | 1 | 0 | 0 | 0 | 0.925 | 0 | 0 | 0 | 0 | 0.895 | 0 | 0 | 0 | 0 | 0 | 0
Number days between delivery of gilts | 60 | 60 | 60 | 60 |  | 4 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Noncyclic gilts, % | 0.05 | 0.05 | 0.05 | 0.05 |  | 5 | 1 | 0 | 0.985 | 0 | 0 | 0.925 | 0 | 0 | 0.895 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Average weight gain of problem gilts before culled, lbs | 100 | 100 | 100 | 100 |  | 6 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0 | 0 | 0 | 0
 | Scenario | Scenario | Scenario | Scenario |  | 7 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0.87 | 0 | 0 | 0
Input Values | Natural | On-farm | Off-farm | Commercial |  | 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
Additional space in breeding facility |  |  |  |  |  | 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.83
Enter percentage of number of sows weaned per group | 0.5 | 0.5 | 0.5 | 0.5 |  | 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.83
Farrowing and Weaned Piglet Information |  |  |  |  |  | 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.83
Number of days between farrowing groups | 7 | 7 | 7 | 7 |  | 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.83
Average age of piglets at weaning, days | 15 | 15 | 15 | 15 |  | 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.83
Breeding Herd Death Loss Information |  |  |  |  |  | 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.83
Annual death loss of females, % of inventory | 0.01 | 0.01 | 0.01 | 0.01 |  | 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.83
Average weight of dead females, lbs | 400 | 400 | 400 | 400
Sale Weights, Selling Prices and Feed Prices |  |  |  |  |  | Column D
Average sale weight of weaned piglets, lbs | 12 | 12 | 12 | 12 |  | 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
Average selling price of weaned piglets, $/lb | 2.5 | 2.5 | 2.5 | 2.5 |  | Gest units | Row 166 | Row 167 | Row 168 | Row 169 | Row 170 | Row 171 | Row 172 | Row 173 | Row 174 | Row 175 | Row 176 | Row 177 | Row 178 | Row 179 | Row 180 | Row 181
Average sale weight of culled females, lbs | 425 | 425 | 425 | 425 |  | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Average selling price of culled females, $/lb | 0.28 | 0.28 | 0.28 | 0.28 |  | 3 | 1 | 0 | 0 | 0 | 0.925 | 0 | 0 | 0 | 0 | 0.895 | 0 | 0 | 0 | 0 | 0 | 0
Purchase price for gestation & open sow feed, $/lb | 0.055 | 0.055 | 0.055 | 0.055 |  | 4 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Purchase price for lactation feed, $/lb | 0.056 | 0.056 | 0.056 | 0.056 |  | 5 | 1 | 0 | 0.985 | 0 | 0 | 0.925 | 0 | 0 | 0.895 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Purchase price for boar feed, $/lb | 0.055 | 0.055 | 0.055 | 0.055 |  | 6 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0 | 0 | 0 | 0
Average Pounds of Feed Per Animal |  |  |  |  |  | 7 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0.87 | 0 | 0 | 0
Open females not gestating or lactating, lbs/day | 5 | 5 | 5 | 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
Gestating females, lbs/day | 5 | 5 | 5 | 5 |  | 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
Lactating females, lbs/day | 13 | 13 | 13 | 13 |  | 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.83
Boars, lbs/day | 5 | 5 | 5 | 5 |  | 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.83
 |  |  |  |  |  | 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.83
Facility Cost |  |  |  |  |  | 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.83
Construction cost (breeding/gestation), $/female | 550 | 550 | 550 | 550 |  | 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.83
Construction cost (farrowing), $/space | 1700 | 1700 | 1700 | 1700 |  | 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.83
Total number of farrowing crates | 168 | 168 | 168 | 168
Construction cost (replacement gilts), $/space | 250 | 250 | 250 | 250 |  | Column E
Construction cost (gilts in isolation), $/space | 190 | 190 | 190 | 190 |  | 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
Construction cost (AI boars), $/space | 400 | 400 | 0 | 0 |  | Gest units | Row 166 | Row 167 | Row 168 | Row 169 | Row 170 | Row 171 | Row 172 | Row 173 | Row 174 | Row 175 | Row 176 | Row 177 | Row 178 | Row 179 | Row 180 | Row 181
Construction cost (Heat-check boars), $/space | 550 | 550 | 550 | 550 |  | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Useful life span of structure, years | 15 | 15 | 15 | 15 |  | 3 | 1 | 0 | 0 | 0 | 0.925 | 0 | 0 | 0 | 0 | 0.895 | 0 | 0 | 0 | 0 | 0 | 0
Percent of construction cost financed | 0.8 | 0.8 | 0.8 | 0.8 |  | 4 | 1 | 0 | 0 | 0.97 | 0 | 0 | 0 | 0.91 | 0 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Interest rate, % | 0.07 | 0.07 | 0.07 | 0.07 |  | 5 | 1 | 0 | 0.985 | 0 | 0 | 0.925 | 0 | 0 | 0.895 | 0 | 0 | 0.88 | 0 | 0 | 0 | 0
Number of payment periods for the loan | 15 | 15 | 15 | 15 |  | 6 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0 | 0 | 0 | 0
Yearly taxes (% of total investment) | 0.005 | 0.005 | 0.005 | 0.005 |  | 7 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0.87 | 0 | 0 | 0
Yearly insurance (% of total investment) | 0.01 | 0.01 | 0.01 | 0.01 |  | 8 | 1 | 0 | 0.985 | 0 | 0.925 | 0 | 0.91 | 0 | 0.895 | 0 | 0.89 | 0 | 0.87 | 0 | 0.84 | 0
Repairs and maintenance (% of total investment) | 0.01 | 0.01 | 0.01 | 0.01 |  | 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
Labor cost |  |  |  |  |  | 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.83
Number of employees (Level 1) | 1 | 1 | 1 | 1 |  | 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.83
Average wages per employee, $/hour | 12 | 12 | 12 | 12 |  | 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.83
Average number of hours per week per employee | 50 | 50 | 50 | 50 |  | 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.83
Number of weeks per year | 51 | 51 | 51 | 51 |  | 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.83
Number of employees (Level 2) | 2 | 2 | 2 | 2 |  | 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.83
Average wages per employee, $/hour | 10 | 10 | 10 | 10 |  | 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.83
Average number of hours per week per employee | 50 | 50 | 50 | 50
Number of weeks per year | 51 | 51 | 51 | 51
Number of employees (Level 3) | 1 | 1 | 1 | 1
Average wages per employee, $/hour | 7 | 7 | 7 | 7
Average number of hours per week per employee | 50 | 50 | 50 | 50
Number of weeks per year | 51 | 51 | 51 | 51
Other Costs
Operating loan | 129000 | 129000 | 129000 | 129000
Interest rate on operating loan, % | 0.07 | 0.07 | 0.07 | 0.07
Number of payment periods for operating loan | 12 | 12 | 12 | 12
Utilities (fuel, electricity, etc.), $/pig | 1.15 | 1.15 | 1.15 | 1.15
Veterinary expense and medication, $/pig | 1 | 1 | 1 | 1
 | Scenario | Scenario | Scenario | Scenario
Calculated Values | Natural | On-farm | Off-farm | Commercial
Breeding Data
Number of productive groups of sows (rounded down) | 19 | 19 | 19 | 19
Number of farrowing crates per group | 56 | 56 | 56 | 56
Number of females bred per group | 66.11570247933885 | 74.66666666666667 | 74.66666666666667 | 66.11570247933885
Number of groups bred during period analyzed | 52.14285714285715 | 52.14285714285715 | 52.14285714285715 | 52.14285714285715
Total number of females bred during period analyzed | 3447.461629279812 | 3893.333333333334 | 3893.333333333334 | 3447.461629279812
Total number of natural matings by boars | 6894.923258559624 | 0 | 0 | 0
Total number of artificial matings by "on-farm" semen | 0 | 7786.666666666668 | 0 | 0
Total number of artificial matings by "off-farm" semen | 0 | 0 | 7786.666666666668 | 0
Total number of artificial matings by "commercial" semen | 0 | 0 | 0 | 6894.923258559624
Total number of females farrowed during period analyzed | 2920 | 2920 | 2920 | 2920
Calculated farrowing rate, % | 0.8469999999999999 | 0.7499999999999999 | 0.7499999999999999 | 0.8469999999999999
Calculating Inventory of Boars to Produce Semen
Number of female services by boars per unit of time | 132.2314049586777 | 0 | 0 | 0
Number of female services by 'on-farm' AI semen | 0 | 149.3333333333333 | 0 | 0
Number of female services by 'off-farm' AI semen | 0 | 0 | 149.3333333333333 | 0
Minimum number of boars needed for natural matings | 30 | 0 | 0 | 0
Minimum number of boars needed for 'on-farm' semen | 0 | 6 | 0 | 0
Minimum number of boars needed for 'off-farm' semen | 0 | 0 | 6 | 0
Total number of boars to produce semen | 30 | 6 | 6 | 0
Calculating Inventory of Heat-Check Boars
Number of boars needed while inseminating females | 0 | 1.493333333333333 | 1.493333333333333 | 0
Number of boars needed for checking heat of gestating sows | 5.23818181818182 | 5.861333333333334 | 5.861333333333334 | 5.23818181818182
Total number of heat-check boars | 5.23818181818182 | 7.354666666666668 | 7.354666666666668 | 5.23818181818182
Inventory of Females
Percentage of females pregnant (end of week)
Week 1 of Gestation | 1 | 1 | 1 | 1
Week 2 of Gestation | 0.998 | 0.998 | 0.998 | 0.998
Week 3 of Gestation | 0.98 | 0.9 | 0.9 | 0.98
Week 4 of Gestation | 0.87 | 0.88 | 0.88 | 0.87
Week 5 of Gestation | 0.86 | 0.86 | 0.86 | 0.86
Week 6 of Gestation | 0.86 | 0.85 | 0.85 | 0.86
Week 7 of Gestation | 0.86 | 0.84 | 0.84 | 0.86
Week 8 of Gestation | 0.86 | 0.83 | 0.83 | 0.86
Week 9 of Gestation | 0.86 | 0.82 | 0.82 | 0.86
Week 10 of Gestation | 0.85 | 0.81 | 0.81 | 0.85
Week 11 of Gestation | 0.85 | 0.8 | 0.8 | 0.85
Week 12 of Gestation | 0.85 | 0.79 | 0.79 | 0.85
Week 13 of Gestation | 0.85 | 0.78 | 0.78 | 0.85
Week 14 of Gestation | 0.85 | 0.77 | 0.77 | 0.85
Week 15 of Gestation | 0.85 | 0.76 | 0.76 | 0.85
Week 16 of Gestation | 0.847 | 0.75 | 0.75 | 0.847
Total number of females gestating: | 963.6363636363639 | 1088.266666666667 | 1088.266666666667 | 963.6363636363639
Space for recently weaned sows: | 56 | 56 | 56 | 56
Additional space for "problem" females | 28 | 28 | 28 | 28
Females in breeding & gestation (without gilts): | 1047.636363636364 | 1172.266666666667 | 1172.266666666667 | 1047.636363636364
Number of Gilts to be Served Per Group | 10.18460772104608 | 11.14067579908676 | 11.14067579908676 | 10.18460772104608
Gilts in Estrus Per Farrowing Group , % | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333
Required number of ELIGIBLE gilts | 30.55382316313824 | 33.42202739726028 | 33.42202739726028 | 30.55382316313824
Number of "on-deck" Gilts | 56.74281444582815 | 62.06947945205479 | 62.06947945205479 | 56.74281444582815
Females in breeding & gestation with gilts: | 1134.93300124533 | 1267.758173515982 | 1267.758173515982 | 1134.93300124533
Females in farrowing houses: | 112 | 112 | 112 | 112
Total Females in farrowing, breeding & gestation | 1246.93300124533 | 1379.758173515982 | 1379.758173515982 | 1246.93300124533
Number of Gilts Per Delivery Group (in isolation) | 87.29663760896639 | 95.49150684931507 | 95.49150684931507 | 87.29663760896639
TOTAL FEMALE INVENTORY FOR ENTERPRISE: | 1334.229638854297 | 1475.249680365297 | 1475.249680365297 | 1334.229638854297
 | Scenario | Scenario | Scenario | Scenario
Item | Natural | On-farm | Off-farm | Commercial
Reproductive Performance during Period Analyzed
Farrowings from gilts, % | 0.38 | 0.38 | 0.38 | 0.38
Farrowings per female per year (without isolated gilts) | 2.341745704928615 | 2.116312884423132 | 2.116312884423132 | 2.341745704928615
Number of females farrowing per group | 56 | 56 | 56 | 56
Total number of piglets born live per group farrowed | 576.8 | 551.6 | 551.6 | 576.8
Average number of piglets born live per litter | 10.3 | 9.85 | 9.85 | 10.3
Total number of piglets weaned per group farrowed | 522.0039999999999 | 499.198 | 499.198 | 522.0039999999999
Average number of piglets weaned per litter | 9.321499999999999 | 8.91425 | 8.91425 | 9.321499999999999
Total number of piglets weaned during period analyzed | 27218.78 | 26029.61 | 26029.61 | 27218.78
Total pounds of weaned piglets sold during period analyzed | 326625.3599999999 | 312355.32 | 312355.32 | 326625.3599999999
Gross income from sales of piglets | 816563.3999999998 | 780888.3 | 780888.3 | 816563.3999999998
Weight gain of culled & sold sows & gilts, lbs | 80427.1785803238 | 88994.40219178083 | 88994.40219178083 | 80427.1785803238
Selling price of culled females, $/lb | 0.28 | 0.28 | 0.28 | 0.28
Gross income from culled females | 22519.61000249067 | 24918.43261369863 | 24918.43261369863 | 22519.61000249067
Feed for open females,lbs | 392252.7272727282 | 634658.6666666673 | 634658.6666666673 | 392252.7272727282
Total cost of feed for open females | 21573.90000000005 | 34906.22666666671 | 34906.22666666671 | 21573.90000000005
Feed for gestating females | 1664400 | 1664400 | 1664400 | 1664400
Total cost of feed for gestating females | 91541.99999999999 | 91542 | 91542 | 91541.99999999999
Feed for lactating females, lbs | 569400 | 569400 | 569400 | 569400
Total cost of feed for lactating females | 31886.4 | 31886.4 | 31886.4 | 31886.4
Feed for heat-check boars, lbs | 9559.681818181822 | 13422.26666666667 | 13422.26666666667 | 9559.681818181822
Total cost of feed for heat-check boars | 525.7825000000001 | 738.2246666666668 | 738.2246666666668 | 525.7825000000001
Feed for AI and(or) natural service boars, lbs | 54750 | 10950 | 0 | 0
Total cost of feed for AI and(or) natural service boars | 3011.25 | 602.25 | 0 | 0
Total cost of feed for boars | 3537.0325 | 1340.474666666667 | 738.2246666666668 | 525.7825000000001
Total pounds of feed to breeding herd | 2635612.40909091 | 2881880.933333334 | 2881880.933333334 | 2635612.40909091
Total cost of feed to breeding herd | 148539.3325 | 159675.1013333334 | 159072.8513333334 | 145528.0825
Average cost per ton of feed | 112.7171294137555 | 110.8131147865605 | 110.3951585878612 | 110.432081741637
Feed conversion of breeding herd | 6.474870340529331 | 7.180473223191262 | 7.180473223191262 | 6.474870340529331
Pounds of feed per piglet sold | 96.83065916587408 | 110.7154864530561 | 110.7154864530561 | 96.83065916587408
Gross income from weaned piglets | 816563.3999999998 | 780888.3 | 780888.3 | 816563.3999999998
Gross income from culled females | 22519.61000249067 | 24918.43261369863 | 24918.43261369863 | 22519.61000249067
TOTAL GROSS INCOME | 839083.0100024905 | 805806.7326136987 | 805806.7326136987 | 839083.0100024905
Total gross income | 839083.0100024905 | 805806.7326136987 | 805806.7326136987 | 839083.0100024905
Total feed cost | 148539.3325 | 159675.1013333334 | 159072.8513333334 | 145528.0825
RETURNS ABOVE FEED COSTS | 690543.6775024905 | 646131.6312803653 | 646733.8812803653 | 693554.9275024905
Number of gilts to be served per group | 9.087237762500216 | 10.05522394945894 | 10.05522394945894 | 9.087237762500216
Number of service eligible gilts | 27.26171328750065 | 30.16567184837681 | 30.16567184837681 | 27.26171328750065
Number of gilts per delivery | 77.89060939285899 | 86.18763385250517 | 86.18763385250517 | 77.89060939285899
Total number of gilts per year | 497.5262674968868 | 550.5235112328768 | 550.5235112328768 | 497.5262674968868
Total number of gilts during period of analysis | 497.5262674968868 | 550.5235112328768 | 550.5235112328768 | 497.5262674968868
Total cost of replacement gilts | 49752.62674968868 | 55052.35112328768 | 55052.35112328768 | 49752.62674968868
RETURNS ABOVE FEED & GILT COSTS | 640791.0507528018 | 591079.2801570776 | 591681.5301570776 | 643802.3007528018
Genetic cost of semen per period of analysis | Natural | On-farm | Off-farm | Commercial
Per natural mating by boars, $ | 2.285541735197368 | 0 | 0 | 0
Per AI dose of "on-farm" semen, $ | 0 | 0.8095189144736842 | 0 | 0
Per AI dose of "off-farm" semen, $ | 0 | 0 | 0.8095189144736842 | 0
Per AI dose of "commercial" semen, $ | 0 | 0 | 0 | 6
Total "genetic" cost of semen per period of analysis, $ | 15758.63486842105 | 6303.453947368422 | 6303.453947368422 | 41369.53955135774
Total fixed & variable cost for processing on-farm semen, $ | 0 | 14016 | 0 | 0
Total fixed and variable cost of "off-farm" semen, $ | 0 | 0 | 22036.26666666667 | 0
Summary for Producing Segregated-Early-Weaned Pigs
 | Scenario | Scenario | Scenario | Scenario
Item | Natural | On-farm | Off-farm | Commercial
Inventory of Breeding Animals
Total number of females in farrowing, breeding & gestation | 1246.93300124533 | 1379.758173515982 | 1379.758173515982 | 1246.93300124533
Number of gilts per delivery group (in isolation) | 87.29663760896639 | 95.49150684931507 | 95.49150684931507 | 87.29663760896639
Total number of boars | 35.23818181818182 | 13.35466666666667 | 13.35466666666667 | 5.23818181818182
Reproductive Performance
Number of Litters Farrowed per Year | 2920 | 2920 | 2920 | 2920
Proportion of farrowings from gilts, % | 0.38 | 0.38 | 0.38 | 0.38
Farrowings per female per year (without isolated gilts) | 2.341745704928615 | 2.116312884423132 | 2.116312884423132 | 2.341745704928615
Number of live piglets farrowed per litter | 10.3 | 9.85 | 9.85 | 10.3
Number of piglets weaned per litter | 9.321499999999999 | 8.91425 | 8.91425 | 9.321499999999999
Total number of piglets weaned during period analyzed | 27218.78 | 26029.61 | 26029.61 | 27218.78
Number of piglets weaned per female per year | 21.82858258849208 | 18.86534212996891 | 18.86534212996891 | 21.82858258849208
Total pounds of weaned piglets sold during period analyzed | 326625.3599999999 | 312355.32 | 312355.32 | 326625.3599999999
Total pounds of live animals sold | 407052.5385803237 | 401349.7221917808 | 401349.7221917808 | 407052.5385803237
EXPENSE ITEMS
Cost of facilities
Breeding/gestation for sows (initial cost) | 576200.0000000002 | 644746.6666666667 | 644746.6666666667 | 576200.0000000002
Farrowing facility (initial cost) | 285600 | 285600 | 285600 | 285600
Gilt facility in breeding area (initial cost) | 21824.1594022416 | 23872.87671232877 | 23872.87671232877 | 21824.1594022416
Gilt facility in isolation area (initial cost) | 16586.36114570361 | 18143.38630136986 | 18143.38630136986 | 16586.36114570361
Boar facility for AI & natural service boars (initial cost) | 12000 | 2400 | 0 | 0
Boar facility for heat-check boars (initial cost) | 2881.000000000001 | 4045.066666666667 | 4045.066666666667 | 2881.000000000001
Total initial cost of facilities | 915091.5205479454 | 978807.996347032 | 976407.996347032 | 903091.5205479454
Amount financed | 732073.2164383563 | 783046.3970776256 | 781126.3970776256 | 722473.2164383563
Principal and interest payment (yearly) | 80377.70405250805 | 85974.28529061323 | 85763.47961118731 | 79323.67565537839
Taxes and insurance (yearly) | 13726.37280821918 | 14682.11994520548 | 14646.11994520548 | 13546.37280821918
Repairs and maintenance (yearly) | 9150.915205479454 | 9788.07996347032 | 9764.07996347032 | 9030.915205479454
Recover of nonfinanced down payment (yearly) | 12201.22027397261 | 13050.77328462709 | 13018.77328462709 | 12041.22027397261
Facility cost for peroid analyzed | 115456.2123401793 | 123495.2584839161 | 123192.4528044902 | 113942.1839430496
Cost of feed
Cost of open sow feed | 21573.90000000005 | 34906.22666666671 | 34906.22666666671 | 21573.90000000005
Cost of gestation feed | 91541.99999999999 | 91542 | 91542 | 91541.99999999999
Cost of lactation feed | 31886.4 | 31886.4 | 31886.4 | 31886.4
Cost of boar feed | 3537.0325 | 1340.474666666667 | 738.2246666666668 | 525.7825000000001
Total cost of feed | 148539.3325 | 159675.1013333334 | 159072.8513333334 | 145528.0825
Cost of labor | 99450 | 99450 | 99450 | 99450
Cost of utilities | 31301.59699999999 | 29934.0515 | 29934.0515 | 31301.59699999999
Cost of veterinary services and medicine | 27218.78 | 26029.61 | 26029.61 | 27218.78
Cost of semen | 15758.63486842105 | 20319.45394736842 | 28339.72061403509 | 41369.53955135774
Cost of replacement gilts | 49752.62674968868 | 55052.35112328768 | 55052.35112328768 | 49752.62674968868
Repayment of operating loan | 194896.2784379717 | 194896.2784379717 | 194896.2784379717 | 194896.2784379717
TOTAL EXPENSE | 682373.4618962607 | 708852.1048258772 | 715967.315813118 | 703459.0881820677
GROSS INCOME ITEMS
Sale price of weaned piglets, $/lb | 2.5 | 2.5 | 2.5 | 2.5
Gross income from weaned piglets, $ | 816563.3999999998 | 780888.3 | 780888.3 | 816563.3999999998
Sale price of culled females, $/lb | 0.28 | 0.28 | 0.28 | 0.28
Gross income from culled females, $ | 22519.61000249067 | 24918.43261369863 | 24918.43261369863 | 22519.61000249067
Total Gross Income, $ | 839083.0100024905 | 805806.7326136987 | 805806.7326136987 | 839083.0100024905
Gross Income minus Total Expense | 156709.5481062297 | 96954.62778782146 | 89839.41680058069 | 135623.9218204228
Software:  Microsoft Excel 97 |  |  | (May 25, 1999)
[NAME], Ph.D.
Extension Swine Specialist
Department of Animal Science
University of Nebraska
P.O. Box 830908
Lincoln, NE 68583-0908
Telephone: 402/472-6445
FAX: 402/472-6362
E-Mail: [EMAIL]