tableau ferme (XLS) - Fichier XLS

Fichier partagé
tableau ferme (XLS)

Aperçu texte

Feuil1
TABLEAU SYNTHETIQUE DES VALEURS par Fred                                   
   pates   pates napolitaines    tarte aux pommes    soupe    pate brisée   glace              
   blé œuf total tomates oignons pates total pomme pate brisée sucre total oignons choux legumes total Blé beurre total pate d'am crème total            0.64285943878371
 qté matière première  20.0 160.0  60.0 60.0 175.0  15.0 70.0 15.0  200.0 80.0 180.0  10.0 75.0  280.0 240.0             1.5555555555555556
 tps transformation  80.0 14.939759036144578 94.93975903614458 145.66473988439304 201.86915887850466 788.4053862508858 1135.9392850137835 24.69130133928571 354.0065573770492 8.693181818181818 387.3910405345167 672.8971962616822 72.0 135.0 807.8971962616822 40.0 254.0065573770492 294.0065573770492 7465.012818662819 1499.0163934426228 8964.02921210544            
 cout matière première  208.08888888888887 121.76867469879518 329.85756358768407 4838.583815028902 2454.1682242990655 3077.6479250334673 10370.399964361435 262.91109004910714 3999.1812887067395 6060.298295454546 10322.390674210394 8180.560747663551 220.48000000000002 4976.1 13377.140747663552 104.04444444444444 2730.136844262295 2834.1812887067395 84000.0 13200.0 97200.0            
   Nourriture animaux           panier    bouquet estival   pate d'amande              
 MOULIN  N poule N cochon N vache         pates tomat Fleur s total fleur s blé total sucre amande total            
 qté produite  10.0 10.0 10.0         60.0 40.0 280.0     100.0 120.0             
 qté mat premiere nécessaire  28.0 56.0 75.0         270.31041814316086 97.10982658959537 31.11111111111111 398.53135584386735    869.3181818181819 2503.1882275132275 3372.5064093314095            
 cout mat premiere  85.16666666666666 154.336 780.3333333333333         1055.1935742971887 3225.7225433526014 0.0 4280.91611764979    40401.98863636364 24296.583114021163 64698.5717503848            
 cout production  22.0 89.0 1845.0                              
 satisfaction  -1.1 -4.45 -92.25                              
 cout production total  20.9 84.55 1752.75                              
 prix de revient total  106.06666666666666 238.88600000000002 2533.083333333333                              
 prix de revient unitaire  10.606666666666666 23.888600000000004 253.3083333333333                              
 temps de transfo mat prem  7.777777777777779 50.4 300.0                              
 temps de transfo instal  2.8 12.0 68.0                              
 temps de transfo total  10.57777777777778 62.4 368.0                              
 tps transfo unitaire  1.057777777777778 6.24 36.8                              
 FUMIER  poules cochons vaches                              
 qté fumier produit  14.0 40.0 108.0                              
 temps transfo  15.5 78.1 456.0                              
 temps transfo unitaire  1.1071428571428572 1.9525 4.222222222222222                              
 rendement fumier  0.9032258064516129 0.5121638924455826 0.23684210526315788                              
 prix de revient unitaire  9.023928571428572 8.937435 31.13680555555555                              
 ENGRAIS (SILO)                                  
 qté produite  10.0                                
 qté mat premiere  205.0                                
 cout mat premiere  3355.0415570105815 moyenne des prix de revient du fumier poule cochon et vache                               
 cout production  1285.0                                
 satisfaction  -64.25                                
 cout production total  1220.75                                
 prix de revient total  4575.7915570105815                                
 prix de revient unitaire  457.57915570105814                                
 temps de transfo mat prem  497.59411375661375                                
 temps de transfo instal  34.0                                
 temps de' transfo total  531.5941137566138                                
 tps transfo unit  53.15941137566138                                
   bénéf total Rendement (dollar/min) temps de' transfo total (min) tps transfo unitaire Bénéfice unitaire qté produite qté mat premiere nécessaire Cout Semence cout production satisfaction cout production total cout matières premières prix de revient total prix de revient unitaire prix de vente unitaire recherche (%) prix de vente unitaire réel temps de transfo mat prem temps de transfo instal temps de' transfo total (min)             
  fleurs sauvages 18.0 9.0 2.0 0.1111111111111111 1.0 18.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 0.0 1.0 0.0 2.0 2.0             
FERME PRINCIPALE  mais 53.25 10.65 5.0 0.2777777777777778 2.9583333333333335 18.0 0.0 50.0 5.0 -0.25 54.75 0.0 54.75 3.0416666666666665 6.0 0.0 6.0 0.0 5.0 5.0  NIVEAU CHAMP  4.0         
  chou 112.19999999999999 2.493333333333333 45.0 0.9 2.2439999999999998 50.0 0.0 115.0 24.0 -1.2 137.8 0.0 137.8 2.7560000000000002 5.0 0.0 5.0 0.0 45.0 45.0  NIVEAU POULAILLER  5.0         
