Excel tools and VBA snippets for focused business tasks

This repository represents a comprehensive operations research case study at a steel production plant facility implementing aggregate production planning using Excel solver to minimise scrap generation across three specialised divisions.

Prescriptive analytics suite using Linear Programming (LPP) and Transportation modeling to minimize healthcare supply chain costs.

Comparing and solving transportation cost optimization problems using linear programming

Resolução de problemas de Pesquisa Operacional e Otimização Linear utilizando modelagem matemática no Excel Solver e no Software LINDO.

This repository s to show my personal project on process design

Operations research case study for feed mix cost optimization using linear programming and Excel Solver.

UNCW BAN 501 This course introduces students to the field of prescriptive analytics. Students will learn how to develop and use modeling techniques used extensively in the business world. Both mathematical and spreadsheet skills in MS Excel are utilized for performing optimization, simulation, and decision analysis techniques.

Linear-programming model in Excel Solver maximising stadium ticket revenue (£4.85M optimum) with shadow-price and ±sensitivity analysis.

Attached in this repository are Excel projects that range from Data Analytics to Optimization Models.

Hong Kong hotspots closed route simulator using traveling salesman problem model

Quantitative finance project applying Modern Portfolio Theory, CAPM, VaR, and GARCH volatility modeling for portfolio optimization and risk analysis.

This project uses Global Firepower Index dataset to explore India's potential in becoming a dominant force in global military power using Excel's What-If Analysis and Solver.

Researching and using evidence-based data to find optimal cost for a brain-supporting diet using linear programming

Utilizing Linear Programming through Excel Solver to optimize business strategy for maximum profit

Portfolio of operations analytics optimization models (LP, sensitivity, scenario analysis) built with Excel Solver.

Excel-based freight cost optimization model for Shanghai-Africa trade lanes. Uses Solver (Simplex LP) to minimize shipping costs across 15 route/carrier combinations.

🏭 A linear programming project using Excel Solver to optimize rug production for "Beirafio". Minimizes total cost by balancing in-house manufacturing and external suppliers. Developed for the OCD course at ISCTE.

A data-driven workforce restructuring project combining machine learning and optimization to predict employee attrition and design cost-efficient, legally compliant decision strategies.

LP crop-allocation model with Excel Solver + sensitivity reporting.