學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
Solver in Excel and VBA
內容大綱
This note is an introduction to Solver in Excel and Visual Basic for Applications (VBA). Solver is a Microsoft Excel tool that determines variables and objective function values of linear, integer, binary, and non-linear optimization models. These models are used in insurance, finance, operations, logistics, engineering, and medicine. This note uses screenshots to help demonstrate various examples of the use of Solver, including assembling a portfolio of ideal stocks and assigning the location of fire stations in cities.