Question: I need some help with this problem. mestion 2: [25 points] Create a stochastic model in Excel for a manufacturing operation. The machine is cutting

I need some help with this problem.

mestion 2: [25 points] 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 unifome 0.50 inch thick. Two cutting processes are needed. The blanks are cut to an average width of 4&'4 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 specication for the blanks is to have volume between 46 and 49 ina. With the current procaas,r what fracb'on 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 specication? Consider at least 200 but not more than 1000 parts. Be certain to document the proposed changes on a third worksheet in H\"! workbook

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

2: (25 points) 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 1.00 inch thick....

please answer the entire question showing each step taken, cells selected, and functions used. Question 2: (25 points) Create a stochastic model in Excel for a manufacturing operation. The machine is...

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

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

Course: Facilities Layout Planning Abstract This project illustrates a full design from the scratch for the lifting jack starting from the product, process and schedule design. Followed by Flow,...

NT 5160, Fall 2015 Semester Individual Case Assignment: Cutting Edge This case was adapted from Hiller, Frederick S. & Mark S. Hillier (2014). Introduction to Management Science: A Modeling and Case...

Cutting Edge This case was adapted from Hiller, Frederick S. & Mark S. Hillier (2014). Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets, 5th ed.,...

On the profitability side, you should specifically address the following points: a) Is the cost structure of the two companies similar or different? Does the cost structure reflect their respective...

Qustion1. identify what job from duplex copiers you would use for "key job matching". Make the choice from the jobs included in the job evaluation outcomes spreadsheet you have been provided. You...

Allegheny Ludlum Steel! Question: What is your overall evaluation of Allegheny Ludlum Steel's productivity improvement program? Discuss the productivity improvement program at Allegheny Ludlum in...

Harmony Corporation manufactures and sells a single product. In preparing the budget for the first quarter, the companys cost accountant has assembled the following information: The company uses the...

Multiple Choice Questions 1. Which of the following statements regarding the traditional manufacturing environment is not true? a. Factories were organized so that similar machines were grouped...

Which of the following events would be classified as an investing activity on a statement of cash flows? a . the receigt of cash dividends on an available - for - sale investment b . the payment of...

You have just purchased an investment that generates the following cash flows for the next four years. You are able to reinvest these cash flows at 9.9 percent, compounded annually. End of year...