-5.0  blé 1763.6000000000001 4.898888888888889 360.0 4.0 19.595555555555556 90.0 0.0 450.0 512.0 -25.6 936.4 0.0 936.4 10.404444444444444 30.0 0.0 30.0 0.0 360.0 360.0  NIVEAU PORCHERIE  3.0         
  œuf 705.325 45.50483870967742 15.5 0.09337349397590361 4.24894578313253 166.0 9.0 0.0 32.5 -1.625 30.875 95.46 126.335 0.7610542168674699 3.0 67.0 5.01 2.5 13.0 15.5  NIVEAU ETABLE  3.0         
  cochon 992.5025999999999 12.708099871959027 78.1 0.5206666666666666 6.616683999999999 150.0 9.0 0.0 150.0 -7.5 142.5 214.99740000000003 357.4974 2.383316 5.0 80.0 9.0 8.1 70.0 78.1  NIVEAU MOULIN  3.0         
  lait 7312.225 16.035581140350878 456.0 1.4950819672131148 23.974508196721313 305.0 9.0 0.0 1140.0 -57.0 1083.0 2279.7749999999996 3362.7749999999996 11.025491803278687 25.0 40.0 35.0 36.0 420.0 456.0  NIVEAU SILO  2.0         
  pomme 14637.037598690475 22.230051887851264 658.4347023809523 1.6460867559523809 36.59259399672619 400.0 9.0 0.0 3045.0 -152.25 2892.75 4118.212401309524 7010.962401309524 17.52740600327381 44.0 23.0 54.12 478.4347023809524 180.0 658.4347023809523  NIVEAU POMMERAIE  3.0         
  cerise 30396.11279607143 14.102934567486873 2155.304107142857 7.982607804232804 112.5781955410053 270.0 27.0 0.0 8715.0 -435.75 8279.25 12354.63720392857 20633.88720392857 76.4218044589947 180.0 5.0 189.0 1435.3041071428572 720.0 2155.304107142857  NIVEAU CERISERAIE  3.0         
FERME RESTAURANT  omelette 1741.3818674698796 51.208040744021254 34.006024096385545 34.006024096385545 1741.3818674698796 1.0 150.0 0.0 62.0 82.46 144.45999999999998 114.15813253012048 258.6181325301205 258.6181325301205 2000.0 0.0 2000.0 14.006024096385541 20.0 34.006024096385545  NIVEAU CHÂTEAU DO  1.0 0.1        
  compote 9432.25939967262 29.98092592909852 314.6086755952381 314.6086755952381 9432.25939967262 1.0 100.0 0.0 500.0 665.0 1165.0 1752.7406003273811 2917.740600327381 2917.740600327381 12350.0 0.0 12350.0 164.60867559523808 150.0 314.6086755952381  NIVEAU BOULANGERIE  1.0         
