Back to Mavenlink.com Blog Tour Status

Insights: Margin & Cost Dashboard

Available in: Enterprise and Premier

Overview

The Margin & Cost dashboard reveals business-critical information, such as your organization's profit and loss down to the project-level. This information can help determine whether a project is worth continuing.

The standard Margin and Cost tabs are, in order from most to least used:

 

T&M Margin Contribution

The Time and Materials (T&M) Margin Contribution tab contains reports that show a month-by-month breakdown of each time and materials project by fees, cost, and margin. Note that non-billable expenses are treated as a cost against the project. insights-resourcing-margin-cost-time-materials-monthly.png

 

The Margin Table: T&M table shows two important things: the complete to-date margin for each project with Time & Materials tasks (or time applied without a task), and the fees and costs for the for the life of the project. Since the Date filter is ignored in this table, the rollup margin may differ from the headline margin. 

ingsights-margin-cost-margin-time-materials-table.png

 

Project Margin at Completion (Project Budget Method)

The Project Margin at Completion (Project Budget Method) tab is helpful if your business is primarily a fixed fee business. You get a breakdown of project cost to date and Estimate at Completion (EAC) cost, or what has already been spent and is expected to be spent by the time the project is complete.

The Fee and Cost Burn Against Budget: Project Level graph gives you a visual representation of all of your project's margins, which can help you reveal potential issues early. insights-margin-cost-project-budget-method-fee-cost-burn.png

Use the Project Based EAC Margin table to see your EAC cost and margin. insights-margin-cost-project-based-eac-margin-table.png

 

Fixed Fee

Reports in the Fixed Fee Margin Contribution to Date tab provide a monthly cost-to-date breakdown so you can quickly see the fixed fee revenue vs. the burn vs. the cost all in one graph.

The dates for the Monthly Burn vs. Budget: Fixed Tasks and Completed Fixed Fee Tasks - Earned (by Complete Date) graphs are independent, meaning you can change the date range for one without impacting the other. This is useful for calculating your revenue recognition.

The Monthly Burn vs. Budget: Fixed Tasks graph compares the cost incurred on all fixed fee tasks during a specified month to the value of tasks due during that month. insights-margin-cost-fixed-fee-monthly-burn-budget.png

The Completed Fixed Fee Tasks - Earned (by Complete Date) graph displays the earned value of tasks completed (task budget in the month completed), and all costs and fees incurred on completed tasks, regardless of the month incurred. In other words, if you have a task that was worked on in April and May, but it wasn’t marked as complete until July, the full cost of the task appears for July.insights-margin-cost-fixed-fee-completed-fixed-fee-earned.png

Use the Fixed Fee Tasks (Completions and In-Process) table to see total budgets rolled up from all fixed fee tasks, the value of budgets on completed tasks, and all costs accumulated to date. insights-margin-cost-fixed-fee-completions-in-process.png

 

Resource Schedule Method

The Resource Schedule Method looks at cost-to-date and the projected cost from resources scheduled on tasks. Use this equation to calculate your resource schedule cost:  margin-and-cost-resource-scheduled-equation.svg

Then you can find your margin for the Resource Schedule Method with this equation: margin-and-cost-margin-equation.svg

Reports in the Projected Margin at Completion (Resource Schedule Method) tab provide a visual comparison of the project budget over time. Use the Fee and Cost Burn Against Budget: Project and Task graph to see fees and cost-to-date. insights-margin-cost-resouce-schedule-method.png

 

The Actual + Schedule Method table shows projected margins based on actual and scheduled hours. This lets you see how project budgets compare against a roll-up of budgets from each task. insights-margin-cost-resource-schedule-actual-schedule-table.png

 

Resource Allocation Method

The Resource Allocation Method calculates the margin based on the project-level budget. The method looks at cost-to-date and the projected cost from resources allocated in the future. Your resource allocation cost is calculated using this equation:  margin-and-cost-resource-allocation-equation.svg

Then you can find your margin for the Resource Allocation Method using this equation: margin-and-cost-margin-allocation-equation.svg

The Project Margin at Completion (Resource Allocation Method) tab is a mirror view of the Resource Scheduled Method tab with one important difference: projected costs and fees are calculated using allocated hours, not scheduled hours. insights-margin-cost-resource-allocation-method.png

 

Percent Complete Method

The Percent Complete Method looks at cost-to-date and the projected cost, calculated via manual percent complete entries on each task. Percent complete for tasks is found in the display drop-down in Task TrackerTask Progress.

Use this equation to calculate your percent complete cost:margin-and-cost-percent-complete-equation.svg

Then you can find your margin for the Percent Complete Method using this equation:

margin-and-cost-margin-percent-complete-equation.svg

The Project Margin at Completion (Percent Complete Method) tab contains reports that show a roll-up of margins to the project from task-level calculations. insights-margin-cost-percent-complete.png

 

Related Articles:

Standard Dashboards

Step-by-Step:

Created on