Question: please help with excels or risk solver this is the only part I need help with Instructions: Answer the following questions using the Risk Solver

please help with excels or risk solver this is the only part I need help with

please help with excels or risk solver this is
Instructions: Answer the following questions using the Risk Solver Platform (RSP) Excel add-in. A machine produces an average of 500 parts per day with a standard deviation of 10 parts. This is a normally distributed variable. The percent of defective parts ranges from 8-12%. Parts which need minor repair comprise 75% of the defective parts and cost $5 to repair. The rest of the defective parts cost $20 to repair. What formulas should go in cells B8:B15 to compute the daily cost of defective parts? A B D E F 1 initial Conditions: Number of Parts: 2 Average 10 Normal 500 8% Std dev Hi 3 LO 12% Cont. Uniform 4 75% Constant % Defective % Minor Defects Cost of Minor Defect Cost of Major Detect 5 $5 Constant 6 $20 Constant 7 8 Units Produced 500 8.2% 9 % Defective 10 Total # Defective 11 w With Minor Defects 41 31 12 Cost of Minor Defects $155 10 13 # With Major Defects Cost of Major Defects Total Cost $200 15 $355

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 General Management Questions!