Procurement Planning Excel Template

Table of Contents

Toggle

Procurement Planning Excel Template

Overview:

Procurement is important in project management, the critical part here when you do a construction project is when selecting the seller, supplier or a bidder when you failed on the selection, your entire project is at risk in terms of quality, scope, cost, and schedule.

Procurement Management Plan is another necessary component of the project management plan that addresses the procurement process, including documentation, managing & closure of contracts. This template is often created during the second step in managing construction projects.

Components of the procurement management plan

Stakeholder
Type of Contract
Documentation
Estimate
Schedule
Performance report
WBS
Bonds or Insurances
Assumption and Constraints
Risk

Procurement Planning Excel Sheet

-Procurement planning excel sheet can be used in tracking the procurement of materials

-Procurement planning excel sheet can be used in tracking delivery of materials

Download Link

Source : bibloteka.com

To download Free Project Management Templates you can visit www.managementproject.net

2 Weeks Lookahead Excel Template

Overview:

All Project managers need performance reports for the actual works & two or four weeks lookahead schedule for the future works of their projects. So, Tracking works of a schedule is the next step of preparing it. 4 Week Look Ahead schedules are commonly used in construction & energy industry to recognize what work will be done in the next four weeks.

Lookahead Excel Template schedule excel template teaches you how to successfully plan your project 2,4, or 6 weeks ahead. A look ahead is a perspective of your present project but looking ahead for 2 or 4 or 6 weeks so you filter data date + 2 weeks for a two weeks look ahead, or apply your progress focus and establish it to the weeks you need and you will only focus on the work that must be done for the next 2/4/6 weeks. This can then be specified more if necessary & is mostly applied to plan ahead and ensure you have the necessary tools & equipment and resources to enable the work to happen.

Lookahead Excel Template

-Lookahead Excel Template will help you in the presentation of the lookahead activities

-Lookahead Excel Template is useful for project managers in highlighted the lookahead activities

-Lookahead Excel Template will focus on lookahead schedules activities

Download Link

To download more project management resources please visit www.managementproject.net

Monthly Summary Dashboard Excel Template

Overview:

This Monthly Summary Dashboard Excel Template will help all engineers in creating monthly dashboard reports.

Excel Dashboard Template

Excel dashboards are merely good-looking worksheets that use small charts & tables. Daily, weekly & monthly reporting uses essentially the same process, but with different date formulas.

Before we start building queries, perform a layout review – remember that Excel is a spreadsheet tool that is restricted to rows & columns, and that columns are the same width all the way down the page & rows are the same height across the entire page, so you need to make the layout fit into those constraints. Another consideration is whether the page will need to be printable, which further restricts your design.

This report has a couple of tables of similar contents stacked one over the other & the rest is charts, which provide great flexibility. One concern is that the original report appears to have a square overall shape, which is fine for desktop screen presentation but could be a problem for printing.

Download Link

To download Free Project Management Templates you can visit www.managementproject.net

Construction Project Dashboard Excel Template

Description:

Every project manager needs a predetermined road map for following his/her own and the team’s progress with the project. The team can refer to this document which may be in the form of a spreadsheet. This also helps them follow their targets, keep up with the pace, create projections and assignments. These elements are made available in such a template.

Templates are easily available for free these days. A project manager can find a huge variety of such project management templates and can choose one on the basis of its suitability to the project.

A place where all the mentioned charts can be viewed easily is essential for a project. The project management dashboard provides this platform. This dashboard gives all the information in one single view.

Charts like issues, project budget, project risk, Gantt chart, to do lists are present for a project manager on the dashboard. The project manager can then take a glance at the charts with ease and dive deep into the ones he feels necessary.

The dashboard is applicable or rather essential for all the types of projects. It is, in fact, a must for the project lead to carry out his job with efficiency.

Download Link

To download More Project Management Templates, visit www.managementproject.net

Individual Risk Dashboard (Excel Template)

Table of Contents

Toggle

Individual Risk Dashboard (Excel Template)

Overview:

Risk can’t be eliminated. Organizations, therefore, need to manage all the factors that increase & reduce those risks so that they can pursue a strategic advantage at minimum costs.
This includes risk classification which in turn supports better risk management. In view of the definition of risk as an unfavorable event capable of generating a negative sign deviation from a given expected situation, such as a smaller gain or a big loss.

