{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Feuil1","index":0,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,0,0,4],[14,0,14,4],[31,0,31,4],[37,0,37,3],[51,0,51,5]],"flags":["formulas_cached_only"]}
["Prévision de la production de récipients 454g année 10"]
["Mois","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
["Demande",30817,22613,38585,39667,62568,86984,91692,82797,51940,50420,63628,83264]
["Demande cum",30817,53430,92015,131682,194250,281234,372926,455723,507663,558083,621711,704975]
["Quantité produite",20000,30000,40000,100000,80000,60000,60000,80000,50000,70000,70000,70000]
["Quantité produite cum",20000,30000,70000,170000,250000,310000,370000,450000,500000,570000,640000,710000]
["Quantité vendable",19000,28500,38000,95000,76000,57000,57000,76000,47500,66500,66500,66500]
["Stock début",12000,183,6070,5485,60818,74250,44266,9574,2777,-1663,14417,17289]
["Stock fin",183,6070,5485,60818,74250,44266,9574,2777,-1663,14417,17289,525]
["Cout rupture","-","-","-","-","-","-","-","-",83.15,"-","-","-",1372.39]
["Cout stockage",7.32,242.8,219.4,2432.7200000000003,2970,1770.64,382.96000000000004,111.08,"-",576.6800000000001,691.5600000000001,21]
["Penalité lot","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
[]
["Prévision de la production de récipients 907g année 10"]
["Mois","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
["Demande",12673,8211,13258,13496,20894,27853,29673,27876,17158,17186,22912,29829]
["Demande cum",12673,20884,34142,47638,68532,96385,126058,153934,171092,188278,211190,241019]
["Quantité produite",10000,0,30000,10000,20000,30000,30000,20000,30000,20000,30000,30000]
["Quantité produite cum",10000,10000,40000,50000,70000,100000,130000,150000,180000,200000,230000,260000]
["Quantité vendable",9000,0,27000,9000,18000,27000,27000,18000,27000,18000,27000,27000]
["Stock début",12000,8327,116,13858,9362,6468,5615,2942,-6934,2908,3722,7810]
["Stock fin",8327,116,13858,9362,6468,5615,2942,-6934,2908,3722,7810,4981]
["Cout rupture","-","-","-","-","-","-","-",1040.1,"-","-","-","-"]
["Cout stockage",499.62,6.96,831.48,561.72,388.08,336.9,176.51999999999998,"-",174.48,223.32,468.59999999999997,298.86]
["Penalité lot","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
[]
["Quantité PPH trans",40000,30000,100000,120000,120000,120000,120000,120000,110000,110000,130000,130000]
[]
[]
["Prévision de la production globale de pph année 2010"]
["Mois","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
["Quantité",56163,39035,65101,66659,104356,142690,151038,138549,86256,84792,109452,142922]
[]
[]
[]
["Tableau des besoins"]
[null,"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
["Dmde prév A10",40000,30000,100000,120000,120000,120000,120000,120000,110000,110000,130000,130000]
["Stock Début",104000,64000,64000,-36000,-156000,-276000,-396000,-516000,-636000,-746000,-856000,-986000]
["Stock Virtuel Déb",null,64010]
["Cde nécéssaire ?","NON","OUI","OUI","OUI","OUI","OUI","OUI","OUI","OUI","OUI","OUI","OUI"]
["Qté commandée"]
["Livraison",null,30000]
["Stock Virtuel Fin",64000,34000,-36000,-156000,-276000,-396000,-516000,-636000,-746000,-856000,-986000,-1116000]
["Stock Fin",64000,64000,-36000,-156000,-276000,-396000,-516000,-636000,-746000,-856000,-986000,-1116000]
[]
[]
[null,null,null,"METHODE D'APPRO? PERIODIQUE, Qté fixe, … + Stock sécu? + …. "]
[]
["Plan de PRODUCTION 454g et 907g (adéquation charge/capacité)"]
[null,"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
["Production (pph)",40000,30000,100000,120000,120000,120000,120000,120000,110000,110000,130000,130000]
["Production cumulée",40000,70000,170000,290000,410000,530000,650000,770000,880000,990000,1120000,1250000]
["Effectifs ",20,20,20,24,24,24,24,24,24,24,24,24]
["Heures sup",0,0,0,0,0,0,0,0,0,0,2,2]
["Coût heure supp",0,0,0,0,0,0,0,0,0,0,7500,7500,15000]
["Capacites (pph)",100000,100000,100000,120000,120000,120000,120000,120000,120000,120000,130000,130000]
["Capacité cumulée",100000,200000,300000,420000,540000,660000,780000,900000,1020000,1140000,1270000,1400000]
["Coût embauche","-","-","-",4000,"-","-","-","-","-","-","-","-",4000]
["Coût liscenciement",0,"-","-","-","-","-","-","-","-","-","-","-",0]
["Pénalité PPH transformé",6000,7000,"-","-","-","-","-","-",1000,1000,"-","-",15000]
["Pénalité prod 454g","-","-","-","-","-","-","-","-","-","-","-","-",0]
["Coût stockage 454g",7.32,242.8,219.4,2432.7200000000003,2970,1770.64,382.96000000000004,111.08,"-",576.6800000000001,691.5600000000001,21,9426.16]
["Coût rupture 454g","-","-","-","-","-","-","-","-",83.15,"-","-","-",83.15]
["Coût de production 454g",10000,15000,20000,50000,40000,30000,30000,40000,25000,35000,35000,35000,365000]
["Pénalité prod 907g","-","-","-","-","-","-","-","-","-","-","-","-",0]
["Coût stockage 907g",499.62,6.96,831.48,561.72,388.08,336.9,176.51999999999998,"-",174.48,223.32,468.59999999999997,298.86,3966.5400000000004]
["Coût rupture 907g","-","-","-","-","-","-","-",1040.1,"-","-","-","-",1040.1]
["Coût production 907g",10000,0,30000,10000,20000,30000,30000,20000,30000,20000,30000,30000,260000]
[{"$nulls":12},"Coût global",673515.95]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}