Skip to main content

How does the "Gross Margin produced per person" widget work?

Updated over 2 weeks ago

What is the purpose of this feature?

This widget allows viewing the Gross Margin production attributed to each user based on the time they actually spent on projects during the selected period.

🎯 Business Objective: Identify individual contributions to overall production and detect discrepancies between the production generated by employees and the total project production (e.g., hosting, equipment, external services).

How does it work?

Bar Chart: Production by Person

The bar chart displays production allocated to each user based on the time they spent on projects during the selected period.

Calculation Method:

Production allocated to each person is calculated using the following formula:

(Valuation of the person's time on the project) / (Valuation of all project times) × Declared project production for the period

💡 Tip: This calculation allows for distributing the project's total production proportionally to the weight of each employee's time.

Concrete Calculation Example

Context:

• Project with declared production over the period: 1,500 €

• Valuation of all project times: 1,000 €

Distribution of Valued Times:

• Adrien

0.3 day on a line at 1,000 €/day = 300 €
• 0.5 day on another line at 800 €/day = 400 €
• Valued time for Adrien = 700 €

• Bruno accounted for the remaining project times valued at 300 €

Calculation of Production Allocated to Adrien:

(700 / 1,000) × 1,500 = 1050 €

Therefore, Adrien is allocated 1050 € of production for the period, while his time valuation represents 700 €. The fact that his allocated production exceeds the valuation of his time reflects that he produced more quickly than planned.

Option: Calculation differentiated by rate card line item

⚠️ For projects with differentiated progress by rate card line, you have two calculation options, configurable in Configuration > Project > General Configuration > Production by person: differentiated by rate card line

No: the calculation is the same as above

Yes: the calculation is similar but is done at the line item level instead of the project level

• Production is calculated per person on each rate card line according to the time spent on that line.
Example: Lena spent 2h and Vincent 3h on rate card line 1, where 500€ of Gross Margin was produced.
Production for Lena: 2 / (2 + 3) * 500 = 200€
Production for Vincent: 3 / (2 + 3) * 500 = 300€

Note: this implies that a line with production but without time spent will not impact any employee's production

Total Based on Time

This total represents the sum of individual productions displayed in the bar chart.

It corresponds to production attributed to users based on the actual time they spent on projects.

💡 Tip: Users with negative production are currently not displayed in this total.

Total Production Period

This total is based on the declared production for the period, regardless of recorded times.

It accounts for the project's overall progress for the given period and represents the total project production, whether or not linked to recorded times.

Difference Between the Two Totals: Why Does It Matter?

The gap between "Total Based on Time" and "Total Production Period" helps identify:

• Productions without associated time: for instance, hosting, equipment, or external services that generate production without any employee logging time.

Understanding the Difference Between Monthly View and Period View

When analyzing Gross Margin production by person, you might observe differences between:

• The sum of an employee's monthly productions

• The production of this employee filtered over a complete period

This difference is explained by the proportional calculation mode of production relative to time spent.

Concrete Example — Etienne's Case

Context: A project generates 3,000 € in total gross margin over the January-February period.

In January:

• Declared project production: 2,000 €

• Etienne logged timesheets on this project

• Production attributed to Etienne in January: 2,000 €

In February:

• Declared project production: 1,000 €

• Etienne did not log any timesheets on this project

• Production attributed to Etienne in February: 0 €

Sum of Etienne's Monthly Productions: 2,000 € (January) + 0 € (February) = 2,000 €

But when you filter over the period from January 1st to February 28th:

• Total project production over the period: 3,000 €

• Etienne has timesheets over this entire period

• Production attributed to Etienne over the period: 3,000 €

⚠️ Attention: Production per person is recalculated globally over the selected period, taking into account the project's total production and the user's times across this entire period. The sum of monthly values might differ from the result obtained when directly filtering over a complete period.

The Objective

The displayed objective corresponds to the average daily cost of the employee multiplied by the number of working days in the analyzed period.

It allows comparing each employee's actual production with their structural cost.

Filters

This widget is filtered by the selected Business Unit on the dashboard filters.

To Go Further

Takeaways

This widget allocates declared project production to collaborators proportionally to the weight of their valued time. The gap between total production and production per person helps identify production sources not linked to time, like equipment, hosting, or external services.

Did this answer your question?