Use excel or R:

An activity that has a predecessor means that the predecessor must be completed before starting that activity. For example, Activity A.2 must be completed before activity A.3 can start.

The expected completion of the project is 1,460 days at a cost of $850,000. A late completion of the project incurs in a penalty of $10,000 for each day the project is late. An early completion represents savings of $5,000 per day. Develop a Monte Carlo simulation model with 500 trials and answer the following questions.

A.Calculate the Early and Late completion dates for each activity (complete the table).

B.Calculate the cost of late completion for the project

C.Calculate the savings of early completion for the project

Project Start Date 6-Nov-17 TOTAL DAYS Activity Completion Date Duration ACTIVITY Predecessor Mean St DevEarly Late 10 100 125 A.1 15 A.2 30 20 10 10 15 10 15 20 200 A.3 A.4 A.5 B.1 B.2 C.1 C.2 D.1 A.2 A.3 A.1, A.4 A.4 B.1 B.1 C.1, B.1 C.1, C.2 145 120 100 160 185 125 200 1460 Project Start Date 6-Nov-17 TOTAL DAYS Activity Completion Date Duration ACTIVITY Predecessor Mean St DevEarly Late 10 100 125 A.1 15 A.2 30 20 10 10 15 10 15 20 200 A.3 A.4 A.5 B.1 B.2 C.1 C.2 D.1 A.2 A.3 A.1, A.4 A.4 B.1 B.1 C.1, B.1 C.1, C.2 145 120 100 160 185 125 200 1460