People, I am developing a spreadsheet to better control the production of the factory in which I work, I do not understand much of excel and I am with a doubt that it might be simple to solve. Next, I have 35 machines available for production, and I know how long it takes for this machine to complete a production order with an X quantity, I have a list of orders, and I calculate the production time on the machine, and I would like to fit it the date of the next request based on the term of the previous one: I will show:
order 1 = 6 machines (there are 35 plus 26) starts on 04/06
order 2 = 37 machines (there are 26 left, I can start to produce simultaneous), it also starts 4/06 but as the first order it will end, on the 5th I can pick up the 6 machines to continue the order 2, and so on, it will add up these dates, so I will have a production gantt, and still in order 2 I will have 2 pending production orders (37- 35).
Any ideas on how to do it?
Thank you!