Question

Problem: At the K&W Computer Company, Computers are produced in a four-stage process. Products are inspected following each stage, with percentage yields (on average) of good-quality, Work-in-process units as follows:

Average Percentage

Stage 1 2 3 4

Good Quality 0.91 0.85 0.95 0.89

2. The Company wants to know the daily product yield (Y) for product inputs of 100 units per day. Furthermore, it would like to know how many input units (I) it would have to start with each day to result in a final daily yield of 100 good-quality units. All answers must be displayed in a Word file for responses and an Excel file for calculations and submitted through D2L to receive full credit

I need the answers as well as how it would be solved in Excel.

Answer 1

Stage 1 2 3 4 Average percentage grad quality 0.91 .085 0.95 0.89 A) a yield for 150 units day? Yield = Input times G_1 times G_2 times G_3 times G_4 = 100 times 0.91 times 0.85 times 0.95 times 0.89 = 65.39 Rightarrow 65 computers b) product of input ? Let product input be x yield = Input times G_1 times G_2 times G_3 times G_4 = 100 = x times 0.91 times 0.85 times 0.95 times 0.89 x = 100/0.91 times 0.85 times 0.95 times 0.89 = 152.9 Rightarrow 152 computer