133.0  yahourt 10598.176229508197 22.827992584745765 464.2622950819672 464.2622950819672 10598.176229508197 1.0 150.0 0.0 600.0 798.0 1398.0 1653.823770491803 3051.823770491803 3051.823770491803 13650.0 0.0 13650.0 224.2622950819672 240.0 464.2622950819672  NIVEAU POTAGER  2.0         
  jus cerise 20666.409777050263 23.507786793805494 879.1303902116401 879.1303902116401 20666.409777050263 1.0 50.0 0.0 1250.0 1662.5 2912.5 3821.090222949735 6733.590222949735 6733.590222949735 27400.0 0.0 27400.0 399.1303902116402 480.0 879.1303902116401  NIVEAU RESTO  4.0         
  legumes -65.79999999999998 -2.193333333333333 30.0 0.75 -1.6449999999999996 40.0 0.0 500.0 260.0 345.8 1105.8 0.0 1105.8 27.645 26.0 0.0 26.0 0.0 30.0 30.0  NIVEAU AMANDERAIE  1.0         
  oignons 1401.3999999999999 3.8927777777777774 360.0 3.364485981308411 13.097196261682242 107.0 0.0 2000.0 1020.0 1356.6 4376.6 0.0 4376.6 40.90280373831776 54.0 0.0 54.0 0.0 360.0 360.0  NIVEAU LAITERIE  1.0         
  soupe 14292.859252336448 14.766918746680828 967.8971962616822 967.8971962616822 14292.859252336448 1.0 0.0 0.0 1000.0 1330.0 2330.0 13377.140747663552 15707.140747663552 15707.140747663552 30000.0 0.0 30000.0 807.8971962616822 160.0 967.8971962616822             
  tomate 1099.7499999999989 2.618452380952378 420.0 2.4277456647398843 6.356936416184965 173.0 0.0 9000.0 2125.0 2826.25 13951.25 0.0 13951.25 80.64306358381504 87.0 0.0 87.0 0.0 420.0 420.0             
  betterave -695.0 -3.861111111111111 180.0 2.25 -8.6875 80.0 0.0 6000.0 1500.0 1995.0 9495.0 0.0 9495.0 118.6875 110.0 0.0 110.0 0.0 180.0 180.0             
  pates 545.142436412316 1.423572307520206 382.93975903614455 4.5051736357193475 6.413440428380188 85.0 0.0 0.0 500.0 665.0 1165.0 329.85756358768407 1494.8575635876841 17.586559571619812 24.0 0.0 24.0 94.93975903614458 288.0 382.93975903614455             
  pates napo 18969.600035638563 15.103914864348221 1255.9392850137835 1255.9392850137835 18969.600035638563 1.0 0.0 0.0 2000.0 2660.0 4660.0 10370.399964361435 15030.399964361435 15030.399964361435 34000.0 0.0 34000.0 1135.9392850137835 120.0 1255.9392850137835             
  sucre -18042.1875 -18.86764705882353 956.25 8.693181818181818 -164.01988636363637 110.0 345.0 0.0 1500.0 1995.0 3495.0 40947.1875 44442.1875 404.0198863636364 240.0 0.0 240.0 776.25 180.0 956.25   1.0          
  beurre 179.90877049180335 1.0624259409851307 169.33770491803278 3.386754098360656 3.5981754098360668 50.0 33.0 0.0 625.0 831.25 1456.25 363.84122950819665 1820.0912295081966 36.40182459016393 40.0 0.0 40.0 49.33770491803279 120.0 169.33770491803278   2.0          
  pate brisé -849.1812887067396 -2.398772765675875 354.0065573770492 5.057236533957846 -12.131161267239136 70.0 0.0 0.0 500.0 665.0 1165.0 2834.1812887067395 3999.1812887067395 57.131161267239136 45.0 0.0 45.0 294.0065573770492 60.0 354.0065573770492   3.0          
  tarte pomme 4347.609325789606 10.416153926596024 417.3910405345167 417.3910405345167 4347.609325789606 1.0 0.0 0.0 1000.0 1330.0 2330.0 10322.390674210394 12652.390674210394 12652.390674210394 17000.0 0.0 17000.0 387.3910405345167 30.0 417.3910405345167   4.0          
  crème -713.5196721311479 -2.379959536307963 299.8032786885246 6.245901639344262 -14.864993169398915 48.0 40.0 0.0 1250.0 1662.5 2912.5 441.01967213114744 3353.5196721311477 69.86499316939891 55.0 0.0 55.0 59.80327868852459 240.0 299.8032786885246   5.0          
  amande -148.2915570105814 -0.11848214639288272 1251.5941137566138 20.859901895943562 -2.471525950176357 60.0 10.0 0.0 3250.0 4322.5 7572.5 4575.7915570105815 12148.291557010582 202.47152595017636 200.0 0.0 200.0 531.5941137566138 720.0 1251.5941137566138   6.0          
  pate d'amande -27358.5717503848 -7.32981239683536 3732.5064093314095 26.660760066652927 -195.4183696456057 140.0 0.0 0.0 2000.0 2660.0 4660.0 64698.5717503848 69358.5717503848 495.4183696456057 300.0 0.0 300.0 3372.5064093314095 360.0 3732.5064093314095   7.0          
  glace -117587.5 -12.611232475262462 9324.02921210544 9324.02921210544 -117587.5 1.0 0.0 0.0 8750.0 11637.5 20387.5 97200.0 117587.5 117587.5 0.0 0.0 0.0 8964.02921210544 360.0 9324.02921210544             
  lait de chèvre 7 7 0.0 7 7     0.0 0.0  0.0 7   0.0   0.0             
  salade 0.0 7 0.0 0.0 0.0 1.0    0.0 0.0  0.0 0.0 0.0  0.0   0.0             
  fromage de ch 7 7 264.0 7 7     0.0 0.0  0.0 7 46000.0  46000.0  264.0 264.0             
FERME FLORALE  bouquet fleur sauv 0.0 7 0.0 0.0 0.0 1.0    0.0 0.0  0.0 0.0   0.0   0.0             
  bouquet estival 0.0 7 0.0 0.0 0.0 1.0 0.0 0.0  0.0 0.0  0.0 0.0   0.0   0.0             
6.0  panier 31119.08388235021 31.164853962999697 998.5313558438673 998.5313558438673 31119.08388235021 1.0 0.0 0.0 10000.0 600.0 10600.0 4280.91611764979 14880.916117649791 14880.916117649791 46000.0 0.0 46000.0 398.53135584386735 600.0 998.5313558438673             
   0.0 7 0.0                 0.0             
                      0.0             
Feuil2
tableau ferme (XLS) - Fichier XLS

tableau ferme (XLS)

Aperçu texte

Sur le même sujet

Partager le fichier

Lien court

Code HTML

Code BB

Lien permanent
