Find Jobs
Hire Freelancers

Do some Excel Work

$30-250 AUD

Terminado
Publicado hace más de 9 años

$30-250 AUD

Pagado a la entrega
The need is this. We want to pay an increasing level of incentive for an increasing level of actual revenue earned. And we want to pay it in bands. 1.5% for the first 50% or target actually earned 3.0% for the next 20% 6.0% for the next 20% 8.0% for the last 10% and finally any amount above target to earn at the rate of 10.0%. Each of the target, actual, incentive percentage and the band upper limit have to be variable. In other words these will change so they need to reference a cell that we can change. Again see the attached sheet. So here’s how it should work. (See col K in the attached spreadsheet as the example) If the target was say $100,000, and the sales person earned actual revenue of $85,000 we want to pay (say) 1.5% for the first 50% of that target reached. 100,000*50%=50,000*1.5%=$750. Then we want to pay 3% for the next 20% of the target achieved. In other words pay 3% for all the actual earned after the first 50% and for the next 20% of the target. $100,000*20%=20,000*3%= $600. And then (in this case) pay the balance of the actual earned using the next band up of commission. In this case the balance is 15,000*6%=$900 The challenge is that when the "actual" goes into the next band (tipping from $70,000 to $85,000 for example but not reaching the full amount of the next band – which would be 90,000) the calculator needs to pay the incentive for the actual amount earned. In this case the balance or extra bit is 15,000 (85,000-75,000) and the incentive to be applied is the incentive in that next band 6% but only against the balance amount of (in this case) 15,000*6%=$900 I want the one same formula for all the cells to make these correct calculations. I want to be able to amend any of the grey cells and see the total outcome.
ID del proyecto: 6160823

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
I can do this for you. I am proficient in Microsoft Excel. I work fast and accurately. See my reviews. Please award me this project.
$30 AUD en 0 día
5,0 (8 comentarios)
3,9
3,9
9 freelancers están ofertando un promedio de $98 AUD por este trabajo
Avatar del usuario
A proposal has not yet been provided
$157 AUD en 3 días
4,8 (111 comentarios)
6,3
6,3
Avatar del usuario
Hi there, Aussie Freelancer here. I am working as business process improvement professional with extensive knowledge in Excel and Processes streamlining. I managed Excel improvements materials for such companies as AOL, DELL and L’Oreal etc. I will provide you with a high quality and time committed service with outcomes match your needs and look professional and attractive. I can provide you with Excel that will automate majority of these tasks . Kind Regards, Stephanie
$64 AUD en 4 días
5,0 (11 comentarios)
4,7
4,7
Avatar del usuario
Hello Sir, Here is very good team work, we can make any kind of Chart,any formula apply,macro,vba work. Kindly contact me for further discuss. thanks.
$200 AUD en 2 días
4,9 (12 comentarios)
3,8
3,8
Avatar del usuario
Dear Sir’ I see your project description. I can do the job accurate perfect. Recent I create a new team now totally free my team. So need lots of work. my team are 5 person everyone have lots of experience with minimum 3 years about Copy Typing, Data Entry, Data Processing, web search & Excel. The work will be accurate perfect in time. Sir’ can you give a chance to work with you. Waiting for your reply. Thanks
$72 AUD en 3 días
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
HI Good Day I am interested to this calculated related project. I can give you the exact result that you said in the brief. Thank You Aust Sujan
$120 AUD en 1 día
0,0 (1 comentario)
0,0
0,0
Avatar del usuario
I can make your green formula cells display the answers you desire that will be variable according to the cells you wish , however i will need to use more formula cells perhaps located off page or on a hidden and protected sheet that will cover more formula that is needed to make your calculations. I am already working on your Project , cell ranges E11-E15, F11-F15, G11-G15,..... will all work exactly how your discription in cell P22-P26 work
$55 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, The formula(s) for this request is complete and I shall be able to provide you with the same for the sheet attached. You may have a proof reading of the same and get back if any discrepancy. Please feel free to reach out for any queries/concerns. Thanks, Sri.
$111 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I was a sales manager with Malaysian yellow pages for 11 years. I am able to work long hours as I don't have any job now. Hope you can give me a chance.
$100 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Sir, I'm very expert in any kind of data entry job, and have interest to do this project, I'm ready to start this project from right now. Sincerely, JulfikarVutt
$30 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Mosman, Australia
5,0
23
Forma de pago verificada
Miembro desde sept 10, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.