Creating a production schedule

K

Kees Vos

I have a sheet with amounts that have to delivered in every week. (Delivery
Schedule).
The first column (a1,a2, etc) of the sheet contains the item number.
The second column of the sheet contains the production capacity of a week
All the folowing colums (c,d,e, etc) are the need of each week. (column c
contains the need of week 1; column d contains the need of week 2)

Now I need a second sheet that creates a production planning, using the
information above (Production schedule)

Since he first column (a1,a2, etc) of each sheet contains a equal variable,
the item number, I can use VLOOKUP to find the accompanying capacity of each
item.

But how do I calculate that I need to produce 2 pieces in week 1 and 5
pieces in week 2, because I need to deliver 7 pieces in week 3 and my
capacity is 5 per week?

Hope my question is clear! Thanx in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top