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

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
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

System Analysis and Design (SAD)

Introduction to System Analysis and Design (SAD) System are created to solve Problems. One can think of the systemsapproch as an organised way of dealing with a problem. In this dynamic world , the subject system analysis and design, mainly deals with the software development activities. This post include:- What is System? What are diffrent Phases of System Development Life Cycle? What are the component of system analysis? What are the component of system designing? What is System? A collection of components that work together to realize some objectives forms a system. Basically there are three major components in every system, namely input, processing and output. In a system the different components are connected with each other and they are interdependent. For example, human body represents a complete natural system. We are also bound by many national systems such as political system, economic system, educational system and so forth. The objective of the system demands tha...
37 comments
Read more