For this exercise we are focusing on the transactional fees that riders are charged: Subscribers are charged nothing ($0.00) for the first 45 minutes of their rental and $2.50 for each additional 15 minutes. A 61 minute Subscriber rental would cost $5.00. Subscribers can make an unlimited number of rentals in a day. Customers (non-subscribers) are charged $3.00 for the first 30 minutes and $3.00 for each additional 30 minutes. A 61 minute Customer (non-subscriber) rental would cost $9.00.

What was the Total revenue from all subscribers ?

Enter the value and the spreadsheet tab containing your calculations.

What was the Total revenue from all customers (non-subscribers) ?

Which route was the most popular in terms of total minutes ?

Which route was the most popular in terms of total trips ?