# 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
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews