What formulas to use to work out the following questions

  • Context: MHB 
  • Thread starter Thread starter JimBobBrown
  • Start date Start date
  • Tags Tags
    Formulas Work
Click For Summary
SUMMARY

This discussion focuses on calculating the number of employees and full-time employees based on total revenue and revenue per employee metrics for the years 2007 to 2010. The key formulas used are: Revenue per Employee = Total Revenue / Number of Employees and Revenue per Full-Time Employee = Total Revenue / Number of Full-Time Employees. For 2010, using the total revenue of $63.31 billion and revenue per employee of $175,300, the number of employees is calculated to be 158,275. For 2008, using the total revenue of $63.31 billion and revenue per full-time employee of $224,700, the number of full-time employees is approximately 281,753.

PREREQUISITES
  • Understanding of basic financial metrics such as total revenue and revenue per employee
  • Familiarity with algebraic equations for calculating ratios
  • Knowledge of financial reporting years and their significance
  • Ability to perform division and interpret large numbers in financial contexts
NEXT STEPS
  • Learn how to calculate employee metrics using financial statements
  • Explore advanced financial ratios and their implications for business analysis
  • Research the impact of employee productivity on overall company performance
  • Study the differences between full-time and part-time employee metrics in financial reporting
USEFUL FOR

Financial analysts, business managers, and anyone involved in workforce planning and performance analysis will benefit from this discussion.

JimBobBrown
Messages
3
Reaction score
0
[table="width: 500, class: grid"]
[tr]
[td][/td]
[td]2007[/td]
[td]2008[/td]
[td]2009[/td]
[td]2010[/td]
[/tr]
[tr]
[td]Total revenue
($1,000 million)[/td]
[td]60.05[/td]
[td]58.43[/td]
[td]61.24[/td]
[td]63.31[/td]
[/tr]
[tr]
[td]Revenue per employee
($1,000)[/td]
[td]168.8[/td]
[td]163.5[/td]
[td]170.6[/td]
[td]175.3[/td]
[/tr]
[tr]
[td]Revenue per full-time employee
($1,000)[/td]
[td]198.6[/td]
[td]197.1[/td]
[td]210.6[/td]
[td]224.7[/td]
[/tr]
[/table]

1. What was the number of employees in 2010?

2. What was the number of full-time employees in 2008?
 
Physics news on Phys.org
JimBobBrown said:
[TABLE="class: grid, width: 500"]
[TR]
[TD][/TD]
[TD]2007[/TD]
[TD]2008[/TD]
[TD]2009[/TD]
[TD]2010[/TD]
[/TR]
[TR]
[TD]Total revenue
($1,000 million)[/TD]
[TD]60.05[/TD]
[TD]58.43[/TD]
[TD]61.24[/TD]
[TD]63.31[/TD]
[/TR]
[TR]
[TD]Revenue per employee
($1,000)[/TD]
[TD]168.8[/TD]
[TD]163.5[/TD]
[TD]170.6[/TD]
[TD]175.3[/TD]
[/TR]
[TR]
[TD]Revenue per full-time employee
($1,000)[/TD]
[TD]198.6[/TD]
[TD]197.1[/TD]
[TD]210.6[/TD]
[TD]224.7[/TD]
[/TR]
[/TABLE]

1. What was the number of employees in 2010?

2. What was the number of full-time employees in 2008?
Hi JimBobBrown,

Here you are given the revenue per employee and the revenue per full time employee. If we we take the first one; the revenue per employee it means that you take the total revenue and divide by the number of employees. In equation form we can write this as,

\[\mbox{Revenue per Employee}=\frac{\mbox{Total Revenue}}{\mbox{Number of Employees}}\]

So you are given the Revenue per employee as well as the total revenue for 2010. Plugging those values in the above equation you can find the number of employees for 2010. Can you try to do part 2 yourself? It's basically the same thing but instead of the number of total employees you have number of full time employees. :)
 
Thanks for that, still can't get my head around it for some reason. So for question 1. I would add up both revenues per employee then divide total revenue by that figure?

175300 + 224700 = 400000
63,310,000,000 / 400,000 = 158275
Employees = 158,275
 
JimBobBrown said:
Thanks for that, still can't get my head around it for some reason. So for question 1. I would add up both revenues per employee then divide total revenue by that figure?

175300 + 224700 = 400000
63,310,000,000 / 400,000 = 158275
Employees = 158,275

You don't have to add up both revenues since the "Revenue Per Employee" includes the "Revenue per Full Time Employee". So you just got to use the Revenue per Employee amount. :)
 
WoW I thought something was not making sense. but it does now many thanks Sudharaka. So follow that question 2. would be just

total / full-time =

63,310,000,000 / 224700 = 281753.4
 
JimBobBrown said:
WoW I thought something was not making sense. but it does now many thanks Sudharaka. So follow that question 2. would be just

total / full-time =

63,310,000,000 / 224700 = 281753.4

The method is correct but note that in question 2 you have to find the number of full time employees in 2008.