I have a list of parts that has x amount of minutes to produce. I have a limited capacity each week. I would like to create an easy way to create a "matrix" that shows how the production minutes can be distributed. I need to be able to change the capacity as necessary.
<colgroup><col><col><col><col span="4"></colgroup><tbody>
</tbody>
Part | Total Minutes | WK1 | WK2 | WK3 | WK4 | WK5 |
1 | 280 | 280 | ||||
2 | 2079 | 1640 | 439 | |||
3 | 4200 | 1481 | 1920 | 799 | ||
4 | 2552 | 1121 | 1431 | |||
5 | 396 | 396 | ||||
6 | 7134 | 93 | ||||
7 | 1476 | |||||
8 | 2288 | |||||
Capacity | 1920 | 1920 | 1920 | 1920 | 1920 |
<colgroup><col><col><col><col span="4"></colgroup><tbody>
</tbody>