Profiling Actual v Planned savings - 2007

• Tuesday, April 24, 2012 9:18 PM

   

   
  

  0

  Dear All – any views / guidance on the following I am trying to do would be greatly appreciated.

  I have a project that is expected to create savings of £620,000

  It is expected that the tasks associated with the project will create a savings profile of:

  Apr (£50K), May (£80K), Jun (£80K), Jul (£30K) Aug (£70K), Sep (£30K), Oct (£10K), Nov (£10K), Dec (£50K), Jan (£90K), Feb (£50K), Mar (£70K)

  The finance Dept will provide me with the savings as they are ledgered each month end and so I will have as set of actual savings against the project.

  I appreciate that MS Project is not a finance system.  The tasks in the project are important for me to assess and manage the likelihood of savings delivery.  However, is there a way of me associating the planned (and then actual) financial profile with the project?

  There is a possibility of numerous savings projects like this one being created and so the firm anticipate being able to merge up the info into a cost improvement programme.  Keeping this in one system / area is therefore attractive.  We have access to an enterprise project environment.

  The alternative is spreadsheets linked to project files and then merging the spreadsheets each month. Not very elegant.

  Best wishes,

  Chris.

  • Reply
  • Quote