Question
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
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:
- Draw the project network for the new LaPenta School of Business
- Identify the Critical Path to:
- Occupancy?
- Completion of the building?
- How long is the Critical Path to:
- Occupancy?
- Completion of the building?
- What can be done to shorten the Critical Path? Explain your ideas!
With Excel OM:
- Develop the Gantt Chart for this project
- 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!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started