Operations and Supply Chain Management

Production | Inventory | Sale | Operation | Transportation | Supply Chain | Forecasting | Linear Programming | Resource Planning | Scheduling

Transportation & Transshipment Models

  1. Transportation Problem Solving Using Microsoft Excel

  2. Transshipment Problem Solving Using Microsoft Excel

  3. Transshipment Problem Two or More Intermediate Points Solving Using Microsoft Excel

Forecasting

  1. Moving Average Forecasting Using Microsoft Excel

  2. Weighted Moving Average Forecasting Using Microsoft Excel

  3. Linear Trend Forecasting Using Microsoft Excel

  4. Exponential Smoothing Forecasting Using Microsoft Excel

  5. Adjusted Exponential Smoothing Forecasting Using MS Excel

  6. Regression Method of Forecasting Using Microsoft Excel

  7. Seasonally Adjusted Forecasting Using Microsoft Excel

  8. Forecast Effectiveness and Comparison by Mean Absolute Deviation MAD in MS Excel

  9. Forecast Control by Tracking Signal Using Mean Absolute Deviation MAD MS Excel

  10. Forecast Control Using Statistical Control Chart in MS Excel

  11. Forecast Control , Tracking Signal , Mean Absolute Deviation MAD , Error & Statistical Control Chart

Inventory Management

  1. Economic Order Quantity EOQ

  2. Basic Economic Order Quantity EOQ | Problem Solving

  3. Production Economic Order Quantity EOQ

  4. Production Economic Order Quantity EOQ | Problem Solving

  5. Economic Order Quantity EOQ | Understanding Details | Developing Graphs In MS Excel

  6. Economic Order Quantity EOQ | Discounted Items | Problem Solving

  7. Reorder Point | Economic Order Quantity EOQ | How to Calculate | MS Excel

  8. Order Quantity for Variable Demand | Economic Order Quantity EOQ

Monte-Carlo Simulation

  1. Monte Carlo Simulation using Microsoft Excel and Solve Problems

Production, Operations, & Sales Planning

  1. Level Production | Operations & Sales Planning | Inventory Management

  2. Chase Demand | Operations & Sales Production Planning | Inventory Management

  3. Productions, Sales, & Operations Planning | Linear Programming | Using MS Excel Solver Function

  4. Productions, Sales, & Operations Planning | Linear Programming | MS Excel Solver Function | Details

Application of Linear Programming

Using MS Excel Solver Function

  1. Mixing Strategy | Gas, Recipe, Color

  2. Disaster Management Strategy

  3. Optimization of Diet & Nutrition

  4. Optimization of Transportation Cost

Scheduling

  1. Assignment Problem/Method/Model/Algorithm Example Solved Using MS Excel

  2. Assignment Problem Method Model Algorithm Using MS Excel Practical Example

  3. Job Sequencing Using MS Excel - FCFS, LCFS, Earliest Deadline, Shortest Processing Time, and Slack

  4. Job Sequencing Through Two Serial Processes - Johnson Rule - Example Problem Solved Using MS Excel

  5. Employee Scheduling Using the Linear Program Solver Function in MS Excel

  6. Case Problem # 1 Russell and Taylor: Linear Program Scheduling Assignment Problem Solution Using MS Excel Solver Function