Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Dimitris_Kats
Helper V
Helper V

Optimal Stuffing Levels

Dear memebers hi.

 

Since this forum is full of data analyst and data scientists I would like to ask you if anyone can help me calculate the optimal number of employees based on financial data and based on the industry.

 

Is there any model or kpis or metrics or something I could use to determine if the company is overstaffed??

 

Thank you in advanced!!

1 ACCEPTED SOLUTION
technolog
Super User
Super User

@Dimitris_Kats it's wrong place for you question, because it's DAX part of forum, anyway:
if you're looking to determine the optimal number of employees based on financial data, one of the most straightforward ways is to look at the revenue per employee. This metric gives you an idea of how much each employee contributes to the company's revenue. By comparing this number with industry benchmarks, you can get a sense of whether you're overstaffed or understaffed. If your revenue per employee is significantly lower than the industry average, it might indicate that you have too many employees for the amount of revenue being generated.

Another metric to consider is the profit per employee. This is similar to revenue per employee but takes into account the company's expenses. A declining profit per employee over time might suggest inefficiencies in staffing.

Also, consider looking at the operating expense ratio, which is the operating expenses divided by the total revenue. If this ratio is higher than the industry average, it might indicate that the company's operational costs (including salaries and wages) are too high relative to its revenue.

But remember, these metrics are just starting points. There are many factors that can influence these numbers, such as the company's growth phase, market conditions, and specific industry nuances. It's also essential to consider non-financial metrics like employee satisfaction, turnover rates, and productivity levels. An overstaffed company might have low employee morale because workers feel underutilized, leading to higher turnover rates.

Lastly, if you're really looking to dive deep, you might want to consider building a predictive model using historical financial data. This could help forecast the impact of hiring or letting go of employees on future financial performance. But that's a more complex route and might require some expertise in data modeling.

View solution in original post

3 REPLIES 3
technolog
Super User
Super User

@Dimitris_Kats it's wrong place for you question, because it's DAX part of forum, anyway:
if you're looking to determine the optimal number of employees based on financial data, one of the most straightforward ways is to look at the revenue per employee. This metric gives you an idea of how much each employee contributes to the company's revenue. By comparing this number with industry benchmarks, you can get a sense of whether you're overstaffed or understaffed. If your revenue per employee is significantly lower than the industry average, it might indicate that you have too many employees for the amount of revenue being generated.

Another metric to consider is the profit per employee. This is similar to revenue per employee but takes into account the company's expenses. A declining profit per employee over time might suggest inefficiencies in staffing.

Also, consider looking at the operating expense ratio, which is the operating expenses divided by the total revenue. If this ratio is higher than the industry average, it might indicate that the company's operational costs (including salaries and wages) are too high relative to its revenue.

But remember, these metrics are just starting points. There are many factors that can influence these numbers, such as the company's growth phase, market conditions, and specific industry nuances. It's also essential to consider non-financial metrics like employee satisfaction, turnover rates, and productivity levels. An overstaffed company might have low employee morale because workers feel underutilized, leading to higher turnover rates.

Lastly, if you're really looking to dive deep, you might want to consider building a predictive model using historical financial data. This could help forecast the impact of hiring or letting go of employees on future financial performance. But that's a more complex route and might require some expertise in data modeling.

@technolog thank you very much!

 

This is really helpful. To be honest I have already calculated all of  the above metrics and I was looking a way to build the predictive model you mentioned. I would be grateful if we could discuss it further or if you could give me guidance. 🙏

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors