BUSN330 Project Management - Team Project Using Microsoft Project to Setup the Team Project Each team member will create their own project using the steps listed below. When all team members have completed the steps, the team will agree on which file to submit on behalf of the group. The following steps are a guide for using MS-Project to plan the baseline for this project: 1. Each student in the group will start MS-Project and create a new Blank Project. 2. Make sure to set new tasks to Auto Schedule (bottom left corner). 3. Go to the Project Information dialog box and set Schedule from: Project Start Date (ASAP) and pick the start date of March 8", 2021 for the project. Click Ok when complete. 4. Type the list of tasks with durations into the Task Sheet. Summary tasks are created when you select the tasks below the summary task and then indent. The summary task automatically calculates the duration for the set of tasks summarized below. Do not establish any relationships yet. 5. Once the tasks and durations are in, save the project as ProjectTeam99 to your Google Drive (the 99 is your group number). 6. Establish the relationships between the tasks by creating one link between each pair of tasks from predecessor to successor. 7. The Project Information will show the completion date of the project. 8. Save as ProjectTeam99Schedule to your Google Drive when all relationships are established. 9. You should now be able to determine the critical path of the project (view or report), 10. Print your Gantt Chart, Calendar, Task Sheet with Entry table, and the PERT chart as PDFs. 11. Switch to the Resource Sheet view and enter your list of resources with costs. 12. Change the view back to the Gantt Chart and Assign the resources to the appropriate tasks. Make sure that when you are assigning multiple resources to a single task you identify all of the resources for that task before you click on the Assign button. If you don't do it that way you may find that the durations change. 13. Save as ProjectTeam99Plan when all the resources have been assigned to their tasks. 14. The Project Information - Statistics should now show the total project cost, duration and, work hours. 15. Set the Baseline for the project and then Save as Project Team99Baseline to your Google Drive. 16. PDF Print the Project Summary, Budget, Cost per Task and Cost per Resource 17. Save again then exit Project. Create a backup of the file called ProjectTeam99 Baseline 18. Once all group members have created their individual project files, have your group make sure that everyone agrees on the schedule, budget, work hours and duration hours (see Project Information, Statistics) then submit one of your team's files for marking with the zipped reports.KEY Winter 2021 Project Statistics for "BUSN330FinalProjectPlan.mpp' X Start Finish Current Mon 3/8/21 Fri 3/26/21 Baseline NA NA Actua NA NA Variance Oh Oh Duration Work Cost Current 112.85h 213.75h $9,960.00 Baseline Oh oh $0.00 Actual oh oh $0.00 Remaining 112.85h 213.75h $9,960.00 Percent complete: Duration: 0% Work: 0% Close KEY Fall 2020 Project Statistics for 'BUSN330FinalProjectClass1.mpp' X Start Finish Current Mon 11/9/20 Tue 11/24/20 Baseline NA NA Actual NA NA Variance Oh Oh Duration Work Cost Current 95h 213.75h $9,960.00 Baseline Oh Oh $0.00 Actual Oh I Oh I $0.00 Remaining 95h 213.75h $9,960.00 Percent complete: Duration: 0% Work: 0% CloseTask# Task Name Duration Predecessors Resource Nomes 1 Planning Phase Summary 2 Initial Client Meeting 2 hrs Client, Project Manager 3 Contact Signed with Client O hr Client, Project Manager 4 Website Criteria Determined 4 hrs Graphic Artist, Project Manager, Web Developer 5Storyboard Presented 3 hr Graphic Artist, Project Manager 6 Approval of Storyboard D hrs Client, Graphic Artist, Project Manager Design Phase Summary 8 Design Meeting 3 hrs Graphic Artist, Project Manager, Web Developer 9 Scope of Work Plan 2.5 hrs 18 Project Manager 10 Design Specifications Developed 3 hrs Graphic Artist, Web Developer 11 Standards Developed 2 hrs 10 Graphic Artist, Web Developer 12 Decision on Portal Technology O hrs 11 Project Manager, Web Developer 13 Framework Designed 4 hrs 12 Graphic Artist 14 Design Tab Layouts 6 hrs 13 Graphic Artist 15 Design Panel Styles 4 hrs 13 Graphic Artist Design Landing Page 1 hr 13 Graphic Artist 17 Design Portal Login (with role based security 5 hrs 12 Web Developer 18 Design Navigation Graphics 6 hrs 11 Graphic Artist 19| Design Approval 0 hrs 13,14,15,16,17,18 Client, Graphic Artist, Project Manager, Web Developer 20 Develop Portal Phase Summary 21 Develop Framework to Specification 8 hrs 15 Web Developer 22 Build News Layout 0.5 hrs 21 Web Developer 23 Build Basic Content Panel 1 hr 22 Web Developer 24| Build Links Layout 2 hrs 23 Web Developer 25 Build Table Layout 4 hrs 24 Web Developer 26 Build Images Layout 2 hrs 25 Web Developer 27 Build Inquiry form 1.1 hrs 26 Web Developer 28 Build Events Layout 4 hrs 27 Web Developer 29| Install Weather Widget 0.25 hrs 28 Web Developer 30 Install Poll/Survey widget 0.5 hrs 29 Web Developer 31 Install Phone List Widget 2 hrs 30 Web Developer 32| Install Document Widget 0.3 hrs 31 Web Developer 33 Install Mapping Widget 0.5 hrs 21 Web Developer 34 Install Flight Informaton Widget 0.5 hrs 21 Web Developer 35 Install Photo Rotation Widget 0.5 hrs 21 Web Developer 36 Install Press Release Widget 0.5 hrs 21 Web Developer 37 Install News Feed Widget 0.3 hrs 21 Web Developer 38 Install Flight Planning Widget 1 hr 21 Web Developer 39 Install NOTAMS widget 0.5 hrs 21 Web Developer 40 Build Tabs Summary 41 Build Home Tab 3 hrs 23,22,29,30 Web Developer 12 Build Contacts Tab 5 hrs 25,31 Web Developer 13 Build Business Development Tab 4 hrs 23,31 Web Developer 14 Build Regional Airport Authority Tab 13 hrs 23,25,32 Web DeveloperTask# Task Name Duration Predecessors Resource Nomes 45 Build Passenger Information Tab 4 hr 23,25,26,33,34 Web Developer 46 Build Flight Information Tab 3 hr 22,23,25,34 Web Developer 47 Build Airport History Tab 2 hr 23,25,26 Web Developer 48 Build Media Tab 3 hr 22,23,25,26,32 Web Developer 49 Build Local Region Tab 5 hr 23 Web Developer 50 Build Pilot Information Tab 0.3 hrs 23,38,39 Web Developer 51 Build Discussion Module 2 hr 21 Web Developer 52 Build Blog too 2 hr 21 Web Developer 53 Build Education and Fun Stuff Tab 1 hr 23,25 Web Developer 41,42,43,44,45,46,47,4 54 Tab Build Complete O hrs 8,49,50,51,52,53 55 Build System Parts Summary Graphic Artist 56 Build Website Banner 0.5 hrs 21 Graphic Artist 57 Build Navigation Graphics 2 hr 21 Web Developer 58 Install Quick Links Widget 0.5 hrs 21 Web Developer 59 Install Sitemap Wiget 3 hrs 21 Web Developer 60 Build Site Documents (Legal, Cookies, Privacy, 1 hr 21 Terms of Use) Web Developer 61 Build Login/Logout 3 hrs Web Developer 62 Build System Parts Complete 0 hr 56.57.58,59,60,61 63 Beta Acceptance Phase Summary 64 Test Navigation System 0.5 hrs 62,54 Tester 65 Test Security System 1 hr 62,54 Tester 66 Test Links 4 hr 62,54 Tester 67 Beta Test Sign-off O hrs 64,65,66 Project Manager, Tester 68 Delivery Phase Summary 69 Install Files on Server 3 hr 67 Web Developer 70 Upload User List with Rights 2 hrs 69 Web Developer 71 Test Links on Server 4 hr 69 Tester 72 Client Accptance Testing 5 days 70,71 Client 73 Client Sign-Off 3 hrs 72 Client, Project Manager 74 Celebration 2 hrs 73 Client, Graphic Artist, Project Manager, Tester,Web Developer 8-Mar Planned Start Date Project Resources Resource Name Std. Rate Max. Units Project Manager $45.00/hr 100% Graphic Artist $55.00/hr 400% Web Developer $60.00/hr 400% Tester $80.00/hr 100%BUSN330 Group Project Update1 as of March 15th, 2021 The Project Manager provided the following report at the Update Meeting on March 15" that included all tasks completed or in progress up to the end of the day on March 12". A copy of this update report will be included in the Final Report. The following changes were recorded to update the project: . The project extended by 11 hours and $1,085 because these tasks took longer than planned: O #4. Website Criteria Determined from 4 to 6 hours (+2hrs, $320) O #5. Storyboard Presented from 3 to 5 hours (+2hrs, $200) O #10. Design Specifications Developed from 3 to 6 hours (+3hrs, $345) O #13. Framework Designed from 4 to 6 hours (+2hrs, $110) o 15#. Design Panel Styles from 4 to 6 hours (+2hrs, $110) . The person that was taking too much time to do the work was replaced with another person that could do the tasks faster. This substitution in the resource pool does not require any changes in MS-Project but would be noted in the Final Report. The project required an increase in the number of available Web Developers and Graphic Artists to eliminate the overallocation when some tasks occurred simultaneously. This will prevent delays and does not change to the budget or schedule. Check the Project Information Status to see that the project is overbudget and behind schedule. We can also see this issue by looking at the Earned Value Report. The client expects the budget to stay below $10k and the latest completion date of March 25th. The project manager has made the following changes to the project in consultation with the team: Tasks 21 and 25-Added one more Web Developer to these tasks in order to completed faster (same work hours with 2 people time 4 hours = 8 hours). No change to the budget Tasks 43 and 45 will benefit from the Web Developer assisting the Tester. This will not change the budget but will allow those tasks to be completed in one half (50%) of the time. The duration is reduced but the tasks will have the same work hours. . The following tasks were discussed with the team and can be completed faster: o #28 to 3hrs O #49 to 2hrs O #66 to 2hs O #42 to 4hrs o #59 to 1hr O #71 to 2hrs Make the proposed changes from the Project Manager to your group project. Save and print the reports. Compare your group's reports and determine the "best" .MPP to submit for your group