Thursday, January 24, 2008

Data Analysis Term Paper

In our search for takt time, Allison Kennedy, a Memorial University Naval Architecture student, wrote a final work term paper on, "Lean Principles in a Marine and Shipbuilding Engineering Environment."

This detailed analysis used data collected from past projects at Genoa and tested theories of production rates existing in the marine engineering design field. This is something we've been working on as a R&D project and I've referred to it in past blog postings.

While the entire paper most accurately describes the process and findings, the following is a summary of Allison's conclusions and next steps.

It doesn't read like a John Grisham novel but contains some valuable information.

Ken Hogan
Lean Guy at Genoa

"Lean Principles in a Marine and Shipbuilding Engineering Environment"

Conclusions
Implementing lean into a virtual marine and Shipbuilding Company is not a straightforward process. There are no physical objects to count or measure in order to determine the production rate. It is still unknown if a valid production rate can be determined by analyzing accumulated data from past projects. This may be an aspect contributing to the fact that there are hardly any similar companies worldwide that have attempted to implement lean. Since there are no guidelines to follow, the process is deemed as research and development and this adds to the level of difficulty of the problem.
There were a total of six tests completed using the accumulated data from past projects in an attempt to determine a valid production rate. Five of these tests were based on the same idea, which is to use the collected data to find parts per volume and parts per hour value. These general values were used to determine the number of completion hours required to complete future projects. The first step taken was to determine the calculated number of parts by multiplying the calculated parts per hour value by the known volume. Next, the number of completion hours could be found by dividing the calculated number of parts by the calculated parts per hour value.
Tests one through five grew increasingly more detailed in attempt to determine a smaller completion hour variance. The first test was general and determined ppv and pph values from analyzing the entire data set. The second test divided the data based on ship type assuming that similar ship types would have similar ppv and pph values. Test five was the most detailed test in which the data was split into ship type, ship section and ship length. The outliers were also removed in this test. The results prove that as the testing process moves forward, the completion time variance between actual and calculated values becomes smaller. Test five provides the best results having a variance of approximately 23 percent. This variance is still high and therefore the production rate calculated would not provide beneficial results. However, one must note that the results are continually improving as testing continues. This is a positive factor, which gives hope that an accurate production rate can be achieved.
Test six was based on the determination of a volume per hour value from the analysis of vessels of similar types. The idea for this test was sprung from the thought that additional inaccuracies are introduced from the calculation of a number of parts and that this uncertainty was introduced into the calculated number of completion hours. The method used in test six is more direct than that of tests one through five because the completion hours are calculated in a single step. The results of test six are poorer than that of test five. The barge results of test six are compared to the results of test five since test five was completed only on barges. It can be seen that test six produces a variance that is higher by approximately ten percent. This was the first test completed using the volume per hour method, further testing will undoubtedly determine a closer approximation.

Recommendations
There are a number of recommendations which should be taken in order to develop the most efficient and effective method of completion time determination. These are all outlined below for review and consideration:
1. The validity of data should be studies to determine usefulness. As discussed, old data is less valid than newer data for various reasons. A study could be completed to test variations in new and old data and remove any old data which falls out of a certain range.
2. Data capture process should be more accurate. A process should be put in place so that employee time recording must be done at the end of each day. This will decrease the chance that time is allotted to the wrong task and increase the validity of the collected data.
3. There should be consideration put into performing an analysis based on the input of design drawings received from the client. Some details contain less detail causing more PM, set up, modeling etc.
4. An analysis should be done in which the actual hours worked are compared to bid hours. This will give an idea of the variations in bid and actual hours.
5. Additional columns should be added to the ‘Time Estimation’ spreadsheet to ensure the user compares the vessels, which are indeed the most similar. For example the overall length, draft and hull form coefficients should be displayed for each of the completing vessels so that they can be compared with the proposed vessel.Research and development should continue in this area so that an efficient and effective method of determining completion time can be found.