In EXEL: Solve the question by excel (Use Decision tree) and it is not considered invalid Q3. A product is manufactured by a certain automatic machine in batches of 3 items. The selling price is $10, and the production cost is $5 per item. Before each batch is produced, the machine may be adjusted by a skilled mechanic at a cost of $6 per batch. If the machine is so adjusted, there will be no defectives in the batch. If it is not adjusted, some items may be defective; on the basis of past experience, the probability distribution of the number of defectives is estimated as follows: Number of defectives in batches of 3 items Probability 0.4 0.3 0 1 2 3 0.2 0.1 Defective items may be sold as scrap for $5 each, or may be reprocessed at the following cost schedule: Number of Total reprocessed items reprocessing cost $ 6 1 2 3 10 12 Reprocessed items can be sold as good items. Should the machine be adjusted before each batch is produced? Use Decision tree. In EXEL: Solve the question by excel (Use Decision tree) and it is not considered invalid Q3. A product is manufactured by a certain automatic machine in batches of 3 items. The selling price is $10, and the production cost is $5 per item. Before each batch is produced, the machine may be adjusted by a skilled mechanic at a cost of $6 per batch. If the machine is so adjusted, there will be no defectives in the batch. If it is not adjusted, some items may be defective; on the basis of past experience, the probability distribution of the number of defectives is estimated as follows: Number of defectives in batches of 3 items Probability 0.4 0.3 0 1 2 3 0.2 0.1 Defective items may be sold as scrap for $5 each, or may be reprocessed at the following cost schedule: Number of Total reprocessed items reprocessing cost $ 6 1 2 3 10 12 Reprocessed items can be sold as good items. Should the machine be adjusted before each batch is produced? Use Decision tree