Spreadsheet: 26d8cf2e-c581-44f7-ba78-460b4319a598
Sheet: Sheet1

Total number of days in period of analysis | Unnamed: 1 | 365 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Total number of collections per period of analysis |  | 5616
Total number of doses prepared per period of analysis |  | 84240
 |  | 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 | 1 | 90.4
Rubber breeding  mat |  | 3 | 1 | 99 | 4 | 132
Collection vessel |  | 2 | 1 | 4.75 | 12 | 28.5
Precollection incubator |  | 5 | 1 | 360 | 1 | 72
 |  |  |  |  |  | 0
 |  |  | Initial cost | 1265 | Subtotal | 322.9
 |  |  | Quantity | Price | Quantity | Total cost
Semen Collection (Equipment & Supplies) |  |  | per unit | per unit | for | for
Consumable supplies | Initial Purchase |  | sold | sold, $ | period | Period
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
 |  |  |  |  |  | 0
 |  |  | Initial cost | 1274.832 | Subtotal | 2549.664
 |  | Useful | Quantity | Price | Quantity | Total cost
 |  | Life | per unit | per unit | for | for
Semen Evaluation (Equipment & Supplies) |  | (Years) | sold | sold, $ | period | Period
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
 |  |  |  |  |  | 0
 |  |  | Initial cost | 4293.49 | Subtotal | 860.4300000000002
 |  |  | Quantity | Price | Quantity | Total cost
Semen Evaluation (Equipment & Supplies) |  |  | per unit | per unit | for | for
Consumable supplies | Initial Purchase |  | sold | sold, $ | period | Period
Ethyl alcohol | 0.6 |  | 1 | 25 | 5 | 125
Detergent concentrate | 0.6 |  | 1 | 15.7 | 2 | 31.4
Parafilm | 0.6 |  | 1 | 16 | 2 | 32
Immersion oil for 100x objectives | 0.6 |  | 1 | 45 | 1 | 45
Lens paper for microscope | 0.6 |  | 1 | 2.25 | 2 | 4.5
Compressed air for microscope | 0.6 |  | 1 | 9.5 | 6 | 57
Microscope slides, caffeine | 0.6 |  | 50 | 15 | 100 | 30
Microscope slides | 0.6 |  | 50 | 3.5 | 1900 | 133
Cover glass for slides | 0.6 |  | 100 | 2.1 | 5616 | 117.936
Kimwipes | 0.6 |  | 280 | 2.85 | 5616 | 57.16285714285715
Sperm concentration supplies | 0.6 |  | 100 | 63.5 | 5616 | 3566.16
Tubes for semen samples | 0.6 |  | 1000 | 39 | 5616 | 219.024
Pipette tips | 0.6 |  | 1000 | 37.5 | 5616 | 210.6
Transferring sample to slide | 0.6 |  | 200 | 8.5 | 5616 | 238.68
 |  |  |  |  |  | 0
 |  |  | Initial cost | 2920.477714285715 | Subtotal | 4867.462857142858
 |  | 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
 |  |  |  |  |  | 0
 |  |  | Initial cost | 816.25 | Subtotal | 163.25
Semen Extension (Equipment & Supplies)
Consumable supplies
Raw semen per dose, mL |  | 18
Total volume of extended semen/dose,mL |  | 90 | Quantity | Price | Quantity | Total cost
 |  | Initial | per unit | per unit | for | for
 |  | Purchased | sold | sold, $ | period | period
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
 |  |  |  |  |  | 0
 |  |  | Initial cost | 3144.967418758256 | Subtotal | 6289.934837516512
 |  | Useful | Quantity | Price | Quantity | Total cost
 |  | Life | per unit | per unit | for | for
Semen Packaging (Equipment & Supplies) |  | (years) | sold | sold, $ | period | period
Nonconsumable equipment
Dispensing unit |  | 5 | 1 | 200 | 1 | 40
Sealing apparatus |  | 5 | 1 | 909 | 1 | 181.8
 |  |  |  |  |  | 0
 |  |  | Initial cost | 1109 | Subtotal | 221.8
 |  |  | Quantity | Price | Quantity | Total cost
Semen Packaging (Equipment & Supplies) | Initial |  | per unit | per unit | for | for
Consumable supplies | Purchase | % Used | sold | sold, $ | period | period
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
 |  |  |  |  |  | 0
 |  |  | Initial cost | 5686.200000000001 | Subtotal | 11372.4
 |  | Useful | Quantity | Price | Quantity | Total cost
Semen Storage (Equipment & Supplies) |  | Life | per unit | per unit | for | for
Nonconsumable equipment |  | (years) | sold | sold, $ | period | period
Semen cooler |  | 5 | 1 | 436 | 1 | 87.2
Temperature recorder |  | 3 | 1 | 50 | 1 | 16.66666666666666
 |  |  |  |  |  | 0
 |  |  | Initial cost | 486 | Subtotal | 103.8666666666667
Summary of Costs for AI Equipment (without interest payment)
Initial cost of nonconsumables: |  |  | 7969.74
Initial cost of consumables: |  |  | 13026.47713304397
 |  | TOTAL | 20996.21713304397
Cost during period of analysis:
Nonconsumables: |  | 1672.246666666667
Consumables: |  | 25079.46169465937
 | Total: | 26751.70836132604 |  | Interest
Cost per dose of semen during period of analysis: |  |  |  | charges | Total
Nonconsumables: |  | 0.01985098132320355 |  | 0.004074116963189286 | 0.02392509828639283
Consumables: |  | 0.2977144075814265 |  | 0.006116394037288738 | 0.3038308016187153
 | Total: | 0.3175653889046301 |  | 0.01019051100047802 | 0.3277558999051081
Summary of Costs for AI Equipment (with amortized principal & interest payment; PMT[rate,nper,loan])
 |  |  |  | Type of
 | Annual | Monthly | Duration | Payment
 | Interest | Interest | of loan | Monthly=2 | Percent | Amount of
Item | rate, % | rate, % | (months) | Yearly = 1 | borrowed | loan, $
Nonconsumables: | 0.07 | 0.005833333333333334 | 24 | 1 | 0.8 | 6375.792
Consumables (yearly total): | 0.075 | 0.006249999999999999 | 12 | 2 | 0.5 | 12539.73084732969
 |  |  | Total | Interest
 | Amount/ | Total of | interest | for period | Interest cost per
Item | payment | payments | paid | analyzed | dose for period
Nonconsumables: | 3526.398193623188 | 7052.796387246376 | 677.0043872463757 | 343.2036129790654 | 0.004074116963189286
Consumables (yearly supply): | 1087.914656752574 | 13054.97588103089 | 515.2450337012033 | 515.2450337012033 | 0.006116394037288738
Template developed by: |  |  |  |  | (July 7, 2000)
[NAME], Ph.D.
Extension Swine Specialist
Department of Animal Science
P.O. Box 830908
University of Nebraska
Lincoln, NE 68583-0908
Telephone: 402/472-6445
Fax: 402/472-6362
E-mail:  [EMAIL]