Can you make a report

1 Instructions for Case 2 Glove Company Case Bu SI EDELE D THE EU 1 2 1 GE T- 1 Instructions for Case Introduction: What is the case and what is the problem? Answers: Ench answer should have a paragraph that explains what the answer is and why it be the correct answer Ideas/Conclusion: Conclude your work with your ideas on case. (Put yourself on the shoes of Steve what would you do? Reference: Put every source you used in references even you did not use it for citations Appendix: Put every calculation that you did to solve questions to the appendix. Add crownshots of "Edit data" part and your gurobi codes of your case. Also do not forget to send your excel files, word for pdf) files and powerpoint files boy saving them with the surname and name of the group members. (For instance, if group members are Gene Simmons and Paul Stanley they will save their files as "Summons, General Stanley, Patul") Cost 130 150 2 Glovo Company Case Gloro is a Spanish quick-commorto start-up founded in Barerfona in 2015. It is an on-bmd courier service that purchases, picks up, and delivers products ordered through its mobile app. The company has 14 different regions to service, and 10 manager responsible from these regions. The budget and time requirement for each project we shown in below table. For example, time requiremeuts for region 1 is 280 hours and budget for region 7 850 (1000 TL Regkom 1 2 3 4 7 8 10 11 12 13 14 Timehow 320 20 250 280 000 180 340 150 270 150 3:20 470 250 Budget OT 750 1250 600 650 1250 700 850 1100 650 1300 1500 1100 1000 900 96 125 400 115 110 600 1:40 150 10 50 The hourly wage paid to the manager (it varies according to experience and competence), and the hours they can work per month are given in below table. Manager Hourly Wage Capacity (hor) 600 210 370 530 120 510 340 360 280 370 470 570 1 270 730 J 150 A B D E F 100 300 180 G H1 For all managers, their stritability for the region they can be signed are noted on a scale of 1-10 and it is shown in below talle. For example manager F give out of 10 for suitability of region 3. Region 1 2 3 4 5 6 7 8 9 10 11 12 13 14 AIS 8 2 8 6 10 1 +7 3 10 10 B 1 5 7 10 5 2 2 8 16 2 2 73 C 8 3 4 10 4 3 2 7 10 2 + 10 1 10 D1 32 10 975 68 2828 E 337 1 2 9 8 4 2 10 9 1 2 2 F. 144 1 3 10 5 2 10 10 2 7 10 10 G6 2 9 5 1 10 34 6 2 3 3 3 H 25 10 8 43 +385 296 16 8 2 1 69 659 2588 J3710 6 3 2 13 38 10 229 The company wants to determine how many hours each manager sboruld work on each region. Establish tive assignment model that will consider suitability for the region a) Write decision variatiken of twee and explain them in detail. You can see the example for definition of decision variabile Buy amount of brand purchased at the beginning of the time VjB-(Brand X. Brand Y). ic T-(Time 1. Time 2 Time 3) . b) Specify the clusters, Indoos, objective function and parameters. Rename them to be used in mathe mutical model and guro parts. (Please explain each parameters by wing its indexes, you can get luip from the Lab Hour excel documents) . c) Write a mathematical programming model of the case. There is an example for the part band cbelow. Claret Some Other Info D:Destination in Custom source Decision Ville Xumber of proportions de pomma Supply Chain demands the most products and de Objective function in re Const : . d) Please find bow many hours each tiger should work on each region by wing gurobi 1 Instructions for Case 2 Glove Company Case Bu SI EDELE D THE EU 1 2 1 GE T- 1 Instructions for Case Introduction: What is the case and what is the problem? Answers: Ench answer should have a paragraph that explains what the answer is and why it be the correct answer Ideas/Conclusion: Conclude your work with your ideas on case. (Put yourself on the shoes of Steve what would you do? Reference: Put every source you used in references even you did not use it for citations Appendix: Put every calculation that you did to solve questions to the appendix. Add crownshots of "Edit data" part and your gurobi codes of your case. Also do not forget to send your excel files, word for pdf) files and powerpoint files boy saving them with the surname and name of the group members. (For instance, if group members are Gene Simmons and Paul Stanley they will save their files as "Summons, General Stanley, Patul") Cost 130 150 2 Glovo Company Case Gloro is a Spanish quick-commorto start-up founded in Barerfona in 2015. It is an on-bmd courier service that purchases, picks up, and delivers products ordered through its mobile app. The company has 14 different regions to service, and 10 manager responsible from these regions. The budget and time requirement for each project we shown in below table. For example, time requiremeuts for region 1 is 280 hours and budget for region 7 850 (1000 TL Regkom 1 2 3 4 7 8 10 11 12 13 14 Timehow 320 20 250 280 000 180 340 150 270 150 3:20 470 250 Budget OT 750 1250 600 650 1250 700 850 1100 650 1300 1500 1100 1000 900 96 125 400 115 110 600 1:40 150 10 50 The hourly wage paid to the manager (it varies according to experience and competence), and the hours they can work per month are given in below table. Manager Hourly Wage Capacity (hor) 600 210 370 530 120 510 340 360 280 370 470 570 1 270 730 J 150 A B D E F 100 300 180 G H1 For all managers, their stritability for the region they can be signed are noted on a scale of 1-10 and it is shown in below talle. For example manager F give out of 10 for suitability of region 3. Region 1 2 3 4 5 6 7 8 9 10 11 12 13 14 AIS 8 2 8 6 10 1 +7 3 10 10 B 1 5 7 10 5 2 2 8 16 2 2 73 C 8 3 4 10 4 3 2 7 10 2 + 10 1 10 D1 32 10 975 68 2828 E 337 1 2 9 8 4 2 10 9 1 2 2 F. 144 1 3 10 5 2 10 10 2 7 10 10 G6 2 9 5 1 10 34 6 2 3 3 3 H 25 10 8 43 +385 296 16 8 2 1 69 659 2588 J3710 6 3 2 13 38 10 229 The company wants to determine how many hours each manager sboruld work on each region. Establish tive assignment model that will consider suitability for the region a) Write decision variatiken of twee and explain them in detail. You can see the example for definition of decision variabile Buy amount of brand purchased at the beginning of the time VjB-(Brand X. Brand Y). ic T-(Time 1. Time 2 Time 3) . b) Specify the clusters, Indoos, objective function and parameters. Rename them to be used in mathe mutical model and guro parts. (Please explain each parameters by wing its indexes, you can get luip from the Lab Hour excel documents) . c) Write a mathematical programming model of the case. There is an example for the part band cbelow. Claret Some Other Info D:Destination in Custom source Decision Ville Xumber of proportions de pomma Supply Chain demands the most products and de Objective function in re Const : . d) Please find bow many hours each tiger should work on each region by wing gurobi