Assume that you are a quality inspector for a manufatcuring company. Every day you take a random sample of 10 parts (items) of finished products and inpsect the items to see if there is any defective item. If you found any defective item, then you send it to the rework station for recovery. Based on the past historical data, we know that there is 15% chance that an item to be defective. There is a rework cost associated with each defective item. The rework cost is following Uniform distribution with parameters of $30 and $50. Rework Cost Uniform [30, 50] What is the total cost of reworks for a random sample of 10 parts? IF(test logic,"Yes","No") Part 1 Quality Inspection Problem Item is defective? Item needs rework? 0 0 Rework cost 0 Part 2 0 0 0 IF(test logic, "a+RAND()*(b-a)", "0") Part 3 0 0 0 Part 4 0 0 0 Part 5 0 0 0 Part 6 0 0 0 Part 7 1 1 49 Part 8 1 1 42 Part 9 0 0 0 BINOMINV(RAND(),n,p) Part 10 0 0 0 Total rework costs 92

Solid Waste Engineering
3rd Edition
ISBN:9781305635203
Author:Worrell, William A.
Publisher:Worrell, William A.
Chapter4: Mechanical Processes
Section: Chapter Questions
Problem 4.5P
Question
100%

Trying to see if I did this right or how to adjust formulas. This is not a graded assignment I have changed the values around so I can understand the formulas or if there are mistakes in the formulas to use that with my assignment.  Thank you.

Assume that you are a quality inspector for a manufatcuring company. Every day you take a random
sample of 10 parts (items) of finished products and inpsect the items to see if there is any defective
item. If you found any defective item, then you send it to the rework station for recovery.
Based on the past historical data, we know that there is 15% chance that an item to be defective.
There is a rework cost associated with each defective item. The rework cost is following Uniform
distribution with parameters of $30 and $50.
Rework Cost Uniform [30, 50]
What is the total cost of reworks for a random sample of 10 parts?
IF(test logic,"Yes","No")
Part 1
Quality Inspection Problem
Item is defective? Item needs rework?
0
0
Rework cost
0
Part 2
0
0
0
IF(test logic, "a+RAND()*(b-a)", "0")
Part 3
0
0
0
Part 4
0
0
0
Part 5
0
0
0
Part 6
0
0
0
Part 7
1
1
49
Part 8
1
1
42
Part 9
0
0
0
BINOMINV(RAND(),n,p)
Part 10
0
0
0
Total rework costs
92
Transcribed Image Text:Assume that you are a quality inspector for a manufatcuring company. Every day you take a random sample of 10 parts (items) of finished products and inpsect the items to see if there is any defective item. If you found any defective item, then you send it to the rework station for recovery. Based on the past historical data, we know that there is 15% chance that an item to be defective. There is a rework cost associated with each defective item. The rework cost is following Uniform distribution with parameters of $30 and $50. Rework Cost Uniform [30, 50] What is the total cost of reworks for a random sample of 10 parts? IF(test logic,"Yes","No") Part 1 Quality Inspection Problem Item is defective? Item needs rework? 0 0 Rework cost 0 Part 2 0 0 0 IF(test logic, "a+RAND()*(b-a)", "0") Part 3 0 0 0 Part 4 0 0 0 Part 5 0 0 0 Part 6 0 0 0 Part 7 1 1 49 Part 8 1 1 42 Part 9 0 0 0 BINOMINV(RAND(),n,p) Part 10 0 0 0 Total rework costs 92
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Solid Waste Engineering
Solid Waste Engineering
Civil Engineering
ISBN:
9781305635203
Author:
Worrell, William A.
Publisher:
Cengage Learning,
Fundamentals Of Construction Estimating
Fundamentals Of Construction Estimating
Civil Engineering
ISBN:
9781337399395
Author:
Pratt, David J.
Publisher:
Cengage,
Engineering Fundamentals: An Introduction to Engi…
Engineering Fundamentals: An Introduction to Engi…
Civil Engineering
ISBN:
9781305084766
Author:
Saeed Moaveni
Publisher:
Cengage Learning
Construction Materials, Methods and Techniques (M…
Construction Materials, Methods and Techniques (M…
Civil Engineering
ISBN:
9781305086272
Author:
William P. Spence, Eva Kultermann
Publisher:
Cengage Learning
Materials Science And Engineering Properties
Materials Science And Engineering Properties
Civil Engineering
ISBN:
9781111988609
Author:
Charles Gilmore
Publisher:
Cengage Learning
Residential Construction Academy: House Wiring (M…
Residential Construction Academy: House Wiring (M…
Civil Engineering
ISBN:
9781285852225
Author:
Gregory W Fletcher
Publisher:
Cengage Learning