Table of Contents: Case Study 2: Project Cost Management:.........................................................2 Activity estimates & budget creation (w/cash flow projections)..................2 Part 1: Activity cost estimates:......................................................................2 Part 2: Budget creation (w/cash flow projections):......................................2 Rubrics:..........................................................................................................3 o Hygiene factors ........................................................................................3 2. Part 1: Activity cost estimates... (40%)........................................................3 3. Part 2: Budget creation (w/cash flow projections): (40%)..............................3 Case Study 2: Project Cost Management: Activity estimates & budget creation (w/cash flow projections) Part 1: Activity cost estimates: Using your case study project, make a Cost Estimates in MS Excel, that will be reviewed by the sponsor. You should use the data you earlier created for assignments 1 and 2. If you consider that the earlier activity or Work Package data needs some refinements or modification, you can do that. You should create a list of Control Accounts with appropriate code numbers that will help stakeholders easily identify the Department or the Work Packages. The Estimates should have a clear demonstration of a) Activity Cost Estimates b) Activity Contingency Estimate c) Work Package Contingency Estimate d) Control Accounts Part 2: Budget creation (w/cash flow projections): 1. Using

This document describes a case study on project cost management, with a focus on activity estimates and budget creation with cash flow projections. The case study includes two parts: Part 1 covers activity cost estimates, while Part 2 focuses on budget creation with cash flow projections. The rubrics for the case study include hygiene factors, Part 1 activity cost estimates, and Part 2 budget creation.

Part 1: Activity cost estimates

To complete Part 1 of the case study, students are required to make cost estimates in MS Excel for their selected project, which will be reviewed by the sponsor. The data used in earlier assignments 1 and 2 should be used for this task. If students feel that the earlier activity or work package data needs some refinements or modifications, they are free to do so. Students should make a list of control accounts with appropriate code numbers that will help stakeholders easily identify the department or the work packages. The cost estimates should have a clear demonstration of the following:

a) Activity Cost Estimates b) Activity Contingency Estimate c) Work Package Contingency Estimate d) Control Accounts

Part 2: Budget creation (w/cash flow projections)

Part 2 of the case study requires students to prepare a budget in MS Excel for their selected project, which will be presented to the Board of Directors for approval. The data used in earlier assignments should be used for this task. If students feel that the earlier activity, work package or estimates data needs some refinements or modifications, they are free to do so. The budget should include a management reserve. The distribution of the budget in various heads of accounts should be shown on a pie chart in another sheet. The pie chart should depict information on the percentage distribution of funds among heads of accounts. Additionally, the periodic projected cash flow of the project should be included, as appropriate for the selected case study (quarterly, monthly, weekly, or daily). Students are expected to demonstrate efficient use of MS Excel features, including formulae, cell-referencing, built-in functions, and other features.

Rubrics

The rubrics for the case study include hygiene factors, Part 1 activity cost estimates, and Part 2 budget creation. Hygiene factors refer to the basic requirements for each part of the case study. For Part 1, activity cost estimates account for 40% of the rubrics, while Part 2 budget creation with cash flow projections accounts for another 40%.

In conclusion, this case study provides a practical and comprehensive exercise in project cost management. By completing this case study, students can develop a deeper understanding of activity estimates and budget creation with cash flow projections in a real-world scenario. They can develop practical skills in MS Excel that they can apply in their future careers.

please find the attached case study to answer the above assignment and i request you to help me with this assignment.

Case study 1

Introduction

Constructing a building from the ground up necessitates meticulous planning, organization, and oversight to guarantee a successful outcome. This venture comprises excavating and developing the basement walls at 124 Eglington Avenue West in Toronto, Ontario, estimated to take five months.

The commencement of the project necessitates detailed planning and enforcement of the excavation process to ensure it is safe and meets its deadline. Additionally, the crew must be mindful of the environmental effects of the development work on nearby properties and roads to limit disturbance.

