Forecasting Production

[hotkissa]

I need to calculate how many units can be produced by my team based on our inventory. We have 3 levels with 3 different goals due to the amount of time it takes to complete the units (level 1 has 120 unit goal, each unit taking approximately 3.25 minutes to complete per producer). The units need to be worked by age with the oldest first and the youngest last. Now here's where it gets a little more tricky: Level 1 producers can only produce level 1 units, level 2 can produce level 1 and 2 units (level 2 being first, then moving to level 1), and level 3 can produce all levels (first level 3, then 2, and finally 1).

With 6.5 productive hours, or 390 minutes, a day and the above conditions in consideration, how can I predict how many units each level producer will complete? (i.e. level 3 producers will complete approximately 250 units total today, level 2 will complete 400, and level 1 will complete 600)

Level	Goal (units)	Minutes/Unit	Producers
1	120	3.25	10
2	60	6.5	5
3	40	9.75	3
Inventory
Age	1	2	3	4	5	6	7	8	9	10
Level 1	200	100	400	50	800	750	380	295	1009	58
Level 2	0	300	750	80	60	204	835	195	745	809
Level 3	20	0	300	10	400	195	48	293	14	294