Planning and Scheduling Project PMPG302 Assignment #3 - Individual Assignment Objective The objective of this assignment is to develop each student's familiarity with the use of MS Project to record the following project: building of a Tiny Hotel. You will be presented with the following information to create and update the MS Project: Work Breakdown Structure Activity List (Duration, time, and resource assigned to each activity), Task relationship (relationship between each task in the Project), Resource sheet, and Fixed cost (entered via Table/Cost/Fixed Cost column). Assumptions: Project Starts March 5, 2018 Enter Statuary holidays for Easter Weekend, Victoria Weekend, and Canada Day Marks Enter Project Summary Task activity - 5 marks Enter activities of WBS into MS Project - 20 marks Please enter milestones for each summary task. - 5 marks Enter resources into Resource sheet - 5 marks Enter duration and resources per activity - 30 marks Enter Task Relationship - 25 marks What is the End Date of the Project - 5 marks What is the Project Cost - 5 marks Total Marks: 100 Marks Work Breakdown Structure (WBS) Activity List No. Name Duration Resources 1.1.1 Research Hospitality Standards 4 days Consultant 1.1.2 Sponsor & stakeholder workshop for structure 3 days Consultant 1.1.3 Training Completed 0 Days 1.2.1 Tender RFP to potential builders 2 days Consultant 1.2.2 Select builder 3 days Consultant 1.2.3 Builder Selected 0 Days 1.3.1 Hotel Design 10 days Architect 1.3.2 Design cost evaluation 5 days Consultant, Architect 1.3.3 Builder Onboarding 3 days Consultant 1.3.4 Builder Updated and On boarded 0 Days 2.1.1 Hospitality Standards Research 5 days Consultant 2.1.2 Sponsor & stakeholder workshop for location 2 days Consultant 2.1.3 Hospitality Design Completed 0 days 2.2.1 Tender RFP to potential realtors 5 days Builder, Consultant 2.2.2 Realtor Selection 2 days Consultant, Architect 2.2.3 Realtor On boarded 0 days 2.3.1 View available properties 10 days Realtor 2.3.2 Purchase Agreement Negotiations 3 days Consultant, Realtor 2.3.3 Sign property purchase agreement contract 1 Days Lawyer 2.3.4 Property acquired 0 days 3.1.1 Structure Inspection 1 days Builder, Consultant, Architect 3.1.2 Tow structure to final location 5 days Transporter 3.1.3 Connect electrical & sanitation 3 days Electrician 3.1.4 Structure Installed 0 days 3.2.1 Build deck 4 days Contractor 3.2.2 Plant trees and shrubs 3 days Landscaper 3.2.3 Build fence 2 days Landscaper, Contractor 3.2.4 Exterior Complete 0 days 3.3.1 Select and acquire furnishing 5 days Interior Designer, Consultant 3.3.2 Install Furnishing 3 days Interior Designer, Consultant, Electrician 3.3.3 Interior Completed 0 days 4.1.1 Safety inspection & cert. 2 days Safety Inspector, Consultant 4.1.2 Hospitality inspection & cert. 1 day Contractor, Hospitality Inspector 4.1.3 Inspections Completed 0 days 4.2.1 Marketing photo shoot 2 day Consultant, Photographer 4.2.2- 1 Marketing Write up and Documentation 3 days Consultant 4.2.2- 2 Sponsor approval 2 days 4.2.3 Post Airbnb page 1 day Consultant 4.2 Documentation Completed 0 days Task Relationships 1. Project starts with Research Hospitality Standards 2. Sponsor workshop for Structure starts when Research ends 3. Training completed milestone when workshop ends 4. RFP for potential builders start when Training Milestone completed 5. Builder selection starts when RFP's completed 6. Builder Selection Milestone achieved when Builder selection completed 7. Hotel Design starts when Builder is Selected 8. Design cost is evaluated when design is completed 9. Builder is onboarded when Design evaluation is completed 10. Builder onboarded milestone completed when Builder onboarding is completed 11. Hospitality research starts when Builder is onboarded 12. Training Workshop for hospitality starts when research is completed 13. Hospitality milestone completed when training is completed 14. Realtor RFPs go out when Hospitality milestone is completed 15. Realtor Selection starts after RFP's are completed 16. Realtor is onboarded after realtor selection is completed 17. Property viewings start after realtor is onboarded 18. Purchase negotiations start when Property Viewings are completed 19. Property purchase agreement is signed after negotiations are finished 20. Property acquired milestone achieved after Purchase agreement signed 21. Structure Inspection starts after property is acquired 22. Transporting structure starts after structure inspection is completed 23. Electrical and sanitation connections are started after structure has been transported 24. Structure installation is completed when Electrical and Sanitation connections are completed 25. Deck building starts after Structure is installed 26. Trees and Shrubs plating is started when Deck building is 50% complete 27. Fence building is started when Trees and Shrubs are 2/3rds completed 28. Exterior is complete when Fence Building and Deck, Trees and Shrubs, and fence are completed 29. Selection of Furnishings start when Structure is installed. 30. Furnishings are installed when selection is complete 31. Interior is complete when Furnishings are installed 32. Safety inspection begins are exterior and interior is completed 33. Hospitality Inspection is started when Exterior is completed 34. Inspections complete when Safety and Hospitality inspections and certifications are completed 35. Marketing photo shoot starts after inspections are completed 36. Write up begins with marketing photo shoot 37. Sponsor Approval after marketing write up and documentation and photo shoot are completed 38. Airbnb page is made after sponsors approve marketing material 39. Documentation completed when Airbnb page is posted 40. Project completed when Documentation is complete Resource Sheet Resource Name Type Initials Max. Units Peak Std. Rate Ovt. Rate Consultant Work C 200% 200%$150.00/hr$250.00/hr Architect Work A 100% 100%$200.00/hr$350.00/hr Builder Work B 100% 100%$200.00/hr$400.00/hr Realtor Work R 100% 100% $80.00/hr $120.00/hr Lawyer Work L 100% 100%$300.00/hr$500.00/hr Transporter Work T 100% 100% $50.00/hr $80.00/hr Electrician Work E 100% 100% $60.00/hr $80.00/hr Contractor Work C 200% 200% $40.00/hr $60.00/hr Landscaper Work L 200% 200% $30.00/hr $50.00/hr Interior Designer Work I 100% 100%$100.00/hr$150.00/hr Safety Inspector Work S 100% 100%$100.00/hr$150.00/hr Hospitality Inspector Work H 100% 100% $80.00/hr $100.00/hr Photographer Work P 100% 100% $40.00/hr $60.00/hr Fixed Material Costs (entered into Table/Cost/Fixed Cost Column) Activity Fixed Cost Stakeholder Workshop 1 $2,000 Stakeholder Workshop 2 $1,500 Builder Onboarding $120,000 Sign Property Purchase Agreement $80,000 Build Deck $2,000 Plant Trees and Shrubs $500 Build Fence $750 Acquire Furnishings $5,000