Screencam Tutorial 1: Using Templates Topics in this Tutorial: - Viewing tutorials
- Using the Excel templates that accompany the text
Screencam Tutorial 2: Introducing Excel Topics in this Tutorial: - Creating your own Excel worksheets to solve problems
Screencam Tutorial 3: Forecasting Topics in this Tutorial: - Using the Excel templates for the following forecasting methods:
- Moving Averages
- Exponential Smoothing
- Linear Trend
- Trend Adjusted Exponential Smoothing
Screencam Tutorial 4: Linear Programming Topics in this Tutorial: - Constructing a spreadsheet model for linear programming
- Finding a solution manually
- Using Solver to find an optimal solution
- Sensitivity analysis
Screencam Tutorial 5: Transportation Topics in this Tutorial: - Using the Excel Transportation Problem template for the following:
- Finding a solution manually
- Using Solver to find the optimal solution
- Solving and unbalanced problem
Screencam Tutorial 6: Inventory Topics in this Tutorial: - Using the Excel templates for the following Inventory methods:
- Basic Economic Order (EOQ) model
- Economic Production Quantity (EPQ) model
- Quantity Discounts
Screencam Tutorial 7: Aggregate Planning Topics in this Tutorial: - Using the Excel Aggregate Planning templates for the following:
- Level Approach for Aggregate Planning
- Chase Approach for Aggregate Planning
- Manually improving the Aggregate Plan
- Using the Transportation Method to optimize the plan
Screencam Tutorial 8: PERT/CPM Topics in this Tutorial: - Using the Excel PERT/CPM templates for the following:
- PERT/CPM with deterministic time estimates
- Time/Cost crashing with PERT/CPM
| 