Spreadsheet: 39172a67-9106-4d63-b9cb-aacd793ee494
Sheet: Sheet1

Estimated Cost to Construct a Boar Isolation Facility | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Input values |  |  | $ [NAME]
Number of boar spaces (isolation) |  |  | 20
Estimated cost per boar space (below estimates are unknown) |  |  | 400
Estimated total cost |  |  | 8000
Preparation of site
Road development |  |  | 0
Electrical line |  |  | 0
Energy supply (natural gas, propane) |  |  | 0
Telephone line |  |  | 0
Water supply |  |  | 0
Manure storage |  |  | 0
Initial earthwork (leveling, fill, etc.) |  |  | 0
Final grading & drainage |  |  | 0
Landscaping (top soil, seeding, planting, etc.) |  |  | 0
Perimeter fencing (chain link) |  |  | 0
Construction labor |  |  | 0
 |  | Subtotal | 0
Animal and [NAME]
Concrete (foundation, floors, walls, manure pit, etc.) |  |  | 0
Roofing |  |  | 0
Ceiling |  |  | 0
Walls, doors and windows |  |  | 0
Electrical equipment |  |  | 0
Ventilation system |  |  | 0
Insulation & vapor barrier |  |  | 0
Heating system |  |  | 0
Cooling system |  |  | 0
Penning & gating |  |  | 0
Watering system |  |  | 0
Feeding system |  |  | 0
Alarms for temperature |  |  | 0
Automated semen delivery system |  |  | 0
Loading/unloading chute |  |  | 0
Construction labor |  |  | 0
 |  | Subtotal | 0
Estimated Cost to Construct a Boar Isolation Facility
Input values for housing boars in isolation
Useful life span of structure, years |  |  |  | 15
Percent of construction cost financed |  |  |  | 0.8
Interest rate, % |  |  |  | 0.08
Number of payment periods for the loan |  |  |  | 7
Yearly taxes (% of total investment) |  |  |  | 0.005
Yearly insurance (% of total investment) |  |  |  | 0.01
Yearly return on investment (structure & nonconsumable AI equipment) |  |  |  | 0.12
Calculated values for housing boars in isolation
Total amount borrowed |  |  |  | 6400
Amortized principal and interest payment per year |  |  |  | 1229.263369141827
Nonfinanced dollars spread over useful life span of structure |  |  |  | 106.6666666666667
Taxes and insurance (yearly cost) |  |  |  | 120
 |  |  | TOTAL | 1455.930035808494
Input values for husbandry of boars in isolation
Number of days in isolation |  |  |  | 60
Labor for care of animals (hours per day) |  |  |  | 0.4
Labor for training boars to mount dummy (total hours/boar) |  |  |  | 2.33
Rate of pay for labor ($ per hour) |  |  |  | 10
Feed cost ($ per pound) |  |  |  | 0.06
Boar feed (pounds per head per day) |  |  |  | 6
Veterinary fees per boar |  |  |  | 120
Calculated values for husbandry of boars in isolation
Potential turns per year through the isolation facility |  |  |  | 6.083333333333333
Estimated utilization of capacity per turn, % |  |  |  | 0.5
Estimated number of boars per turn through the isolation facility |  |  |  | 10
Estimated number of boars per year through the isolation facility |  |  |  | 60.83333333333333
Total pounds of feed per turn |  |  |  | 3600
Total cost of feed per turn |  |  |  | 216
Total cost of feed per year |  |  |  | 1314
Total cost of labor per year to care for boars |  |  |  | 1460
Total cost of labor per year to train boars to mount dummy |  |  |  | 1417.416666666667
Total cost of veterinary fees per year |  |  |  | 7299.999999999999
Estimated Cost to Construct the Main Boar Stud Facility
Input values for main boar stud |  |  |  | $ [NAME]
Number of boar spaces |  |  |  | 60
Estimated cost per boar space (below estimates are unknown) |  |  |  | 1900
Estimated total cost |  |  |  | 114000
Preparation of site
Road development |  |  |  | 0
Electrical line |  |  |  | 0
Energy supply (natural gas, propane) |  |  |  | 0
Telephone line |  |  |  | 0
Water supply |  |  |  | 0
Manure storage |  |  |  | 0
Initial earthwork (leveling, fill, etc.) |  |  |  | 0
Final grading & drainage |  |  |  | 0
Landscaping (top soil, seeding, planting, etc.) |  |  |  | 0
Perimeter fencing (chain link) |  |  |  | 0
Construction labor |  |  |  | 0
 |  |  | Subtotal | 0
