Closed

Business Modelling

Hi I need 2 different What If Scenarios developed in an Excel Spreadsheet which will give me a few fields I need to enter, and it will spit out the scenarios. All the scenarios are for a sales environment and will be used to assess the ROI of various strategies.

They are all about measuring the impact of a variable client attrition rates, (and its cost in terms of man hours and sales staff costs to replace) & the impact of existing active clients and how much they are likely to buy (and the cost in terms of man hours and sales staff costs to get that business), and how much new business development activities I need to also pursue (in terms of cost of man hours & sales staff costs to get that business) in order to achieve a certain sales revenue growth over a year.

There is a linear model assuming all clients are equal. The 2nd scenario is the same but based on the 80/20 rule (ie 20% of your clients represent 80% of your business), where the impact of losing some of the value of my 20% top clients is much higher.

It needs to looks aesethic and smart as I will be presenting it to clients. It needs to be easy to use. Backend workings need to be available as part of client due dilligence.

If you have any queries please contact me because I'm not entirely sure my notes attached will answer every question.

Skills: Excel, Mathematics

See more: what is the value of i in mathematics, top mathematics, need a sales man, i need a sales man, how to buy an existing business, excel spreadsheet business, business mathematics, excel scenario, i need sales staff, part modelling, new business development, excel mathematics, due dilligence, business modelling, development excel model, excel linear, business development spreadsheet, linear excel, cost roi, excel roi, sales model excel, model based excel, roi excel, attached spreadsheet revenue, roi excel spreadsheet

About the Employer:
( 0 reviews ) Australia

Project ID: #4419119