3 Cocktail Hour 3.1 Catering 3.1.1 Research Caterers None 3.1.2 Arrange & Attend Tasting 3.1.1 3.1.3 Select & Hire Caterer 3.1.2 3.1.4 Finalize menu selection 3.1.3 3.2 Volunteers 3.2.1 Select Volunteers 2.3.4 3.2.2 Train Volunteers 3.2.1HR Networking Event Duration Activity Task Predecessors [in days] 1 Advertising campaign 1.1 Compile Information None 1 1.2 Design Materials 1.1 10 Distribute Flyers 1.2 S 1.4 Post on social media 1.2 2 Information Session 2.1 Venue 2.1.1 Research Venues None 2.1.2 Visit Venues 2.1.1 2.1.3 Select Venue 2.1.2 2.1.4 Secure Venue 2.1.3 2.1.5 Rent Equipment 2.1.4 2.2 Participating Companies 2.2.1 Research Companies None 2.2.2 Communicate the Opportunity 2.2.1 in 2.2.3 Register Companies/Collect Fees 2.2.2 10 2.3 HR Grads/Participants 2.3.1 Send event details to program coordinators 2.1.4 2 2.3.2 Arrange Class Visits 2.3.1 4 2.3.3 Attend Classes 2.3.2 5 2.3.4 Register Attendees 2.3.3 15Introduction to Project Management Group Assignment 2 - Project Budget (20%) Your team will take the project plan that was used for the individual project schedule assignment, the HA Networking Event, to determine how much it will cost to deliver this project's scope. In other words, we're building the project's budget. For this assignment, you will create a budget using Excel. You will use the data in the chart below including: tasks, predecessors and durations. 1. Create the structure of your budget in Microsoft Excel. Estimate the labour and non-labour costs, use the duration estimates provided. a. Determine hourly rates b. Consider non-labour costs of this project, equipment, furniture, food and supplies. 3. Create the total (aggregate) budget a. Sum up the costs of each major deliverable b. Create subtotals at the major deliverable level C. Create subtotals for the labour and non-labour costs d. Use formulas whenever possible so you fully harness the power of Microsoft Excel. e. Establish a reasonable contingency for this project f. You are free to make any assumptions you like; simply ensure they are well documented Create the time-phased budget a. Consider when the work will be done. b. Contingency can be spread across the project's duration c. Ensure your time-phased budget has the same total cost as your aggregate budget. Assignment Instructions: 1. Please submit your Microsoft Excel file (not a PDF version) as I will be reviewing the calculations made. 2. Create aggregated (total) budget on first sheet of excel. 3. Create time phase budget on the second sheet of excel. 4. Upload one assignment per group. You can make multiple submissions before the deadlines (in case you make a mistake, just go back to BB and upload the correct file) 5. Every member of the team needs to submit a completed Participation Log. The submission link is in the "Individual Assignments" content area