cow calculation
DESCRIPTION
cow wise incomeTRANSCRIPT
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