Skip to main content

VBA LAB Exercises (SimulatioModeling)

                                                 

Even Roll No.s

Write a program in VB to pick a value from the excel and sheet and print out its square root,cube root on the excel sheet. Also, check whether the number is prime or not.
 Once this task is complete take a range of values (depicting arrival of customer) from excel and generate its cumulative frequency and using a rand function  generate arrival distribution

Odd RollNO.s

Write a program in VB to pick two values from the  excel and sheet and print out their addition and multiplication results on the excel sheet.  Also, check whether the sum of number is even or odd
 Once this task is complete take a range of values (depicting arrival of customer) from excel and generate its cumulative frequency and using a rand function   generate arrival distribution.  Simulate this process for generating arrival of 100 customers.
1. 

Assignment    

 Generate a set of random numbers taking input seed from the user
2.       Generate the arrival  data for set of customers to the grocery shop given that the arrival follow poisson distribution with mean M
3.       Create a program in VB to calculate mean and srtandard deviation for the given data


           Take input in excel sheet and display the output in the excel sheet itself.
4.       Take  100 arrival data from user. Determine skewness of data using the skewness  formula

5.       Generate simulation table for Single server grocery shop problem in VBA range of values from excel sheet 
Labels:

Comments

Post a Comment

Popular posts from this blog

Advantages and Disadvantages of EIS Advantages of EIS Easy for upper-level executives to use, extensive computer experience is not required in operations Provides timely delivery of company summary information Information that is provided is better understood Filters data for management Improves to tracking information Offers efficiency to decision makers Disadvantages of EIS System dependent Limited functionality, by design Information overload for some managers Benefits hard to quantify High implementation costs System may become slow, large, and hard to manage Need good internal processes for data management May lead to less reliable and less secure data
1 comment
Read more

Inter-Organizational Value Chain

The value chain of   a company is part of over all value chain. The over all competitive advantage of an organization is not just dependent on the quality and efficiency of the company and quality of products but also upon the that of its suppliers and wholesalers and retailers it may use. The analysis of overall supply chain is called the value system. Different parts of the value chain 1.  Supplier     2.  Firm       3.   Channel 4 .   Buyer
Post a Comment
Read more

Big-M Method and Two-Phase Method

Big-M Method The Big-M method of handling instances with artificial  variables is the “commonsense approach”. Essentially, the notion is to make the artificial variables, through their coefficients in the objective function, so costly or unprofitable that any feasible solution to the real problem would be preferred, unless the original instance possessed no feasible solutions at all. But this means that we need to assign, in the objective function, coefficients to the artificial variables that are either very small (maximization problem) or very large (minimization problem); whatever this value,let us call it Big M . In fact, this notion is an old trick in optimization in general; we  simply associate a penalty value with variables that we do not want to be part of an ultimate solution(unless such an outcome is unavoidable). Indeed, the penalty is so costly that unless any of the  respective variables' inclusion is warranted algorithmically, such variables will ...
Post a Comment
Read more