????????????????????????????????????????????? Microsoft Excel

1
?????????????????????????????????????????????
Microsoft Excel

• ??????? ??????????????????????????????????????????
  ?? Excel
• ????? ????????
• ???????? ????????????
• ?????? ???????????????????????? ?????

2
?????????????????????????????????????????????
Microsoft Excel

• ??????? ??????????????????????????????????????????
  ?? Excel
• ????? ????????
• ???????? ????????????
• ?????? ???????????????????????? ?????
• 339 ???

3
?????????????????????????????????????????????
Microsoft Excel

• Model and Decision Analysis
• Optimization Linear Programming
• Make or buy Decision
• Investment decision problem
• Transportation problem
• Production problem
• Inventory Planning problem

4
?????????????????????????????????????????????
Microsoft Excel

• Integer Linear Programming
• Employee Scheduling
• Capital Budgeting
• Production Mix
• Purchasing-Procurement problem

5
?????????????????????????????????????????????
Microsoft Excel

• Network Model
• Assignment Model
• Shortest Path
• Equipment Replacement problem
• Maximal Flow problem

6
?????????????????????????????????????????????
Microsoft Excel

• Goal Programming
• Goal seeking
• AHP (Analytical Hierarchical Approach)
• Regression Analysis
• Time Series Forecasting
• Queuing Theory
• Simulation Model

7
?????????????????????????????????????????????
Microsoft Excel

• Project Management Model
• PERT/CPM
• Gantt Chart
• Decision Model
• Tree
• Payoff table