Project Management

its in Excel file , please show calculations for Excel.

Answering this :

Assume all Labour is at $100/hour

1. Calculate BAC for each activity (=hrs x $100)

2. Draw activities in sequence. (colour in the boxes in a logical sequence)

3. Milestones should be represented as Black Dimond symbol

months go until 12 months but dont show fully in picture

5 pictures in total

last picture just showing how the full layout looks like.

2 Activity ID WBS/Activity Name 3 4 PLAN BECKY'S NEW OFFICE BUILDING Initiation **Project Start MILESTONE PM-0000 PM-1110 PM-1010 PM-1020 10 PM-1030 11 General Project Management Activities (Level of Effort) Client Requirements Document (CRD) Prepare Draft - CRD Conduct review and comment-CRD Disposition comments and issue for use CRD Detail Desien Scope of Work Prepare draft - Detail Design -2 DD-1010 * DD-1020 5 DD-1030 11 DD-2010 1 DD-2020 15 DD-2030 20 DD-2040 21 DD-2050 Conduct review and comment Detail Design Disposition comments and issue for use. Detail Desien Procurement Detail Design Contract Prepare Supplemental Information and Quality Program Selection forms. Detail Design Contract Prepare and Issue Requisition - Detail Design Contract Bid Period - Detail Design Contract Conduct evaluation and select Contractor Negotiate Detail Design Contract **AWARD DETAIL DESIGN CONTRACT** MILESTONE Execute - Detail Design Contract Planning activity: Contractor Deliverables Planning activity Becky's Review and Oversight Construction 32 DD-2060 23 24 DD-3010 3 DD-3020 27 CS-1010 2 CX-1010 Planning activity: Construction Decommissioning Planning activity: Decommissioning of old office **PROJECT FINISH MILESTONE" 30 PM-9999 31 NOTE: There are 4 weeks in each month and 5 days in each we SDL Week #12 - Using the above chart: Sheet1 Accessibility: Investigate Type here to search o Introc Successor Duration (days) Resources Hours BAC % Complete EV 0 PM-1010 PM-0000 SS PM-9999 FF Project Manager 225h Planner 75h 220 PM-1020 PM-1030 DD-1010 10 10 Project Manager 20h Reviewers 4 x 2h Project Manager 7h 5 DD-1020 15 DD-1030 DD-2010 10 10 Project Engineer 40h Project Engineer Sh Reviewers 3 x 5h Project Engineer 40h DD-2020 5 5 20 DD-2030 DD-2040 DD-2050 DD-2060 DD-3010 DD-3020 Project Engineer 20h Project Manager 30h Project Manager 25h Project Manager 30h Legal 40h 5 20 o 30 CS-1010 CS-1010 Contractor $60,000 Project Engineer 120h 30 Contractor $160,000 Project Engineer Sih CX-1010 55 PM-9999 CX Engineer 50h 20 0 BAC $ 1 M 1 T V Introduction to Project Management - SDL Week #12 EV Month 1 Month 2 Month 3 Month 4 Sheet1 Accessibility Investigate Type here to search o G DD-2020 DD-2030 DD-2040 DD-2050 Prepare and Issue Requisition - Detail Design Contract Bid Period - Detail Design Contract Conduct evaluation and select Contractor Negotiate Detail Design Contract DD-2060 DD-3010 DD-3020 **AWARD DETAIL DESIGN CONTRACT** MILESTONE Execute - Detail Design Contract Planning activity Contractor Deliverables Planning activity. Becky's Review and Oversight Construction CS-1010 CX-1010 PM-9999 Planning activity Construction Decommissioning Planning activity: Decommissioning of old office **PROJECT FINISH MILESTONE NOTE: There are 4 weeks in each month and 5 days in each week. 16 Points 16 Points 3 Points /35 SDL Week #12 - Using the above chart: Assume all Labour is at $100/hour 1. Calculate BAC for each activity (#hrs x $100) 2. Draw activities in sequence. (colour in the boxes in a logical sequence) 3. Milestones should be respresented as a Black Diamond symbol + Sheet1 Accessibility Investigate Type here to search O RI E Page View Descloper he Sh. H? M - V MO Chane 10 Map Introduction to Proje RAMOWAWCTOS WES/Activame Du end TV FO 1010 PM 20 19 IM 100 Do CD 0001 at Bang OD 100 15 DO 100 0 m Conde Pro 1010 10 DONDE OR Prebermanfaat -2000 DO Credit 10 9 30 STALNO MESTO BO BOLO 2000 0 ICM CE 1010 59 Deco POUR NOTE: There are 4 weeks in each month and 5 days in each week. SOL Week #12 -Using the above chart: TA Sheet BAC type here O it $ 2 Activity ID WBS/Activity Name 3 4 PLAN BECKY'S NEW OFFICE BUILDING Initiation **Project Start MILESTONE PM-0000 PM-1110 PM-1010 PM-1020 10 PM-1030 11 General Project Management Activities (Level of Effort) Client Requirements Document (CRD) Prepare Draft - CRD Conduct review and comment-CRD Disposition comments and issue for use CRD Detail Desien Scope of Work Prepare draft - Detail Design -2 DD-1010 * DD-1020 5 DD-1030 11 DD-2010 1 DD-2020 15 DD-2030 20 DD-2040 21 DD-2050 Conduct review and comment Detail Design Disposition comments and issue for use. Detail Desien Procurement Detail Design Contract Prepare Supplemental Information and Quality Program Selection forms. Detail Design Contract Prepare and Issue Requisition - Detail Design Contract Bid Period - Detail Design Contract Conduct evaluation and select Contractor Negotiate Detail Design Contract **AWARD DETAIL DESIGN CONTRACT** MILESTONE Execute - Detail Design Contract Planning activity: Contractor Deliverables Planning activity Becky's Review and Oversight Construction 32 DD-2060 23 24 DD-3010 3 DD-3020 27 CS-1010 2 CX-1010 Planning activity: Construction Decommissioning Planning activity: Decommissioning of old office **PROJECT FINISH MILESTONE" 30 PM-9999 31 NOTE: There are 4 weeks in each month and 5 days in each we SDL Week #12 - Using the above chart: Sheet1 Accessibility: Investigate Type here to search o Introc Successor Duration (days) Resources Hours BAC % Complete EV 0 PM-1010 PM-0000 SS PM-9999 FF Project Manager 225h Planner 75h 220 PM-1020 PM-1030 DD-1010 10 10 Project Manager 20h Reviewers 4 x 2h Project Manager 7h 5 DD-1020 15 DD-1030 DD-2010 10 10 Project Engineer 40h Project Engineer Sh Reviewers 3 x 5h Project Engineer 40h DD-2020 5 5 20 DD-2030 DD-2040 DD-2050 DD-2060 DD-3010 DD-3020 Project Engineer 20h Project Manager 30h Project Manager 25h Project Manager 30h Legal 40h 5 20 o 30 CS-1010 CS-1010 Contractor $60,000 Project Engineer 120h 30 Contractor $160,000 Project Engineer Sih CX-1010 55 PM-9999 CX Engineer 50h 20 0 BAC $ 1 M 1 T V Introduction to Project Management - SDL Week #12 EV Month 1 Month 2 Month 3 Month 4 Sheet1 Accessibility Investigate Type here to search o G DD-2020 DD-2030 DD-2040 DD-2050 Prepare and Issue Requisition - Detail Design Contract Bid Period - Detail Design Contract Conduct evaluation and select Contractor Negotiate Detail Design Contract DD-2060 DD-3010 DD-3020 **AWARD DETAIL DESIGN CONTRACT** MILESTONE Execute - Detail Design Contract Planning activity Contractor Deliverables Planning activity. Becky's Review and Oversight Construction CS-1010 CX-1010 PM-9999 Planning activity Construction Decommissioning Planning activity: Decommissioning of old office **PROJECT FINISH MILESTONE NOTE: There are 4 weeks in each month and 5 days in each week. 16 Points 16 Points 3 Points /35 SDL Week #12 - Using the above chart: Assume all Labour is at $100/hour 1. Calculate BAC for each activity (#hrs x $100) 2. Draw activities in sequence. (colour in the boxes in a logical sequence) 3. Milestones should be respresented as a Black Diamond symbol + Sheet1 Accessibility Investigate Type here to search O RI E Page View Descloper he Sh. H? M - V MO Chane 10 Map Introduction to Proje RAMOWAWCTOS WES/Activame Du end TV FO 1010 PM 20 19 IM 100 Do CD 0001 at Bang OD 100 15 DO 100 0 m Conde Pro 1010 10 DONDE OR Prebermanfaat -2000 DO Credit 10 9 30 STALNO MESTO BO BOLO 2000 0 ICM CE 1010 59 Deco POUR NOTE: There are 4 weeks in each month and 5 days in each week. SOL Week #12 -Using the above chart: TA Sheet BAC type here O it $