Planing the individual budget goal for each salesperson

Zvek

New Member
Joined
Dec 15, 2020
Messages
1
Office Version
  1. 365
Platform
  1. MacOS
Hello everyone!
Im super new to all of this and am hoping for your help.

Im trying to calculate the prevision of the exact week revenue goal for each salesperson.
Using the data of final yearly revenue goal we would need to reach, weekly working hours for each salesman
(40h / 30h / 25h), total year working days (254), daily and monthly revenue goal.

Is there any formula for this or any interactive formula for personal revenue goal that can automatically subtract or add where necessary, given that the salespersons work together to reach the goal but not the same amount of time and there are not always the same number of salespersons.

Thank you very much!
I really hope you guys can help me

Stay well and my best to all !
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,587
Office Version
  1. 365
Platform
  1. MacOS
can you give some examples
I suspect you would need to look at the number of working days left in the year per salesman
Then how would you want to break that down by the hours per week / day

without further examples
a salesman working 25 hours / week = X hrs / day
Number of working days till end of your revenue year , which you could use something like networkdays() or =NETWORKDAYS.INTL()
to calculate the number of days left in your year
then if you know the working hours perday for the 3 different shift hours - then you could multiply by that number and assign that to a salesman
BUT i think some examples of the results may help
 

Watch MrExcel Video

Forum statistics

Threads
1,127,539
Messages
5,625,402
Members
416,100
Latest member
lirongr1996

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top