Chapter 14 - Spreadsheet Modeling & Decision Analysis A...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
Spreadsheet Modeling A Practical Introduction to Management Science 5 th edition Cliff T. Ragsdale
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Project Management Chapter 14
Background image of page 2
Introduction to Project Management Projects can be simple (planning a company picnic) or complex (planning a space shuttle launch). Successfully completing a project requires: Knowledge of the tasks involved Accurate estimates of time and resources required Knowledge of physical and logical relations between the various tasks Project management techniques Critical Path Method (CPM) Program Evaluation and Review Technique (PERT) Spreadsheets can be used to manage projects, but dedicated project management software is often more effective.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
An Example: Lightner Construction Tom Lightner owns Lightner Construction, a general contracting company specializing in the construction of single-family residences and small office buildings. Tom frequently has numerous construction projects going on at the same time and needs a formal procedure for planning, monitoring, and controlling each project. He is aware of various project scheduling techniques but has never used them. He wants to see how he might apply such techniques to one of the home-building projects he will be undertaking in the near future. The following slide summarizes each of the major activities required for this project.
Background image of page 4
Summary of Activities Time Immediate Required Predecessor Activity Description  (in days) Activities A Excavate 3 -- B Lay foundation 4 A C Rough plumbing 3 B D Frame 10 B E Finish exterior 8 D F Install HVAC 4 D G Rough electric 6 D H Sheet rock 8 C, E, F, G I Install cabinets 5 H J Paint 5 H K Final plumbing 4 I L Final electric 2 J M Install flooring 4 K, L
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
An Activity-On-Node (AON) Network Install Cabinets A B C D E F G H I J K L M Excavate Lay Foundation Rough Plumbing Frame Finish Exterior HVAC Rough Electric Sheet Rock Paint Final Plumbing Final Electric Install Flooring
Background image of page 6
A Comment of Project Networks Projects can also be depicted using Activity-On- Arc (AOA) networks. This book uses AON networks (which the author views as superior to AOA). Some software packages use AOA networks, so you should at least be aware that they exist.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
An Activity-on-Arc (AOA) Network 1 2 3 4 5 6 7 8 9 10 11 12 13 Excavate Lay Foundation Rough Plumbing Frame Finish Exterior HVAC Rough Electric Sheet Rock Paint Install Cabinets Final Plumbing Final Electric Install Flooring A B C D G F E H I J K L M
Background image of page 8
Start and Finish Points AON networks should have unique start and finish points. A B C D E A B C D E start finish
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CPM: An Overview A Forward Pass through the network determines the earliest times each activity can start and finish. A
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/06/2012 for the course BUSINESS CS204, Eco taught by Professor Mr during the Spring '12 term at American University of Beirut.

Page1 / 46

Chapter 14 - Spreadsheet Modeling & Decision Analysis A...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online