Your team will take the project plan that was used for the individual project schedule assignment, the HR 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. You will do a budget using Excel. You will use the data in the chart below including; tasks, predecessors and durations. 1. Do the structure of your budget in Microsoft Excel. 2. 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. Build the total (aggregate) budget a. Sum up the costs of each major deliverable b. Build subtotals at the major deliverable level c. Do 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 4. Do 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. Do aggregated (total) budget on first sheet of excel. 2. Do time phase budget on the second sheet of excel.

HR Networking Event Duration Activity Task Predecessors (in days) 1 Advertising campaign 1.1 Compile Information None 1 1.2 Design Materials 1.1 10 1.3 Distribute Flyers 1.2 5 2 1.4 Post on social media 1.2 2 Information Session 2.1 Venue 2.1.1 Research Venues None 7 2.1.2 Visit Venues 2.1.1 6 N 2.1.3 Select Venue 2.1.2 N 2.1.4 Secure Venue 2.1.3 2.1.5 Rent Equipment 2.1.4 1 2.2 Participating Companies 2.2.1 Research Companies None 5 2.2.2 Communicate the Opportunity 2.2.1 5 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 15 3 Cocktail Hour 3.1 Catering 3.1.1 Research Caterers None 7 3.1.2 w Arrange & Attend Tasting 3.1.1 3.1.3 Select & Hire Caterer 3.1.2 3 3.1.4 Finalize menu selection 3.1.3 2 3.2 Volunteers 3.2.1 Select Volunteers 2.3.4 3 3.2.2 Train Volunteers 3.2.1 4 2 | Page