Problem 4: (25 points) Development of a new deluxe version of a particular software product is being considered by Ravi Beharas software house. The indirect cost is $500 per week. The activities necessary for the completion of this project are listed in the following table

a) (5 points) What is the project completion time and the total cost required for completing this project on normal time?

b) (5 points) If you wish to reduce the time required completing this project by 1 week, which activity should be crashed, and how much will this change the total cost?

c) (10 points) If you wish to reduce the total cost to the minimum level, which activities should be crashed, and how much will this make the total cost?

d) (5 points) What is the earliest time that the project can be completed by crashing the activities? How much will this make the total cost?

PLEASE USING EXCEL FOR THE WORK