Creating Queue Formulas

[Pestomania]

Hello all!

I am working on a year long-table to understand input and outputs of different machines and the effect on down-line machinery.

I can create a manual table based on cycle times, when machine 1 will kick product to machine 2 and machine 2 will send to machine 3. But I am trying to set it so that if I change the cycle time or how much is being outputted, what does that look like for the entire year. I am stumped on how to do this. I have attached XL2BB for this.

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Inputs	Machine 1	Machine 2		Machine 3	Mach 3 Overage
2	Cycle Time	7	7		3
3	Output/week	7	8		7
4	Starting Inventory		10		5
5
6
7
8
9
10
11
12
13
14
15										The highlighted field should move up/down based on the "cycle time" of the previous step (this goes for any "added inventory")
16			Added Inv	Queue	Added Inv	Queue				This highlighted field takes into account the current queue, plus the "added inventory" minus the amount that can be moved per week
17
18		7		10		5
19				10		5			Goal:
20				10		5				Make dynamic cycle times so that the "added inventory" can move up/down
21				10		5				Make dynamic output/week so that we can see dynamic changes dependent on the machine output
22				10		5				See overages or growth in a machine that maintains queue
23				10		5				Make this to where it can be adapted to more machines and cycles like below: As you can see after Machine 4, it starts using Machine 2 and 4 a few more times. I cannot figure out how to make all of this dynamic
24		7		10		5
25			7	9		5
26				9		5
27				9		5
28				9		5
29				9		5
30				9		5
31		7		9		5
32			7	8		5
33				8	8	6
34				8		6
35				8		6
36				8		6
37				8		6
38		7		8		6
39			7	7		6
40				7	8	7
41				7		7
42				7		7
43				7		7
44				7		7
45		7		7		7
46			7	6		7
47				6	8	8
48				6		8
49				6		8
50				6		8
51				6		8
52		7		6		8
53			7	5		8
54				5	8	9
55				5		9
56				5		9
57				5		9
Sheet1

Cell Formulas
Range	Formula
B18	B18	=B2
C25	C25	=B18
D18,F18	D18	=C4
D19:D24,D30:D31,D37:D38,D44:D45,D51:D52,F19:F32	D19	=D18
D25,D32,D39,D46,D53	D25	=D24+C25-C$3
D26:D29,D33:D36,D40:D43,D47:D50,D54:D57	D26	=IF(C26>0,(D25+C26)-C$4,D25)
F33:F57	F33	=IF(E33>0,(F32+E33)-E$3,F32)

Workflow:

 

[sijpie]

the flow is not very clear.
I am assumin that Machine2 can only produce if machine 1 has produced something. So if machine1 produces 7 item per cycle, then machine2 can only use 7 item , even if its output per week could be 8.

Why is machine 3 (cycle every three days) only doing something every 8 days in your schedule?