In the first simulation, we made our initial decisions by calculating the average capacity of each step of the shop floor using the average capacity formula. This formula shows that average capacity of a process is equal to the average number of jobs completed divided by the average machine utilization. The results, as followed, gave us the maximum capacity of each step in the process: …show more content…
With the available data, we modeled the trend function, the standard deviation, the average growth rate and the average demand within excel. With this analysis, we predicted the future demand and the expected maximum peaks within the demand. As the simulation progressed we regularly updated this analysis with new data and looked for changes. With growing demand, we had to increase the capacity of the machines. We assumed we should order new machines at the bottleneck whenever the average demand hits our maximum process capacity. We put all the data in a regularly updated graphic and had a dashboard with the status of the simulation. Please find the final graphic