Project Managment : Crash Cost Analysis
Not what you're looking for?
This is a problem #9, chapter 14 - Project Management, from the textbook by Cliff Ragsdale, "Spreadsheet Modeling and Decision Analysis".
This problem requires the use of Excel and the add-in, called Solver. The course is Excel-based and Solver is the optimization application used for all problems. Attached is an excel document with the data and the problem.
The following data summarizes the per-day cost of crashing the activities in the problem described in the previous question (# 8)
Crash Cost Maximum
Activity per Day Crash Days
A $50 2
B 60 3
C 57 1
D 45 2
E 25 2
F 30 2
G 65 5
H 55 2
I 28 4
J 33 3
K 40 1
L 37 2
(a) Create an LP model to determine the least costly way of crashing the project to complete in within 20 days
(b) By how much should each activity be crashed, and what is the total crashing cost?
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Basics of corporate finance
These questions will test you on your knowledge of finance.