Creating a production schedule
 

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.

--
Kees Vos