Catalog Items
Analyses Folder
The Catalog folder \\Public\Meridium\Modules\LCC\Analyses contains individual cost data queries for each analysis created in a database.
Dashboards Folder
The Catalog folder \\Public\Meridium\Modules\LCC\Dashboards contains the following items.
| Item Name | Behavior and Usage |
|---|---|
| LCC Dashboard | A dashboard featuring information related to Life Cycle Cost Analysis. |
Graphs Folder
The Catalog folder \\Public\Meridium\Modules\LCC\Graphs contains the following items.
| Graph Name | Behavior and Usage |
|---|---|
| Life Cycle Performance - Highest IRR Scenario for Each Analysis | Graph for the LCC Overview dashboard. This graph shows the Total Cost of Ownership, Net Present Value, and Internal Rate of Return of the top 10 LCC Scenarios with the highest NPV of all LCC Scenarios with the highest IRR within a LCC Analysis. |
| Life Cycle Performance - Highest NPV Scenarios | Graph for the LCC Overview dashboard. This graph shows the NPV of the top 10 LCC Scenarios with the highest NPV of all LCC Scenarios. |
Queries Folder
The Catalog folder \\Public\Meridium\Modules\LCC\Queries contains the following items.
| Query Name | Behavior and Usage |
|---|---|
| AnalysisTileQuery | Returns a list of LCC Analyses. This query is used to generate the list of LCC Analyses that is displayed on the LCC Overview page. |
| Capital Cost Breakdown vs Sequence Name | Used to generate the Capital Cost Breakdown chart on the LCC Overview page. |
| Capital Cost vs Sequence name | Used to generate the Capital Cost chart on the LCC Overview page. |
| Cash Flow vs Sequence name | Used to generate the Cash Flow chart on the LCC Overview page. |
| Cost Data Query | Used to collect all of the data in the cost data grid. |
| Depreciated Values vs Sequence Name | Used to generate the Depreciated Value chart on the LCC Overview page. |
| Example - Labor Cost by Year and Name | Sample query that returns the labor cost by year and resource name for a selected analysis and scenario. |
| Example - Resource Cost by Year and Name | Sample query that returns the resource cost by year and resource name for the selected analysis and scenario. |
| Example - Total Costs by Year | Sample query that returns the total cost by year and resource name for the selected analysis and scenario. |
| Get Cost Details for Scenario | Returns all LCC Cost records in a LCC Scenario. The APM system uses this query when copying an LCC Scenario. |
| Get Cost Value Details from Scenario | Returns all LCC Cost Value records in a LCC Scenario. The APM system uses this query when copying LCC Scenario. |
| Get Element Details for Scenario | Returns all LCC Element records in a LCC Scenario. The APM system uses this query when copying an LCC Scenario. |
| Get Period Details for Scenario | Returns all LCC Period records in a LCC Scenario. The APM system uses this query when copying an LCC Scenario. |
| IRR Query | Returns the Total Cost of Ownership, NPV, and IRR of the top 10 LCC Scenarios with highest NPV of all LCC Scenarios with highest IRR within an LCC Analysis. This query is used to generate data for the Life Cycle Performance - Highest IRR Scenario for Each Analysis section on the LCC Dashboard. |
| IRR Query dependency | Returns the Total Cost of Ownership, NPV, and IRR of all LCC Scenarios with highest IRR among those within an LCC Analysis. This query is used as a sub-query of the IRR Query query. |
| LCC Dashboard Graph Query - NPV with ACC and NA | Returns the NPV of the top 10 LCC Scenarios with highest NPV of all LCC Scenarios. |
| LCC Page Filter | This query is used to generate the page filter on the LCC Overview page. |
| LCC Resource List Query |
Returns a list of LCC Resources. This query is used to generate the list of LCC Resources on the LCC Overview page. |
| Operating Cost Breakdown vs Sequence Name stacked | Operating Cost Breakdown chart in LCC Overview page. |
| Operating Cost vs Sequence Name | Used to generate the Operating Cost chart on the LCC Overview page. |
| Present Value Vs Sequence Name | Used to generate the Present Value chart on the LCC Overview page. |