Excel OM Assignment for PROJECT MANAGEMENT Your Excel OM assignment for Project Management is to develop the Gannt Chart for the construction of the Lapenta School of Business building using the project information shown in the table below. Scenario: Iona College decided to build a new School of Business as a result of a major gift of $15 Million from long-time donor, and member of the Legal Board of Trustees, Mr. Robert V. LaPenta (BBA lona 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. Methodology: Using Excel OM, select the Project Management menu option for our textbook and then select the first of the ancillary menu options: "Predecessor List." You will determine the information for the CRITICAL PATH METHOD (CPM) [select the "one time" option*" of Project Management. Requirement: 1) Develop the Gannt Chart for the project 2) Identify the Critical Path to a) Occupancy and b) Completion of the building 3) How long is the Critical Path to a) Occupancy and b) Completion of the building 4) What can be done to shorten the Critical Path? Explain your ideas! The following are the necessary activities to accomplish the mission. \begin{tabular}{|l|l|l|l|l|} \hline Code & Activity & Description & Time (in days) & Immediate Predecessor(s) \\ \hline A & Select Architect & Request for Bids, review by Steering Committee & 21 & None \\ \hline B & Conduct focus group sessions with various constituencies & Get design input & 21 & A \\ \hline C & Conduct soil testing & Prepare soil analysis for design phase and for Permitting & 10 & None \\ \hline D & Steering Committee approval of design & Have the proposed design options reviewed by constituencies & 7 & B, C \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline & Complete the interior of the new building & Ready the interior of the new building for outfitting & 75 & H \\ \hline L & Purchase furniture & Ready the new building for use & 45 & E \\ \hline M & Paint interior spaces & Ready the new building for installation of furniture and office equipment & 30 & N \\ \hline N & Install data highways & IT Department and vendors wire the new building for Information Technology and media & 30 & K \\ \hline O & Develop the occupancy plan & 5 & K \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline Q & Final inspections by Building Department, City of New Rochelle, NY & Obtain Certificate of Occupancy and Certificate of Compliance & M \\ \hline R & Develop a list of unfinished items, items needing repair or items out-of-code & Develop the "Punch List" & 3 & Q \\ \hline S & Occupy the new School & Move the faculty and their various Departments into the LaPenta School of business & 14 & Q \\ \hline T & Execute the "Punch List" & Complete the outstanding items that remain & 14 & R \\ \hline \end{tabular} *Do not select the "three time" option as that is for the PERT Method" Project Management Precedences; 1 time estimate Gantt Chart Results \begin{tabular}{|l|r|r|r|r|r|} \hline Activity & Early Start & \multicolumn{1}{|l|}{ Early Finish } & \multicolumn{1}{l|l|}{ Late Start } & \multicolumn{1}{l|}{ Finish } & \multicolumn{1}{l|}{ Slack } \\ \hline A & 0 & 0 & 0 & 0 & 0 \\ \hline B & 0 & 0 & 0 & 0 & 0 \\ \hline C & 0 & 0 & 0 & 0 & 0 \\ \hline D & 0 & 0 & 0 & 0 & 0 \\ \hline E & 0 & 0 & 0 & 0 & 0 \\ \hline F & 0 & 0 & 0 & 0 & 0 \\ \hline G & 0 & 0 & 0 & 0 & 0 \\ \hline H & 0 & 0 & 0 & 0 & 0 \\ \hline I & 0 & 0 & 0 & 0 & 0 \\ \hline J & 0 & 0 & 0 & 0 & 0 \\ \hline K & 0 & 0 & 0 & 0 & 0 \\ \hline L & 0 & 0 & 0 & 0 & 0 \\ \hline M & 0 & 0 & 0 & 0 & 0 \\ \hline N & 0 & 0 & 0 & 0 & 0 \\ \hline & Project & 0 & & & \\ \hline \end{tabular} A B C D \begin{tabular}{l|l} E & F \\ \hline \end{tabular} G \begin{tabular}{l|l} 1 & J \end{tabular} K L M N P Early start computations Late finish computations