1 00:00:13,420 --> 00:00:20,320 Hi, everyone, and today we have an important principle about Berita principles, the secret to success 2 00:00:20,320 --> 00:00:27,190 by achieving more, with less so Breteau principle defenders, that how to find the most important thing 3 00:00:27,190 --> 00:00:31,610 is to do the great success based on these things. 4 00:00:31,840 --> 00:00:39,570 How can 20 percent of effort for making the 80 percent of results? 5 00:00:39,700 --> 00:00:45,010 So it's called 20, 80 percent. 6 00:00:45,020 --> 00:00:53,800 OK, on the other hand, 80 percent of the result is produced by only 20 percent of effort. 7 00:00:53,880 --> 00:01:00,400 OK, so 20 percent of effort producing 80 percent of results. 8 00:01:01,010 --> 00:01:10,580 So the important here, how to find the 20 percent of the effort that forming the 80 percent of results. 9 00:01:10,870 --> 00:01:14,500 This is the question and this is the analysis. 10 00:01:14,620 --> 00:01:19,380 And this is the burrito principle and berita analysis, OK? 11 00:01:23,700 --> 00:01:32,650 So here in this chart, there are many components and we will focus on the 80 percent of this component. 12 00:01:32,670 --> 00:01:34,730 OK, and this is Berita analysis. 13 00:01:34,740 --> 00:01:41,550 There are two types of items, 80 percent items and 20 percent items. 14 00:01:41,580 --> 00:01:44,610 OK, and here is another example. 15 00:01:44,850 --> 00:01:51,040 There are two items, 80 percent items and 20 percent items. 16 00:01:51,420 --> 00:01:56,120 The question is, how can we get the 80 percent items? 17 00:01:56,220 --> 00:01:59,990 Okay, let's take a practical example from Microsoft Excel. 18 00:02:00,180 --> 00:02:09,570 And here is one example of a cost analysis with cost analysis with Berita charts, cost analysis of 19 00:02:09,570 --> 00:02:13,410 Tesla factory in USA in 2021. 20 00:02:13,410 --> 00:02:20,440 And here is a cost center, parties, the material, and here is annual cost and percentage total and 21 00:02:20,440 --> 00:02:22,380 there is a cumulative percent. 22 00:02:22,530 --> 00:02:30,180 And here is manufacture, equipment, salaries, maintenance, office lease, warehouse, lease assurance 23 00:02:30,810 --> 00:02:35,070 benefits and pensions and vehicles research. 24 00:02:35,100 --> 00:02:36,490 And here is the total. 25 00:02:36,690 --> 00:02:45,810 So based on this table, what are the most important cost centers based on that annual cost? 26 00:02:46,740 --> 00:02:51,180 The first thing after entering the data is to order the data. 27 00:02:52,250 --> 00:03:01,340 Disentangling you should calculate the percentage of the total by dividing this value. 28 00:03:02,290 --> 00:03:09,640 On the total value of the of the total value of the cost centers and here is the person and based on 29 00:03:09,640 --> 00:03:17,440 this person's order, this person is descendant from the greatest to smallest. 30 00:03:17,840 --> 00:03:27,880 And after that, calculate the cumulative percentage based on the person of total and search for 80 31 00:03:27,880 --> 00:03:28,370 percent. 32 00:03:28,390 --> 00:03:30,540 And here is the 80 percent. 33 00:03:31,000 --> 00:03:38,980 So the most important cost centers for these items are this yellow shaded items. 34 00:03:40,000 --> 00:03:40,480 Why? 35 00:03:40,630 --> 00:03:50,320 Because these items represent 80 percent of the cumulative percentage and 80 percent of the total cost. 36 00:03:50,350 --> 00:03:56,810 OK, and here is presentation of these data based on the political analysis, a chart. 37 00:03:56,920 --> 00:04:01,030 And here is the different cost items. 38 00:04:02,510 --> 00:04:11,180 And the most important items is the parties and the materials and represents about 31 percent. 39 00:04:11,210 --> 00:04:19,550 And after that, the two items represent 52 percent and so on. 40 00:04:19,550 --> 00:04:27,800 The first items are Bartis and material and manufacturing equipment, salaries, maintenance, and these 41 00:04:28,580 --> 00:04:35,190 are formulating 80 percent of the Berita chart and the cost center. 42 00:04:35,390 --> 00:04:41,840 So the most important part is, are these based on Berita analysis? 43 00:04:41,990 --> 00:04:45,740 And here is that bar chart of each cost center. 44 00:04:45,740 --> 00:04:50,920 And here and here is the quality of care of the cost center. 45 00:04:51,050 --> 00:04:53,860 OK, let's take another example. 46 00:04:55,460 --> 00:05:06,040 And here is another example about NASA NewSat and about the testing and and the problem of engines like 47 00:05:06,200 --> 00:05:08,270 Jet Propulsion Lab engines. 48 00:05:08,510 --> 00:05:15,510 And this time and this time the problem not represented in function, of course, but representatives 49 00:05:15,740 --> 00:05:18,460 of function of occurences. 50 00:05:18,590 --> 00:05:21,090 OK, occurences of a problem. 51 00:05:21,260 --> 00:05:31,160 So the first problem was transmission, failed system, miscellaneous noise drive controls other electrical 52 00:05:31,340 --> 00:05:37,610 ignition, cooling system, braking, emissions steering. 53 00:05:37,910 --> 00:05:47,000 So after entering the occurences data, just calculate that percentage based on each occurrence and 54 00:05:47,000 --> 00:05:53,600 the total number of occurrence after that, calculate the cumulative percentage based on that percent 55 00:05:53,600 --> 00:05:56,890 of total and after that search for 80 percent. 56 00:05:56,900 --> 00:05:58,760 And here is the 80 percent. 57 00:05:59,000 --> 00:06:04,880 So these parties are the most important parts of the problem. 58 00:06:04,880 --> 00:06:09,560 And here are so transmission fail system. 59 00:06:09,560 --> 00:06:19,550 Saturnus noise and driver control and other electrical are the most important causes for the problem 60 00:06:19,730 --> 00:06:24,880 because they are represented about 80 percent for this problem. 61 00:06:25,010 --> 00:06:27,470 And here is the graph representation. 62 00:06:28,160 --> 00:06:32,120 Here is the bar chart for the problem. 63 00:06:32,330 --> 00:06:41,240 And here is that commodity care for this problem and here is 80 percent and you can intersect 80 percent 64 00:06:41,240 --> 00:06:54,170 with with with the items to find that the most important items are intersecting with 80 percent from 65 00:06:54,170 --> 00:06:54,440 here. 66 00:06:54,620 --> 00:07:04,190 So just through an intersection with this curve, with 80 percent to find the most important items here. 67 00:07:04,830 --> 00:07:05,240 OK. 68 00:07:07,300 --> 00:07:13,420 That's about Berita analysis, and that's about the problem analysis with Paretta Excel template. 69 00:07:13,450 --> 00:07:16,660 I hope this lecture to be useful for you. 70 00:07:16,900 --> 00:07:17,550 Thank you. 71 00:07:17,560 --> 00:07:19,260 And see you in the next Tremblant.