PJC Categories
The data model encompasses estimates, actuals, and financial metrics related to project tasks or categories, including original and current estimates for quantity, revenue, and cost, total actual quantities and costs, reporting currency conversions, project profit, budget variances, and profit breakdown by category. Views include Category Listing, Contract Costs by Cost Class, and Profit by Category, enabling comprehensive analysis and comparison of financial performance across project categories.
Benefits of This Data Model
- Enhanced Financial Performance Analysis: The data model allows for detailed analysis of project financial metrics such as profit breakdown by category, budget variances, and project profit, enabling better decision-making and performance evaluation.
- Cost Class Insights: The Contract Costs by Cost Class view provides a breakdown of total contract costs by cost class, offering valuable insights into where expenses are being allocated within projects.
- Comprehensive Category Overview: The Category Listing view presents a comprehensive list of all project categories, facilitating easy reference and understanding of the project landscape for stakeholders.
- Improved Profit Analysis: The Profit by Category view showcases profits generated by each category, enabling comparative analysis of financial performance across different project categories, aiding in identifying lucrative areas.
Key Performance Indicators (KPIs)
- Original Estimate Quantity: The initial quantity estimated for a project task or category.
- Original Estimate Revenue: The initial revenue estimated for a project task or category.
- Original Estimate Cost: The initial cost estimated for a project task or category.
- Current Estimate Quantity: The current quantity estimate for a project task or category.
- Current Estimate Cost: The current cost estimate for a project task or category.
- Current Estimate Revenue: The current revenue estimate for a project task or category.
- Total Actual Qty.: The total actual quantity consumed or used for a project task or category.
- Total Actual Cost: The total actual cost incurred for a project task or category.
- Reporting Currency Current Estimate Cost: The current estimated cost of a project task or category in the reporting currency.
- Reporting Currency Current Estimate Revenue: The current estimated revenue of a project task or category in the reporting currency.
- Reporting Currency Total Actual Cost: The total actual cost of a project task or category in the reporting currency.
- Reporting Currency Total Actual Revenue: The total actual revenue of a project task or category in the reporting currency.
- Reporting Currency Project Profit: The project profit calculated in the reporting currency.
- Total Actual Revenue: The total actual revenue generated for a project task or category.
- Cost Budget Over/Under: The variance between the budgeted cost and actual cost - whether over or under budget.
- Cost Budget %: The percentage difference between the budgeted cost and actual cost.
- Project Profit: The profit generated by a project task or category.
- Project Budget: The budget allocated for a project task or category.
Available Visualizations
| View Name | Description |
|---|---|
| Category Listing | Displays a list of all categories available in the PJC system for easy reference. |
| Contract Costs by Cost Class | Breaks down total contract costs by cost class, providing insights into where expenses occur. |
| Profit by Category (List) | Shows profits generated by each category, facilitating comparison and analysis of financial performance. |