Sam O.

asked • 02/18/21

How would I put the below details into an excel spreadsheet?

Year 1 - £350,000 target with a 30% margin, 100 clients

Year 2 - £700,000 target with a 27% margin, 250 clients 

Year 3 - £1,000,000 target with a 25% margin, 300 clients


I am selling to private clients, brokers, retail and on-trade too and there needs to be consistent income month on month, with gradual build.


Ideally there needs to be a monthly split and repeat sales performance from each customer

 

Work off average private client price of £30 ex vat, average broker price £35 ex vat , average on-trade £13 ex vat, average retail of £17 ex vat.


Thanks.


1 Expert Answer

By:

Marc D. answered • 03/08/21

Tutor
5 (1)

Engaging and patient Master of Applied Mathematics.

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.