SCREENCAM TUTORIALS

Document Sample
SCREENCAM TUTORIALS Powered By Docstoc
					                         SCREENCAM TUTORIALS

  All eight tutorials have been re-done using Excel 2010.

        Tutorial                                 Topics                           Chapter

Intro to Excel 2010     Layout and Controls in Excel 2010
                        Creating your own Excel worksheets to solve problems

Using the Templates     Viewing tutorials
                        Using the Excel templates that accompany the text

Forecasting             Using the Excel templates for the following forecasting     3
                        methods:
                               Moving Averages
                               Exponential Smoothing
                               Linear Trend
                               Trend Adjusted Exponential Smoothing


Transportation          Using the Excel Transportation Problem template for the    8S
                        following:
                               Finding a solution manually
                               Using Solver to find the optimal solution
                               Solving an unbalanced problem

Aggregate Planning      Using the Excel Aggregate Planning templates for the      11
                        following:
                               Level Approach for Aggregate Planning
                               Match Demand Approach for Aggregate Planning
                               Manually improving the Aggregate Plan
                               Using the Transportation Method to optimize the
                               plan

Inventory               Using the Excel templates for the following Inventory      13
                        methods:
                               Basic Economic Order (EOQ) model
                               Economic Production Quantity (EPQ) model
                               Quantity Discounts
Project Management   Using the Excel PERT/CPM templates for the following:   17
                            PERT/CPM with deterministic time estimates
                            Time/Cost crashing with PERT/CPM

Linear Programming   Formulating a linear programming model                  19
                     Solving the problem graphically
                     Constructing a spreadsheet model
                     Using Solver to find an optimal solution
                     Sensitivity analysis

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:20
posted:9/11/2012
language:English
pages:2