# Planing the individual budget goal for each salesperson

#### Zvek

##### New Member
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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

#### etaf

##### Well-known Member
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

Replies
0
Views
186
Replies
0
Views
284
Replies
3
Views
177
Replies
0
Views
274

### Forum statistics

Threads
1,126,929
Messages
5,621,656
Members
415,849
Latest member
PhoenixRising2015

### 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

### 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