Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

General Foundrys project crashing data are shown in the following table. Set up and solve an LP model using Excel to crash this project to

General Foundrys project crashing data are shown in the following table. Set up and solve an LP model using Excel to crash this project to 10 weeks. How much does it cost to reduce the duration of this project from 15 to 10 weeks? EXPLAIN WHERE YOU GOT CONSTRAINTS AND USE TEMPLATE BELOW.

Time (weeks) Cost Crash cost per week
Activity Immediate Predecessors Standard Crash Standard Crash
A - 2 1 22000 22750 750
B - 3 1 30000 34000 2000
C A 2 1 26000 27000 1000
D A, B 4 3 48000 49000 1000
E C 4 2 56000 58000 1000
F C 3 2 30000 305000 500
G D, E 5 2 80000 84500 1500
H F, G 2 1 16000 19000 3000
Using EST:
Act Pred Time Cost Cost/Pd EST EFT LST LFT 1 2 3 4 5 6 7 8 9 10 11 12
A -
B A
C A
D B, C
E C
F D, E
Budget per week =
Cumulative budget =
Using LST:
1 2 3 4 5 6 7 8 9 10 11 12
A
B
C
D
E
F
Budget per week =
Cumulative budget =

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Environmental Reporting The Western Approach To Nature

Authors: Leanne J Morrison

1st Edition

0367785455, 9780367785451

More Books

Students also viewed these Accounting questions

Question

In your own words, describe the risk-return tradeoff.

Answered: 1 week ago

Question

Understand the reasons for engaging consultants

Answered: 1 week ago