In Jennifer Bellin’s leadership conference project (Problem 34 in Chapter 11), suppose that the activity times are uncertain. Estimated ranges for these times are shown in the table below. 

Develop a spreadsheet simulation model to find the distribution of the project completion time using 100 trials. All times should be expressed as whole numbers of days.

Data from Problem 34 of Chapter 11

Jennifer Bellin has been put in charge of planning her company’s annual leadership conference. The dates of the conference have been determined by her company’s executive team. The table that follows contains information about the activities, predecessors, and activity times (in days):

Transcribed Image Text:

Activity Description A B с D E T FLG G H I K Develop conference theme Determine attendees Contract facility Choose entertain- ment Send announce- ment Order gifts Order materials Plan schedule of sessions Design printed materials Schedule session rooms Print directions Prede- cessors A A B B B C B, H H Minimum Time Estimate 1 1 5 5 1 1 1 30 10 1 5 Maximum Time Estimate 5 5 15 20 10 10 1 50 20 1 15