I need an Excel spreadsheet created that projects revenue from customers over twelve months, where I specify the following variables:
- Number of new customers each month
- Amount of first sale with us
- Amount of all subsequent sales with us
- Number of months between orders (e.g., they order every two months)
So for example, a new customer spends $100K on the first order and $150K on all subsequent orders. One new customer starts in Feb so we will get $100K in Feb, $150K 90 days after that, $150K 90 days after that, etc. But since some customers won't start until later in the year, we will see fewer sales of the course of the year.
So this is the challenge. How to build formulas so I can plug different numbers in the variables above to calculate revenue for the year from all of those customers. And then I have three different customer types (whales, sharks and minnows) so need to have the spreadsheet calculate each customer type and then total for total revenue for the year.
I'm attaching a spreadsheet where I've placed our initial assumptions to help you get started and make sense of it. I need it turned around fast (e.g., 24 hours). Hoping this is super easy for someone proficient in Excel (which I am not!).
Please only bid if you have the expertise to do this and turn it around in 24 hours or less.
3 freelancers are bidding on average $20 for this job
okay got it ..hi i am interested in your project .. and i would like to work with you .. i will do this job for you ... Stay tuned, I'm still working on this proposal.