Allocation Tool

Marcustewart85

New Member
Joined
Jul 10, 2019
Messages
1
Hi. I'm a an excel novice so apologies in advance.

I need to create an allocation tool which distributes work evenly amongst teams.

We receive a different amount of queries to get through everyday so would need to amend the daily allocation.

Each of the teams have different targets which vary on a week to week basis.

Is anyone able to give me any ideas about the best way of producing this?

Thanks

Ed

EDIT:
The daily allocation should take teams as close to 100% of their target as possible.
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,251
work out how you would do this on a piece of paper

when you have a working system, create an Excel model that does the same thing

if you want help on the Excel side of things, please give details of exactly what needs to be done, what you have done, where you're stuck, etc
some sample data showing the cells helps ENORMOUSLY - so the input cells, the tables, the corresponding results

cheers
 

Forum statistics

Threads
1,089,270
Messages
5,407,302
Members
403,131
Latest member
Lewas2019

This Week's Hot Topics

Top