Using Excel for Analysis

Figure [ 1 ]* Scatter Diagram (with trend lines) of the Level of Machine Manufacturing Efficiency vs. Production Batch Sizes

*vertical axis = levels of efficiency (in %); horizontal axis = batch sizes

Upon close examination of the data about the company’s production, two considerable perspectives were derived which elicited the significant factors as to where the existence of defective products could be attributed and as to what the most efficient levels of production are. On one hand, the production problem was analyzed through comparative scrutiny of the level of efficiency of each machine against production batch sizes. On the other hand, comparing the aggregate of employees’ total level of efficiency vis-à-vis the use of machines was disregarded because of the fact that each employee differs with one another in terms of frequency or the number of times of being employed to produce specific products with specific machine. Instead, employees were individually examined based on their level of efficiency on the use of specific machine in manufacturing a certain type of product by batch size.

The first perspective tackles about relationship of the production batch sizes and the percentage of defective products generated. Based on Figure 1 above, it can be deduced that the number of defective products is inversely related to the production batch sizes. In other words, as production batch size increases, the percentage of defective products significantly decreases.

Figure [ 2 ]** Table Summary of the Level of Efficiency of Machines Corresponding to Employees by Product by Batch Size of 500

**1111, 2222, 3333, 4444= Employee Code; 10, 20, 30=Product Code; 5, 6, 7, 8=Machine Code

Figure 2 implies that by batch size of 500, the most efficient level of manufacturing product 10 is .6 % which corresponds to Machine 7 operated by Employee 3333; product 20 (.8%)—Machine 5, Employee 3333; product 30 (1.2%)—Machine 7, Employee 1111.

Figure [ 3 ]**...