Examlex

Solved

A Machine Produces an Average of 500 Parts Per Day

question 60

Essay

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 BCD E F1 Initial Conditions: 2 Number of Parts:  Average 500 Stcd dev 10 Normal 3% Defective  Lo 8%Hi12% Cont. Uniform 4% Minor Defects 75% Constant 5 Cost of Minor Defect $5 Constant 6 Cost of Major Defect $20 Constant 78 UnitsProduced 5009% Defective 8.2%10 Total # Defective 4111 #WthMinor Defects 3112 Cost of Minor Defects $15513 # With Major Defects 1014 Cost of Major Defects $20015 Total Cost $355\begin{array}{|c|c|c|c|c|c|c|}\hline & \text { A } & B & \mathrm{C} & \mathrm{D} & \text { E } & F \\\hline 1 & \text { Initial Conditions: } & & & & & \\\hline 2 & \text { Number of Parts: } & \text { Average } & 500 & \text { Stcd dev } & 10 & \text { Normal } \\\hline 3 & \% \text { Defective } & \text { Lo } & 8 \% & \mathrm{Hi} & 12 \% & \text { Cont. Uniform } \\\hline 4 & \% \text { Minor Defects } & & 75 \% & & & \text { Constant } \\\hline 5 & \text { Cost of Minor Defect } & & \$ 5 & & & \text { Constant } \\\hline 6 & \text { Cost of Major Defect } & & \$ 20 & & & \text { Constant } \\\hline 7 & & & & & & \\\hline 8 & \text { UnitsProduced } & 500 & & & & \\\hline 9 & \% \text { Defective } & 8.2 \% & & & & \\\hline 10 & \text { Total \# Defective } & 41 & & & & \\\hline 11 & \text { \#WthMinor Defects } & 31 & & & & \\\hline 12 & \text { Cost of Minor Defects } & \$ 155 & & & & \\\hline 13 & \text { \# With Major Defects } & 10 & & & & \\\hline 14 & \text { Cost of Major Defects } & \$ 200 & & & & \\\hline 15 & \text { Total Cost } & \$ 355 & & & & \\\hline\end{array}


Definitions:

Self-regulation

The ability to manage one's emotions, thoughts, and behaviors in accordance with long-term goals.

Cognitive Reappraisal

The cognitive reframing of a situation to minimize one’s emotional reaction to it.

Ego Depletion

The idea that ego strength becomes depleted by extended bouts of self-control.

Implementation Intention

A strategy for goal setting that involves forming a specific plan about when, where, and how to act in order to achieve an objective.

Related Questions