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

CONCEPTUAL VIEW OF MIS

The concept is a blend of principles, theories and practices of management, information and system giving rise to a single product called MANAGEMENT INFORMATION SYSTEM . The concept of management gives high regard to the individual and his ability to use the information. MIS gives information through data analysis. While analyzing the information, it relies on many academic disciplines like management science, OR, organization behavior, psychology, etc. The foundation of MIS is the principles of management and its practices. MIS uses the concept of management control in its design and relies heavily on the fact that the decision maker is a human being and is a human processor of information. A MIS can be evolved for a specific objective it is evolved after systematic planning and design. It calls for an analysis of business, management views and policies, organization culture and the management style. The MIS,therefore relies heavily on systems theory.The systems theory offers soluti
Post a 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