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.
Chapter5: Separation Processes
Section: Chapter Questions
Problem 5.20P
icon
Related questions
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
  • SEE MORE 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