Purchase Solution

Project Managment : Crash Cost Analysis

Not what you're looking for?

Ask Custom Question

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?

Attachments
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.