Hello, I am having trouble solving for a case study of questions using Solver Add-in in Excel for Pioneer Hi-Bred

Question

Here is the prompt:

Solve for the optimal plant, area, and market production plan based on current demand as outlined in the case and supporting data file. Your final solution should include 3 numbers: the optimal minimum transportation cost, production cost, and total cost of operation.

Your submission should include a PDF/Word file specifying the optimal costs at the top and any context to your solver model (e.g., what constraints you used and from which exhibit), as well as an excel file showing your solver solution solution. I can share the excel data set if easier.

Answer 1

Hello Rodrigo, here is a step by step guide which you can use to approach and solve the Excel Solver case study:

1. Set up the Excel model by organizing the data and identifying the key variables
2. Define the objective function to minimize or maximize
3. Determine the relevant constraints based on the case study requirements
4. Use the Solver Add-in to find the optimal solution
5. Interpret the Solver results and document your work