{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ABC","AC","BC","C","Données","RECAP"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ABC","index":0,"n_rows":86,"n_cols":26,"rows_kept":86,"cut":false,"hidden":false,"merged":[[21,10,21,13],[23,2,23,6]]}
[" Début mois",null,null,null,null,null,"Fin mois",null,null,null,null,null,null,null,null,null,null,null,null,null,"Couts"]
[null,"Stock"," Cde reçue"," Cde reçue"," Cde reçue",null,"Stock","Cde","Cde","Qté chez A","Qté chez B","Qté chez C","Stock",null,null,null,"Mois arrivée ","Mois arrivée ","Mois arrivée "]
["Mois",null,"fournisseur A","fournisseur B","fournisseur C","Demande",null,"passée C","passée A ou B","commandée","commandée","commandée","moyen","Délai A","Délai B","Délai C","arrivée cde A","arrivée cde B","arrivée cde C",null,"Possession","Commande A","Commande B","Commande C","Rupture","Gestion"]
[0,null,0,0,0,0,104000,null,null,30000]
[1,104000,0,0,0,97600,6400,"OUI","OUI",80000,32366,60400,55200,2,2,1,3,3,2,null,1104,8200,4883.92,9860,null,24047.919999999998]
[2,6400,30000,0,60400,66800,30000,"OUI","OUI",80000,33540,82366,18200,2,1,1,4,3,3,null,364,8200,5024.7999999999993,13154.9,null,26743.699999999997]
[3,30000,76800,63929,82366,112366,140729,"NON","OUI",null,150000,null,85364.5,null,1,null,null,4,null,null,1707.29,null,11500.000000000002,null,null,13207.29]
[4,140729,77600,147000,0,113540,251789,"NON","OUI",null,150000,null,196259,null,1,null,null,5,null,null,5850.3600000000006,null,11500.000000000002,null,null,17350.36]
[5,251789,0,147000,0,184334,214455,"OUI","OUI",null,264000,41819,233122,null,2,1,null,7,6,null,7324.88,null,16840,7909.2300000000005,null,32074.11]
[6,214455,0,0,41819,256274,0,"OUI","OUI",null,243094,264000,107227.5,null,2,1,null,8,7,null,2289.1,null,15585.64,35120,null,52994.74]
[7,0,0,0,264000,264000,0,"OUI","OUI",null,158620,243094,0,null,2,1,null,9,8,null,0,null,10517.199999999999,32402.22,null,42919.42]
[8,0,0,0,243094,243094,0,"OUI","OUI",null,152806,158620,0,null,2,1,null,10,9,null,0,null,11696.420000000002,23006.800000000003,null,34703.22]
[9,0,0,0,158620,158620,0,"OUI","OUI",null,194066,152806,0,null,1,1,null,10,10,null,0,null,14584.62,22192.840000000004,null,36777.460000000006]
[10,0,0,0,152806,152806,0,"OUI","OUI",null,257480,194066,0,null,2,1,null,12,11,null,0,null,16448.8,26028.58,null,42477.380000000005]
[11,0,0,0,194066,194066,0,"OUI","OUI",null,0,257480,0,null,null,1,null,null,12,null,0,null,null,34272.400000000001,null,34272.400000000001]
[12,0,0,0,257480,257480,0,"NON","NON",null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",18639.63,16400,118581.4,203946.97,null,357568]
[]
[null,null,null,null,null,null,null,null,null,null,"Variation de la demande "]
[null,null,null,null,null,null,null,null,null,null,"x",2]
[null,null,"Couts moyens € (10 simulations)"]
["Variation de la demande ",null,"Possession","Commande A","Commande B","Commande C","Total",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",19768.723000000005,14760,116128.51400000001,193836.68100000004,null,344493.91800000006]
["x",1,11331.651000000002,30239.906000000006,64531.710000000006,88604.777000000002,194708.04400000005]
["x",2,19768.723000000005,14760,116128.51400000001,193836.68100000004,344493.91800000006]
["x",4,25772.616000000002,0,188530.56799999997,434837.43199999991,649140.61600000004]
["x",6,24135.317999999999,0,280664.20000000007,724524.83199999994,1029324.35]
["x",10,32044,0,421311.58000000007,1257002.44,1710358.02]
["x",0.8,8966.7315999999992,23580.351999999999,55883.370999999999,76139.021999999997,164569.47659999999]
["x",0.5,8883.7800000000007,12357.5,36455.906999999999,49708.909000000007,107406.09599999999]
["x",0.2,12835.192000000001,1111.306,11605.503999999997,15312.437999999998,40864.440000000017]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Variation de la demande "]
["Variation de la demande : ",null,null,null,"2Variation de la demande x Variation de la demande : "]

{"sheet":"AC","index":1,"n_rows":33,"n_cols":26,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,10,21,13],[23,2,23,6]]}
[" Début mois",null,null,null,null,null,"Fin mois",null,null,null,null,null,null,null,null,null,null,null,null,null,"Couts"]
[null,"Stock"," Cde reçue"," Cde reçue"," Cde reçue",null,"Stock","Cde","Cde","Qté chez A","Qté chez B","Qté chez C","Stock",null,null,null,"Mois arrivée ","Mois arrivée ","Mois arrivée "]
["Mois",null,"fournisseur A","fournisseur B","fournisseur C","Demande",null,"passée C","passée A ou B","commandée","commandée","commandée","moyen","Délai A","Délai B","Délai C","arrivée cde A","arrivée cde B","arrivée cde C",null,"Possession","Commande A","Commande B","Commande C","Rupture","Gestion"]
[0,null,0,null,0,0,104000,null,null,30000]
[1,104000,0,null,0,488000,0,"OUI","OUI",null,null,718000,52000,null,null,1,null,null,2,null,1040,null,null,101320.00000000001,null,102360.00000000001]
[2,0,30000,null,718000,334000,414000,"OUI","OUI",null,null,147830,207000,null,null,1,null,null,3,null,6280,null,null,21496.2,null,27776.2]
[3,414000,0,null,147830,561830,0,"OUI","OUI",null,null,567700,207000,null,null,1,null,null,4,null,6280,null,null,80278.000000000015,null,86558.000000000015]
[4,0,0,null,567700,567700,0,"OUI","OUI",null,null,921670,0,null,null,1,null,null,5,null,0,null,null,129833.80000000002,null,129833.80000000002]
[5,0,0,null,921670,921670,0,"OUI","OUI",null,null,1281370,0,null,null,1,null,null,6,null,0,null,null,167378.1,null,167378.1]
[6,0,0,null,1281370,1281370,0,"OUI","OUI",null,null,1320000,0,null,null,1,null,null,7,null,0,null,null,172400,null,172400]
[7,0,0,null,1320000,1320000,0,"OUI","OUI",null,null,1215470,0,null,null,1,null,null,8,null,0,null,null,158811.1,null,158811.1]
[8,0,0,null,1215470,1215470,0,"OUI","OUI",null,null,793100,0,null,null,1,null,null,9,null,0,null,null,111834.00000000001,null,111834.00000000001]
[9,0,0,null,793100,793100,0,"OUI","OUI",null,null,764030,0,null,null,1,null,null,10,null,0,null,null,107764.20000000001,null,107764.20000000001]
[10,0,0,null,764030,764030,0,"OUI","OUI",null,null,970330,0,null,null,1,null,null,11,null,0,null,null,126942.90000000001,null,126942.90000000001]
[11,0,0,null,970330,970330,0,"OUI","OUI",null,null,1287400,0,null,null,1,null,null,12,null,0,null,null,168162,null,168162]
[12,0,0,null,1287400,1287400,0,"NON","NON",null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",13600,0,null,1346220.2999999998,null,1359820.2999999998]
[]
[null,null,null,null,null,null,null,null,null,null,"Variation de la demande "]
[null,null,null,null,null,null,null,null,null,null,"x",10]
[null,null,"Couts moyens € (10 simulations)"]
["Variation de la demande ",null,"Possession","Commande A","Commande B","Commande C","Total",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",13600,0,null,1346220.3,null,1359820.3]
["x",1,4923.6359999999995,11069.947999999999,null,122664.48599999999,138658.07]
["x",2,1768,0,null,273455.72000000009,275223.72000000009]
["x",4,3464,0,null,541248.12,544712.12]
["x",6,5792,0,null,809572.17999999993,815364.17999999993]
["x",10,13600,0,null,1346220.3,1359820.3]
["x",0.8,6350.2570000000005,14722.180000000004,null,91811.781000000017,112884.21799999996]
["x",0.5,8648.6689999999981,12039.886,null,51230.698000000011,71919.252999999997]
["x",0.2,12804.772000000001,827.94600000000014,null,15650.235999999999,29282.954000000005]

{"sheet":"BC","index":2,"n_rows":33,"n_cols":26,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,10,21,13],[23,2,23,6]]}
[" Début mois",null,null,null,null,null,"Fin mois",null,null,null,null,null,null,null,null,null,null,null,null,null,"Couts"]
[null,"Stock"," Cde reçue"," Cde reçue"," Cde reçue",null,"Stock","Cde","Cde","Qté chez A","Qté chez B","Qté chez C","Stock",null,null,null,"Mois arrivée ","Mois arrivée ","Mois arrivée "]
["Mois",null,"fournisseur A","fournisseur B","fournisseur C","Demande",null,"passée C","passée A ou B","commandée","commandée","commandée","moyen","Délai A","Délai B","Délai C","arrivée cde A","arrivée cde B","arrivée cde C",null,"Possession","Commande A","Commande B","Commande C","Rupture","Gestion"]
[0,null,null,0,0,0,104000,null,null,30000]
[1,104000,null,0,0,9760,94240,"NON","NON",null,null,null,99120,null,null,null,null,null,null,null,1982.4,null,null,null,null,1982.4]
[2,94240,30000,0,0,6680,117560,"NON","NON",null,null,null,105900,null,null,null,null,null,null,null,2236,null,null,null,null,2236]
[3,117560,null,0,0,11236.6,106323.4,"NON","NON",null,null,null,111941.7,null,null,null,null,null,null,null,2477.6679999999997,null,null,null,null,2477.6679999999997]
[4,106323.4,null,0,0,11354,94969.4,"NON","NON",null,null,null,100646.39999999999,null,null,null,null,null,null,null,2025.8559999999998,null,null,null,null,2025.8559999999998]
[5,94969.4,null,0,0,18433.400000000001,76536,"NON","NON",null,null,null,85752.7,null,null,null,null,null,null,null,1715.0540000000001,null,null,null,null,1715.0540000000001]
[6,76536,null,0,0,25627.4,50908.6,"NON","NON",null,null,null,63722.3,null,null,null,null,null,null,null,1274.4460000000001,null,null,null,null,1274.4460000000001]
[7,50908.6,null,0,0,26400,24508.6,"NON","OUI",null,15663,null,37708.6,null,2,null,null,9,null,null,754.17200000000003,null,2722.9300000000003,null,null,3477.1020000000003]
[8,24508.6,null,0,0,24309.4,199.19999999999709,"OUI","OUI",null,15280,15663,12353.899999999998,null,2,1,null,10,9,null,247.07799999999997,null,2833.6,3619.3399999999997,null,6700.018]
[9,199.19999999999709,null,15350,15663,15862,15350.199999999997,"NON","OUI",null,19337,null,7774.6999999999971,null,2,null,null,11,null,null,155.49399999999994,null,3320.44,null,null,3475.9340000000002]
[10,15350.199999999997,null,14822,0,15280.6,14891.599999999997,"OUI","OUI",null,25748,4515,15120.899999999998,null,2,1,null,12,11,null,302.41799999999995,null,3832.28,1567.5500000000002,null,5702.2480000000005]
[11,14891.599999999997,null,18950,4515,19406.600000000002,18949.999999999996,"OUI","OUI",null,0,6798,16920.799999999996,null,null,1,null,null,12,null,338.41599999999994,null,null,1955.66,null,2294.076]
[12,18949.999999999996,null,24976,6798,25748,24976,"NON","NON",null,null,null,21963,null,null,null,null,null,null,null,439.26,null,null,null,null,439.26]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",13948.261999999999,null,12709.250000000002,7142.5499999999993,null,33800.062000000005]
[]
[null,null,null,null,null,null,null,null,null,null,"Variation de la demande "]
[null,null,null,null,null,null,null,null,null,null,"x",0.2]
[null,null,"Couts moyens € (10 simulations)"]
["Variation de la demande ",null,"Possession","Commande A","Commande B","Commande C","Total",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",13972.382999999998,null,11684.128000000001,7834.0590000000011,null,33490.570000000007]
["x",1,26045.350000000006,null,75135.830000000016,45034.76,146215.94]
["x",2,39928.851000000002,null,106210.47199999999,114855.80400000003,260995.12699999995]
["x",4,45363.732000000004,null,109000,352503.728,506867.45999999996]
["x",6,45748.55,null,109000,634191.14,788939.69000000006]
["x",10,52463,null,109000,1174946.7599999998,1336409.7600000002]
["x",0.8,19549.182800000002,null,67160.753999999986,37328.560000000005,124038.49679999999]
["x",0.5,14476.301499999998,null,42204.307000000001,24069.96,80750.568499999979]
["x",0.2,13972.382999999998,null,11684.128000000001,7834.0590000000011,33490.570000000007]

{"sheet":"C","index":3,"n_rows":33,"n_cols":26,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,10,21,13],[23,2,23,6]]}
[" Début mois",null,null,null,null,null,"Fin mois",null,null,null,null,null,null,null,null,null,null,null,null,null,"Couts"]
[null,"Stock"," Cde reçue"," Cde reçue"," Cde reçue",null,"Stock","Cde","Cde","Qté chez A","Qté chez B","Qté chez C","Stock",null,null,null,"Mois arrivée ","Mois arrivée ","Mois arrivée "]
["Mois",null,"fournisseur A","fournisseur B","fournisseur C","Demande",null,"passée C","passée A ou B","commandée","commandée","commandée","moyen","Délai A","Délai B","Délai C","arrivée cde A","arrivée cde B","arrivée cde C",null,"Possession","Commande A","Commande B","Commande C","Rupture","Gestion"]
[0,null,0,null,0,0,104000,null,null,30000]
[1,104000,0,null,0,9760,94240,"NON",null,null,null,null,99120,null,null,null,null,null,null,null,1982.4,null,null,null,null,1982.4]
[2,94240,30000,null,0,6680,117560,"NON",null,null,null,null,105900,null,null,null,null,null,null,null,2236,null,null,null,null,2236]
[3,117560,0,null,0,11236.6,106323.4,"NON",null,null,null,null,111941.7,null,null,null,null,null,null,null,2477.6679999999997,null,null,null,null,2477.6679999999997]
[4,106323.4,0,null,0,11354,94969.4,"NON",null,null,null,null,100646.39999999999,null,null,null,null,null,null,null,2025.8559999999998,null,null,null,null,2025.8559999999998]
[5,94969.4,0,null,0,18433.400000000001,76536,"NON",null,null,null,null,85752.7,null,null,null,null,null,null,null,1715.0540000000001,null,null,null,null,1715.0540000000001]
[6,76536,0,null,0,25627.4,50908.6,"NON",null,null,null,null,63722.3,null,null,null,null,null,null,null,1274.4460000000001,null,null,null,null,1274.4460000000001]
[7,50908.6,0,null,0,26400,24508.6,"NON",null,null,null,null,37708.6,null,null,null,null,null,null,null,754.17200000000003,null,null,null,null,754.17200000000003]
[8,24508.6,0,null,0,24309.4,199.19999999999709,"OUI",null,null,null,15663,12353.899999999998,null,null,1,null,null,9,null,247.07799999999997,null,null,3619.3399999999997,null,3866.4179999999997]
[9,199.19999999999709,0,null,15663,15862,0.19999999999708962,"OUI",null,null,null,15280,99.69999999999709,null,null,1,null,null,10,null,1.9939999999999418,null,null,3550.4,null,3552.3940000000002]
[10,0.19999999999708962,0,null,15280,15280.6,0,"OUI",null,null,null,19407,9.9999999998544808E-2,null,null,1,null,null,11,null,1.9999999999708962E-3,null,null,4099.1900000000005,null,4099.1920000000009]
[11,0,0,null,19407,19406.600000000002,0.39999999999781721,"OUI",null,null,null,25748,0.19999999999890861,null,null,1,null,null,12,null,3.9999999999781721E-3,null,null,5177.1600000000008,null,5177.1640000000007]
[12,0.39999999999781721,0,null,25748,25748,0.39999999999781721,"NON",null,null,null,null,0.39999999999781721,null,null,null,null,null,null,null,7.9999999999563441E-3,null,null,null,null,7.9999999999563441E-3]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",12714.682000000001,null,null,16446.09,null,29160.772000000001]
[]
[null,null,null,null,null,null,null,null,null,null,"Variation de la demande "]
[null,null,null,null,null,null,null,null,null,null,"x",0.2]
[null,null,"Couts moyens € (10 simulations)"]
["Variation de la demande ",null,"Possession","Commande A","Commande B","Commande C","Total",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",12714.682000000001,null,null,16446.09,null,29160.772000000004]
["x",1,3180,null,null,134426.17999999996,137606.17999999996]
["x",2,1768,null,null,273455.72000000009,275223.72000000009]
["x",4,3464,null,null,541248.12,544712.12]
["x",6,5792,null,null,809572.17999999993,815364.17999999993]
["x",10,13600,null,null,1346220.3,1359820.3]
["x",0.8,4169.8959999999997,null,null,105851.65,110021.546]
["x",0.5,6514.6600000000008,null,null,66130.280000000013,72644.939999999988]
["x",0.2,12714.682000000001,null,null,16446.09,29160.772000000004]

{"sheet":"Données","index":4,"n_rows":93,"n_cols":15,"rows_kept":93,"cut":false,"hidden":false,"merged":[[26,10,26,12],[26,6,26,9],[26,3,26,5]]}
[null,"Demande du récipient en plastique de 454 grammes"]
[null,null,"Janv.","Fév.","Mars","Avril","Mai","Juin","Juil.","Août","Sept.","Oct.","Nov.","Déc."]
[null,"A7",35000,22400,39040,38960,64080,93120,85120,80000,50880,51280,69440,92880]
[null,"A8",36100,26670,41930,41790,74480,99750,106400,97300,69370,58170,71960,95400]
[null,"A9",30700,21420,36000,37140,54000,75300,82560,75600,45100,49200,60900,80280]
[]
[]
[null,"Demande du récipient en plastique de 907 grammes"]
[null,null,"Janv.","Fév.","Mars","Avril","Mai","Juin","Juil.","Août","Sept.","Oct.","Nov.","Déc."]
[null,"A7",4400,2000,4800,4870,8010,11640,10640,10000,6360,6410,8680,11610]
[null,"A8",7700,5715,8990,8960,15960,21380,22800,20850,14870,12470,15420,20460]
[null,"A9",10200,7140,12000,12380,18000,25100,27520,25020,15060,16400,20300,26760]
[]
[null,"Demande en pph"]
[null,null,"Janv.","Fév.","Mars","Avril","Mai","Juin","Juil.","Août","Sept.","Oct.","Nov.","Déc."]
["A7",null,43800,26400,48640,48700,80100,116400,106400,100000,63600,64100,86800,116100]
["A8",null,51500,38100,59910,59710,106400,142510,152000,139000,99110,83110,102800,136320]
["A9",null,51100,35700,60000,61900,90000,125500,137600,125640,75220,82000,101500,133800]
["A10 ? ",null,48800,33400,56183,56770,92167,128137,132000,121547,79310,76403,97033,128740]
[null,"A10 = moyenne des 3 dernières années"]
[]
[null,"Fabrication récipient 454 grammes = 1p.p.h. / 907 grammes = 2 p.p.h."]
[]
[null,"PRIX D’ACHAT DE LA MATIÈRE PREMIÈRE"]
[]
[null,"PRIX D'ACHAT CHEZ LE",null,null,null,null,"PRIX D'ACHAT CHEZ LE",null,null,null,"PRIX D'ACHAT CHEZ LE"]
[null,null,null,"FOURNISSEUR \"A\"",null,null,"FOURNISSEUR \"B\"",null,null,null,"FOURNISSEUR \"C\""]
[null,null,null,"[ < que ]","[ < que ]","[ = a ]","[ < que ]","[ < que ]","[ < que ]","[ = a ]","[ < que ]","[ < que ]","[ >= a ]",null,"vcx"]
[null,null,null,50000,80000,80000,70000,120000,150000,150000,50000,100000,100000]
[null,"JAN",null,0.12,0.1,0.09,0.12,0.1,0.08,7.0000000000000007E-2,0.18,0.15,0.14000000000000001]
[null,"FEV",null,0.12,0.1,0.09,0.12,0.1,0.08,7.0000000000000007E-2,0.18,0.15,0.14000000000000001]
[null,"MAR",null,0.12,0.1,0.09,0.12,0.1,0.08,7.0000000000000007E-2,0.18,0.15,0.14000000000000001]
[null,"AVR",null,0.12,0.1,0.09,0.12,0.1,0.08,7.0000000000000007E-2,0.18,0.15,0.14000000000000001]
[null,"MAI",null,0.11,0.09,0.08,0.11,0.09,7.0000000000000007E-2,0.06,0.17,0.14000000000000001,0.13]
[null,"JUN",null,0.11,0.09,0.08,0.11,0.09,7.0000000000000007E-2,0.06,0.17,0.14000000000000001,0.13]
[null,"JUL",null,0.11,0.09,0.08,0.11,0.09,7.0000000000000007E-2,0.06,0.17,0.14000000000000001,0.13]
[null,"AOU",null,0.12,0.1,0.09,0.12,0.1,0.08,7.0000000000000007E-2,0.18,0.15,0.14000000000000001]
[null,"SEP",null,0.12,0.1,0.09,0.12,0.1,0.08,7.0000000000000007E-2,0.18,0.15,0.14000000000000001]
[null,"OCT",null,0.11,0.09,0.08,0.11,0.09,7.0000000000000007E-2,0.06,0.17,0.14000000000000001,0.13]
[null,"NOV",null,0.11,0.09,0.08,0.11,0.09,7.0000000000000007E-2,0.06,0.17,0.14000000000000001,0.13]
[null,"DEC",null,null,0.09,0.08,0.11,0.09,7.0000000000000007E-2,0.06,0.17,0.14000000000000001,0.13]
[]
[]
[]
[null,"Délais livraison :"]
[]
[null,"A",2,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(K30:M41)","v":0.15166666666666662}]
[null,"C",1,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(G30:J41)","v":8.7499999999999981E-2}]
[null,"B","Délai","Probabilité."]
[null,null,1,0.4]
[null,null,2,0.4]
[null,null,3,0.2]
[]
[null,"Qté max à commander par période :"]
[]
[null,"A",80000,"pph"]
[null,"B",150000,"pph"]
[null,"C","Illim"]
[]
[null,"Coût commande unitaire (dollars)"]
[]
[null,"A",1000]
[null,"B",1000]
[null,"C",800]
[]
[null,"Attention abandon de A"]
[]
[null,"Stock en inventaire janvier",104000,"pph"]
[null,"commande additionnelle auprès A",30000,"pph"]
[null,"en décembre qui sera livrée en février"]
[]
[null,"Capa stock",null,100000,"pph"]
[null,"Coût stockage mensuel",null,0.02,"$"]
[]
[null,"Cap prod ","X+2Y=100000",null,"X : petit récip","Y: grand récip"]
[null,"Nb employés",20]
[]
[null,"Délai","Probabilité."]
[]
[null,1,0.4]
[null,2,0.4]
[null,3,0.2]
[]
[]
["Variation de la demande : "]
[1]
[2]
[4]
[6]
[10]
[0.8]
[0.5]
[0.2]

{"sheet":"RECAP","index":5,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,2,1],[2,2,2,7],[0,0,0,7]]}
[]
[null,null,"Couts moyens totaux € (10 simulations)"]
[]
["Variation de la demande ",null,"Stratégie ABC","Strat AC","Strat BC ","Strat C ","€ MIN ","STRAT ASSOCIÉE"]
["x",0.2,{"$f":"ABC!G33","v":40864.440000000017},{"$f":"AC!G33","v":29282.954000000005},{"$f":"BC!G33","v":33490.570000000007},{"$f":"'C'!G33","v":29160.772000000004},{"$f":"MIN(C5:F5)","v":29160.772000000004},{"$f":"IF(G5=C5,$C$4,IF(G5=D5,$D$4,IF(G5=E5,$E$4,IF(G5=F5,$F$4))))","v":"Strat C "}]
["x",0.5,{"$f":"ABC!G32","v":107406.09599999999},{"$f":"AC!G32","v":71919.252999999997},{"$f":"BC!G32","v":80750.568499999979},{"$f":"'C'!G32","v":72644.939999999988},{"$f":"MIN(C6:F6)","v":71919.252999999997},{"$f":"IF(G6=C6,$C$4,IF(G6=D6,$D$4,IF(G6=E6,$E$4,IF(G6=F6,$F$4))))","v":"Strat AC"}]
["x",0.8,{"$f":"ABC!G31","v":164569.47659999999},{"$f":"AC!G31","v":112884.21799999996},{"$f":"BC!G31","v":124038.49679999999},{"$f":"'C'!G31","v":110021.546},110021.546,"Strat C "]
["x",1,{"$f":"ABC!G26","v":194708.04400000005},{"$f":"AC!G26","v":138658.07},{"$f":"BC!G26","v":146215.94},{"$f":"'C'!G26","v":137606.17999999996},137606.17999999996,"Strat C "]
["x",2,{"$f":"ABC!G27","v":344493.91800000006},{"$f":"AC!G27","v":275223.72000000009},{"$f":"BC!G27","v":260995.12699999995},{"$f":"'C'!G27","v":275223.72000000009},260995.12699999995,"Strat BC "]
["x",4,{"$f":"ABC!G28","v":649140.61600000004},{"$f":"AC!G28","v":544712.12},{"$f":"BC!G28","v":506867.45999999996},{"$f":"'C'!G28","v":544712.12},506867.45999999996,"Strat BC "]
["x",6,{"$f":"ABC!G29","v":1029324.35},{"$f":"AC!G29","v":815364.17999999993},{"$f":"BC!G29","v":788939.69000000006},{"$f":"'C'!G29","v":815364.17999999993},788939.69000000006,"Strat BC "]
["x",10,{"$f":"ABC!G30","v":1710358.02},{"$f":"AC!G30","v":1359820.3},{"$f":"BC!G30","v":1336409.7600000002},{"$f":"'C'!G30","v":1359820.3},1336409.7600000002,"Strat BC "]