MS Project Overallocation

Assigning a project resource to a task by percentage alleviates the problem of overallocation.  Below are two project tasks assigned to the same time period.  If they both must be completed, you have an over-allocation problem.  Over-allocation simply means that the person has been assigned too much work to perform in a given time period.  In all likelihood, they will not be able to complete the work.

 

 

Choose View, Resource Graph in MS Project to see the problem  Red bars mean the resource is overallocated for that time period.  In this case, there is double the work that is reasonably expected from the project team member.  So how do you fix that?

 

 

Here’s how to solve it:  Assign the resource to work only 50% of their hours on each task.  Assigning project team members a certain percentage of their hours reflects the likely situation on the ground.  Hald their time goes to one task and half to the other.  Let the resource figure out when to actually perform the work.

 

 

This is the new resulting project resource allocation graph.  It shows that the resource is fully allocated to 100%.

Seven Days in Utopia

The movie Seven Days in Utopia is clearly not up to Robert Duvall’s standards.  The story points were awkward and difficult to decipher.  One-shot git-er-done scenes and Karate Kid theme didn’t help.  But I managed to scrape out the movie’s arc and purpose.  It’s about faith and trust in God… and a little golf thrown in.

Buried in the poor directing was a principle that resonated with me.  Duvall’s character says, “The game of golf is about conviction.”  He continues with, “Watch out for that random idea that comes at you, that will throw you right out of your game.  Without conviction, it will make you question your game and shake your confidence.  Without confidence, you cannot win.”

It occurred to me that project management is exactly like that.  Without a clear strategy that rests on bedrock conviction, random ideas from so-called experts will shake your confidence.  You’ll chase a dozen “great ideas” from outsiders and never execute your strategy.  Although while that’s true, you must still remain open to new input.  It’s a touchy game.

Moral of the story: Develop a solid project strategy and hold your confidence.  Follow through with confidence.

Why Foundational Features Matter

Let’s say you know customers need a really complex feature, but your project team only has time for a basic implementation.  Do you wait until you have team resources to build the full implementation?  Or do you just build a basic foundational product that doesn’t actually meet any current customer requiments?

My answer: Start with the basics.  Add later.

Foundational product features are usually enough to sell the full implementation.  Customers can see that you have a percentage of what they need.  That helps them have faith in a full implementation at a later time.  They know it’s just a derivative of your current implementation.  But without something tangible to demonstrate, they won’t believe you’ll do the feature at all.

U.S. Losing Competitive Edge in Technology

The recent eWeek story regarding U.S. decline in science and technology (see below) is nothing new.  We’ve heard this same story for twenty years.  But is anyone listening?

http://www.eweek.com/c/a/IT-Infrastructure/US-Losing-Competitive-Edge-in-Technology-Science-National-Science-Board-610257/

Over the Christmas break, I did my bit to encourage passion in software development, engineering, and project management.  I mentored a college student with an Arduio board.  (See http://www.arduino.cc/)  The Arduino is a microcontroller with inputs and outputs for controlling external devices.  It’s big in university engineering departments.  Awesome, dude!

We stayed up past midnight wiring circuits and slinging C++ code to exercise the Arduino I/O ports.  In a rat’s nest of wires, LED’s flashed, speakers squealed, and relays clattered.  Cool!  When it was over, the kid had a new passion for product development and engineering principles.

Code ‘til you drop, and then do it again tomorrow!  That’s my answer to declining technology in the U.S.  And I suppose it’s also my preferred project management style.

Earned Value Increases As It Travels

Earned value (or the value you receive on your intellectual property) increases as it travels through the supply chain.  In other words, the farther an item travels from the manufacturer to the consumer, the more value it brings the manufacturer.  Consumer items change hands many times before they end up in consumer’s hands.  Each time they change hands, more money is invested, and therefore the value goes up.

Consider the illustration below.  A single egg isn’t worth much until it is developed.  Its value rises 100 times from nest to table.

Have you ever considered that software does the same thing?  It earns value as it passes from idea to developer, to QA, to packaging, to reseller, and finally to consumer.  So, the true Earned Value of a product is dependent upon its position in the supply chain, not just at the coder’s keyboard.  You account for such value by quantifying your products on their route to the consumer.

What’s the difference between ‘Duration’ and ‘Work’?

What’s the difference between MS Project ‘Duration’ and ‘Work’ fields?  The image below probably explains it all.  It’s a simple task from Microsoft Project that shows both the ‘Duration’ and ‘Work’ columns.

 

Task Duration

 

As you can see ‘Duration’ defines the calendar time that the task will be worked on, while ‘Work’ defines the number of man-hours.  In this case, Frank is scheduled to work only 40 hours over the next four weeks.  That’s only 25% of his scheduled hours.

 

Small Bites

I like keeping project tasks really, really short.  A week-long task is sometimes too long, but obviously satisfying when finished.  I also like keeping product releases very short.  A release might have only a few of these short tasks.  That ensures that the product is always within a few days of release.  Project scheduling is simpler when tasks are short.

Let’s do a meeting!

Does your company do too few meetings?  Yeah, you heard me right… too few.

If you’re like most corporate employees, you’ll answer, “Definitely not!”

Most of the scenes in the Dilbert comic are in meeting rooms.  That should tell you what Scott Adams thinks of them.  Meetings are the first signs of death in a once vibrant company.  But beware; lack of meetings may spell the same results.

Meetings done right should get your blood pumping for action.  You should go away wanting to try something new, or hoping for change, or at least inspired to follow.  Make that the aim of your next meeting!

Timesheets are boring

Why get passionate about a boring timesheet tool?  They are little more than cells and dropdown choices that collect your time and expenses.  An endless bucket.  Pointless.  Employees reluctantly fill in those monotonous little cells every Friday afternoon or Monday morning for the week prior.  Time tracking is a chore with little value.

Okay, that’s one perspective…

But have you ever viewed them as an investment?  Like pouring value into your organization that you can mine later?  Consider that for a moment.

What if you could magically predict how long your next project would take?  Or cost?  What if you could walk into the next meeting with hard evidence that your company talents are unfocused and distracted?  That you are fighting too on many fronts?  And in too many battles without clear endpoints?  Wouldn’t that be worth documenting your time for.

That’s what time tracking gives you, among other things.  Still see it as a boring chore?