What formula or worksheet application would allow me to estimate how much sales is required to how a given number of employees?

Answer 1

It appears the posted question is multi-valued and would need to be broken down. What is the required mandatory total sales amount per 50 employees? Which employees need to be pulled? What is the Time factor involved? Setting up an Excel worksheet properly could provide the BI needed in this situation; and, also querying the business transaction database could provide the BI results sought.