How to assign my ressources to meet my deadlines

tfassnacht

Hello community,

 

I am stuck in a wall and somebody someone can help.

My project is around write travel brochures. In my sheet, each task is the writing of a brochure.

Each task is associated with a quantity of work (here number of pages per brochure)

My clients impose start and end dates.

My resources are writers (I have 10 writers at my disposal), who have a daily productivity (10 pages per day).

 

I would like to find a way to best assign (possibly automatically) my writers to each tasks to meet my clients end dates. One writer can only work on one task at a time.

 

How can SmartSheet help on this with Resources allocation ? Any idea ?

 

Many thanks in advance for your responses !

 

 

 

Andrée Starå

Hi,

Interesting!

I'd be happy to take a look!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

tfassnacht

Thanks for reaching out Andre.

My process is to coordinate the writing of those brochures.

I am imposed start and end dates by my clients. 

 

For each task I can allocate a set of a pool of writers (from one to many). Each writer can write 10 pages per day.

 

I would like SmartSheet to find the best resource allocation to meet my clients end dates.

 

I send you the smartSheet per email.

 

 

 

Andrée Starå

Hi Thomas,

How did it go? Did you manage to get something set up or do you still need help?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting