Electronic Thesis and Dissertation Repository

A Study in Three Practical Management Science Problems

John S.F. Lyons, The University of Western Ontario

Abstract

This study of practical problems in Management Science (MS) describes novel mathematical models for three different decision settings. It addresses questions of: (a) what optimal route should be taken through a time-windows and topographically complex network; (b) what optimal sequencing of scheduled surgeries best coordinates flow of patients through central recovery; and (c) what prices should be charged and what stock amounts should be produced for two markets or channels to maximize profit explicitly, given various capacity and uncertainty conditions.

The first problem is in a sport analytics context, using a novel Integer Programming and big data from Whistler-Blackcomb ski resort. The second is to coordinate dozens of surgeries at London Health Sciences Centre, using a novel Constraint Programming model mapped to and parameterized with hospital data, including a tool for visualizing process and patient flow. The third problem is relevant to almost any business with a secondary market or sales channel, as it helps them identify profit optimal prices based on simple demand estimates and cost information they can easily provide for their own setting.

The studies use fundamentally different operational research techniques, in each case uniquely extended to the problem setting. The first two are combinatorial problems, neither one extremely beyond human cognitive ability, and both involving lots of uncertainty, and thus the sort of problem managers tend to dismiss as not efficient or practical to solve analytically. We show in the first study that vastly more skiers could achieve the challenge by following our route recommendation, unintuitive as are some of its elements, initially. In the second study, our scheduling model consistently outperforms currently unstructured-independent approach at the hospital. The final study is mathematical but demonstrates that by considering distinct market costs in pricing a firm can invariably earn more profit.