Revenue and Gross Margin by Project
This page gives an overview of organization’s global Revenue, Cost of Sales and Gross Margin, but it also provides an insight into the split by Project and additional drill-through options by Client by Revenue Type and Month, Resource Entity and Project Details.
At the top of the report, right under the slicer pane there are four card visuals showing the global Revenue, Cost of Sales, Gross Margin and Gross Margin % based on the selection made in the slicer
section.
What company retains after Cost of Sales is covered by Revenue is Gross Margin (GM). Gross Margin % is calculated by dividing GM by Revenue.
Below are three visuals which provide more details on projects:
• Revenue by Project bar chart.
• Table showing Revenue, Cost of Sales, GM and GM% by Project.
• Line and column chart at the bottom, which shows a monthly trend of Revenue, Cost of Sales and GM – either total or for the selected Client, Company Chain or Client Company.
All the visuals are synchronised, which means if you click on one of the projects on the Revenue by Project bar chart or the table next to it, the chart below will automatically re-draw to show monthly trend of Revenue, Cost of Sales and GM related to that project. Other visuals – cards and the table will get updated too.
Each visual can be drilled down to four additional pages in case of External view and three additional pages in case of Inter Company view. The difference is in drill-through page Revenue by Resource Entity which adds value to the user only in the case of External view (shows the structure of external revenue by entities that provided resources).
If you would like to see more details just for a particular project, you should right-click on that project, however, if you would like to see the split for all projects, you should right-click on the Total.
The drill-through pages are explained in Revenue and GM by Client section.
Post your comment on this topic.