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

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
Get step-by-step solutions from verified subject matter experts
