{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Rasoirs Production"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"comments":1,"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":"Rasoirs Production","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,"Taux de change",70]
[]
["Prix de vente",150,null,null,"Prix local en Syldavie",{"$f":"$D$1*$B$3","v":10500}]
["Quantités produites",500,null,null,"Ventes",{"$f":"MonVolumeVente(F3,B4)","v":74.999999999999972},"Question 1 - Fonction MonVolumeVente"]
["Coûts fixes",3000,null,null,"Chiffre d'Affaires",{"$f":"F4*F3","v":787499.99999999965}]
["Coût variable",10]
[null,null,null,null,"Frais de transport unitaire",1000]
["Coût total de production",{"$f":"B5+B6*B4","v":8000},null,null,"Taux de taxe sur CA",0.1]
["Recette attendue",{"$f":"B3*B4","v":75000}]
["Benefice attendu",{"$f":"B9-B8","v":67000},null,null,"Frais de transport total",{"$f":"F7*F4","v":74999.999999999971}]
[null,null,null,null,"Valeur de la Taxe",{"$f":"F8*F5","v":78749.999999999971}]
[]
[null,null,null,null,"Bénéfice local",{"$f":"F5-F10-F11","v":633749.99999999965}]
[]
[null,null,"Bénéfice rappatrié",{"$f":"F13/$D$1","v":9053.5714285714239}]
[]
[null,null,"Invendus",{"$f":"B4-F4","v":425}]
[null,null,"Coût unitaire de stockage",1]
[]
[null,null,"Coûts",{"$f":"B8+D18*D17","v":8425}]
[]
[null,null,"Benefice net",{"$f":"D15-D20","v":628.57142857142389},"Question 2 - Pour les valeurs dans le sujet, le bénéfice net est de 628.57 €"]
[]
[]
[]
[]
[null,"Question 3 - Bénéfice net en fonction du taux de change",null,null,null,"Question 4 - Avec l'outil valeur cible : taux de change égal à 90.69937"]
[null,"Taux de change",{"$f":"D22","v":628.57142857142389}]
[null,50,17599.999999999996]
[null,60,9399.9999999999964]
[null,70,628.57142857142389]
[null,80,-8500]
[null,90,-8500]
[null,100,-8500]
[]
[null,{"$f":"MonTauxDeChange(B29:C34)","v":50},"Question 5 - Fonction MonTauxDeChange"]