Project #16512 - Project Task Crashing

Using the chart below, I need the 3 following questions answered - I need a table/excel spreadsheet for each questiom

Activity

Normal Time

Normal Cost

Crash Time

Crash Cost

Crash Cost/Day

a

5

$50

3

$150

$50

b

4

40

2

200

160

c

7

70

6

160

90

d

2

20

1

50

30

e

3

30

-

-

-

f

8

80

5

290

70

g

5

50

4

100

50

h

6

60

3

180

120

 

 

 

 

 

(c). Find the optimal way of getting an 18-day delivery time. What is the projected cost? You may use MS Excel (Solver) to find the optimal way of getting to an 18-day delivery time and copy/paste your table here or create a table in MS Word and enter the results in the table. Once you’ve found the solution, explain the results of your calculations.

 

 

 

           

 

 

 

(d). Find the optimal way of getting a 16-day delivery time. What is the project cost. You can repeat the process here for this question (Excel using Solver) or create a table and enter the results here to determine a 16-day delivery time. Explain your results.

 

 

 

(e). Calculate the shortest delivery time for the project. What is the cost? You can repeat the process here for this question (Excel using Solver) or create a table and enter the results here to determine the shortest delivery time. Explain your results.

 

Subject Business
Due By (Pacific Time) 11/10/2013 6:00 PM
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy