Calcule Vlrtyuipko

Feuil1Evolution du chepteltaux de vlage est de 95%Taux de mortalit des vaches est de 2%Taux de mortalit des veaux est de 5%Taux de reforme des vaches est de 5%Taux de reforme des gnisses est de 5%Catgories1ere anne2eme anne3eme anne4eme anne5eme annevache9386123156205gnisse040375471veau4238577597velle4239577597reforme578911total182210282369481Evolution de production1ere anne2eme anne3eme anne4eme anne5eme anneproduction(vache)60006500700080008000production totale55800055900086100012480001640000PU3.83.83.83.83.8Total21204002124200327180047424006232000Evolution chiffre d'affaire1ere anne2eme anne3eme anne4eme anne5eme annevente du lait21204002124200327180047424006232000veaux210000190000285000375000485000Subvention168000156000228000300000388000Reforme50000700008000090000110000Fumier39858459906175880811105339Total25882582586190392655855882117320339Alimentation1ere anne2eme anne3eme anne4eme anne5eme annePaille80000107200133600170000215200Fourrage255000352590439460556990705180Aliment concentr700800967104120537615277441934208Aliment dmarrage9581295812127750153300204400CMV1800023000310003800045000Lait poudre1260011400171002250029100Total11622121557106195428624685343133088Frais vtrinaires1ere anne2eme anne3eme anne4eme anne5eme annevache46500430006150078000102500gnisse0800074001080014200veau2100019500285003750048500Total675007050097400126300165200Frais personnels1ere anne2eme anne3eme anne4eme anne5eme anneGrant4800048000600006000060000Ouvriers9000090000120000120000120000Gardiens2400024000480004800048000chauffeur3600036000425004250042500TOTAL198000198000270500270500270500Besoins en eau/ cout de pompage1ere anne2eme anne3eme anne4eme anne5eme anneHygine3394.531394489.556947482.5abreuvoirs2715.62511.23591.64555.25986besoins total6110.15650.28081.110249.213468.5cout de pompage3055.052825.14040.555124.66734.25Frais d'lectricit1ere anne2eme anne3eme anne4eme anne5eme anneSalle de tarite87608760131401524019620pompage3055.052825.14040.555124.66734.25batiment d'elevage6188714095881254616354exterieur1314013140131401314013140TOTAL31143.0531865.139908.5546050.655848.25

Feuil2

Feuil3