Risk Dashboard Template

Risk dashboard is very important. They may generate in different areas (risk object, such as corporate processes or function), involve different stakeholders or external contacts & represent different levels of danger. From the risks, that today, worry businesses the most there is, for example, reputational risk a type of transversal risk that may exist in different corporate and governance areas, whose impact is potentially very big. Like the reputational risk many other unfavorable events, capable of threatening the achievement of corporate objectives, extend beyond the company’s individual functions & boundaries, thus tending to become difficult to foresee and monitor.
There is a growth of the phenomenon of different risks, which initially manifest themselves inside certain corporate areas but then have their consequences cascading through many other aspects of the internal & external management of the individual business.

Risk Dashboard :

-This Risk Dashboard is useful for creating a risk management plan

-This Risk Dashboard helps in identifying risks

-This Risk dashboard is highly recommended for project managers, risk analyst, planning engineers

Download Link

To download more project management resources please visit www.managementproject.net

Source: bibloteka.com

Earned Value Management Excel Template

Table of Contents

Toggle

Earned Value Management Excel Template

Overview:

EVM integrates project scope, time & costs through periodic measurements of actual cost & work completion.

It views project progress in terms of cost as a function of time against a firm baseline set up at the project start. When the project is originally planned, it is divided into Work Breakdown Structure (WBS) & further sub-divided into work packages.

These work packages are assessed for cost estimates & scheduled in a time sequence. Taken together, WBS, master schedule & cost budgets form the baseline, represented as a graph of planned costs over time. This is the planned value (PV).

It tells how the costs will flow over time as planned. During the project execution, actual costs (AC) & the quantum of work completed are periodically noted.

Earned value Management Formulas

Completion of work is pro-rated to equivalent monetary value based on the budgetary costs for the work packages completed (work-in-progress packages are assessed on % completion).

This is the earned value (EV). These three numbers, i.e. PV, AC, and EV drive the operation of Earned Value Management. In detail, (EV – AC) measures cost performance and (EV – PV) measures schedule performance. When measuring at periodic intervals, EVM focuses on the flow rates of actual cost and completion against the planned cost and completion.

PV, EV, and AC make it possible to compute cost & time variances, as well as extrapolate how much cost & time would be required for project completion.

Simple calculations based on these numbers yield several ratios for project control. Of these, three ratios can be regarded as important: Cost Performance Index (CPI), Schedule Performance Index (SPI) & Cost Estimate at Completion (CEAC).

By giving historical & forward information about the project, EVM becomes a tool for monitoring & course corrections.

Earned Value Management Excel Template

-This Earned Value Management Excel Template will help you in your project

-This Earned Value Management Excel Template is helpful for creating CPI & SPI

Download Link

Source: bibloteka.com

To download More Project Management Templates, visit www.managementproject.net

PMP Question Bank (1440 Questions)

Overview:

This PMP Question Bank contains 1440 questions and answers, these PMP questions will help you in PMP certification exam preparation. This PMP Question Bank should be used after finishing the PMP exam preparation study.

PMP Question Bank With Answers

Here below sample from PMP Question bank. Download the PDF version for the full PMP question bank.

Question #1

Your developer has provided u with an estimate based on the “cost per line of code”.
What type of estimate did the developer use to provide this information?
A. Parametric estimating.
B. Bottom-up- estimating.
C. Analogues estimating.
D. PERT estimating.

Question #2

A definitive estimate is:
A. Top-down estimating.
B. Created during initiation.
C. Within a range of -10% to +25% of actual.
D. The most expensive to create.

Question #3

All of the following are inputs to the cross-budgeting process expect?
A. cost estimate.
B. project schedule.
C. risk management plan.
Deactivate duration estimates.

Question #4

Analogues estimating is a tool technique used in both Time and Cost management
process. What is the best description of how analogues estimating is performed?
A. by-bottom-up estimating techniques.
B. obtaining management options of the estimate of each task.
C. by-top-down estimating techniques.
D. based on historical costs.

Question #5

