Process Simulation in Microsoft VISIO
hello everyone here we want to talk about the process statistical simulation in
Microsoft Visio here we have the package we have the
software which is developed based on the VBA in the Visio so before the start you
have to enable the content of this because this is the run by macro and you
have to get access to the Microsoft to run the macro here so if you see the
yellow ribbon here you please go and enable the content by pushing this
button ok after that the Microsoft Visio is ready
to use so you have to draw your process first and after that after your draw
your process you have to insert the data for your process for example here we
have you have a simple process for a restaurant we assume that the customers
come into the restaurant sitting on the table you order their foods getting
service eating their food after that if they satisfy they will pay they will pay
bills and if they are not satisfied the restaurant strategy is to not get the
bill so they will get out just without paying any bills so this is a little
small process but as we know you will have very big or complex processes so
you can draw your process first before you drawing you please clear the data
simulation which is already here for example so first clear simulated data to
see that these are the data all data will be calm and for drying your process
you can use the whole space of the vzo in this sheet just using this sheet
please because the data the VBA is based on that
for drying your process please use these exceeds tasks or shapes for example the
entrance I want to draw another type process view for example okay I did use
these data I will use these shapers and I will draw my saree and I will draw my
process here so you can change the data for example here is not in trans to the
the washing center okay and for inserting data you have to go to the
data tab I click the shape data window for the start point you have to enter
the time average here is the time average is 5 based on the minutes for
example in the washing center each minutes one customer will come based on
the exponential distribution please remember that the entrance will be based
on the exponential distribution just this and you cannot change the
distribution you assume just exponential distribution after that you have to
insert the arrow the customer will in turn go to the washing center and
washing their cars
okay so washing is a task and for data here we should assume that the cost of
washing each car for example we have 4 human resources there for example and we
use water we use power and all other kind of the materials you use or
resources you use you have to estimate the cost the class is constant and you
have to enter it based on the dollar or base
the pond all other currency use is no matter just for example $100 is cost of
washing a car okay and after that you have to enter the time average for
washing a simple cup for example for washing a car we need 50 minutes okay 15
minutes for washing a car and you have to insert the time standard deviation
for example for estimating the time you sampling 30 data or hundreds of details
and you estimate the average is the 50 minute and after that you have to
estimate the standard deviation so the standard deviation of the washing car is
the formulas for example so you entered the data the data entrance in training
is complete for the task and after that there is a decision okay
for example customer is satisfied or you need to wash it again need for washing
the second time okay so after you put that you have to put the true
probability and this is based on the Bernoulli distribution so if it's the
true you have to go back for example
yeah and if it's not true the customer will go out okay and is it a yes you
have to say just yes or no for the decision box so if it's yes what is the
probability for example it's 95 percent of the customers needs another
washing or is just one person of the customer needs and 90% we go off so
here's the probability that you have to enter the data for the decision-making
shapes and you have to specify which is the yes arrow or no are just yes or non
that when he nothing more and the dictation it just be yes or no and the
for the task should remember that each task in this simulation is based on the
normal distribution and you cannot choose another distribution for for this
one so this is not just a normal distribution and as you can see we have
three different type of distribution one is for inference which is the based on
the exponential distribution one is the task which is based on the normal
distribution and one is for decision making which is based on the Bernoulli
distribution and we can see the true probability here is a 1 is 0.1 and you
can't change it and say to stir it just for showing the data these shape as is
just for showing the data and be aware of that if you use the task here and put
it simply there there is no data for average time or others so please do not
use them task here and just copy paste their previous tasks ok because we will
use the data for entering data and we will use the data for simulating it ok
for example you complete your process and you try it all and you insert all
the data here so you want to run the simulation for doing so you just simply
come here and put press the Run button if you press that
it's ask you for how much time you want your simulation to be run and it's based
on the minutes for example if you put one here it will be run for one minute
or if you put thirty it will be run for 30 minutes okay so for saving time I
will put half of net which will be run for 30 seconds and I press ok so after I
press ok the customer will enter into the system based on the exponential
distribution and will go to each of the tasks based on the normal distribution
and the data will field here and you can see the total cost for this activity is
3/4 and it's getting a lot and here we can see the customer will come to the
decision point and is the based on the probability they will play table or
getting out after the simulations and you will see the message here at the end
of the simulation and so that you will see ok so that you will see some data
summary data sphere as well so the total simulation time is 30 which is based on
the second 30 seconds as we put it into the input box and here we can see that
30 seconds in the simulation means that 13 minutes in the real world it's
assumed that it's the duration of the system working the weary award is 30
minutes for for example if you put 2 minutes into the input box after the
simulation you will see 60 seconds here for running the simulation and 60
minutes for the real-time simulated so the others is will the others is so
five years and we there is no need for discussing about that they took total
cost of the system and other data here we can see the zero because is a short
time after simulation it just for the 30 seconds and we cannot see the lots of
customers coming into our system and if you want to get more real data you have
to run it in the more time for example for one hour and for doing so you have
to insert the 60 minutes into the input MUX and for one hour the simulation
should run it and this one R will be 316 minutes in the real world just for that
for sure you should be patient for getting more real data in your system so
thank you for watching it I hope this video will help you on the simulation
and one more thing if you want to change the coding and the simulation calls you
should simply go to the Developer tab the Developer tab if you don't have the
Developer tab you have to go to the file option
and you can go to the customize ribbon and check the Developer tab here after
that you have to go to the visual basic and in the visual basic you will see by
click double-clicking and the issue will see the codes of the simulation all the
code here these are all free for seeing at an or using at and it's just a really
good code for studying the simulation coding the simulation in the VBA so
thanks for watching this video this video and I hope this helped you
thank you and goodbye