BMATWT 353 - Asn. 3 Scheduling

Assignment 6 - Scheduling II

Assignment 6 - Scheduling II

Due: Thursday, March 6

In-Class we began the Project Scheduling assignment involving the critical path method.

Complete this assignment including:

1) During class you handed in a sketch of the network of events in logical sequence. Asn. 5 Scheduling I.

2) Open the Projsch0.xls EXCEL spreadsheet. PLEASE RENAME (SaveAs) the spreadsheet with some abbreviation of your name "DAVED-A4.xls" for example.

Depending on your version of EXCEL you may get an error message asking you to disable or enable MACROS. Select Enable MACROS.

3) For each task that is listed input the durations and dependence on preceding events. For example, the first task "Recv Purch O" has zero duration, so you can enter zero. The second task "SHIP" has a duration of 2 days and can only begin once the PO has been received. You can force this dependency by making the Start Date for SHIP the same as the End Date for "Recv Purch O". You do this by "linking" the Start Date Cell for SHIP D8 with the End Date cell for "Recv Purch O" F7. You do this by placing the following formula in cell D8, =F7. For multiple dependencies use the MAX function. For Example, the Task Complete Electrical Wiring, labeled Install Elec is dependent on three tasks, Install Drive, Procure Elec. and Lift BM. Here is the formula which will set the start Date for Install Elec to the latest of these three tasks, =MAX(F10,F19,F21)

3)What is the earliest time we can complete installation of the bandmill?

4) Identify the critical path, you should print out the Excel Spreadsheet and highlight the tasks that form the critical path. (Hand this Sheet in)

5) If we reduce the time required to Procure the drive syste, "Proc Motor" from 14 days to 10 days, how does this impact the time to complete the installation?

6) Can you tell if anything happens to the critical path?

7) Reset the "Proc Motor" duration to 14 Days. Now reduce the Order Crane Duration from 7 to 4 days. What happens to the time to completion?

8) Now reduce the "Proc Motor" duration from 14 to 10 days again. What happens to the time to completion?

9) Can you explain?

Please hand in a sheet showing a printout of your completed spreadsheet, with answers to the questions above.

Many of the materials created for this course are the intellectual property of the instructor. This includes, but is not limited to, the syllabus, lectures and course notes. Except to the extent not protected by copyright law, any use, distribution or sale of such materials requires the permission of the instructor. Please be aware that it is a violation of university policy to reproduce, for distribution or sale, class lectures or class notes, unless the faculty member has explicitly waived copyright. Copyright 2008, David T. Damery

BMATWT 353 - Business of Building

Home
Course Syllabus
Assignments
Readings

Lectures
Contact

Schedule

BMATWT Home
BMATWT Courses

Assignment 6 - Scheduling II

Due: Thursday, March 6

In-Class we began the Project Scheduling assignment involving the critical path method.

Complete this assignment including:

1) During class you handed in a sketch of the network of events in logical sequence. Asn. 5 Scheduling I.

2) Open the Projsch0.xls EXCEL spreadsheet. PLEASE RENAME (SaveAs) the spreadsheet with some abbreviation of your name "DAVED-A4.xls" for example.

Depending on your version of EXCEL you may get an error message asking you to disable or enable MACROS. Select Enable MACROS.

3) For each task that is listed input the durations and dependence on preceding events. For example, the first task "Recv Purch O" has zero duration, so you can enter zero. The second task "SHIP" has a duration of 2 days and can only begin once the PO has been received. You can force this dependency by making the Start Date for SHIP the same as the End Date for "Recv Purch O". You do this by "linking" the Start Date Cell for SHIP D8 with the End Date cell for "Recv Purch O" F7. You do this by placing the following formula in cell D8, =F7. For multiple dependencies use the MAX function. For Example, the Task Complete Electrical Wiring, labeled Install Elec is dependent on three tasks, Install Drive, Procure Elec. and Lift BM. Here is the formula which will set the start Date for Install Elec to the latest of these three tasks, =MAX(F10,F19,F21)

3)What is the earliest time we can complete installation of the bandmill?

4) Identify the critical path, you should print out the Excel Spreadsheet and highlight the tasks that form the critical path. (Hand this Sheet in)

5) If we reduce the time required to Procure the drive syste, "Proc Motor" from 14 days to 10 days, how does this impact the time to complete the installation?

6) Can you tell if anything happens to the critical path?

7) Reset the "Proc Motor" duration to 14 Days. Now reduce the Order Crane Duration from 7 to 4 days. What happens to the time to completion?

8) Now reduce the "Proc Motor" duration from 14 to 10 days again. What happens to the time to completion?

9) Can you explain?

Please hand in a sheet showing a printout of your completed spreadsheet, with answers to the questions above.

HOME | COURSE SYLLABUS | ASSIGNMENTS
READINGS | LECTURES | SCHEDULE | DAVE DAMERY

Produced and maintained by David T. Damery
Building Materials and Wood Technology
Department of Natural Resources Conservation
College of Natural Resources and the Environment
University of Massachusetts, Amherst.