Please use excel when possible

the fraternity council thought that it was a good idea, so they agreed to brainstorm ideas for the party. "First, we have to pick a date," suggested Joe. "It'll have to be after final exams are over, but before graduation." "That narrows it down pretty quickly to June 8,9 , or 10 . The 11th is a Sunday and the 12th is graduation day," said Jim. "I propose that we try for Thursday the 8th, with the alternate date of Friday, the 9 th. We'll have to take a vote at the fraternity meeting tomorrow." "Now, let's list things that have to be done in order to get ready for the party," suggested Amber. They quickly produced the following list (not in any order): - Pickdate - Planmenu - Get food delivered - Estimate costs - Locate and book a hall - Determine budget - Select music - Hire a DJ - Plan decorations - Setup, decorate hall - Determine how much can be paid from treasury and what the cost of the special assessment will be for each member - Design and print invitations - Set up mailing list - Dress rehearsal (day before party) "dummy activity" - Mail invitations - Plan ceremony for seniors - Rehearse ceremony Page 2 of 3 - Plan after-party cleamup and bill paying - Have the party - Cleamp and pay bills Next, they selected Joe to lead the planning because he had fraternity party planning experience. Put yourself in Joe's position and develop a comprehensive plan for the party. Here's a suggested approach: a) Develop a precedence diagram (network) for the 20 party preparation activities listed above. The precedence relationships between the activities in the network should be based on your judgement. (5 Points) b) Estimate the duration of each activity and organize the estimates in a table. (5 Points) c) Estimate how long the party preparation is expected to take in addition to activities slack times using critical path method. (10 Points) d) Develop and visualize a schedule (Gantt chart) to be used by the party planners for planning and monitoring the progress of the party preparation. (5 Points)