{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ABJouets","Prod. du jouet E exclusivement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":34,"comments":2,"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":"ABJouets","index":0,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"A","B","C","D","E","Disponible","Utilisé","Coût unitaire","Coût par produit"]
["Peint rouge",0,1,0,1,1,6250,{"$f":"B2*B$9+C2*C$9+D2*D$9+E2*E$9+F2*F$9","v":200},null,{"$f":"MonCoutPeinture(H2)","v":390}]
["Peint bleue",3,1,0,1,0,2500,0,null,{"$f":"MonCoutPeinture(H3)","v":0}]
["Peint blanche",2,1,2,0,1,1100,200,null,390]
["Plastique",1,0,2,2,1,875,200,8,{"$f":"I5*H5","v":1600}]
["Bois",3,2,3,5,4,1200,800,5,{"$f":"I6*H6","v":4000}]
["Colle",1,1,3,2,1,1500,200,9,{"$f":"I7*H7","v":1800}]
["Recette unitaire",175,100,100,114,250,null,null,null,{"$f":"SUM(J2:J7)","v":8180},"Coût total"]
["Production",0,0,0,0,200]
["Recette brute",{"$f":"B8*B9","v":0},{"$f":"C8*C9","v":0},{"$f":"D8*D9","v":0},{"$f":"E8*E9","v":0},{"$f":"F8*F9","v":50000}]
["Recette totale",{"$f":"SUM(B10:F10)","v":50000}]
[null,null,null,null,null,null,"Bénéfice",{"$f":"B11-J8","v":41820}]

{"sheet":"Prod. du jouet E exclusivement","index":1,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[16,3,16,7],[18,1,25,1]]}
[null,"A","B","C","D","E","Disponible","Utilisé","Coût unitaire","Coût par produit"]
["Peint rouge",0,1,0,1,1,6250,{"$f":"B2*B$9+C2*C$9+D2*D$9+E2*E$9+F2*F$9","v":300},null,{"$f":"MonCoutPeinture(H2)","v":600}]
["Peint bleue",3,1,0,1,0,2500,0,null,{"$f":"MonCoutPeinture(H3)","v":0}]
["Peint blanche",2,1,2,0,1,1100,300,null,600]
["Plastique",1,0,2,2,1,875,300,8,{"$f":"I5*H5","v":2400}]
["Bois",3,2,3,5,4,1200,1200,5,{"$f":"I6*H6","v":6000}]
["Colle",1,1,3,2,1,1500,300,9,{"$f":"I7*H7","v":2700}]
["Recette unitaire",175,100,100,114,250,null,null,null,{"$f":"SUM(J2:J7)","v":12300},"Coût total"]
["Production",0,0,0,0,300]
["Recette brute",{"$f":"B8*B9","v":0},{"$f":"C8*C9","v":0},{"$f":"D8*D9","v":0},{"$f":"E8*E9","v":0},{"$f":"F8*F9","v":75000}]
["Recette totale",{"$f":"SUM(B10:F10)","v":75000}]
[null,null,null,null,null,null,"Bénéfice",{"$f":"B11-J8","v":62700}]
[]
[]
[]
[null,"Question 4 - Table de simulation à deux entrées"]
[null,null,null,"Quantité de E à produire"]
[null,null,{"$f":"H12","v":62700},100,150,200,250,300]
[null,"Coût unitaire du bois",3,21740,32580,43420,54260,65100]
[null,null,4,21340,31980,42620,53260,63900]
[null,null,5,20940,31380,41820,52260,62700]
[null,null,6,20540,30780,41020,51260,61500]
[null,null,7,20140,30180,40220,50260,60300]
[null,null,8,19740,29580,39420,49260,59100]
[null,null,9,19340,28980,38620,48260,57900]
[null,null,10,18940,28380,37820,47260,56700]