{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Questions 1 et 2","Question 3","Question 4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":73,"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":"Questions 1 et 2","index":0,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Matrice de production"]
[null,"Machine M1","Machine M2","Machine M3","Machine M4","Prix de vente","Production","CA"]
["Produit P1",1,6,5,2,{"$f":"81-G3*0.05","v":81},0,{"$f":"G3*F3","v":0}]
["Produit P2",1,8,3,1,{"$f":"90-G4*0.1","v":87.5},25.000000000000004,{"$f":"G4*F4","v":2187.5000000000005}]
["Produit P3",1,0,1,1,{"$f":"85-G5*0.1","v":77.5},75,{"$f":"G5*F5","v":5812.5}]
["Utilisation des machines",{"$f":"$G$3*B$3+$G$4*B$4+$G$5*B$5","v":100},{"$f":"$G$3*C$3+$G$4*C$4+$G$5*C$5","v":200.00000000000003},{"$f":"$G$3*D$3+$G$4*D$4+$G$5*D$5","v":150},{"$f":"SUMPRODUCT(E3:E5,G3:G5)","v":100},null,"Total CA",{"$f":"SUM(H3:H5)","v":8000}]
["Capacités",100,450,150,200]

{"sheet":"Question 3","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Matrice de production"]
[null,"Machine M1","Machine M2","Machine M3","Machine M4","Prix de vente","Production","CA"]
["Produit P1",1,6,5,2,{"$f":"81-G3*0.05","v":81},0,{"$f":"G3*F3","v":0}]
["Produit P2",1,8,3,1,{"$f":"90-G4*0.1","v":90},0,{"$f":"G4*F4","v":0}]
["Produit P3",1,0,1,1,{"$f":"85-G5*0.1","v":75},100,{"$f":"G5*F5","v":7500}]
["Utilisation des machines",{"$f":"$G$3*B$3+$G$4*B$4+$G$5*B$5","v":100},{"$f":"$G$3*C$3+$G$4*C$4+$G$5*C$5","v":0},{"$f":"$G$3*D$3+$G$4*D$4+$G$5*D$5","v":100},{"$f":"SUMPRODUCT(E3:E5,G3:G5)","v":100},null,"Total CA",{"$f":"SUM(H3:H5)","v":7500}]
["Capacités",100,450,150,200]
["Coût horaire d'utilisation",10,5,"-",6,"Total Cout"]
["Coût d'utilisation",{"$f":"B8*B6","v":1000},{"$f":"C8*C6","v":0},{"$f":"MonCoutM3(D6)","v":550},{"$f":"E8*E6","v":600},{"$f":"SUM(B9:E9)","v":2150}]
[]
[]
[null,null,null,null,null,null,"Bénéfice",{"$f":"H6-F9","v":5350}]

{"sheet":"Question 4","index":2,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Matrice de production",null,null,null,null,null,null,null,null,null,"M1","M2","M4","Bénéfice"]
[null,"Machine M1","Machine M2","Machine M3","Machine M4","Prix de vente","Production","CA",null,null,7,4,2,1920]
["Produit P1",1,6,5,2,{"$f":"81-G3*0.05","v":81},0,{"$f":"G3*F3","v":0},null,null,7,4,4,1800]
["Produit P2",1,8,3,1,{"$f":"90-G4*0.1","v":85.5},45,{"$f":"G4*F4","v":3847.5},null,null,7,4,6,1680]
["Produit P3",1,0,1,1,{"$f":"85-G5*0.1","v":83.5},15,{"$f":"G5*F5","v":1252.5},null,null,7,4,7,1620]
["Utilisation des machines",{"$f":"$G$3*B$3+$G$4*B$4+$G$5*B$5","v":60},{"$f":"$G$3*C$3+$G$4*C$4+$G$5*C$5","v":360},{"$f":"$G$3*D$3+$G$4*D$4+$G$5*D$5","v":150},{"$f":"SUMPRODUCT(E3:E5,G3:G5)","v":60},null,"Total CA",{"$f":"SUM(H3:H5)","v":5100},null,null,7,6,2,1200]
["Capacités",100,450,150,200,null,null,null,null,null,7,6,4,1080]
["Coût horaire d'utilisation",7,4,"-",4,"Total Cout",null,null,null,null,7,6,6,960]
["Coût d'utilisation",{"$f":"B8*B6","v":420},{"$f":"C8*C6","v":1440},{"$f":"MonCoutM3(D6)","v":1200},{"$f":"E8*E6","v":240},{"$f":"SUM(B9:E9)","v":3300},null,null,null,null,7,6,7,900]
[null,null,null,null,null,null,null,null,null,null,7,7,2,840]
[null,null,null,null,null,null,null,null,null,null,7,7,4,720]
[null,null,null,null,null,null,"Bénéfice",{"$f":"H6-F9","v":1800},null,null,7,7,6,600]
[null,null,null,null,null,null,null,null,null,null,7,7,7,540]
[null,null,null,null,null,null,null,null,null,null,11,4,2,1680]
[null,null,null,null,null,null,null,null,null,null,11,4,4,1560]
[null,null,null,null,null,null,null,null,null,null,11,4,6,1440]
[null,null,null,null,null,null,null,null,null,null,11,4,7,1380]
[null,null,null,null,null,null,null,null,null,null,11,6,2,960]
[null,null,null,null,null,null,null,null,null,null,11,6,4,840]
[null,null,null,null,null,null,null,null,null,null,11,6,6,720]
[null,null,null,null,null,null,null,null,null,null,11,6,7,660]
[null,null,null,null,null,null,null,null,null,null,11,7,2,600]
[null,null,null,null,null,null,null,null,null,null,11,7,4,480]
[null,null,null,null,null,null,null,null,null,null,11,7,6,360]
[null,null,null,null,null,null,null,null,null,null,11,7,7,300]
[null,null,null,null,null,null,null,null,null,null,13,4,2,1560]
[null,null,null,null,null,null,null,null,null,null,13,4,4,1440]
[null,null,null,null,null,null,null,null,null,null,13,4,6,1320]
[null,null,null,null,null,null,null,null,null,null,13,4,7,1260]
[null,null,null,null,null,null,null,null,null,null,13,6,2,840]
[null,null,null,null,null,null,null,null,null,null,13,6,4,720]
[null,null,null,null,null,null,null,null,null,null,13,6,6,600]
[null,null,null,null,null,null,null,null,null,null,13,6,7,540]
[null,null,null,null,null,null,null,null,null,null,13,7,2,480]
[null,null,null,null,null,null,null,null,null,null,13,7,4,360]
[null,null,null,null,null,null,null,null,null,null,13,7,6,240]
[null,null,null,null,null,null,null,null,null,null,13,7,7,180]
[null,null,null,null,null,null,null,null,null,null,18,4,2,1260]
[null,null,null,null,null,null,null,null,null,null,18,4,4,1140]
[null,null,null,null,null,null,null,null,null,null,18,4,6,1020]
[null,null,null,null,null,null,null,null,null,null,18,4,7,960]
[null,null,null,null,null,null,null,null,null,null,18,6,2,540]
[null,null,null,null,null,null,null,null,null,null,18,6,4,420]
[null,null,null,null,null,null,null,null,null,null,18,6,6,300]
[null,null,null,null,null,null,null,null,null,null,18,6,7,240]
[null,null,null,null,null,null,null,null,null,null,18,7,2,180]
[null,null,null,null,null,null,null,null,null,null,18,7,4,60]
[null,null,null,null,null,null,null,null,null,null,18,7,6,-60]
[null,null,null,null,null,null,null,null,null,null,18,7,7,-120]