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.
Waiting line and Queuing models tutoring covers single and multi channel queuing models. It starts with M/M1 models where the arrival is modeled Poisson and the service is modeled exponential and there is one station. This model is then expanded to many stations to make the M/M/m models. Modifications to these can include constant service and having finite population or constrained waiting space.
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.
Forecasting tutoring covers topics like exponential smoothing, moving average, Holt Winters, regression, etc. We will also compare forecasts using MAD, MSE, RMSE, and MAPE.
I amusing excel to compare the costs of new EV vs New Hybrid or gas car vs keeping old car.
I am putting an ingenious way to model routes that are not possible.
How to solve transportation problem using solver
Binary and Integer Programming with Logical Constraints
How to solve integer programming problem using solver
Binary and Integer Programming with Logical Constraints
How to put the constraints properly in linear programming with integer and binary variables
How to solve the economic order quantity
Check out this great video
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.