Analytical Problem Solving with Spreadsheets

Analytical Problem Solving with Spreadsheets --- With the unprecedented progress in processing Big Data, all industries have started benefiting from analytics to produce quantitative information and make informed decisions. Which breweries should ship to which demand centers to minimize costs? How should a pharmaceutical company assign sales representatives to regions to minimize travel distance and keep fair workloads? How should various tools be used to contain the spread of a virus? How should an airline manage its overbooking to maximize the utilization of flights without upsetting passengers? How should an environmentally-concerned investor choose a portfolio without too much risk/return sacrifice? Where should a bank locate new ATMs to improve customer satisfaction at a minimum cost? In TO 425, we learn to generate quantitatively supported answers to these and other important questions using linear, integer, nonlinear, multi-objective, and simulation modeling and analysis. The skills covered directly apply to consulting, finance, healthcare, manufacturing, logistics, or any other industry facing data and complex decisions.