This page gives a few DILO Excel templates and PowerPoint templates. Each template is made to be used according to the DILO methodology and tools page and the DILO How -To practical guide page.
As stated in these documents, we assume the people performing the DILOs are consultants, external or internal to the organisation and they present the results to a client (internal client for internal consultants).
There are two types of templates, the operational templates and the supervisor templates. Their definition are in the DILO How - To practical guide page.
We believe a good DILO template has four main features
Some of the information is purely back-end work, with intermediate calculations and some other is to be displayed in the reports (mainly the charts). They may contain elements or wordings, in particular ‘‘Non-Value-Added’, that are not always suitable to be shown to people observed or would take a lot of efforts to explain the wording.
However, it is a good practice to show some outputs, for feedback or validation purposes. Hence in our templates, the ‘Timesheet’ and the ‘Chart – public’ worksheets have non conflictual wording and information to fulfil these objectives.
The activity breakdown level of detail may depend on the objective of the DILO. In the the DILO How - To practical guide page we have defined four levels, related to the quantification importance, as recalled below:
For the Level 1 objective, we could consider having only a very simple template with two columns: activities and comments.
For the Level 2, the two minimal additional information could just be the activities times and if they are Value-Added or Non-Value-Added.
For the Level 3 and 4, a detailed breakdown of the Non-Value-Added activities is necessary.
However, we recommend to always use a detailed breakdown, both of the Non-Value-Added and the Value-Added categories, for the following reasons:
If the DILO is performed within a “Lean” project, it might be useful to identify the Muda type of each Non-Value-Added activities, the type 1 that is necessary for the customer, and the type 2 that is fully unnecessary.
By default, all Non-Value-Added activities in the DILO templates are Muda type 2.
There are standard activities that can be applied in any type of job e.g. waiting, travel, but many are specific to the job and interesting to evaluate because they may be related to a particular process e.g.” Tools / Spare parts search in store”.
Value-Added activities are in general more specific to a job than Non-Value-Added ones.
Depending on the context and the client preferences, some results (e.g. VA/NVA, VA details, NVA details) or charts (e.g. pie charts and stacked bar-charts) are a better fit than others; having a number of choices available avoids to lose time to create right one.
These templates may be used to be used under free license by anyone. If you like these templates, there are several ways you could thank us: share this page on your social media networks, write a "Powered by Wevalgo" in your reports, make good publicity of Wevalgo, or link your website (if you have one) to Wevalgo home page (www.wevalgo.com).
Applicable to most production environments and industries except for:
- roles mixing supervisory and operational activities
- roles with a lot of "passive supervision" such as a control room operator; use the template below for this case.
This template is specifically designed for a production control room operator.
Its key differences with standard operator DILO template are specific categories of activities:
Excel template for control room operator DILO
This template is specifically designed for a maintenance technician in a production environment
It can be used in most production environment and industries.
It is not designed for the following roles:
Excel template for maintenance technician DILO
This template is specifically designed for a production supervisor / Front line leader in a production environment
Excel template for supervisor DILO
Discover Wevalgo's free Lean manufacturing and Operational Excellence assessments
You can also perform a very thorough evaluation of your production management system (or your client's if you are a consultant) with our "Production Management" expert evaluations
Related Posts
By accepting you will be accessing a service provided by a third-party external to https://www.wevalgo.com/
Comments 1
Many interesting aspects, i observed. Want to share my ideas and interact with the group members.