Analytics

Linear programming tutoring covers topics in optimization applied to business models. These include integer programming, goal programming, transportation problems, shortest route models, assignment problems, maximal flow problems, minimal spanning tree problems, sensitivity analysis, dynamic programming, knapsack problems, etc. I can help you solve them by hand, graphically or by softwares like Excel solver or by simplex algorithm.

Project management tutoring covers topics that helps minimize project cost and delivered on time. These include PERT/CPM analysis, and project crashing. These are mostly done in excel.

Other topics closely related to project management and evaluation include decision trees, EMV, EVPI, minimax, maximin, minimum regret, etc. These topics can incorporate simulation in Excel through Crystal Ball and Palisade.

Inventory control tutoring covers topics in Economic Order Quantity where the receipt of inventory is assumed to arrive instantaneously and demand is at constant rate. This assumption is then relaxed to accommodate production run models where receipt of inventory is modeled as a flow. Uncertainty is then incorporated in demand in order to introduce concepts such as safety stock and reorder points. Lastly, materials planning models are developed to make sure that there is sufficient flow of materials when it is needed. These topics are done in Excel.

Statistical Process tutoring covers topics in quality management and the use of control charts. These involve heavy use of excel in order to create R chart, p chart and X charts.