Find Jobs
Hire Freelancers

Forecasting / Capacity Planning Template

$10-30 USD

Completed
Posted almost 6 years ago

$10-30 USD

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.
Project ID: 17006979

About the project

18 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
$25 USD in 1 day
5.0 (15 reviews)
3.9
3.9
18 freelancers are bidding on average $48 USD for this job
User Avatar
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 done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, WEKA, TABLEAU and excel tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$250 USD in 1 day
4.8 (61 reviews)
6.5
6.5
User Avatar
A proposal has not yet been provided
$100 USD in 2 days
4.8 (69 reviews)
6.5
6.5
User Avatar
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
4.9 (22 reviews)
5.0
5.0
User Avatar
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 commissions and bonuses. You can check my profile for samples of previous tasks I've done in these subjects. Please send a message so that we can discuss further.
$25 USD in 1 day
5.0 (11 reviews)
4.4
4.4
User Avatar
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 client's satisfaction. If you need help in Excel, data entry, contact me with confidence!
$25 USD in 1 day
5.0 (1 review)
3.4
3.4
User Avatar
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
5.0 (1 review)
1.0
1.0
User Avatar
Hi! I would like to work your project. If interested please contact. Regards, Prabhat Arya Arya Professionals
$55 USD in 1 day
5.0 (1 review)
1.1
1.1
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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 to your satisfaction.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$23 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 provide any additional details for further discussion. I'm also available on Email, Skype, Google Hangouts and Whatsapp. I'm looking forward in collaborating with you in this project. Thank You, Kai Tsen
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$29 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Broken Arrow, United States
5.0
3
Payment method verified
Member since Aug 27, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.