Monthly Revenue : company_name,month,revenue Write a query to pull the monthly revenue as columns instead of rows.
Business Interview Questions
153,426 business interview questions shared by candidates
Ranking a table by revenue (Add a Rank Column), without using Rank()
Tell me about a time when you persuade others
Cap One is usually collects default accts by calling these customers. Usually 15% of customers pay their accounts off. Now, they are consdering giving an offer to the customers for paying 60% amount. Should we do that or not. Abg balance is $2000. This offer will impact now, that only 10% customers will pay in full and 10% will pay 60% offer. part(b)- since we are stealing our own customers by giving an offer, what is the cannibalization rate? and what is the max. cannibalization rate that Capital One can do to break even?
Ok now assume that the day is split into surge and non-surge demand hours. Non-surge demand lasts 4 hours and has 800 rides. Surge demand lasts another 4 hours and has 1,600 rides. Assume you can only hire drivers for the full day. How much would you need to charge during surge hours to breakeven on your profit from the first question?
The company manufactures 3D Printers. Who should they target selling it to and which one will be more profitable? End customers directly or through retailers? Interviewer asked me to plot graph to show the volume of sales with respect to time for each scenario. Asked to calculate the profit in 2years giving fixed cost 6.6m, over head costs 2.4m/yearly, cost of the item=$250 price of the item sold=$500 and no of units= 2000/monthly. Altered the numbers: when 25% of printers breakdown and cost of repairing each one is 200$. What are the additional printers to be sold to make the profit in 1 year?
I had one question for each interview and both were probability puzzles. Here is the tougher one: you have a bag of N strings, and at random, you pull out a end. You pull out another end and you tie the two ends together. You take another two string ends and tie them together. You repeat this until there are no loose ends left to pull out of the bag. What is the expected number of loops?
What is the CAISO? How does PG&E make money?
Why do you want to work here?
What is the name of our CEO?
Viewing 171 - 180 interview questions