Non-Member Fees Owed to a Venue

To work out Non-Member fees owed to the Venue:
  • Run the Venue Report for the required month WITHOUT exporting to .csv
  • The Summary shows the number of non-members that attended that month

1g-1

  • Use this formula to work out how much is owed to the venue in Non-Member Fees for that month:
 
((Non-Members x Non-Member Fee) / Weeks in Course) x Weeks in Month
For example - I have:
  • 82 Non-Members attended in the month
  • A £12.00 per Course Non-Member Fee for the Venue
  • 7 Weeks in the current Course
  • 4 Weeks in the month I'm reporting on
So the formula works out as:
 
((82 x £12 = £984) / 7= £140.58) x 4 = £562.32