Forecasting / Capacity Planning Template

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

I have historical data that has total sales, month, time spent to achieve sales and name of each salesperson. I would like a excel template that once data is entered it will forecast what is needed to achieve a goal. Specifically, Prior year has over 50,000 in sales. Need to achieve 100,000 in sales in next year. The prior year (say 2015) achieved 50k in sales with 8 people. It would be simple to say with 100k with 16 people. However, excel template should account for seasonality. Also trend for what each salesperson will achieve based on 2015 and forecasting their performance for 2016.

Business Analysis Data Entry Data Processing Excel Finance

Project ID: #17006979

About the project

18 proposals Remote project Active 5 years ago

Awarded to:

$25 USD in 1 day
(15 Reviews)
3.9

18 freelancers are bidding on average $48 for this job

suyashdhoot

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d More

$250 USD in 1 day
(61 Reviews)
6.5
RRconsultant

A proposal has not yet been provided

$100 USD in 2 days
(69 Reviews)
6.5
Valuesolutions

Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things

$35 USD in 1 day
(22 Reviews)
5.0
Ipalei1990

Am an experienced excel programmer and financial analyst. I've developed a wide range of market analysis algorithms for seasonality sales forecasting and sales targets. I've even developed payment models for commis More

$25 USD in 1 day
(11 Reviews)
4.4
mohammadasad123

I am senior software engineer having six years of experience, developing mobile application and website. I have good typing speed and knowledge of excel. My goal is to provide professional and high quality work for c More

$25 USD in 1 day
(1 Review)
3.4
ashmamaian12

I have considerable experience in the area of data entry,data processing,excel and finance. Kindly contact me to discuss further details.

$20 USD in 10 days
(1 Review)
1.0
aryaprofessional

Hi! I would like to work your project. If interested please contact. Regards, Prabhat Arya Arya Professionals

$55 USD in 1 day
(1 Review)
1.1
hasikhan326

i well complete this task beauty full and i well complete this task before the day so trust is needed

$30 USD in 1 day
(0 Reviews)
0.0
kamalmsharma

Hi there, i am an expert in data analytics & visualization. I have worked in managerial roles of maultinational corporations where i analyzed data to draw actionable insights. I will surely deiver high quality service More

$111 USD in 3 days
(0 Reviews)
0.0
guptabhawanaca1

I working as Chartered Accountant and have knowledge in the field of auditing, mainly substantive testing, sampling, control testing and Analytical reviews during post qualification experience.

$25 USD in 1 day
(0 Reviews)
0.0
sheetalpanchal06

I am currently working on same kind of project so it will be easy for me to create a template to forecast the performance

$20 USD in 1 day
(0 Reviews)
0.0
sowmyasp

A proposal has not yet been provided

$23 USD in 3 days
(0 Reviews)
0.0
LowKaiTsen01

Hi I have read your job post and I am very interested to work on your project. Based on your brief job description, I am confident I will able to complete the job. Please don't hesitate to contact me back and More

$25 USD in 2 days
(0 Reviews)
0.0
Anand0208

A proposal has not yet been provided

$29 USD in 2 days
(0 Reviews)
0.0
kirankumargowda

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0