Hello all,
This is my first post on the forum so please excuse me if i'm not clear enough.
I'm trying to schedule activity in the team across the calendar days in the month. Each task that has to go in the calendar has a different volume but the approximate time taken to perform a particular task is known. There is also a particular time by which a certain task has to be completed. Considering all the above parameters, will it be possible to create a schedule which will equally distribute the task between the days?
I have attached the input data and how i would like the output to look like. I'm currently using Office 365.
Input data
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
<tbody>
</tbody>Output data
<colgroup><col width="64" span="61" style="width:48pt"> </colgroup><tbody>
</tbody>Thanks everyone in advance!
This is my first post on the forum so please excuse me if i'm not clear enough.
I'm trying to schedule activity in the team across the calendar days in the month. Each task that has to go in the calendar has a different volume but the approximate time taken to perform a particular task is known. There is also a particular time by which a certain task has to be completed. Considering all the above parameters, will it be possible to create a schedule which will equally distribute the task between the days?
I have attached the input data and how i would like the output to look like. I'm currently using Office 365.
Input data
| Task | Time Required/transaction(mins) | Transaction Volume | To be completed before (day of month) |
| A | 5 Mins | 300 | 3 |
| B | 10 Mins | 30 | 6 |
| C | 10 Mins | 60 | 7 |
| D | 10 Mins | 5 | 3 |
| E | 5 Mins | 10 | 1 |
| F | 10 Mins | 60 | 10 |
| G | 40 Mins | 90 | 15 |
| H | 40 Mins | 80 | 17 |
| I | 30 Mins | 600 | 31 |
| J | 120 Mins | ||
| K | 30 Mins | ||
| L | Can vary | ||
| M | 30 Mins | ||
| N | 30 Mins | ||
| O | 20 Mins | ||
| P | 30 Mins | ||
| Q | 20 Mins | ||
| R | 20 Mins | ||
| S | 60 Mins | ||
| T | 60 Mins | ||
| U | 30 Mins | ||
| V | 30 Mins | ||
| W | 10 Mins |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
| Resource Name |
| AB |
| BC |
| CD |
| DE |
| EF |
| FG |
| GH |
| HI |
| IJ |
| JK |
| KL |
| LM |
| MN |
| NO |
| OP |
| PQ |
| QR |
| RS |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
<tbody>
</tbody>
| Resource | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | ||||||||||||||||||||||||||||||
| Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | Activity | Volume | |
| AB | A | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| BC | A | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| CD | A | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| EF | A | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| FG | A | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| GH | A | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| HI | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| IJ | A | 20 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| JK | A | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| KL | A | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| LM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| MN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| NO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| OP | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| PQ | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| QR | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| RS |
<colgroup><col width="64" span="61" style="width:48pt"> </colgroup><tbody>
</tbody>
