Create a stochastic model in Excel for a manufacturing operation. The machine is cutting rectangular cube...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a stochastic model in Excel for a manufacturing operation. The machine is cutting rectangular cube blanks for a forming process. The stock material is uniformly 0.50 inch thick. Two cutting processes are needed. The blanks are cut to an average width of 4.74 inches, and are normally distributed with a standard deviation of 0.10 inches. The blanks are cut to an average length of 20.0 inches. The length of the blanks cut are normally distributed with a standard deviation of 0.10 inches. Create and plot a histogram with CDF. The specification for the blanks is to have volume between 46 and 49 in. With the current process, what fraction of the blanks are meeting the specification? What changes to the process or equipment would you recommend for 99.0% of the blanks to be within the specification? Consider at least 200 but not more than 1000 parts. Be certain to document the proposed changes Create a stochastic model in Excel for a manufacturing operation. The machine is cutting rectangular cube blanks for a forming process. The stock material is uniformly 0.50 inch thick. Two cutting processes are needed. The blanks are cut to an average width of 4.74 inches, and are normally distributed with a standard deviation of 0.10 inches. The blanks are cut to an average length of 20.0 inches. The length of the blanks cut are normally distributed with a standard deviation of 0.10 inches. Create and plot a histogram with CDF. The specification for the blanks is to have volume between 46 and 49 in. With the current process, what fraction of the blanks are meeting the specification? What changes to the process or equipment would you recommend for 99.0% of the blanks to be within the specification? Consider at least 200 but not more than 1000 parts. Be certain to document the proposed changes
Expert Answer:
Answer rating: 100% (QA)
It appears that youve posted an image with instructions to create a stochastic model in Excel for a ... View the full answer
Related Book For
Management Accounting
ISBN: 9781760421144
7th Edition
Authors: Kim Langfield Smith, Helen Thorne, David Alan Smith, Ronald W. Hilton
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
A certain wastewater treatment method is supposed to neutralize the wastewater so that the mean pH is 7. Measurements of pH will be made on seven specimens of treated wastewater, and a test of the...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
The stator of a 220-V, 60-Hz induction motor has 12-turn coils. You wish to re-wound it for working at 380-V, 50-Hz. While maintaining the flux same as of original motor, calculate the number of...
-
The Dahlia Company has two divisions, the Astor Division which started operating in 2005, and the Tulip Division which started operating in 2006. The Astor Division leases medical equipment to...
-
Simplify the expression. Assume that all variables are positive. 5 3 3
-
How would the primordial helium content of the universe have been affected if the present cosmic background radiation temperature was \(27 \mathrm{~K}\) instead of \(2.7 \mathrm{~K}\) ? What about...
-
The following events apply to Gulf Seafood for the 2016 fiscal year: 1. The company started when it acquired $60,000 cash by issuing common stock. 2. Purchased a new cooktop that cost $40,000 cash....
-
Does the City Project Meet the Pareto Efficiency Criterion? Stanley Ryan, Your Supervisor Read the following scenario and then answer the Problem Demonstration Questions below. The allocation of...
-
1. If you were Kelly, what would you tell the CFO? 2. Suppose the union insists on including one of the following stipulations in the agreement: a. No more than half of the total number of bonds...
-
a In the present case we are asked to enumerate the points in detail such that the case in terms of investigation report can be strong enough to claim the book keeper guilty of misappropriation of...
-
5. Describe the Keynesian critique of the Classical principles. Include in your answer Says Law, prices, interest rates and wages. Which U.S. political party is generally associated with Keynesian...
-
What role does "Compounding" play in the valuing of cash flows at different points in time? Explain
-
1. Scientists discover how to increase the output of oranges per tree. Show what happens in the market for orange juice.
-
Your grandparents would like to establish a trust fund that will pay you and your heirs $ 1 6 5 , 0 0 0 per year forever with the first payment 1 1 years from today. If the trust fund earns an annual...
-
What determines how much is spent on your health care: how sick you are or how much money you earn? What determines how much is spent on average in the United States: how sick people are or how much...
-
For all of your assignments in the class this summer, you will be working on a database for a local veterinary clinic. The focus on the clinic is small animals (pets) and will not provide services...
-
When is the indirect pattern appropriate, and what are the benefits of using it?
-
Describe the limitations of activity-based costing?
-
When setting prices, it is important to define the product and market correctly. Do you agree with this statement? Provide an example to illustrate your answer.
-
St Andrews Bank is currently redesigning its performance measurement system. Up until now it has relied heavily on monthly cost variance reports to control the costs in each bank branch but would now...
-
Supposing that all systems in Figure 1.27 are linear and time invariant, compute \(y(n)\) as a function of the input and the impulse responses of each system. x(n) h(n) h(n) h(n) Fig. 1.27. Linear...
-
Find one solution for each of the difference equations below: (a) \(y(n)+2 y(n-1)+y(n-2)=0, y(0)=1\) and \(y(1)=0\) (b) \(y(n)+y(n-1)+2 y(n-2)=0, y(-1)=1\) and \(y(0)=1\).
-
We define the even and odd parts of a sequence \(x(n), \mathcal{E}\{x(n)\}\) and \(\mathcal{O}\{x(n)\}\) respectively, as \[\begin{aligned}\mathcal{E}\{x(n)\} & =\frac{x(n)+x(-n)}{2}...
Study smarter with the SolutionInn App