excel-solver

Excel tools and VBA snippets for focused business tasks

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

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

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

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.

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

Comparing and solving transportation cost optimization problems using linear programming

This repository s to show my personal project on process design

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.

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

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

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

WSQ courseware for TGS-2023036656: linear programming, decision analysis and resource optimisation with eight Excel labs.

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.

Optimizing Toronto warming centre staffing and capacity using Excel Solver, Python simulation, and Monte Carlo stress testing.

🏭 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.

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

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