The second phase of the project involves constructing the building walls. For the job to be completed within the set timeframe and budget, there must be a successful collaboration between the project manager, the building team, and all other stakeholders.

Effective project management tactics, such as communication, risk assessment, and backup planning, are essential for successful completion. The project manager will coordinate with the members to ensure that the excavation and building activities are conducted expeditiously, safely, and to the highest standard. With thorough planning and a committed team, the project team is assured of achieving a successful result for this remarkable project.

Activity Definition & Sequencing

Get Approvals

A vital step in project management is to acquire written authorization from stakeholders before any project can progress. The "Get Approvals" process includes displaying project details to stakeholders, which they assess and sign off on before the project can advance. The project manager's skill is tested when gathering timely approvals to ensure the project continues as planned and stays within its allocated budget. As such, successful project managers need to have excellent communication and negotiation techniques.

Plan Engineering

Engineering planning is a core component of project management, entailing the creation of an encompassing engineering plan. This plan outlines essential needs, regulations, details, construction, and sources while coordinating with the project director, engineering squad, and interested parties to guarantee the successful realization of project aims and ambitions. Furthermore, it outlines the budget, timeframe, quality control, and preventive measures.

Procure Equipment

A crucial aspect of project management is the procurement of materials and equipment, and the process is both intricate and critical to success. Project managers must be adept at recognizing the right equipment, assessing supplier options, making competitive price comparisons, ensuring quality and adhering to regulatory guidelines, all while staying within timeline and budget. Additionally, good communication and negotiation are imperative to carry out the process successfully.

Procure Labour

To effectively complete a project, the necessary personnel must be acquired, which involves recognizing the specific capabilities and qualifications required, announcing job openings or delivering requests for proposals, interviewing and choosing potentials, discussing compensation and advantages, and controlling the labour throughout the project's lifetime. Skilful labour procurement is essential to the success of a project since it guarantees that the right competencies are obtained to conclude the project in time, under budget, and to the predetermined quality criteria. The project manager must possess excellent human resource management expertise to secure the ideal personnel for the project.

Construction

Project management in construction requires the physical development of a structure or facility as outlined in the plan. It includes initial steps such as ground preparation, excavation, and setting up the foundations, as well as subsequent operations such as installing mechanical and electrical systems and completing the project. Proper construction management is paramount to ensure the job is done within the specified timeframe, budget and quality criteria. For this, it is essential to have a comprehensive knowledge of construction practices, materials and techniques. Coordinating with other stakeholders is necessary to reach the overarching project objectives.

Completion

When a project is finalized, all objectives must have been reached. All deliverables must have been given and accepted by the project's sponsor or customer. This calls for all tasks to be accomplished, inspections, tests and approvals, and all related paperwork to be finalized and passed over. This marks the end of the project and is followed by steps such as compiling reports, assessment, and filing of project documents. Successful project completion is vital for accomplishing expected outcomes and attaining the project's objectives.

Summary or Background Information

The construction industry is a highly complex arena requiring careful organization, management, and planning to achieve successful project completion. This specific task requires the excavation and erection of the basement walls of a new building on 124 Eglington Avenue West in Toronto, Ontario, with an estimated completion period of 5 months.

In the first phase of this project, thorough preparation for the foundation must be done through excavation. In doing so, planning is vital to ensure a safe and timely execution. Additionally, the environment, such as buildings and roadways, must be considered to minimize disruption to the local area. After completion of the excavation, the second step is constructing the walls of the building. A successful outcome necessitates meticulous collaboration between the project manager, the construction team, and other related stakeholders to remain within the time and cost limits.

The venture's success relies on effective project management methods, including communication, risk evaluation, and backup planning. Consequently, the project manager must work closely with all participants to ensure the work is done satisfactorily within the allocated timeline and budget. Using the most effective techniques in project management, we can guarantee that the excavation and construction of the basement walls of 124 Eglington Avenue West will be conducted safely, efficiently, and to the highest standards.

WBS

Activity List

1 Get Approvals

