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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,571
Messages
5,838,160
Members
430,532
Latest member
Clod

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.

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

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