I'm having troubles understanding how to get this formula to recieve the correct answer of 92%
Question- In cell I6, calculate the percentage of the total fees that comes from greens fees (that is, divide the greens fees amount by the total amount).
Green fees - (D6) - 95
Total Green amount - (H6) - 25,555Excel formula - calculate the percentage of the total fees that comes from greens fees?
Green fees =Fees - 95
Players = Total green fees (25555.00) divided by 95 equals 269
92% of revenue is from green fees therefore 8% are other fees
Multiply 95 by 1.08 (8%) =102.60 (other fees are 7.60)
Total green fees is Total fees minus 25555.00 equals 102.60 multiplied by 269 players equals 27599.40
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment