Prescriptive Analytics Coursework - OPL & CPLEX

Optimization Modeling using IBM ILOG CPLEX Optimization Studio

This repository contains solutions to three real-world optimization problems solved using Optimization Programming Language (OPL) and CPLEX.

Projects Overview

Problem 1: Diet Formulation Problem

• Goal: Minimize cost of lunch meal while satisfying nutritional constraints for university football team.
• Optimal Cost: $2.8667 per serving
• Key Foods Used: Fried beans, Potatoes, Milk

Problem 2: Student-to-Project Assignment

• Goal: Assign 28 students to 8 projects (3–4 students per project) while minimizing total dissatisfaction (ranks).
• Total Rank Achieved: 35 (Very Good)
• Result: 19 students got their 1st choice, 25 got top-3 choices.

Problem 3: Shortest Path in Hospital Network

• Goal: Find the fastest walking time from Administration Block (Node 3) to Nightingale Ward (Node 8).
• Optimal Time: 64 minutes
• Path: 3 → 1 → 4 → 5 → 8

Technologies Used

• IBM CPLEX Optimization Studio
• OPL (Optimization Programming Language)
• Linear Programming & Integer Programming
• Excel integration for input/output

Repository Structure

• Each problem has separate folder with .mod (model) and .dat (data) files
• Clean separation of model and data
• Excel output generated via OPL scripting

Key Learnings

• Formulating real-world problems as Linear/Integer Programs
• Using duality for shortest path formulation
• Post-processing solutions with OPL scripting
• Converting mathematical models into business insights

Full detailed report available in Summary_Report.pdf

Made by Abeera Javed

---

⭐ Feel free to explore the models!