Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Organisational Behaviour In The Workplace

Authors: Jacqueline Mclean, Laurie Mullins

12th Edition

1292245484, 978-1292245485

Students also viewed these Mathematics questions