What are the different approaches (with great details) to estimate a bike shop revenue in London?
Best way to estimate revenue of a bike shop


How about you provide some ideas and ask for feedback instead of asking others to do your work for you, ("with great details", no less)?
A person running a bike shop in London would say: "Bugger off"...

Hi,
Can only agree with Elias here:)
Best!

Agree too - this is why I never respond to those questions of people asking us to do their job. Pet peeve of mine :)
This would be my way of approaching this....
Revenue: (1) + (2)
- Rev. from sales (1) = (1a) * (1b) + (1c)
- # of bikes sold (1a)
- # Electric bikes
- # Used bikes
- # City bikes
- avg price (1b)
- $ Electric bikes
- $ Used bikes
- $ City bikes
- Accesoirces sold (1c)
- units
- $ per unit
- # of bikes sold (1a)
- Rev. from repair (2)
- # of bikes repaired (2a)
- Hours needed per repair (2a-I)
- [4 segments from 2b ]
- Hours of mechanic time (2a-II)
- # of mechanics
- Opening hours / working hours
- Hours needed per repair (2a-I)
- $ per repair (2b)
- $ of flat tire = 25% of repair jobs
- $ of new tire = 25% of repair jobs
- $ of big maintenance = 25% of repair jobs
- $ of other maintenance = 25% of repair jobs
- # of bikes repaired (2a)
Good luck putting some numbers to it....and it was a good practice case for me, thanks!
@Elias/Guennael/Vlad: if you have some feedback on my structure, I am happy to hear it.




Jacob,
You approach seems good, but it's unclear how will you calculate the actual number of units sold in an actual shop. I see 2 ways:
1) From the demand side: every time you come to this store you see x ppl. You can assume how much time on average they spend at the store and calculate daily traffic. Then multiply it by the conversion rate (use an assumption based on personal experience)
2) You can also do it from the supply side:
Assume the size of the shop + warehouse room-> avg inventory (How many bikes it can fit) -> avg turnover (assume the inventory changing every season) -> sales
Best!









