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