hi all, i have a problem here that i hope can be solved in this section of the forum.

Actually the case is for a manufacturing company for which i'm developing a software and it goes like this:

A factory produces a variety of products of the same type. Each product goes through 5 stages of production that we can call S1, S2...S5 and each stage has a duration in terms of days: 5, 1, 10, 3, 2. Actually the factory has a maximum weekly production capacity for each stage. Say for S1 it can have 100000 units in production for a given week and S2-S5 60000 units.

Now when I receive an order for a set of products for a client, i need to trigger a production order for each product. The program actually does calculates the approximate date of delivery of the order based on the quantity ordered for each product. My problem lies within the situation when I have other orders in production. Say i already reached 90% of my capacity for a given week for a given production stage and a new order comes and takes say 20% of my capacity. So i would be operating on 110% of my actual capacity. This would need have a rippling effect in causing orders already in production to be delayed. i actually want to know how to calculate this delay for the new order and the other ones already launched.

I know it might not be clear enough but i hope to receive some help in here. All help welcomed. thanx.