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 !
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
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
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

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
Back
Top