Microsoft Project 2007
Tracking a Project exercise
Average difficulty

This Microsoft Project 2007 TRACKING A PROJECT exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl MICROSOFT PROJECT 2007 course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: Wedding of the year - Tracking and Reporting

A full answer to this exercise is provided as part of the training course!

1) Download the files needed to start this exercise: exercise-873.zip (and click here if you experience any problems unzipping this file after downloading it).
2) Open the file in the folder shown above.
3) Update the following cost details on the project.
  • The Fixed Cost for The Dress - Pay for Dress task was actually £800
  • The standard rate for The Venue resource was £3,000
  • The standard rate for the Guest resource was £25/hr
4) Due to the increase in the cost per guest the number of Guests assigned to task 28 (The Venue - Pay Balance) should be reduced to 70.
5) Update the actual dates on the tasks as shown in Red on the diagram below.
Exercise screen-shot 2145 The view has been filtered to bring the tasks together.
6) The Venue is now booked for Sat 28/03/09 therefore The Big Day must start on this date.
7) Update the durations as shown in Red  below:
Exercise screen-shot 2146 Remember the total duration is the sum of the actual and remaining durations.
8) Update the entire project through to 22/12/08 (as if this is today's date).
9) Now use the Views, Filters and Reports to answer the following questions.
  • What % complete is the whole project?
  • How many tasks are now completed?
  • What is the variance in duration of the project?
  • Which tasks are slipping?
  • Which tasks are yet to be started?
  • What is the overall cost variance?
  • Which tasks are 'overbudget' and by how much?
10) Save the updated file as Wedding of the year in progress and close it down.

Thank you for showing an interest in this Microsoft Project 2007 training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.

All content copyright Wise Owl Business Solutions Ltd 2008.  All rights reserved..