Dashboard For Cost of Construction Projects Course
Course Link


Practice

https://www.eloquens.com/tool/xA7AC5E5/finance/construction-excel-templates/excel-dashboard-for-cost-of-construction-and-software-projects



You will learn at this Course as follow
- Most popular KPIs at Project Management which are related (Cost Knowledge Area)
Cost Performance Indicator CPI
Cost variances CV
Earned Value EV
Planned Value PV
Estimated at Completion  EAC
Estimated To Completion ETC
Variance At Completion    VAC
Budget At Completion       BAC

- Cost Accounting Cycle and Definitions
Direct  & Indirect Cost
Percentage of Completion POC Implementation for Project Management & Cost Accounting
Material On Site Treatment with ERP System and without
Backlog
Payment Certificates (Client Invoices)
OPM & GPM

-  Cash Conversion Cycle or Working Capital Funding Gap (WCFG)
Accounts Receivable Turnover - AR Days
Accounts Payable Turnover      - AP Days

- Coding & Supported Sheets
Cost Centers & Internal Codes
Cost Breakdown
Contract Details & Change Orders Tracking
Accumulated Payment Certificates and Details for each Invoice
Additions and Deductions
Validation

- Create Profit Or Loss Statement (P/L)
P/L for Each Project
Consolidated Profit or Loss Statement for All Projects

- Dynamic Dashboard
Quick views into key Performance Indicators (KPIs).
Visual Representation of Projects
Relevant Data only to the Dashboard Objective.  
Predefined Conclusions for the stakeholders .  
Graphs, Pie Charts etc.  
Complicated Functions Vlookups, Sumifs, etc.  


This Course for
- Project Managers & CFOs
- Accountants at Construction and software companies
- Cost Control Engineers
- Cost Accountant
- Budgeting and planning Team

Note: This course is not an Excel Dashboard only but it is a cost journey at construction Companies, You will learn the business cycle at construction firms also and going across this journey to create a good presentation through this Dashboard

You can check more through this Introduction which show you the Full output
https://www.youtube.com/watch?v=WSmAvs_m-v8


Sign in to Google to save your progress. Learn more
Name *
Mobile Number *
Country *
How can you know about this course ? *
Education
Email
Course Introduction
Submit
Clear form
Never submit passwords through Google Forms.
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy