70 Part 4 - Flux Analysis Directions: Please answer the questions below using the information provided. partida i flux Analysis wer the ques Scenario: In some instances, regulating authorities charge riders to use Uber in their jurisdictions. As part of Uber's service offering, Uber collects these surcharges (i.e., taxes and fees) from riders, on behalf of drivers, and remits fees collected directly to the regulating body (e.g., municipalities and airport authorities). You are completing the Taxes and Fees Collected flux analysis as part of the quarter end close procedures and notice that taxes and fees collected from riders increased 30% from the comparative period. As part of the flux documentation, you need to explain why the balance changed. Please list out all the specific drivers that could contribute to this net $195 increase, ensuring to address all increases and decreases over +/-$5. Ultimately, your work will be presented to the Controller and Uber's external auditors, so you know you have to be accurate and detailed. To get started, you ran an account detail report (results below). Additionally, you work with your team to find out trip volume increased 20% globally over the same period, and that Uber launched transportation services in City D in October 2018. Tax/Fee Description City A Fee City A Airport Fee City B Tax City B Fee City C Airport Fee City D Airport Fee City D Fee Total $ Change QTD 6/30/18 QTD 6/30/19 YOY%Change $ 100 $ 200 100% $ - $ 25 100% $ 150 $ 150 0% $ 300 $ - -100% $ 100 $ 120 20% - $ 50 100% - $ 300 100% 650 $ 845 30% 195 87 83 70 Part 4 - Flux Analysis Directions: Please answer the questions below using the information provided. partida i flux Analysis wer the ques Scenario: In some instances, regulating authorities charge riders to use Uber in their jurisdictions. As part of Uber's service offering, Uber collects these surcharges (i.e., taxes and fees) from riders, on behalf of drivers, and remits fees collected directly to the regulating body (e.g., municipalities and airport authorities). You are completing the Taxes and Fees Collected flux analysis as part of the quarter end close procedures and notice that taxes and fees collected from riders increased 30% from the comparative period. As part of the flux documentation, you need to explain why the balance changed. Please list out all the specific drivers that could contribute to this net $195 increase, ensuring to address all increases and decreases over +/-$5. Ultimately, your work will be presented to the Controller and Uber's external auditors, so you know you have to be accurate and detailed. To get started, you ran an account detail report (results below). Additionally, you work with your team to find out trip volume increased 20% globally over the same period, and that Uber launched transportation services in City D in October 2018. Tax/Fee Description City A Fee City A Airport Fee City B Tax City B Fee City C Airport Fee City D Airport Fee City D Fee Total $ Change QTD 6/30/18 QTD 6/30/19 YOY%Change $ 100 $ 200 100% $ - $ 25 100% $ 150 $ 150 0% $ 300 $ - -100% $ 100 $ 120 20% - $ 50 100% - $ 300 100% 650 $ 845 30% 195 87 83