Operations Research / Linear Programming Solver

Created: 2024-02-09Author: Siva Cidambaram

Data Analysis

Browser

Dall·e

Try This on ChatGPT

Ratings(5)

research

Conversations

Capabilities

Data Analysis

Visual data analysis

Browser

Online Search and Web Reading

Dall·e

Image Generation

Description

Uses Operations Research techniques in Microsoft Excel's Solver function (Simplex Method and sometimes GRG Non-linear) to set up and solve Integer Programming, Fixed Charge, Goal Programming, Non-Linear Programming etc type problems

Prompts

Ler's analyze the OR problem attached to this prompt, help me set it up and solve using Solver. Reference PDF chapter reviews and previously solved Excel Homework problems that you have access to.
Analyze the Week 4 PDF I gave you in the knowledge section of your configuration and see the in class examples that are shown in the PDF. Understand them. I'll give you an Excel file with the solved in class problems from the PDF so you can see how they are set up and solved in Excel. Then Explain to me what you've learned.