{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Answer Report 1","Sensitivity Report 1","Modèle"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":56,"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":"Answer Report 1","index":0,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Microsoft Excel 11.0 Answer Report"]
["Worksheet: [base14.xls]Modèle"]
["Report Created: 06.02.2006 09:03:16"]
[]
[]
["Target Cell (Max)"]
[null,"Cell","Name","Original Value","Final Value"]
[null,"$C$74","Bénéfice Total Gamay",0,1359710]
[]
[]
["Adjustable Cells"]
[null,"Cell","Name","Original Value","Final Value"]
[null,"$C$46","Quantité mise en bouteille pour vente directe: Gamay",0,12000]
[null,"$D$46","Quantité mise en bouteille pour vente directe: Pinot noir",0,7800]
[null,"$E$46","Quantité mise en bouteille pour vente directe: Syrah",0,8900]
[null,"$F$46","Quantité mise en bouteille pour vente directe: Cornalin",0,1700]
[null,"$G$46","Quantité mise en bouteille pour vente directe: Dôle blanche",0,12000]
[null,"$H$46","Quantité mise en bouteille pour vente directe: Antarès",0,13000]
[null,"$I$46","Quantité mise en bouteille pour vente directe: Douceur capricieuse",0,13000]
[null,"$J$46","Quantité mise en bouteille pour vente directe: A. rouge,  Gally",0,8000]
[null,"$C$50","Quanitité mise en bouteille pour grossite: Gamay",0,600]
[null,"$D$50","Quanitité mise en bouteille pour grossite: Pinot noir",0,0]
[null,"$E$50","Quanitité mise en bouteille pour grossite: Syrah",0,0]
[null,"$F$50","Quanitité mise en bouteille pour grossite: Cornalin",0,0]
[null,"$G$50","Quanitité mise en bouteille pour grossite: Dôle blanche",0,0]
[null,"$H$50","Quanitité mise en bouteille pour grossite: Antarès",0,0]
[null,"$I$50","Quanitité mise en bouteille pour grossite: Douceur capricieuse",0,0]
[null,"$J$50","Quanitité mise en bouteille pour grossite: A. rouge,  Gally",0,0]
[null,"$C$16","Ressources supplémentaires achetées: R_Gamay",0,0]
[null,"$D$16","Ressources supplémentaires achetées: R_Pinot noir",0,0]
[null,"$E$16","Ressources supplémentaires achetées: R_Syrah",0,0]
[null,"$F$16","Ressources supplémentaires achetées: R_Cornalin",0,2000]
[]
[]
["Constraints"]
[null,"Cell","Name","Cell Value","Formula","Status","Slack"]
[null,"$C$14","Ressources totales utilisées - achats: R_Gamay",24000,"$C$14<=$C$11","Binding",0]
[null,"$D$14","Ressources totales utilisées - achats: R_Pinot noir",23000,"$D$14<=$D$11","Binding",0]
[null,"$E$14","Ressources totales utilisées - achats: R_Syrah",18000,"$E$14<=$E$11","Binding",0]
[null,"$F$14","Ressources totales utilisées - achats: R_Cornalin",10000,"$F$14<=$F$11","Binding",0]
[null,"$H$16","litres Somme des achats",2000,"$H$16<=$J$16","Binding",0]
[null,"$C$45","Gamay",12000,"$C$45<=$C$42","Binding",0]
[null,"$D$45","Pinot noir",7800,"$D$45<=$D$42","Not Binding",8200]
[null,"$E$45","Syrah",8900,"$E$45<=$E$42","Not Binding",3100]
[null,"$F$45","Cornalin",1700,"$F$45<=$F$42","Not Binding",4300]
[null,"$G$45","Dôle blanche",12000,"$G$45<=$G$42","Binding",0]
[null,"$H$45","Antarès",13000,"$H$45<=$H$42","Binding",0]
[null,"$I$45","Douceur capricieuse",13000,"$I$45<=$I$42","Binding",0]
[null,"$J$45","A. rouge,  Gally",8000,"$J$45<=$J$42","Binding",0]
[null,"$C$46","Quantité mise en bouteille pour vente directe: Gamay",12000,"$C$46>=0","Not Binding",12000]
[null,"$D$46","Quantité mise en bouteille pour vente directe: Pinot noir",7800,"$D$46>=0","Not Binding",7800]
[null,"$E$46","Quantité mise en bouteille pour vente directe: Syrah",8900,"$E$46>=0","Not Binding",8900]
[null,"$F$46","Quantité mise en bouteille pour vente directe: Cornalin",1700,"$F$46>=0","Not Binding",1700]
[null,"$G$46","Quantité mise en bouteille pour vente directe: Dôle blanche",12000,"$G$46>=0","Not Binding",12000]
[null,"$H$46","Quantité mise en bouteille pour vente directe: Antarès",13000,"$H$46>=0","Not Binding",13000]
[null,"$I$46","Quantité mise en bouteille pour vente directe: Douceur capricieuse",13000,"$I$46>=0","Not Binding",13000]
[null,"$J$46","Quantité mise en bouteille pour vente directe: A. rouge,  Gally",8000,"$J$46>=0","Not Binding",8000]
[null,"$C$16","Ressources supplémentaires achetées: R_Gamay",0,"$C$16>=0","Binding",0]
[null,"$D$16","Ressources supplémentaires achetées: R_Pinot noir",0,"$D$16>=0","Binding",0]
[null,"$E$16","Ressources supplémentaires achetées: R_Syrah",0,"$E$16>=0","Binding",0]
[null,"$F$16","Ressources supplémentaires achetées: R_Cornalin",2000,"$F$16>=0","Not Binding",2000]
[null,"$C$50","Quanitité mise en bouteille pour grossite: Gamay",600,"$C$50>=0","Not Binding",600]
[null,"$D$50","Quanitité mise en bouteille pour grossite: Pinot noir",0,"$D$50>=0","Binding",0]
[null,"$E$50","Quanitité mise en bouteille pour grossite: Syrah",0,"$E$50>=0","Binding",0]
[null,"$F$50","Quanitité mise en bouteille pour grossite: Cornalin",0,"$F$50>=0","Binding",0]
[null,"$G$50","Quanitité mise en bouteille pour grossite: Dôle blanche",0,"$G$50>=0","Binding",0]
[null,"$H$50","Quanitité mise en bouteille pour grossite: Antarès",0,"$H$50>=0","Binding",0]
[null,"$I$50","Quanitité mise en bouteille pour grossite: Douceur capricieuse",0,"$I$50>=0","Binding",0]
[null,"$J$50","Quanitité mise en bouteille pour grossite: A. rouge,  Gally",0,"$J$50>=0","Binding",0]

{"sheet":"Sensitivity Report 1","index":1,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Microsoft Excel 11.0 Sensitivity Report"]
["Worksheet: [base14.xls]Modèle"]
["Report Created: 06.02.2006 09:03:16"]
[]
[]
["Adjustable Cells"]
[null,null,null,"Final","Reduced","Objective","Allowable","Allowable"]
[null,"Cell","Name","Value","Cost","Coefficient","Increase","Decrease"]
[null,"$C$46","Quantité mise en bouteille pour vente directe: Gamay",12000,0,11.3,1e+30,2.7]
[null,"$D$46","Quantité mise en bouteille pour vente directe: Pinot noir",7800,0,16.6,3.7999999999999927,1.7]
[null,"$E$46","Quantité mise en bouteille pour vente directe: Syrah",8900,0,19.2,3.7999999999999927,4.4]
[null,"$F$46","Quantité mise en bouteille pour vente directe: Cornalin",1700,0,23.9,4.212499999999987,2.5375000000000116]
[null,"$G$46","Quantité mise en bouteille pour vente directe: Dôle blanche",12000,0,14.42,1e+30,2.62]
[null,"$H$46","Quantité mise en bouteille pour vente directe: Antarès",13000,0,20.62,1e+30,1.52]
[null,"$I$46","Quantité mise en bouteille pour vente directe: Douceur capricieuse",13000,0,19.06,1e+30,2.549999999999994]
[null,"$J$46","Quantité mise en bouteille pour vente directe: A. rouge,  Gally",8000,0,24.21,1e+30,3.369999999999991]
[null,"$C$50","Quanitité mise en bouteille pour grossite: Gamay",600,0,8.6,2.7,1.1333333333333357]
[null,"$D$50","Quanitité mise en bouteille pour grossite: Pinot noir",0,-3.8,12.8,3.8,1e+30]
[null,"$E$50","Quanitité mise en bouteille pour grossite: Syrah",0,-4.4,14.8,4.4,1e+30]
[null,"$F$50","Quanitité mise en bouteille pour grossite: Cornalin",0,-5.35,18.55,5.35,1e+30]
[null,"$G$50","Quanitité mise en bouteille pour grossite: Dôle blanche",0,-0.6800000000000015,11.12,0.6800000000000015,1e+30]
[null,"$H$50","Quanitité mise en bouteille pour grossite: Antarès",0,-3.13,15.97,3.13,1e+30]
[null,"$I$50","Quanitité mise en bouteille pour grossite: Douceur capricieuse",0,-1.75,14.76,1.75,1e+30]
[null,"$J$50","Quanitité mise en bouteille pour grossite: A. rouge,  Gally",0,-2.03000000000001,18.81,2.03000000000001,1e+30]
[null,"$C$16","Ressources supplémentaires achetées: R_Gamay",0,-14.5,-1.5,14.5,1e+30]
[null,"$D$16","Ressources supplémentaires achetées: R_Pinot noir",0,-6.6,-1.6,6.6,1e+30]
[null,"$E$16","Ressources supplémentaires achetées: R_Syrah",0,-4.3,-1.9,4.3,1e+30]
[null,"$F$16","Ressources supplémentaires achetées: R_Cornalin",2000,0,-2.3,1e+30,4.3]
[]
["Constraints"]
[null,null,null,"Final","Shadow","Constraint","Allowable","Allowable"]
[null,"Cell","Name","Value","Price","R.H. Side","Increase","Decrease"]
[null,"$C$14","Ressources totales utilisées - achats: R_Gamay",24000,8.6,24000,1e+30,600]
[null,"$D$14","Ressources totales utilisées - achats: R_Pinot noir",23000,16.6,23000,8200,7799.999999999994]
[null,"$E$14","Ressources totales utilisées - achats: R_Syrah",18000,19.2,18000,3100,8900]
[null,"$F$14","Ressources totales utilisées - achats: R_Cornalin",10000,23.9,10000,4300,1700]
[null,"$H$16","litres Somme des achats",2000,21.6,2000,4300,1700]
[null,"$C$45","Gamay",12000,2.7,12000,600,12000]
[null,"$D$45","Pinot noir",7800,0,16000,1e+30,8200]
[null,"$E$45","Syrah",8900,0,12000,1e+30,3100]
[null,"$F$45","Cornalin",1700,0,6000,1e+30,4300]
[null,"$G$45","Dôle blanche",12000,2.62,12000,1000,12000]
[null,"$H$45","Antarès",13000,1.52,13000,8499.99999999998,7750]
[null,"$I$45","Douceur capricieuse",13000,2.5499999999999945,13000,3000,10333.333333333341]
[null,"$J$45","A. rouge,  Gally",8000,3.3699999999999917,8000,2125,5375]

{"sheet":"Modèle","index":2,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[39,2,39,5],[39,6,39,9],[21,12,21,16],[26,2,26,5],[26,6,26,9],[33,2,33,5],[33,6,33,9],[59,2,59,5],[59,6,59,9],[53,2,53,5],[53,6,53,9]],"flags":["formulas_cached_only"]}
["Groupe A05 www.fritscher.ch/hec"]
["Optimisation du choix de la production de cépages et d’assemblages de vins."]
[]
["Ressources:"]
[null,null,"R_Gamay","R_Pinot noir","R_Syrah","R_Cornalin"]
["Contrainte légale de production:",null,0.8,0.8,0.8,0.6,"litre / m2 de vignes"]
["Surface de vignes",null,30000,40000,30000,20000,"m2"]
["Quantités produites maximales autorisées:",null,24000,32000,24000,12000,"litres"]
[null,null,">=",">=",">=",">=","contrainte légale, non incluse par le solveur"]
[null,null,"R_Gamay","R_Pinot noir","R_Syrah","R_Cornalin"]
["Récolte (ressources disponibles):",null,24000,23000,18000,10000,"litres"]
[null,null,">=",">=",">=",">="]
[null,null,"R_Gamay","R_Pinot noir","R_Syrah","R_Cornalin"]
["Ressources totales utilisées - achats:",null,24000,23000,18000,10000,"litres"]
[null,null,"R_Gamay","R_Pinot noir","R_Syrah","R_Cornalin",null,"Somme des achats",null,"limite légale"]
["Ressources supplémentaires achetées:",null,0,0,0,2000,"litres",2000,"<=",2000,"litres"]
[null,null,"R_Gamay","R_Pinot noir","R_Syrah","R_Cornalin"]
["Quantité totale à disposition:",null,24000,23000,18000,12000,"litres"]
[]
["Matrice de production (assemblage constitué de cépage):"]
[null,"assemblages \\ cépages","Gamay","Pinot noir","Syrah","Cornalin","Somme"]
[null,"Dôle blanche",0.6,0.4,0,0,1]
[null,"Antarès",0,0.4,0.4,0.2,1]
[null,"Douceur capricieuse",0.2,0.4,0.3,0.1,1.0000000000000002]
[null,"A. rouge,  Gally",0.2,0,0,0.8,1]
[]
["Coût au litre:",null,"cépages",null,null,null,"assemblages"]
[null,null,"Gamay","Pinot noir","Syrah","Cornalin","Dôle blanche","Antarès","Douceur capricieuse","A. rouge,  Gally"]
[null,null,2.2,2.4,2.8,3,2.2800000000000002,2.68,2.54,2.8400000000000003,"Frs / litres"]
[]
[null,null,"Gamay","Pinot noir","Syrah","Cornalin"]
["Coût d'achat de cépage",null,1.5,1.6,1.9,2.3,"Frs /litres"]
[{"$nulls":5}," "]
["Prix de vente par litre:",null,"cépages",null,null,null,"assemblages"]
[null,null,"Gamay","Pinot noir","Syrah","Cornalin","Dôle blanche","Antarès","Douceur capricieuse","A. rouge,  Gally"]
[null,"Vente directe par le vigneron",13.5,19,22,26.9,16.7,23.3,21.599999999999998,27.05,"Frs / litres"]
[null,"Majoration prix assemblage:",{"$nulls":4},1,1.5,2,2.8,"Frs / litres"]
[null,"Vente au grossiste (-20% du PV)",10.8,15.2,17.6,21.549999999999997,13.399999999999999,18.65,17.3,21.65,"Frs / litres"]
[]
["Demande en litres:",null,"cépages",null,null,null,"assemblages"]
[null,null,"Gamay","Pinot noir","Syrah","Cornalin","Dôle blanche","Antarès","Douceur capricieuse","A. rouge,  Gally"]
[null,null,12000,16000,12000,6000,12000,13000,13000,8000,"litres"]
[null,null,">=",">=",">=",">=",">=",">=",">=",">="]
[null,null,"Gamay","Pinot noir","Syrah","Cornalin","Dôle blanche","Antarès","Douceur capricieuse","A. rouge,  Gally"]
[null,null,12000,7800,8900,1700,12000,13000,13000,8000]
["Quantité mise en bouteille pour vente directe:",null,12000,7800,8900,1700,12000,13000,13000,8000,"litres"]
[null,null,"Gamay","Pinot noir","Syrah","Cornalin"]
["Utilisation cépage pour assemblage (directe):",null,11400,15200,9100,10300,"litres"]
[null,null,"Gamay","Pinot noir","Syrah","Cornalin","Dôle blanche","Antarès","Douceur capricieuse","A. rouge,  Gally"]
["Quanitité mise en bouteille pour grossite:",null,600,0,0,0,0,0,0,0,"litres"]
[null,null,"Gamay","Pinot noir","Syrah","Cornalin"]
["Utilisation cépage pour assemblage (grossiste):",null,0,0,0,0,"litres"]
[]
["Bilan détaillé (vente directe):",null,"cépages",null,null,null,"assemblages"]
[null,null,"Gamay","Pinot noir","Syrah","Cornalin","Dôle blanche","Antarès","Douceur capricieuse","A. rouge,  Gally"]
[null,"Chiffre d'affaire",162000,148200,195800,45730,200400,302900,280800,216400,"Frs"]
[null,"Coûts totaux",26400.000000000004,18720,24920,5100,27360.000000000004,34840,33020,22720.000000000004,"Frs"]
[null,"Bénéfice",135600,129480,170880,40630,173040,268060,247780,193680,"Frs"]
[]
["Bilan détaillé (vente grossiste):",null,"cépages",null,null,null,"assemblages"]
[null,null,"Gamay","Pinot noir","Syrah","Cornalin","Dôle blanche","Antarès","Douceur capricieuse","A. rouge,  Gally"]
[null,"Chiffre d'affaire",6480,0,0,0,0,0,0,0,"Frs"]
[null,"Coûts totaux",1320,0,0,0,0,0,0,0,"Frs"]
[null,"Bénéfice",5160,0,0,0,0,0,0,0,"Frs"]
[]
["Bilan final:"]
[null,"Chiffre d'affaire ventes directes",1552230,"Frs"]
[null,"Coût totaux de production vente directe",-193080,"Frs"]
[null,"Bénéfice vente directe",1359150,"Frs"]
[null,"Chiffre d'affaire ventes aux grossistes",6480,"Frs"]
[null,"Coûts totaux production ventes aux grossistes",-1320,"Frs"]
[null,"Bénéfice de vente au grossiste",5160,"Frs"]
[null,"Coûts d'achat ressources supplémentaires",-4600,"Frs"]
[null,"Bénéfice Total",1359710,"Frs"]