Reverse scheduling

L

lk50

Hi there,

Is it possible in Ms Project to have a fixed end date and work
backwards to find out what the project start date should be.

Many thanks.
 
R

Rob Schneider

lk50 said:
Hi there,

Is it possible in Ms Project to have a fixed end date and work
backwards to find out what the project start date should be.

Many thanks.

Yes, it's possible, but you will be by definition scheduling with "as
late as possible" dates, which means that your schedule will be probably
impossible to achieve since there is no room for anything being late. A
very risky thing to do.

Instead, define a "deadline" date for the completio milestone and
schedule from the start date, let Project compute when it will get done,
and if you don't like the date it computes, then change the plan.
 
J

John

lk50 said:
Hi there,

Is it possible in Ms Project to have a fixed end date and work
backwards to find out what the project start date should be.

Many thanks.

lk50,
Yes, but although it may sound like a neat way to go about it, reverse
scheduling is very challenging. It is better to lay out the plan using
normal forward scheduling and then set one or more deadlines for various
milestones throughout the plan, including the end date. You see, once a
project starts, that's when the real fun begins - reality creeps into
that ideal plan and a lot of project management effort is required to
meet or even come close to the desired finish date.

OK, now to answer your question. Go to Project/Project Information and
set the "Schedule from" entry box to "Project Finish date". Project will
then schedule all tasks with an as-late-as-possible constraint.

Good luck.

John
Project MVP
 
D

Dave

It is although most people here would strongly counsel against doing it
as it means you throw away any of your contingency.

Look under Project/Project Information/ Schedule from Project Finish Date.
 
D

Dale Howard [MVP]

lk50 --

To add to the two excellent answers already given, here is how I would
handle your situation:

1. In your project, click Project - Project Information.
2. Click the Schedule From pick list and select the Project Finish date
item.
3. Click the OK button.

This will put Microsoft Project into "backwards" scheduling mode. As you
have been warned by the others, you should NOT leave the software in this
"backwards" scheduling mode when you finish planning the project.

4. Do all task planning for the project, including task names, WBS, task
dependencies, and task Durations (if appropriate),
5. Place a final Milestone task at the end of the project, name it Project
Complete, and link it to any predecessor task(s).

The software will show you a calculated Start date, which is the date when
you need to begin work on your project. The problem with this, however, is
that your project has no Slack. I think of Slack as "the amount of time for
things to go wrong in your project." In the real world, things go wrong.
If your project has no Slack, and then things do go wrong, your project will
finish late. So, you need a Start date that is earlier than you think you
need.

6. Click Project - Project Information again.
7. Click the Schedule From pick list and select the Project Start date
item.
8. Click the Start Date pick list and choose a date EARLIER than the
current calculated Start date (to give you time for things to go wrong).
9. Click the OK button.

Just one more thought. Hope this helps.
 
J

Jan De Messemaeker

Hi,

I've always been a bit stubborn so I'll tell you the reverse.
Don't set Project information to "schedule from finish date".
Instead, show the columns "Late Start" and "Late Finish". They show you what
you need whilst keeping the "normal" start and finish values to the early
dates.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top