Gig Driver Earnings: True Hourly Pay, Cost per Mile & Platform Comparison

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn Maya's Tuesday trip log into minutes per trip, total earnings with tips, gross pay per paid mile and gross pay per engaged hour.
• Build Maya's vehicle cost per mile from six cost items, find the true total and chart which items drive it.
• Subtract the vehicle cost of all miles, including dead miles, from Maya's daily gross, divide by the hours she was online and find her true net pay per hour for the week.
• Compare two generic ways to deduct Maya's car costs: a standard rate per business mile and the business share of the actual costs, and let Excel name the larger one.
• Summarise 30 trips by start hour: average pay per trip with AVERAGEIFS, the share of surge trips with COUNTIFS, pay per engaged hour with SUMIFS, and the best hour to drive.
• Compare four weeks of Maya's driving (three single apps and one multi-app week) by net pay per online hour, rank them and highlight the winner.
• Estimate Maya's taxable profit per quarter after the mileage deduction and other costs, apply illustrative income-tax and contribution rates and total the money to set aside for the year.
• Turn eight weeks of totals into net income and net per hour, chart the weekly net, and work out how many online hours Maya needs for a $1,000 net week at her recent rate.