Animal and Semen Collection Area
Concrete (foundation, floors, walls, manure pit, etc.) |  |  |  | 0
Roofing |  |  |  | 0
Ceiling |  |  |  | 0
Walls, doors and windows |  |  |  | 0
Electrical equipment |  |  |  | 0
Ventilation system |  |  |  | 0
Insulation & vapor barrier |  |  |  | 0
Heating system |  |  |  | 0
Cooling system |  |  |  | 0
Penning & gating |  |  |  | 0
Watering system |  |  |  | 0
Feeding system |  |  |  | 0
Alarms for temperature |  |  |  | 0
Automated semen delivery system |  |  |  | 0
Loading/unloading chute |  |  |  | 0
Construction labor |  |  |  | 0
 |  | Subtotal |  | 0
Estimated Cost to Construct the Main Boar Stud Facility
Laboratory, Office, Break Room, and Storage Area |  |  |  | $ [NAME]
Concrete (foundation, floors, etc.) |  |  |  | 0
Roofing |  |  |  | 0
Ceiling |  |  |  | 0
Walls, doors and windows |  |  |  | 0
Insulation & vapor barrier |  |  |  | 0
Heating system |  |  |  | 0
Cooling system |  |  |  | 0
Water heater |  |  |  | 0
Clothes washer |  |  |  | 0
Clothes dryer |  |  |  | 0
Cupboards & cabinets |  |  |  | 0
Plumbing |  |  |  | 0
Electrical |  |  |  | 0
Refrigerator |  |  |  | 0
Rangetop |  |  |  | 0
Office furnishings |  |  |  | 0
Breakroom furnishings |  |  |  | 0
Septic system |  |  |  | 0
Shower & restroom furnishings |  |  |  | 0
Construction labor |  |  |  | 0
 |  |  | Subtotal | 0
 |  |  | TOTAL | 0
Input values for main boar stud
Useful life span of structure, years |  |  |  | 7
Percent of construction cost financed |  |  |  | 0.8
Interest rate, % |  |  |  | 0.08
Number of payment periods for the loan |  |  |  | 7
Yearly taxes (% of total investment) |  |  |  | 0.005
Yearly insurance (% of total investment) |  |  |  | 0.01
Yearly return on investment (structure & nonconsumable AI equipment) |  |  |  | 0.12
Calculated values for housing boars in main stud
Total amount borrowed |  |  |  | 91200
Amortized principal and interest payment per year |  |  |  | 17517.00301027103
Nonfinanced dollars spread over useful life span of structure |  |  |  | 3257.142857142857
Taxes and insurance (yearly cost) |  |  |  | 1710
 |  |  | TOTAL | 22484.14586741389
Main Boar Stud Facility
Input values for animal husbandry in the main boar stud
Number of days in period of analysis |  |  |  | 365
AI boar feed ([NAME] lbs/head/day) |  |  |  | 6
AI boar feed cost ($/lb) |  |  |  | 0.05
Labor for animal husbandry (min/boar/day) |  |  |  | 4
Rate of pay for labor ($ per hour) |  |  |  | 10
Average veterinary cost per month per boar |  |  |  | 60
Calculated values for animal husbandry in the main boar stud
Pounds of AI boar feed during period of analysis |  |  |  | 131400
Cost of boar feed during period of analysis |  |  |  | 6570
Cost of labor for animal husbandry during period of analysis |  |  |  | 14600 | 1460 | Hours
Cost of veterinary during period of analysis |  |  |  | 730
Input values for main boar stud
Labor to collect boars (min/collection) |  |  |  | 8
Labor to process semen (min/collection) |  |  |  | 10
Labor to clean laboratory (min/day of use) |  |  |  | 20
Proportion of boar "battery" collected per week |  |  |  | 0.9
Average number of times a boar is collected/wk |  |  |  | 2
Number of times per week laboratory is used |  |  |  | 5
Number of weeks semen collected in period of analysis |  |  |  | 52
Average number of doses per collection |  |  |  | 15
Estimated Cost of Labor in [NAME]
Cost for semen collection labor, $ |  |  |  | 7488 | 748.8 | Hours
Cost for semen processing, $ |  |  |  | 9360 | 936 | Hours
Cost for cleaning laboratory, $ |  |  |  | 2600 | 260 | Hours
 |  |  | Subtotal | 19448 | 3404.8 | Total Hrs
