Question: please solve in excel and show step by step Q2. (15 points) Grand River Construction Company (GRCC) located in Brantford, Ontario has a construction budget

please solve in excel and show step by step

please solve in excel and show step by step Q2. (15 points)

Q2. (15 points) Grand River Construction Company (GRCC) located in Brantford, Ontario has a construction budget to build a new clubhouse for the Brantford Harlequins Rugby Club. GRCC uses both union and non-union workers. Levelling and grading of land, electrical wiring and plumbing work is contracted out to union workers. The actual construction of the project, though supervised by union carpenters, is performed by mainly non-union laborers (including volunteers) to reduce costs. Project planning has produced the following chart. Immediate Expected Completion Predecessors Time (Days) A Grade land 3 Order building supplies 4 Hire nonunion labor - 7 Pour concrete slab A 8 Receive/organize supplies B 8 Build clubhouse frame C, D, E 30 G|Electrical installation F 15 H Plumbing installation F 11 I Stucco/paint exterior H 20 J Dry wall/paint interior G, H 18 K Finish/cleanup I, J 6 L Landscaping K 8 a. Draw a PERT/CPM network for this problem. b. Prepare a chart showing the earliest/latest start and finish times and the slack for each activity. What is the expected completion time for the rugby club project? c. What is the impact of a delay of 1 day in the pouring of the concrete slab? d. On Day 42, what is the priority of jobs? If there were some cross -trained electrician- plumbers, what might be a good decision? e. What is the impact of building the clubhouse 3 days early? f. What is the priority of job at the start of the project? Why? g. On Day 58, what is the priority of jobs? Why

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!