Question: This is a management science simulation exercise in excel. Please help me answer this I will give a thumbs up if it is correct. Problem

This is a management science simulation exercise in excel. Please help me answer this I will give a thumbs up if it is correct.

This is a management science simulation exercise in excel. Please help me

Problem A project has 4 remaining activities and 15 days left and a penalty of $10,000 per day of delay. Activity B and C can begin as soon as activity A is completed. Activity D can begin as soon as both B and C are completed. Activity times in days for the 4 remaining activities of the project are variable with each duration Simulate 3 completions of the project and determine expected penalty for each simulation. Activity A can take 6 days (. 4 prob), or 7,8,9,10,11, or 12 days with each having a 10% probability. Activity B has 20% prob of taking 5 days, 50% chance of 6 days and 30% chance of 7 days. Activity C, 30% prob of 4 days, 50% for 5 days and 20% for 6 days. Activity D10% chance of 1,2,5,6, or 7 days, 20% for 3 days and 30% for 4 days

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!