Develop the processes before conducting the simulation

Assignment Help Basic Statistics
Reference no: EM131046007

Your recent business-to-business (B2B) implementation of a Web-based inventory tracking system is a huge success with your customer. However, the equipment continues to have reliability issues. Currently, failures seem to be exponentially distributed, with a mean of 2 days. The duration of the equipment failures is distributed as follows:

1216_8c59c516-ed72-4363-abfd-6cca535d6c88.png

To determine the time between failures, use the following CPG:
Days until next failure = -2 ln(r1)
where:
r1 = a random number (0 ≤ r1 ≤ 1).

Simulate at least 1 month of business operations in Excel. Assuming that you lose $200/hr in business and another $500/hr in customer goodwill, determine the average cost per day and the average cost per equipment failure. Use the list below to develop the processes before conducting the simulation in Excel, Crystal Ball, or another software package:

• Draw a picture or a flowchart to help identify the processes

• Develop process generators

• Set up spreadsheet headings

• Develop simulation

• Capture output using a "what if" or "define forecast" table

• Post process the results a. What statistics could you obtain from this simulation that would be of interest to your management? b. What processes could you include to develop a more accurate model?

Reference no: EM131046007

Questions Cloud

Consumer surplus derived from buying goods : In the former Soviet Union, people often resorted to black market transactions preferring them over waiting in long lines for goods and services. This fact seems to suggest that saving time is part of the consumer surplus derived from buying goods..
Laboratory management deposited : Laboratory Management deposited into its account at Pulaski Bank a check issued by Fairway Farms in the amount of $150,000. The date of deposit was February 5. Pulaski, the depositary bank, initiated the collection process immediately by forwardin..
How can modeling and simulation be used for the enterprise : The DoD builds complex architectures for all major weapons systems and has significant experience in developing systems of systems.
What is the difference between quantitative and qualitative : What is the difference between quantitative and qualitative research in terms of: Overall world view, Specific types of research designs, and Methods of sampling.
Develop the processes before conducting the simulation : Your recent business-to-business (B2B) implementation of a Web-based inventory tracking system is a huge success with your customer.
Advanced alloys recover the payment : Advanced Alloys, Inc., issued a check in the amount of $2,500 to Sergeant Steel Corporation. The check was presented for payment fourteen months later to the Chase Manhattan Bank, which made payment on the check and charged Advanced Alloy's accoun..
Discuss trends in some of these major social institutions : Discuss the group dynamics that you observed in the group setting and how these dynamics influenced the group's success (or lack thereof) in achieving its objectives.
Discuss benefits and limitations using pricing method : ACC 349 Cost Accounting - One of the pricing approaches is Cost-Plus pricing. Let's discuss the benefits as well as limitations using this pricing method. When is this method typically used and give an example.
A.c. manufacturing company as payees : On July 21, Boehmer, a customer of Birmingham Trust, secured a loan from that bank for the principal sum of $5,500 to purchase a boat allegedly being built for him by A.C. Manufacturing Company, Inc. After Boehmer signed a promissory note, Birming..

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd