Seeds Inc. is a company that produces and exports bags of corn seeds. For this purpose,...

  

Transcribed Image Text:

Seeds Inc. is a company that produces and exports bags of corn seeds. For this purpose, the company has a production plant in the state of Oklahoma, in which the company processes corn of two varieties: Hard and Serrated. To make the seed bags, the plant uses three resources: water, electricity, and gas. The following table provides the basic data of the problem: Serrated (units of Maximum monthly Hard (units of resources per bag of seeds) availability (units of Liters, kWh, and cm, respectively) 810.50 655.80 520.75 Resource raw resources per bag of seeds) Water Electricity Gas 100.05 60.75 5.50 10.25 75.30 24.84 Profit per seed bag $275.75 $120.50 In this way, Seeds Inc. produces bags of seeds for both varieties of corn that it processes (i.e., hard corn seeds and serrated corn seeds). Given that Seeds Inc. is so famous and respected, the demand for her seed bags is always very high, so they always sell all the seed bags they produce, and they cand produce fractional numbers of seed bags (i.e., 7.22 bag of hard corn seed bags). You want to determine the production plan that retrieves Seeds Inc.'s profit. To do this, first you decide to formulate this problem as an LP model. In particular: a. (5 points) Define the decision variables for this problem. What is its gradient? b. (15 points) Plot the gradient and the feasible region (clearly indicating all the constraints and "shading" the feasible region). c. (5 points) Solve this problem using the graphical method. Indicate the values of all the variables and the objective function associated with the optimal solution. d. (10 points) Solve the problem using Excel Solver and indicate the values of all the variables and the objective function associated with the optimal solution. Compare your results with part c. Include a snapshot of your Excel model (Excel cells and the Solver window). e. (15 points) Solve the problem using Gurobi/Python. Compare your results with parts c and d. Include a snapshot of your Gurobi/Python code and obtained results. Seeds Inc. is a company that produces and exports bags of corn seeds. For this purpose, the company has a production plant in the state of Oklahoma, in which the company processes corn of two varieties: Hard and Serrated. To make the seed bags, the plant uses three resources: water, electricity, and gas. The following table provides the basic data of the problem: Serrated (units of Maximum monthly Hard (units of resources per bag of seeds) availability (units of Liters, kWh, and cm, respectively) 810.50 655.80 520.75 Resource raw resources per bag of seeds) Water Electricity Gas 100.05 60.75 5.50 10.25 75.30 24.84 Profit per seed bag $275.75 $120.50 In this way, Seeds Inc. produces bags of seeds for both varieties of corn that it processes (i.e., hard corn seeds and serrated corn seeds). Given that Seeds Inc. is so famous and respected, the demand for her seed bags is always very high, so they always sell all the seed bags they produce, and they cand produce fractional numbers of seed bags (i.e., 7.22 bag of hard corn seed bags). You want to determine the production plan that retrieves Seeds Inc.'s profit. To do this, first you decide to formulate this problem as an LP model. In particular: a. (5 points) Define the decision variables for this problem. What is its gradient? b. (15 points) Plot the gradient and the feasible region (clearly indicating all the constraints and "shading" the feasible region). c. (5 points) Solve this problem using the graphical method. Indicate the values of all the variables and the objective function associated with the optimal solution. d. (10 points) Solve the problem using Excel Solver and indicate the values of all the variables and the objective function associated with the optimal solution. Compare your results with part c. Include a snapshot of your Excel model (Excel cells and the Solver window). e. (15 points) Solve the problem using Gurobi/Python. Compare your results with parts c and d. Include a snapshot of your Gurobi/Python code and obtained results. Seeds Inc. is a company that produces and exports bags of corn seeds. For this purpose, the company has a production plant in the state of Oklahoma, in which the company processes corn of two varieties: Hard and Serrated. To make the seed bags, the plant uses three resources: water, electricity, and gas. The following table provides the basic data of the problem: Serrated (units of Maximum monthly Hard (units of resources per bag of seeds) availability (units of Liters, kWh, and cm, respectively) 810.50 655.80 520.75 Resource raw resources per bag of seeds) Water Electricity Gas 100.05 60.75 5.50 10.25 75.30 24.84 Profit per seed bag $275.75 $120.50 In this way, Seeds Inc. produces bags of seeds for both varieties of corn that it processes (i.e., hard corn seeds and serrated corn seeds). Given that Seeds Inc. is so famous and respected, the demand for her seed bags is always very high, so they always sell all the seed bags they produce, and they cand produce fractional numbers of seed bags (i.e., 7.22 bag of hard corn seed bags). You want to determine the production plan that retrieves Seeds Inc.'s profit. To do this, first you decide to formulate this problem as an LP model. In particular: a. (5 points) Define the decision variables for this problem. What is its gradient? b. (15 points) Plot the gradient and the feasible region (clearly indicating all the constraints and "shading" the feasible region). c. (5 points) Solve this problem using the graphical method. Indicate the values of all the variables and the objective function associated with the optimal solution. d. (10 points) Solve the problem using Excel Solver and indicate the values of all the variables and the objective function associated with the optimal solution. Compare your results with part c. Include a snapshot of your Excel model (Excel cells and the Solver window). e. (15 points) Solve the problem using Gurobi/Python. Compare your results with parts c and d. Include a snapshot of your Gurobi/Python code and obtained results. Seeds Inc. is a company that produces and exports bags of corn seeds. For this purpose, the company has a production plant in the state of Oklahoma, in which the company processes corn of two varieties: Hard and Serrated. To make the seed bags, the plant uses three resources: water, electricity, and gas. The following table provides the basic data of the problem: Serrated (units of Maximum monthly Hard (units of resources per bag of seeds) availability (units of Liters, kWh, and cm, respectively) 810.50 655.80 520.75 Resource raw resources per bag of seeds) Water Electricity Gas 100.05 60.75 5.50 10.25 75.30 24.84 Profit per seed bag $275.75 $120.50 In this way, Seeds Inc. produces bags of seeds for both varieties of corn that it processes (i.e., hard corn seeds and serrated corn seeds). Given that Seeds Inc. is so famous and respected, the demand for her seed bags is always very high, so they always sell all the seed bags they produce, and they cand produce fractional numbers of seed bags (i.e., 7.22 bag of hard corn seed bags). You want to determine the production plan that retrieves Seeds Inc.'s profit. To do this, first you decide to formulate this problem as an LP model. In particular: a. (5 points) Define the decision variables for this problem. What is its gradient? b. (15 points) Plot the gradient and the feasible region (clearly indicating all the constraints and "shading" the feasible region). c. (5 points) Solve this problem using the graphical method. Indicate the values of all the variables and the objective function associated with the optimal solution. d. (10 points) Solve the problem using Excel Solver and indicate the values of all the variables and the objective function associated with the optimal solution. Compare your results with part c. Include a snapshot of your Excel model (Excel cells and the Solver window). e. (15 points) Solve the problem using Gurobi/Python. Compare your results with parts c and d. Include a snapshot of your Gurobi/Python code and obtained results. Seeds Inc. is a company that produces and exports bags of corn seeds. For this purpose, the company has a production plant in the state of Oklahoma, in which the company processes corn of two varieties: Hard and Serrated. To make the seed bags, the plant uses three resources: water, electricity, and gas. The following table provides the basic data of the problem: Serrated (units of Maximum monthly Hard (units of resources per bag of seeds) availability (units of Liters, kWh, and cm, respectively) 810.50 655.80 520.75 Resource raw resources per bag of seeds) Water Electricity Gas 100.05 60.75 5.50 10.25 75.30 24.84 Profit per seed bag $275.75 $120.50 In this way, Seeds Inc. produces bags of seeds for both varieties of corn that it processes (i.e., hard corn seeds and serrated corn seeds). Given that Seeds Inc. is so famous and respected, the demand for her seed bags is always very high, so they always sell all the seed bags they produce, and they cand produce fractional numbers of seed bags (i.e., 7.22 bag of hard corn seed bags). You want to determine the production plan that retrieves Seeds Inc.'s profit. To do this, first you decide to formulate this problem as an LP model. In particular: a. (5 points) Define the decision variables for this problem. What is its gradient? b. (15 points) Plot the gradient and the feasible region (clearly indicating all the constraints and "shading" the feasible region). c. (5 points) Solve this problem using the graphical method. Indicate the values of all the variables and the objective function associated with the optimal solution. d. (10 points) Solve the problem using Excel Solver and indicate the values of all the variables and the objective function associated with the optimal solution. Compare your results with part c. Include a snapshot of your Excel model (Excel cells and the Solver window). e. (15 points) Solve the problem using Gurobi/Python. Compare your results with parts c and d. Include a snapshot of your Gurobi/Python code and obtained results. Seeds Inc. is a company that produces and exports bags of corn seeds. For this purpose, the company has a production plant in the state of Oklahoma, in which the company processes corn of two varieties: Hard and Serrated. To make the seed bags, the plant uses three resources: water, electricity, and gas. The following table provides the basic data of the problem: Serrated (units of Maximum monthly Hard (units of resources per bag of seeds) availability (units of Liters, kWh, and cm, respectively) 810.50 655.80 520.75 Resource raw resources per bag of seeds) Water Electricity Gas 100.05 60.75 5.50 10.25 75.30 24.84 Profit per seed bag $275.75 $120.50 In this way, Seeds Inc. produces bags of seeds for both varieties of corn that it processes (i.e., hard corn seeds and serrated corn seeds). Given that Seeds Inc. is so famous and respected, the demand for her seed bags is always very high, so they always sell all the seed bags they produce, and they cand produce fractional numbers of seed bags (i.e., 7.22 bag of hard corn seed bags). You want to determine the production plan that retrieves Seeds Inc.'s profit. To do this, first you decide to formulate this problem as an LP model. In particular: a. (5 points) Define the decision variables for this problem. What is its gradient? b. (15 points) Plot the gradient and the feasible region (clearly indicating all the constraints and "shading" the feasible region). c. (5 points) Solve this problem using the graphical method. Indicate the values of all the variables and the objective function associated with the optimal solution. d. (10 points) Solve the problem using Excel Solver and indicate the values of all the variables and the objective function associated with the optimal solution. Compare your results with part c. Include a snapshot of your Excel model (Excel cells and the Solver window). e. (15 points) Solve the problem using Gurobi/Python. Compare your results with parts c and d. Include a snapshot of your Gurobi/Python code and obtained results.

Answer rating: 100% (QA)

a First we need to define the decision variables Let H be the numbe... View the full answer