I'm looking for a bit of help, if possible, with trying to produce a production schedule.

We manufacture 3 units per day (number 3 contained within Cell A1). Say Job A contains 4 units (cell B1 = 4), Job B 5 units (C1 = 5) and Job C 13 (D1 = 13).

If Job A starts on the date 16/11 (Cell F1), I can use WORKDAY(F1,(B1/A1)) to calculate that job finishes on 17/11. Say that formula goes into Cell G1.

This however leaves 2 units capacity for job B on the 17/11. The problem I have is I cant find a smart way to use the new date given in G1 to schedule the next job accurately, using the 2 units spare capacity. The easy was would be to say the start date of job B is simply G1+1 however that would then lose the 2 units spare on 17/11.

I don't even know if I'm trying to go about this the right way!

Any help appreciated.