Create a stochastic model in Excel for an assembly operation. The assembly operation has been timed...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a stochastic model in Excel for an assembly operation. The assembly operation has been timed and takes an average of 15 minutes. The time variation is normally distributed with a standard deviation of 1.5 minutes. Create and plot a histogram with CDF. With the current operation, what fraction of the assemblies are completed in less than 17 minutes? Consider at least 200 but not more than 1000 production cycles. Create a stochastic model in Excel for an assembly operation. The assembly operation has been timed and takes an average of 15 minutes. The time variation is normally distributed with a standard deviation of 1.5 minutes. Create and plot a histogram with CDF. With the current operation, what fraction of the assemblies are completed in less than 17 minutes? Consider at least 200 but not more than 1000 production cycles.
Expert Answer:
Answer rating: 100% (QA)
Stochastic Model for Assembly Operation in Excel Step 1 Setting Up the Model 1 Open a new Excel ... View the full answer
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these finance questions
-
The time it takes a cell to divide (called mitosis) is normally distributed with an average time of one hour and a standard deviation of 5 minutes. (a) What is the probability that a cell divides in...
-
In the financial world, there are many types of complex instruments called derivatives that derive their value from the value of an underlying asset. Consider the following simple derivative. A...
-
A local diner is interested in understanding the flow of customers (5 pm to 9 pm). Customers arrive in parties of 1 or 2 with probabilities 0.4, and 0.6, respectively. The time between arrivals is...
-
Cindy Bagnal, the manager of Cayce Printing Service, has provided you with the following aging schedule for Cayce's accounts receivable: Cindy indicates that the $126,700 of accounts receivable...
-
A monochromatic beam falls on a reflection grating with period d = 1.0 mm at a glancing angle o = 1.0% When it is diffracted at a glancing angle = 3.0 a Fraunhofer maximum of second order occurs....
-
You are developing an instrument that measures vocational preferences (what someone wants to do for a living), and you need to administer the test several times during the year while students are...
-
Why is the distinction between general and specific indicators of eco-efficiency important for accounting in (a) ecological and (b) financial terms?
-
On January 1, 2014, the Vasquez Company ledger shows Equipment $32,000 and Accumulated Depreciation-Equipment $9,000. The depreciation resulted from using the straight-line method with a useful life...
-
Question 3 (4 points) Yoyo's is an ice cream manufacturer with an annual sales volume of 4,000 units. It costs them $2 dollars per unit and they sell at a price of $5 each. Fixed costs to run the...
-
ZIM Inc. (ZIM) is a high-technology company that develops, designs, and manufactures telecommunications equipment. ZIM was founded in Year 5 by Dr. Alex Zimmer, the former assistant head of research...
-
The following events apply to Montgomery Company for Year 1, its first year of operation: 1. Received cash of $40,000 from the issue of common stock. 2. Performed $59,000 of services on account. 3....
-
Giovanni is planning to purchase an Australian Treasury bond with a coupon rate ( j 2 ) of 4.48% and face value of $100. The maturity date of the bond is 15 May 2033. Giovanni's bond matures at par....
-
Once you have analyzed your business data, there are two questions the article by Walter (2014) recommends considering when evaluating correlations in the data: "How confident are you in the...
-
3. Suppose that MIPS had a set greater than or equal instruction with the mneumonic sge. Such an instruction might look like this. sge Rd, Rs, Rt We would define this instruction to mean: Rd= (Rs >=...
-
Bond valuation - Quarterly interest Calculate the value of a $ 5 0 0 par - value bond paying quarterly interest at an annual coupon interest rate of 8 % and having 1 4 and having 1 1 % annual rate....
-
Mountain Country Inc. sells an Xpert skateboard that is popular with skateboard enthusiasts. The following information shows Mountain Country's purchases and sales of Xpert skateboards during...
-
The following items were selected from transactions completed by the O'Donnel Co. during the current year: January 10. Merchandise purchased on account of Laine Co., $144,000, terms n/30. February 9....
-
suppose a nickel-contaminated soil 15 cm deep contained 800 mg/kg Ni, Vegetation was planted to remove the nickel by phytoremediation. The above-ground plant parts average 1% Ni on a dry-weight bas...
-
A trust officer at Pond Island Bank needs to determine what percentage of the banks investible funds to place in each of the following investments. The column labeled Yield represents each...
-
Use Holts method to create a model that minimizes the MSE for the data set. Use Solver to determine the optimal values of and . a. What are the optimal values of and ? b. Prepare a line graph...
-
Omega Airlines has several nonstop flights between Atlanta and Los Angeles every day. The schedules of these flights are shown in the following table. Omega wants to determine the optimal way of...
-
Which one of the following is an exact straight line mechanism using lower pairs? (a) Watt's mechanism (b) Grasshopper mechanism (c) Robert's mechanism (d) Peaucellier's mechanism.
-
In the epicyclic gear train shown in the Fig. \(88, T_{A}=40, T_{B}=20\). For three revolutions of the arm, the gear \(B\) will rotate through (a) 6 revolutions (b) 2.5 revolutions (c) 3 revolutions...
-
Which one of the following statements in respect of involute profiles for gear teeth is not correct? (a) Interference occurs in involute profiles (b) Involute tooth form is sensitive to change in...
Study smarter with the SolutionInn App