Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.

Budgets-Costs-Advances of Projects with Microsoft Excel

Define Scope and Budget scenarios for effective execution control.

0.0
(0 ratings)

Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.

This course will show you how to define Project Activities, resources and Cost. Also how to plan RISKS and how much money could be needed is something occurs during execution. All done with Pivot Tables of Excel. Every project has to have a defined SCOPE. SCOPE has activities , time and resources. The Gantt Chart will show what is the order of precedence of each activity. Resources cost will give the Budget for each Activity and for all the Project.The SCOPE definition using Break Down Structure of Activities is the input for Gantt Chart. The planned Cashflow is got from activities time and resources/cost.

The SCOPE definition using Break Down Structure of Activities is the input for Gantt Chart. The planned Cashflow is got from activities time and resources/cost.

Introduction to Project Scope

09:40

+–

SCOPE

1 Lecture
14:34

The first task of every project is the SCOPE definition. All the involved parts:must agree with the Project Definition and SCOPE. The easiest way to explain the Project definition is with a diagram: The Work Breakdown Structure and the Gannt Chart.

SCOPE

14:34

+–

Time, Resources, Quantity and Costs

1 Lecture
15:44

Each activity will demand resources and quantity. The sum of the budgets of all activities will give the general budget of the project.

Time, Resources, Quantity and Costs

15:44

+–

Cashflow need along the Project

1 Lecture
14:39

The dates of Start and Finish of each activity and the cost for the resources, will give the cash flow need all over the project duration.

Cashflow need along the Project

14:39

+–

Cost Escenarios Modeling

2 Lectures
27:39

Cost Escenarios Modeling

15:48

The scenario modeling for situation a) can be shown on the Excel Worksheet of the Project. On the resources sheet, a new column of cost scenario for every resource can be added. The on the Project Sheet a new column for Modeling will show if we are working on the original budget

Cost Escenarios Modeling II

11:51

+–

Risk Management

2 Lectures
30:11

After the Work Breakdown Structure design explained before, every activity must be analyzed to visualize if there could be not planned events that could affect the project. And if it is the case, what activities are needed to face the problem and delay. Alse what human & materials

Risk Management I

13:41

Risk Management makes possible to see the impact of the need for more cash flow, if the risk affects the project and provision and over costs have to be covered.

Risk Management II

16:30

+–

Execution and Change Control

2 Lectures
33:11

Each bought of material resources and payments to human resources must be recorded on the Activity/Resource pair. This is key to see if the expenses are under budget and the requests for resources corresponds to the actual activity of the project.

Execution and Change Control I

16:26

New requirements has to be documented on Change Control. These requirements consumed human and material resources that were not on the Budget. So this Change Control must be charged to the client. Otherwise it will impact the Project Revenue.

Execution and Change Control II

16:45

+–

Procurement

1 Lecture
05:23

The reason to keep the provider name on every purchase on execution is to have a historical log of costs. With this log, the Purchase Office can do an analysis of the providers that are giving best costs for the project.

Procurement

05:23

+–

Lessons Learned

1 Lecture
08:02

After the project close, it is important to do an analysis on lesson learned, because the Project Documentation will be use for the next proposal to a new project. It can’t repeat the errors and missings.