Question: Individual Assignment 5 Simulation A construction Project Alpha has 7 tasks. The estimated durations and the predecessors of each task are shown in the following

Individual Assignment 5 Simulation A construction

Individual Assignment 5 Simulation A construction Project Alpha has 7 tasks. The estimated durations and the predecessors of each task are shown in the following table. Task Optimistic Duration Most likely Predecessor Pessimistic B. C D, E, F Cost information is as following. 1) Task A, the daily cost is $500. 2) Task B, costs $5,000 regardless of duration. 3) For Task C, we have to borrow the concrete mixing machine. The minimum rental duration is 5 days with $1,500 and the fee increases by $500 daily after 5th day. 4) Task D, costs $ 6,000, regardless of duration. 5) For Task E, our head quarter made a contract with Jim, a carpenter, so we, project team, don't pay him. However, he has another contract he has to leave at the end of 15 day. If we have to keep him on our site, we have to pay $1,200 for him to cancel his another contract. 6) Task F, will cost $3,000 if it can be done within 3 days, otherwise, it will cost $5,000. 7) For Task G, we will hire two workers. But the daily payment for the workers varies. According to the historical data, we assume that the daily payment per worker follows Normal distribution with mean $600, standard deviation 200. 8) And overhead cost ($900/day) will be applied to the total duration of the project Allow the decimals for the durations and costs. Use more than 10,000 replications. Q1. What would be the expected duration of the project? Q2. What would be the probability that the duration of the project is less than 20 days? Q3. What would be the expected cost of the project? Q4. What would be the probability that the total cost goes above $44,000? Submit your Excel file, and the answers of four questions in a separate document

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!