2 Codron Farm Case Melis Gn is a medium-sized farmer on his 500 decares of land in the north of Antalya. She has been in this market as a Codron Farn by expanding farm since 2018. It plans to plant wheat, barley, oats and rye in the coming season. The table below shows the estimated values for these products' yields, labor requirements, pre-harvest expenditures, water requirements other than rain, and sales prices. Estimated Revenue (kg/decares) Labor Requirement (hour/decares) Pre-harvest Expenditures (TL/decares) water requirements (ton/decares) Sales Price (TL/decares) Wheat Barley Oats Rye 525 750 150 600 1 1,25 0,75 2,5 18 28 11 22 5 15 2,5 10 0.18 0.39 0,215 0.155 Codron Form expect to produce at least 80 tons of wheat and 80 tons of barley. The demand of oat in market has been decreasing year by yner. Therefore, the maximum tons of ont to produce is 50 tons. The company is a budget of 16 thousand TL to spend on products throughout the year and will be able to work 9 hours a day during the 200-dny product development period. It will be able to provide a total of 5000 tons of water throughout the your from the irrigation cann. . a) Write decision variables of the case and explain them in detail. You can see the example for definition of decision variable. Big: amount of j broad purchased at the beginning of the i time Vje B={Brand X, Brand Y), i E T={Time 1, Time 2, Time 3) b) Specify the clusters, indexes, objective function and parameters. Rename them to be used in mathe matical model and gurobi parts. (Please explain each parameters by using its indexes, you can get help from the Lab Hour excel documents) . c) Write a mathematical programming model of the case. There is an example for the part band e below. Cluster (Set): S: Source Cities Cluster { Des Moines, Evansville, Fort Lauderdale) D: Destination Cities Cluster Albuquerque, Boston, Cleveland) Index: i: source type j: destination type Decision Variable: Xij: number of products transport from source i to destination Parameter: costij: unit cost of transportation from source i to destination supply : the amount of products source i produced amount of products demanded in destination i unit cost of transportation from source to destination] supply the amount of products source i produced demand; the amount of products demanded in destination) Mathematical Model: Objective Function: Min Exp cost i Constraints: xu e supply ties D xu = demands Vied Xij* . d) Please finds finds how muy decars of which crop should be planted in order to maxim expeted revenue of the company at the end of the harvest by using gurobi on excel 2 Codron Farm Case Melis Gn is a medium-sized farmer on his 500 decares of land in the north of Antalya. She has been in this market as a Codron Farn by expanding farm since 2018. It plans to plant wheat, barley, oats and rye in the coming season. The table below shows the estimated values for these products' yields, labor requirements, pre-harvest expenditures, water requirements other than rain, and sales prices. Estimated Revenue (kg/decares) Labor Requirement (hour/decares) Pre-harvest Expenditures (TL/decares) water requirements (ton/decares) Sales Price (TL/decares) Wheat Barley Oats Rye 525 750 150 600 1 1,25 0,75 2,5 18 28 11 22 5 15 2,5 10 0.18 0.39 0,215 0.155 Codron Form expect to produce at least 80 tons of wheat and 80 tons of barley. The demand of oat in market has been decreasing year by yner. Therefore, the maximum tons of ont to produce is 50 tons. The company is a budget of 16 thousand TL to spend on products throughout the year and will be able to work 9 hours a day during the 200-dny product development period. It will be able to provide a total of 5000 tons of water throughout the your from the irrigation cann. . a) Write decision variables of the case and explain them in detail. You can see the example for definition of decision variable. Big: amount of j broad purchased at the beginning of the i time Vje B={Brand X, Brand Y), i E T={Time 1, Time 2, Time 3) b) Specify the clusters, indexes, objective function and parameters. Rename them to be used in mathe matical model and gurobi parts. (Please explain each parameters by using its indexes, you can get help from the Lab Hour excel documents) . c) Write a mathematical programming model of the case. There is an example for the part band e below. Cluster (Set): S: Source Cities Cluster { Des Moines, Evansville, Fort Lauderdale) D: Destination Cities Cluster Albuquerque, Boston, Cleveland) Index: i: source type j: destination type Decision Variable: Xij: number of products transport from source i to destination Parameter: costij: unit cost of transportation from source i to destination supply : the amount of products source i produced amount of products demanded in destination i unit cost of transportation from source to destination] supply the amount of products source i produced demand; the amount of products demanded in destination) Mathematical Model: Objective Function: Min Exp cost i Constraints: xu e supply ties D xu = demands Vied Xij* . d) Please finds finds how muy decars of which crop should be planted in order to maxim expeted revenue of the company at the end of the harvest by using gurobi on excel