Using excel precision tree $,$ build amodel

q In a production operation of an electronics firm, a company manufactures V$/$O circuit chips that is used in a final assembly process. The chips, manufactured in batches sizes are either good $($ G $)$ or defective $($B$).$

q Historical data indicates that $P(G)=8$ and $P(B)=2$

q The company has the following options:

q Send the batch, $"$as is$,"$ onto the final production assembly

alt costs $$1,000$ to send good parts onto

production and $$4,000$ to send bad parts to final production $($due to rework$)$

q Rework all chips $($once reworked, all chips are good$)$

alt cost $$2,000$ to rework chips

Background Information q The company also has the option of performing inspection on a single chip in the batch to determine if it is defective or not defective

$q$ It cost $$100$ to test a chip

q The following relates to the test results

q $P(\frac{D}{G})=1$ therefore. $P(N\frac{D}{G})=9$

q $P(\frac{D}{B})=\mathrm{.}5$ therefore, $P(N\frac{D}{B})=\mathrm{.}5$

$q$ Determine the company's best decision strategy based on probability assessment and costs. Also Calculate EVSI, EVPI Gand Efficiency