Calculating costs in Excel

[nischal4487]

hi, if 496 hours per month and actual team cost is $6895.38 per month and this arrives to $13.90 as my hourly team rate.

What would be my team cost per month is the total hours 785 during the month? Please let me know how do i calculate the team cost in excel when I only have hours for the month in the case.

Regards,
Nik

 

[tyija1995]

Hey,

First you get the hourly rate which you have done ($13.90) - now as that is the cost PER HOUR and you have 785 HOURS you just multiply the 2 together.

Cost:= $13.90 * 785 = $10911.50