Estimated Costs for Artificial Insemination Equipment and Supplies
 |  | Useful | Quantity | Price | Quantity | Total cost
 |  | Life | per unit | per unit | for | for
Semen Collection (Equipment & Supplies) |  | (Years) | sold | sold, $ | period | Period
Nonconsumable equipment
Dummy sow |  | 5 | 1 | 452 | 4 | 361.6
Rubber breeding  mat |  | 3 | 1 | 99 | 4 | 132
Collection vessel |  | 2 | 1 | 4.75 | 12 | 28.5
Precollection incubator |  | 5 | 1 | 360 | 1 | 72
 |  |  | Initial cost | 2621 | Subtotal | 594.1
Consumable supplies | Initial Purchase
Plastic bags | 0.5 |  | 1000 | 99 | 5616 | 555.984
Filters for collection | 0.5 |  | 500 | 80 | 5616 | 898.5600000000001
Rubber bands | 0.5 |  | 100 | 1.1 | 5616 | 61.776
Gloves, vinyl | 0.5 |  | 100 | 14.5 | 5616 | 814.3199999999999
Precollection gloves | 0.5 |  | 1000 | 39 | 5616 | 219.024
 |  |  | Initial cost | 996.8399999999999 | Subtotal | 2549.664
Semen Evaluation (Equipment & Supplies)
Nonconsumable equipment
Sperm concentration instrument |  | 5 | 1 | 1975 | 1 | 395.0000000000001
Microscope |  | 5 | 1 | 725 | 2 | 290
Slide warmer |  | 5 | 1 | 360 | 1 | 72
Adjustable pipetter |  | 5 | 1 | 235 | 2 | 94
Washbottle, water |  | 3 | 1 | 4.33 | 1 | 1.443333333333333
Washbottle, alcohol |  | 3 | 1 | 4.33 | 1 | 1.443333333333333
Washbottle, soap |  | 3 | 1 | 4.33 | 1 | 1.443333333333333
Rack for semen samples |  | 5 | 2 | 12.75 | 2 | 5.1
 |  |  | Initial cost | 2318.49 | Subtotal | 860.4300000000002
Consumable supplies | Initial Purchase
Ethyl alcohol | 0.6 |  | 1 | 25 | 5 | 125
Detergent concentrate | 0.5 |  | 1 | 15.7 | 2 | 31.4
Parafilm | 0.5 |  | 1 | 16 | 2 | 32
Immersion oil for 100x objectives | 1 |  | 1 | 45 | 1 | 45
Lens paper for microscope | 0.5 |  | 1 | 2.25 | 2 | 4.5
Compressed air for microscope | 0.5 |  | 1 | 9.5 | 6 | 57
Microscope slides, caffeine | 0.5 |  | 50 | 15 | 100 | 30
Microscope slides | 0.5 |  | 50 | 3.5 | 1900 | 133
Cover glass for slides | 0.5 |  | 100 | 2.1 | 5616 | 117.936
Kimwipes | 0.5 |  | 280 | 2.85 | 5616 | 57.16285714285715
Sperm concentration supplies | 0.5 |  | 100 | 63.5 | 5616 | 3566.16
Tubes for semen samples | 0.53 |  | 1000 | 39 | 5616 | 219.024
Pipette tips | 0.53 |  | 1000 | 37.5 | 5616 | 210.6
Transferring sample to slide | 0.5 |  | 200 | 8.5 | 5616 | 238.68
 |  |  | Initial cost | 2481.620148571428 | Subtotal | 4867.462857142858
Estimated Costs for Artificial Insemination Equipment and Supplies
 |  | Useful | Quantity | Price | Quantity | Total cost
Semen Extension (Equipment & Supplies) |  | Life | per unit | per unit | for | for
Noncomsumable equipment |  | (years) | sold | sold, $ | period | period
Warm water bath system |  | 5 | 1 | 525 | 1 | 105
Electronic balance |  | 5 | 1 | 235 | 1 | 47
Thermometer |  | 5 | 1 | 10 | 3 | 5.999999999999999
Water distiller |  | 0 | 0 | 0 | 0 | 0
Plastic pitcher(s) |  | 5 | 1 | 8.75 | 3 | 5.25
 |  |  | Initial cost | 816.25 | Subtotal | 163.25
