80.2K

Verified Solution

Link Copied!

After analysing the performance of Quber, the CEO acknowledges that the company is heading in the right direction. The next step Quber would like to extend the application to improve its usability for users and also include a stronger and transparent commission system for the drivers.

The drivers are currently collecting a small tip from some passengers and this is expected to amount to $100,000 collectively at the end of 12 months. The drivers have promised to hand this amount to Quber as an initiative to not only help with bookkeeping, the development of the app as a small business owner, but to overall increase the number of rides undertaken and their percentage cut of the shared revenue. The CEO believes this could be a point of differentiation between Quber and its competitors and would like to support the initiative.

However, as part of the additional feature within the application, Quber would need an initial outlay of an $800,000 fee for overhaul of its current booking application. Based on this positive update, Quber expects the average amount of total combined revenue (Quber and all their drivers) from rides to be $335,000 per month. Quber will however have to pay a small dedicated maintenance team of $17,000 per month in this trial phase of 12 months. Quber set their cost of capital at 5% per annum compounded monthly. They are currently giving the drivers 70% of the total combined revenue cut but there is a feeling this figure might be low.

The CEO believes as a socially responsible company that values its people, the driver should receive the benefits of this enhanced feature within the booking application. Quber would like to determine if the drivers can be awarded with a higher percentage cut from the shared revenue. From part (a) and (b), use GoalSeek in EXCEL to determine the percentage which the drivers should receive such that the amount from the drivers of $100,000 at end of 12 months is the operating surplus for this proposed enhancement

Answer & Explanation Solved by verified expert

See Answer