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.
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.
Each activity will demand resources and quantity. The sum of the budgets of all activities will give the general budget of the project.
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.
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
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 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.
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.
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.
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.
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.
I do process and quality control using statistics. The data entry for data analysis is done with mobile software developed by my company, SD METRICS.
Expert in Geographical Information Systems, Logistics and data acquisition with mobile and using Google Maps API.
Cross platform development for Android, Windows Mobile and Iphone with HTML5 and JSONP with webservices and Database on the Cloud (PHP, MYSQL).