Consumable supplies
Raw semen per dose, mL |  | 18
Total volume of extended semen/dose,mL |  | 90
Plastic bags to mix extender |  | 0.5 | 100 | 15 | 5616 | 842.4
Extender powder (based on liters made per quantity) |  | 0.5 | 5 | 3.5 | 6065.28 | 4245.696
Distilled water (purchased), [NAME] |  | 0.5 | 1 | 0.75 | 1602.45178335535 | 1201.838837516513
 |  |  | Initial cost | 3144.967418758256 | Subtotal | 6289.934837516512
Semen Packaging (Equipment & Supplies)
Nonconsumable equipment
Dispensing unit |  | 5 | 1 | 200 | 1 | 40
Sealing apparatus |  | 5 | 1 | 909 | 1 | 181.8
 |  |  | Initial cost | 1109 | Subtotal | 221.8
 | Initial
Consumable supplies | Purchase | % Used
Tubes | 0.5 | 1 | 100 | 13.5 | 84240 | 11372.4
Cochettes | 0 | 0 | 0 | 0 | 0 | 0
Sembags | 0 | 0 | 0 | 0 | 0 | 0
Bottles | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Initial cost | 5686.200000000001 | Subtotal | 11372.4
Semen Storage (Equipment & Supplies)
Nonconsumable equipment
Semen cooler |  | 5 | 1 | 436 | 1 | 87.2
Temperature recorder |  | 3 | 1 | 50 | 1 | 0.273972602739726
 |  |  | Initial cost | 486 | Subtotal | 87.47397260273974
Summary of Costs for AI Equipment
Initial cost of nonconsumables: |  |  | 7350.74
Initial cost of consumables: |  |  | 12309.62756732968
 |  | TOTAL | 19660.36756732968
Cost during period of analysis:
Nonconsumables: |  | 1927.05397260274
Consumables: |  | 25079.46169465937
 | Total: | 27006.51566726211
Estimated Cost for Semen Delivery Vehicle
Initial investment |  | 18000
Down payment |  | 2000
Yearly interest rate, % |  | 0.08
Number of payments |  | 36
Amortized principal & interest payment per month |  | 444.9928057544562
Principal & interest payment per year |  | 5339.913669053475
Estimated miles per year to deliver semen |  | 26000
Estimated miles per gallon |  | 15
Estimated miles per oil change |  | 3000
Estimated price per gallon of fuel |  | 1.029
Estimated price per oil change |  | 20
Estimated cost of insurance per year |  | 1500
Estimated cost of vehicle taxes per year |  | 400
Labor to deliver semen ($ per mile) |  | 0.35
Calculated cost for fuel per year |  | 1783.6
Calculated cost for oil changes per year |  | 173.3333333333333
Calculated cost for delivering semen |  | 9100
Total Initial Costs (without purchase price of boars):
Isolation facility for boars |  | 8000
Main facility for boars |  | 114000
Nonconsumables |  | 7350.74
Consumables |  | 12309.62756732968
Semen delivery vehicle |  | 18000
 | TOTAL | 159660.3675673297
Total Yearly Costs (without purchase price of boars):
Isolation facility for boars (payment, taxes, insurance) |  | 1349.263369141827
Main facility for boars (payment, taxes, insurance) |  | 19227.00301027103
[NAME] (AI equipment) |  | 1927.05397260274
Consumables (AI equipment) |  | 25079.46169465937
Semen delivery vehicle (principal & interest) |  | 5339.913669053475
Semen delivery vehicle (fuel & oil) |  | 1956.933333333333
Semen delivery vehicle (taxes & insurance) |  | 1900
Boar feed (isolation) |  | 1314
Boar feed (main stud) |  | 6570
Veterinary fee (isolation) |  | 7299.999999999999
Veterinary fee (main stud) |  | 730
Labor, isolation (animal husbandry, training) |  | 2877.416666666667
Labor, main stud (animal husbandry) |  | 14600
Labor, main stud (semen collection) |  | 7488
Labor, main stud (semen processing) |  | 9360
Labor, main stud (cleaning laboratory) |  | 2600
Labor to deliver semen |  | 9100
 | Total | 118719.0457157284
Template developed by [NAME], University of Nebraska (May 8, 1999)