DFMEA "Risks" Log by Project

注目の投稿

In a recent post a user asked if anyone managed a risk log within Wrike.  I'm posting this to share how we manage risks for our own projects.

We frequently have 20+ product development projects running concurrently throughout the year.  We use a project template to kickoff each project with about 30 high-level tasks per project.  We perform DFMEAs on every project and used to just log them in an Excel spreadsheet.  However, that Excel sheet would get lost as an attachment in the sea of tasks we swim in, and makes it difficult to view DFMEA issues for multiple projects in a meeting.

To mitigate this and allow for quick access to DFMEA actions and status, I created a log folder in each project.  However, I did not want to see every task in my table, only the tasks related to DFMEAs.

I created a drop-down custom field titled CATEGORY which allows me to quickly assign a category to specific tasks for filtering.

As you can see, I have numerous categories to choose from depending on the type of reports I need to generate, but that's covered in a different post.

When logging the potential failures our products might see in use, I like to work in the Table view (New Table is my preference).  This allows me to just type and tab over as if I'm working in Excel to populate all of the other custom fields.  As you can see below, I have a workflow specific to DFMEAs, and the following custom fields: FAILURE MODE, EFFECT OF FAILURE, SEVERITY (number), CAUSE OF FAILURE, OCCURRENCE (number), DESIGN CONTROL, and DETECTION (number).  Severity, occurrence, and detection all need to be defined as "Numbers" for the custom field type to allow for report level calculations.

Now, when I run a report I can filter by Category > DFMEA and group by Parent Folder to see multiple projects at a time.

In the report, I add the calculated column "RPN" (risk priority number) which multiplies the severity, occurrence, and detection values.  

From RPN, I can determine if action needs to be taken based on our threshold criteria of 100 or greater, and sort from high to low to quickly see the status of each risk.

We can also see which projects have not had a DFMEA run yet to ensure those are addressed as well.  In the design phase of our project template, we have a workflow status that indicates we need to run a DFMEA.  This prevents us from unknowingly moving past this process.

I hope some of you find this helpful.  I would also love to hear any suggestions you have for me to improve our process.

Cheers!

3
5件のコメント
Spot On Innovative Approach Stellar Advice
Avatar
Stephen

This is insanely helpful, thank you, Trevor!

I've featured it on the Community homepage, and I'd encourage anyone reading here to let us know if you're doing something like this already, or if this has helped you, give the post a thumbs up 🙂

0
コメントアクション Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Thanks, Stephen!

0
コメントアクション Permalink
Spot On Innovative Approach Stellar Advice
Avatar

As a colleague of Trevors',allow me to give a ringing endorsement of this tool he's created within wrike!

 

 

1
コメントアクション Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Stephen

It's excellent stuff, Greg, you've a clever colleague! 😎

I've already sent the link onto our Customer Success Managers so they can direct users here to show how a Risk log like this can be achieved.

@Trevor, looking forward to reading more tips, tricks or best practices 👏

0
コメントアクション Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Wow! This is awesome. Nice work @Trevor - 

0
コメントアクション Permalink

Folllowing List for Post: DFMEA "Risks" Log by Project
[this list is visible for admins and agents only]

Didn’t find what you were looking for? Write new post