Your Excel OM assignment for Project Management is to verify and confirm your hand-calculations and network diagram.

Scenario: Iona College decided to build a new School of Business as a result of a major gift of $15 long-time donor, and member of the Legal Board of Trustees, Mr. Robert V. LaPenta (BBA Iona in Accounting). Mr. LaPenta donated an additional amount that had to be matched by donations from other individuals. Mr. LaPenta's combined donations of $17.5 million plus the $2.5 million match enable the College to have $20 Million of the required amount with which to build the new School of Business facility. Gensler Architectural firm was engaged to design the building which, by focus group sessions with alumni, faculty, students, administrators and staff employees and other constituents, had to include the old building and the clock tower and gold dome. The following are the necessary activities to accomplish the mission.

Code	Activity	Description	Time (in days)	Immediate Predecessor(s)
A	Select Architect	Request for Bids, review by Steering Committee	21	None
B	Conduct focus group sessions with various constituencies	Get design input	21	A
C	Conduct soil testing	Prepare soil analysis for design phase and for Permitting	10	None
D	Steering Committee approval of design	Have the proposed design options reviewed by constituencies	7	B, C
AND	Apply for Permits from the City of New Rochelle and gain approvals to proceed	Obtain approvals to construct the new Building as designed	365	D
F	Order building materials	Prepare for construction	90	AND
G	Excavation of the front of Hagan Hall	Prepare the property for construction	180	AND
H	Strip Hagan Hall interior	Ready Hagan Hall for incorporation in the new design	60	AND
I	Extend exterior windows in basement of Hagan Hall	Ready front of Hagan Hall for inclusion in the new design	20	G
J	Construct the new portion of the La Penta School of Business	Ready the exterior of the new building	75	G
K	Complete the interior of the new building	Ready the interior of the new building for outfitting	75	H, I
L	Purchase furniture	Ready the new building for use	45	AND
M	Paint interior spaces	Ready the new building for installation of furniture and office equipment	30	N
N	Install data highways	IT Department and vendors wire the new building for Information Technology and media	30	K
O	Faculty, administrators and staff select their offices spaces	Develop the occupancy plan	5	K
P	Install furniture and office equipment	Prepare for occupancy	10	L, M
Q	Final inspections by Building Department, City of New Rochelle, NY	Obtain Certificate of Occupancy and Certificate of Compliance	7	M
R	Develop a list of unfinished items, items needing repair or items out-of-code	Develop the "Punch List"	3	Q
S	Occupy the new School	Move the faculty and their various Departments into the LaPenta School of business	14	Q
T	Execute the "Punch List"	Complete the outstanding items that remain	14	R

Using the CRITICAL PATH METHOD (CPM) of Project Management,

By hand:

2. Draw the project network for the new LaPenta School of Business
4. Identify the Critical Path to:
6. Occupancy?
8. Completion of the building?
10. How long is the Critical Path to:
12. Occupancy?
14. Completion of the building?
16. What can be done to shorten the Critical Path? Explain your ideas!

With Excel OM:

2. Develop the Gantt Chart for this project
4. Confirm/Verify your Critical Path hand-calculations

HINT: DON'T FORGET THAT YOU NEED A "DUMMY NODE (NO TIME)" FOR THE STARTING POINT OF YOUR NETWORK DIAGRAM!