Create an Excel Model of Sales
- or -
Post a project like this1978
£40(approx. $50)
- Posted:
- Proposals: 23
- Remote
- #2202551
- Awarded
Transcription, PDF conversion, Fillable PDF form, PDF Editing, Data Entry,Excel,WORD HRMS, FORM NO 16 PREPARATION(INDIA)
Nagpur
Expert in Translation , Transcription, Mathematics , Data Entry, Ms Office , Typing in Hindi and English with 50 WPM(100% accuracy), Office assistant .
Rajsamand
139401523260892477794246954224670222462588246234824613582459523244618924385682437054
Description
Experience Level: Entry
I would like to have a sales model created that works backwards from a total sales target for the year. We have 3 variables that determine our sales income. These are number of sight tests x conversion rate x average transaction value.
The sales model should be completely interactive and on one output show me the complete sales brokwn down into monthly, weekly, quarterly targets and the necessary number of tests required for each depending on the average order value.
We also update our information every day depending on weekly targets, so for example if our target this week is £7000 and we only work 3 days, then we need 2333 per day, however if we hit 2000 on the first day then the remaining 2 days we need 5000, this should also tell us the number of tests needed.
I can go into further detail and have an example for you also
The sales model should be completely interactive and on one output show me the complete sales brokwn down into monthly, weekly, quarterly targets and the necessary number of tests required for each depending on the average order value.
We also update our information every day depending on weekly targets, so for example if our target this week is £7000 and we only work 3 days, then we need 2333 per day, however if we hit 2000 on the first day then the remaining 2 days we need 5000, this should also tell us the number of tests needed.
I can go into further detail and have an example for you also
Sohail K.
95% (26)Projects Completed
29
Freelancers worked with
27
Projects awarded
28%
Last project
21 Apr 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies