We still couldn’t find our tape measure after two weeks of looking and in the meantime we received boxes from Amazon that our relatives sent us for the Holidays. The pile of the empty boxes that my wife stacked in the living room on top of the existing mess affected my motivation for continuing our project, so I tried to ignore the mess until after the holidays.
Your comments and ‘Likes’ encouraged us (Thank you very much), so now we’ve decided to resume the project. I finally got rid of the overwhelming tower of boxes but we were still looking our tape measure. In fact my wife found it in the kitchen tools drawer. She felt this entitled her to claim that my method of organization (putting things in a specific place) was faulty and that her method of putting things where they made sense at the moment was better. I told her that it simply meant that we hadn’t organized things enough and should keep going with our project. Motivating your project team is very important but challenging sometimes.
I even almost forgot why we were looking for the tape measure. After reviewing my previous post I was reminded of why I needed the tape measure, which was to calculate “Mess Occupation Ratio (MOR)”.
Here is how the MOR calculator that I created works:
I discussed the scope of our project (which rooms we’ll target), which we decided would be the living room, kitchen, home office and hallway. I drew a simplified room floor plan using only rectangles in the calculator (Excel) and printed it out. Then I did a walk-through of each room with the printout and drew in the messy spots, which I transferred to differently colored rectangles in Excel. Here’s what we ended up with:
The yellow rectangles are the basic floor plan and the blue ones are the mess. Clicking the ‘Mess Calculation’ button on cell L6 gives me the MOR ratio in cell N4.
The result was that 18.15%, of our target area is messy! Even though I was not supposed to discuss math with my team member (my wife), I had to tell her (I just didn’t mention the calculation process). I guess she was in a good mood because she simply replied “That’s not so bad.”
I thought that was pretty bad, actually. In Benchmarking, though, we can’t really decide if 18.15% is “Good” or “Bad”, so at some point, I’d like to get other families’ MOR to compare. However, I was certain that I could use the MOR as our CTQ (Critical to Quality) and 18.15% is our project benchmark for checking our progress.