1.1 Get construction permits -Obtain the necessary approvals to begin construction work. 1.2 Get no objection approval from the municipality -Obtain the necessary permissions from the city to begin construction work.

2 Plan engineering 2.1 Decide shape, materials, anddimensions - Determine the building's required form, materials, and measurements be constructed. 2.2 Plan excavation process -Plan the excavation process, considering safety, time, and cost factors. 2.3 Plan construction process -Plan the construction process, considering safety, time, and cost.

3 Procure equipment

3.1 Select vendor for machinery -Identify and select a vendor who can provide the required machinery. 3.2 Select a vendor for construction materials- Identify and select a vendor who can provide the required construction materials. 3.3 Procure machinery -Obtain the necessary machinery for the construction work. 3.4 Procure construction materials -Obtain the necessary construction materials for the construction work.

4 Procure Labour 4.1 Excavators -Procure labor in the form of excavators. 4.2 Masons -Procure labor in the form of masons. 4.3 Polish Crew -Procure labor in the form of a polishing crew.

5 Construction 5.1 Clearing and levelling -Clear and level the construction site before beginning any construction work. 5.2 Excavate to a depth -Dig to the required depth to lay the foundation of the building. 5.3 Footings and Support Structure -Construct the footing and support structure of the building. 5.4 Pour concrete -Pour concrete to construct the walls and floors of the building. 5.5 Dry Wall -Install drywall to partition rooms or create a false ceiling. 5.6 Polish Wall - Polish the walls of the building for a finished look.

6 Completion 6.1 Remove Equipment -Remove all machinery and equipment from the construction site. 6.2 Cleaning -Clean the construction site after the work is completed. 6.3 Formal closure -Formally close the project by obtaining the necessary signoffs and approvals.

Activity Sequencing/Relationship

Note:Start-to-Start (SS): This relationship means that an activity's start depends on the beginning of another action. The most seen type of dependency relationship in project management is Finish to Start (FS). This implies that the second task cannot begin until the first task has been fully completed. As an example, the walls of a building can only be constructed once its foundation is finished.

Network diagram

Project Roles (Team Members):

Mehul Pahuja:As the project manager, it is Mehul's responsibility to construct the project plan, oversee the execution of the project, and make sure it is done within the assigned timeline and budget.

Azhar Nazir:Azhar Nazir is responsible for making and monitoring the project's advancement. He is required to guarantee that the project continues as planned and that any diversions from the plan are distinguished and taken care of quickly.

Ojas Arora:As the individual accountable for arranging and managing the project, Ojas' roles incorporate forming the project range, budget, and schedule. He likewise oversees the everyday exercises of the project and ensures the project is finished successfully.

Sachin Borra:Sachin is responsible for dealing with any issues during the project. He should distinguish cases, investigate the fundamental driver, and plan and actualize solutions.

Lakpa Singhi Sherpa:Lakpa is liable for arranging and developing the project. He will work near the project manager to ensure the project is executed as planned and any issues are quickly resolved.

Zhia Dupitas:As the individual responsible for controlling the team, Zhia is liable for guaranteeing that team members are allocated tasks, given the essential assets, and spurred to finish their work to the most elevated expectations.

Venkata Naga Sai Sri Krishna Sameer Popuri:Sameer guarantees that stakeholders and customers are fulfilled. He will collaborate with the project team to comprehend the stakeholders' necessities and ensure that they are met during the whole lifecycle of the project.

Reference List:

Team Members' Discussion: The information gathered from our discussions was used extensively throughout this project to inform our decisions and recommendations. The ideas and insights shared by our team members were valuable in shaping the direction of our project.

• Internet Sources:We consulted several internet sources for this project, including: Project Management Institute (PMI) website. (https://www.pmi.org/)
• Presentation from Class:We used the presentations delivered by our instructor during the project to supplement our knowledge and understanding of project management tools and techniques. The presentations provided valuable insights on various project management topics, such as Agile methodology, risk management, and project scheduling.