The only way I know of to do such a thing would be to add a label for the price per each item (i.e. PricePerCpu, PricePerRAM, PricePerVms, etc) and populate it with that data. After the labels are created and populated, go to the search for * on vms. Next, export the data, and select the attributes and labels you want. Once the results are exported to excel, you will have to multiply out the Price label and the item count in a new field. Hope this helps!
Virtualization Manager's Cloud Cost (EC2) dashboard leverages trends to put together a dshboard that can calculate the cost of your virtual infrastructure on Amazon. Some good references:
- Link to a detailed blog post on how to build chargeback or showback - Creating a Chargeback Dashboard With Virtualization Manager
- Here is the help for trends.
- Below is a sample widget you can see in your Virtualization Manager instance or on online demo. It leverages trends to calculate the actual costs of items over time (see image).
Let me know if you need more help.