Return to Index
Operations Research Models and Methods
 
excel head
Subunit Operations Management/Industrial Engineering
  - Project Management
  This add-in performs the computations of CPM and PERT. Given the activities of the project, the add-in computes the critical path. The program creates a graph of the project network and a Gantt chart showing the schedule. With restricted resources, the add-in generates schedules which optimize resource usage and cash flows. Activity durations may be specified as random variables. Then the Monte Carlo method is used for simulation analysis.
Add-in - Click the add-in name to download a zipped .xla file.
Add-in Name
File
Date
project.xla
2/06/2011

 

Associated Add-ins - Click the add-in name to transfer to the add-in page.
Add-in Name
File
 
ran_var.xla
When activity times are uncertain, simulation can be used to estimate the project duration and the critical path. The Random Variables add-in can be used to model the uncertainty.

 

Demonstration Files - Click the demo name to download a .xls file.
Demo Name
File Name
 
projdem.xls
 
 
gray line
  
Return to Top

tree roots

Operations Research Models and Methods
Internet
by Paul A. Jensen
Copyright 2010 - All rights reserved