How to Conduct a Job Analysis and Make a Job Description【Excel Template】

This article is about how to make a job description. Because it’s necessary to know your target position’s job content, you should do a job analysis first. This article will show how to conduct a job analysis and make a job description using an Excel template.

(Duration: 7:45)

 

<< Related Posts >>

(more…)

Job Description and Performance Appraisal, which is an Employee Development PDCA Cycle 

The answer to “What tool clarifies responsibility and authority?”, would be a job description, which is a document that is commonly used to show the details about a particular position in the company. This episode will explain both a job description and performance appraisal.

(Duration: 5:36)

 

<< Related Posts >>

(more…)

How to Calculate an Adequate Inventory and Proper Order Quantity

This article introduces the type of ordering method and how to calculate the adequate inventory quantity of the regular timing & unfixed-quantity ordering method and how to calculate the proper ordering quantity from them and explain why it’s a right method with simulation.

(Duration: 8:04)

DOWNLOAD  ← Click this to download the “Proper Order Qty” Excel sample file.

 

<< Related Posts >>

(more…)

FIFO: the 4 Points Needed Thoroughly Implement ‘First In, First Out’

This article will explain the four important points needed to thoroughly implement ‘First In, First Out’. Those points are 1) “To design a process where FIFO is achieved naturally”, 2) “To make it easy to know the ‘freshness’ of your inventory”, 3) “To minimize inventory quantity” and 4) “Thorough employee education”.

(Duration: 7:22)

 

<< Related Posts >>

(more…)

How to use the T-test and F-test in a real world【Excel Function】

Today’s topic is the T-test and F-test and their Excel functions. The T-test is used to compare two data groups’ averages and the F-test is used during the process of obtaining the T-test’s result.

(Duration: 8:03)

 

<< Related Posts >>

(more…)

Use an Affinity Diagram to organize your issues/ideas.【Excel Template】

You can list up all the issues/ideas in the Affinity Diagram, organizing them by affinity and create group names easily. This Affinity Diagram is very useful when you don’t know what to do with problems or when you have a lot of unclear ideas and want to think about what to do next.

(Duration: 6:02)

DOWNLOAD  ← Click this to download the “Affinity Diagram and Prioritizing” template file.

 

<< Related Posts >>

(more…)

8D Problem Solving: Great for Process Improvement【Excel Template】

The 8D Problem-Solving is utilized in process and product improvement. I made a template for the 8D Problem-Solving. This post shows you the comparison between the 8D Method and DMAIC and explain each step of 8D on the template.

(Duration: 7:30)

DOWNLOAD  ← Click this to download the “8D Problem Solving” template file.

 

<< Related Posts >>

(more…)