cow calculation

6
Asuming 100% female 15 No of cows 10 Year Milking one Calfs removal cows 1 0 10 0 2 0 10 0 3 10 20 0 4 10 30 0 5 20 50 0 6 30 80 10 7 50 120 0 8 80 190 10 9 120 290 10 10 190 450 20 Total Milkin 470 740 Total Calfs for 5 2350 3700 10 4700 7400 Cow Calf Total Total value of form 40000 7000 47000 1 400000 70000 470000 2 400000 140000 540000 3 800000 210000 1010000 4 1200000 350000 1550000 5 2000000 560000 2560000 6 2800000 910000 3710000 7 4800000 1400000 6200000 8 7600000 2170000 9770000 9 12000000 3360000 15360000 10 18800000 5180000 23980000 Asuming 50% female No of cow 10 Year on Year Milking ones Calfs removal Milking Milk per cow/per day on annual basis

Upload: udaya

Post on 20-Nov-2015

216 views

Category:

Documents


0 download

DESCRIPTION

cow wise income

TRANSCRIPT

Sheet110 cows one employee @10K/monthAsuming 100% femaleAvg Milk per cow/per day on annual basis15Avg Price exp[15Out Flow per animal(1000 per month for feed + 1000 per month for takecare + 1000 misl) day and 1500 per calfs10050No of cows10Year on YearTotal AnimalsMilk pro per day(Lts)Inflow per day(Rs)Monthly Inflow(Rs)Daily cow costDaily Calf costMonthly CostInflowAnnual Income/YrYearMilking onesCalfsremoval cowsMilkingCalfs101502250675001000030000375004500001010010102015022506750010005004500022500270000201001020201502250675001000100060000750090000310200203040300450013500020001500105000300003600004103003050504506750202500300025001650003750045000052050050808075011250337500500040002700006750081000063080107013012012001800054000070006500405000135000162000075012001202001801950292508775001200010000660000217500261000088019010190310280315047250141750019000155001035000382500459000091202901030048042049507425022275003000024000162000060750072900001019045020470740650780011700035100004700037000252000099000011880000

Total Milking 470740Total Calfsfor5235037001047007400CowCalfTotalTarget10000000Total value of form40000700047000140000070000470000No2400000140000540000No38000002100001010000No412000003500001550000No520000005600002560000No628000009100003710000No7480000014000006200000No8760000021700009770000No912000000336000015360000Yes1018800000518000023980000YesAsuming 50% femaleNo of cows10Year on YearYearMilking onesCalfsremoval cowsMilkingCalfsShortage10100101002010010200310150202554101503030155152304538276153010505350723370736783830471093841439375810120105232104774151521323760Total Milking 152132Total Calfsfor57606601015203300