I want to understand the best way to run a simulation in excel.
Input data:
Client orders (normal distribution, time of order placement is random over 24 hours).
1 order is a box (it contains 10 items).
Step 1:
Compare to Inventory level, do we have over 10 items? If yes > go to step 2, otherwise, wait in queue
Step 2:
Is Machine 1 busy? If not, go to machine 1, otherwise, wait in queue
Step 3:
If machine 2 busy? if not, go to machine 2, otherwise, wait in queue. After machine 2 - production complete.
So, I want to simulate how much time will orders on average spend in production (from order to completeness).
Machines 1 and 2 will take normal distribution time for each order (so it might vary).
Any help is appreciated.
Input data:
Client orders (normal distribution, time of order placement is random over 24 hours).
1 order is a box (it contains 10 items).
Step 1:
Compare to Inventory level, do we have over 10 items? If yes > go to step 2, otherwise, wait in queue
Step 2:
Is Machine 1 busy? If not, go to machine 1, otherwise, wait in queue
Step 3:
If machine 2 busy? if not, go to machine 2, otherwise, wait in queue. After machine 2 - production complete.
So, I want to simulate how much time will orders on average spend in production (from order to completeness).
Machines 1 and 2 will take normal distribution time for each order (so it might vary).
Any help is appreciated.
