Hi everyone,
I am writing with a somewhat complex issue that I have with excel (at least it's complex to me). I use Excel 2010 by the way.
I basically have an monthly order schedule and I am trying to come up with a monthly delivery schedule for products that have a very long production cycle and are very intense in labour. The fact that there are various products and various production steps make it quite hard to calculate when the products will be completed.
The Order table looks something like that
Orders / month 1 / month 2 / month 3 / month 4 / etc..
Product 1 / 1 / 2/ 3 / 1 / 0 /1 / etc
Product 2 / 1 / 0/ 0 / 1 / 1 / 0 / etc
Product 3 / 0 / 2/ 1 / 2 / 4 / 1 / etc
And the delivery table which I am trying to come up with should look like that
Deliveries / month 1 / month 2 / month 3 / month 4 / etc..
Product 1 / 0 / 0/ 0 / 0 / 0 /1 / etc
Product 2 / 0 / 0/ 0 / 1 / 1 / 0 / etc
Product 3 / 0 / 2/ 0 / 2 / 0 / 1 / etc
For every month I know the amount of direct labour hours availabe for each production step
Direct Labour hours available / month 1 / month 2 / month 3 / month 4 / etc..
Production Step 1 / 2000 / 3000 / 3500 / 5000 / 6000 / 7000 / etc.
Production Step 2 / 3000 / 4000 / 5000 / 6000 / 7000 / 8000 / etc
Production Step 3 / 4500 / 4500 / 6500 / 7500 / 8500 / 9600 / etc
For every Product I know the amount of direct labour hours required per production step
Product 1 - Direct Labour hours required
Production Step 1: 450
Production Step 2: 1500
Production Step 3: 2500
Product 2 - Direct Labour hours required
Production Step 1: 1200
Production Step 2: 1350
Production Step 3: 2310
Product 3 - Direct Labour hours required
Production Step 1: 800
Production Step 2: 1250
Production Step 3: 2045
I am not sure how this could work with a standard excel formula.
Maybe someone can point into the right direction or help. It would be greatly appreciated.
Please let me know if you need more details.
Regards,
Felix
I am writing with a somewhat complex issue that I have with excel (at least it's complex to me). I use Excel 2010 by the way.
I basically have an monthly order schedule and I am trying to come up with a monthly delivery schedule for products that have a very long production cycle and are very intense in labour. The fact that there are various products and various production steps make it quite hard to calculate when the products will be completed.
The Order table looks something like that
Orders / month 1 / month 2 / month 3 / month 4 / etc..
Product 1 / 1 / 2/ 3 / 1 / 0 /1 / etc
Product 2 / 1 / 0/ 0 / 1 / 1 / 0 / etc
Product 3 / 0 / 2/ 1 / 2 / 4 / 1 / etc
And the delivery table which I am trying to come up with should look like that
Deliveries / month 1 / month 2 / month 3 / month 4 / etc..
Product 1 / 0 / 0/ 0 / 0 / 0 /1 / etc
Product 2 / 0 / 0/ 0 / 1 / 1 / 0 / etc
Product 3 / 0 / 2/ 0 / 2 / 0 / 1 / etc
For every month I know the amount of direct labour hours availabe for each production step
Direct Labour hours available / month 1 / month 2 / month 3 / month 4 / etc..
Production Step 1 / 2000 / 3000 / 3500 / 5000 / 6000 / 7000 / etc.
Production Step 2 / 3000 / 4000 / 5000 / 6000 / 7000 / 8000 / etc
Production Step 3 / 4500 / 4500 / 6500 / 7500 / 8500 / 9600 / etc
For every Product I know the amount of direct labour hours required per production step
Product 1 - Direct Labour hours required
Production Step 1: 450
Production Step 2: 1500
Production Step 3: 2500
Product 2 - Direct Labour hours required
Production Step 1: 1200
Production Step 2: 1350
Production Step 3: 2310
Product 3 - Direct Labour hours required
Production Step 1: 800
Production Step 2: 1250
Production Step 3: 2045
I am not sure how this could work with a standard excel formula.
Maybe someone can point into the right direction or help. It would be greatly appreciated.
Please let me know if you need more details.
Regards,
Felix