Estimating, Not Guesstimating Using Fixed Work, Duration, and Resources

So, we’ve built our WBS and determined our project schedule. We’re finally ready to start putting tasks into the View pane of the Microsoft Project.

In this crash course screencast, Dux recommends that the first task you put in is either a start task or an end task. Aside from that, you can put the tasks from your WBS in any order. You’ll order these things later. For the moment, list them off in whatever order you think of them (or whatever order they’re in on your WBS, or whatever). The point is, you don’t have to worry about the order of your tasks quite yet. Just plug them into the cells in any order in the “Task Name” column.

When creating my WBS, I listed things roughly in the order I needed to do them. But as I was putting my WBS items into Project, I realized I’d left an important item off my WBS list: selecting dates for the vacation. When plugging these tasks into Project, my impulse was to go back and add a row so I could put “Select dates of vacation” before “Drive to airport.” I don’t even know if that’s possible, adding a row. It looks kind of like Excel; does it behave like Excel? But I overrode my neurotic need to order my tasks properly at this point, trusting that there is a mechanism later for ordering them, and stuck “Select dates of vacation” (what would be the second item on my task list) between “Drive to airport” and “Park car in long-term parking” (considerably further down on my task list). Because Dux told me that the order doesn’t matter at this point, this is putting your brain dump (WBS) to paper, and is, at this moment in time, also a brain dump just into the software rather than on paper.

Once I got all my tasks in, I saved the file with a descriptive name because that’s how I roll.

I’ve got the first two steps of my project done in Microsoft Project 2010. I’ve defined a schedule and put my project tasks into the software. This has been remarkably easy. I’m sure there has to be some big bad something lurking around the corner to make this whole thing a lot more difficult than it has been so far.

Step three is entering estimates for each task. How long will each task take, how much work will each task take, and how many resources do you have at your disposal to get this task done? When you put in your estimates, you’re measuring three things: duration, work, and resources.

This is, obviously, a little more involved than just brainstorming all the stuff you’ve gotta do to make your project happen and throwing it into a table. You have to drill down into each task, and you want to carefully consider the amount of time, resources, and work you’re allotting to each task rather than throwing in some random number to fill in the cell so you can move on to the next thing. If you put in an inaccurate number to have anything filling that field, it will throw your whole project off.

Determining the duration, work, and resources can be tricky. It’s a whole other way of thinking, a very specialized groove into which to fit your gray matter.

Duration is how long each task will take – the starting point, the endpoint, and the points in between. If the duration of your project task doesn’t change no matter how many resources you have or how much work is going into it, this is called, handily enough, “fixed duration.”

Work is how much effort goes into making your task happen. It is generally something you can estimate based on previous experience with a similar effort: you know it’s going to take you about 20 minutes to shower in the morning because you’ve taken countless showers in your life; the work you calculate for the “cleaning self” task is 20 minutes. Work can be varied tremendously depending on how many resources you put into a task. The work estimate is the sum of how much time your resources put into the task: man-hours.  If the work is the same, no matter how many people you put on a task, it’s called “fixed work.”

Your resources are your people working on a task. (Your resources can also be material resources, but for this formula, your resources are the folks doing the work.) It will shock you that if you have the same number of resources assigned to a task, it’s called a “fixed resource.”

For each task, you can only have one fixed thing. If your duration is fixed, your resources and work are fluid. If your task is fixed work, your resources and duration are likely to change as you alter the ratios. And so forth.

It should also be noted that this whole time, I have been talking about estimating for individual tasks, not for the project. When estimating the duration, we’re estimating each task’s duration, not the project’s duration.

SharePoint Online

The cloud parts are functional components that extend your SharePoint Online environment in Microsoft 365.

Supports Classic and Modern sites for SharePoint Online/Microsoft 365

Small Business Pricing and Discounts

SharePoint

Top SharePoint Online Products

Experience greater power and savings by bundling our SharePoint apps and cloud parts.


Calendar Plus


Carousel


Employee Directory Plus


Org Chart Plus


Simple Search


Tabify


Tree View

 

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2016, 2019, 2022 – Classic Pages Only

SharePoint

Top On-Premises Only Products

Experience greater power and savings by bundling our SharePoint apps and web parts.


Calendar Plus


Data Viewer


Password Change


Password Expiration


Password Reset

 

Our team of Microsoft 365 Technology Consultants helps you get the most out of your Microsoft technology, we have the best Microsoft 365 talent to streamline your organization.

Consulting to Streamline Your Department

M365 Plus

Managed Services

Microsoft 365

Consulting to Streamline Your Department


Human Resources


Information Technology


Marketing Campaigns


Healthcare


Sales

 

Our Consultants Have What You Need

Federal Contractors