Cost budgeting is defined as
A. the estimated total cost of the Project when done.
B. allocating the cost estimates to the individual work items.
C. developing estimates of the cost of the resources needed to complete project activities.
D. the sum of the approved cost estimates.

Question #6

Due to recent company downsizing, u can only authorize 1 of the 2 projects u really
planned to complete this year. You have decided to select the project with the NPV of $95k
and proceed to cancel the other project which had an NPV of $37k what are the
opportunity costs associated with this new decision?
A. $37k
B. $95k
C. $123k
D. $58k

Question #7

Analogues estimating is a form of
A. earned value.
B. expert judgment.
C. cost planning
D. parametric modeling.

Risk Register Example

Overview:

When it comes to project management, understanding risk & knowing how to minimize its impacts (or take full advantage of its opportunities) on your project are essential for success. The Risk Register is important to the management of risk. As risks are identified they should be logged on the register & actions should be taken to respond to the risk.

Risk Managers always try to reduce the likelihood of the risk occurring or the impact if the risk does occur. These responses are documented on the Risk Register & the register should always be reviewed to monitor progress. the Risk Register must be reviewed in every project team meeting. It should certainly be a review at the end of each phase of the project lifecycle. Risk management should be a constant ongoing process with the project team raising risks with the Risk Manager or Project Manager who then logs the risk and identifies actions that can be taken to mitigate the risk. To respond properly to a risk the Risk Manager may need to bring in experts to understand the actions that can be taken to reduce the likelihood of the risk appearing or the impact if the risk does occur.

Download Link

Source: bibloteka.com

Sample CPT Test Result

Description:

The soil classification, i.e. division into categories and subcategories with pertaining symbols enables understanding of mechanical behavior of soil under the influence of load.

Traditionally, soils were divided according to grain size into noncoherent or coarse-grained soils (gravel and sand), and coherent or fine-grained soils (silt and clay). Non-coherent soils are then categorized based on their relative proportion in the total mass of the soil tested, while coherent soils are categorized according to their plasticity properties. The procedure for describing and labeling of soils is called soil classification.

The world’s most widely known and used soil classification is the Unified Soil Classification System (USCS), created through modification of the Airfield Classification System (ACS). Classifications according to the British Soil classification System (BSCS) and the Deutsches Institut für Normung (DIN) are widely used in Europe [6]. Kovacevic and Juric-Kacunic developed the European Soil Classification System (ESCS) for engineering purposes, which makes use of the soil description and symbols in line with the European standard EN ISO 14688-1.

The system is based on soil classification principles prescribed in EN ISO 14688-2. In order to ensure compliance with the European guidelines for soil description and classification, Kovačević et al. placed emphasis on the need to develop information support for the implementation of ESCS and USCS in order to facilitate their parallel use, i.e. on the need to transfer to and adopt the soil classification that is in line with European guidelines.

Download Link

Soil Boring Log Excel Template

Description:

The boring log is the basic record of almost every geotechnical exploration and provides a detailed record of the work performed and the findings of the investigation. The field log should be written or printed legibly and should be kept as clean as is practical. All appropriate portions of the logs should be completed in the field prior to completion of the field exploration.
A wide variety of drilling forms are used by various agencies. The specific forms to be used for a given type of boring will depend on local practice. Typical boring log, core boring log and test pit log forms endorsed by the ASCE Soil Mechanics & Foundations Engineering Committee.

-Topographic survey data including boring location and surface elevation, and benchmark location and datum, if available.
-An accurate record of any deviation in the planned boring locations.
-Identification of the subsoils and bedrock including density, consistency, color, moisture, structure, geologic origin.
-The depths of the various generalized soil and rock strata encountered.
-Sampler type, depth, penetration, and recovery.
-Sampling resistance in terms of hydraulic pressure or blows per depth of sampler penetration. Size and type of hammer. The height of the drop.
-Soil sampling interval and recovery.
-Rock core run numbers, depths & lengths, core recovery, and Rock Quality Designation (RQD)
-Type of drilling operation used to advance and stabilize the hole.
-Comparative resistance to drilling.
-Loss of drilling fluid.
-Water level observations with remarks on possible variations due to tides and river levels.