Project Management Knowledge Base

Go Back   Project Management Knowledge Base > Project Management Knowledge Base > Project Management

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-04-2011, 07:18 AM
Forum Newbie
 
Join Date: May 2011
Posts: 1
How to plot an S Curve On MS Project

Hi People

Please could someone assist me on how to plot an S curve on MS project or Excel?

I'm at my wits end.

I'm currently studying project management and one of the questions in my assignment is:

Based on the outcome of your calculations, i.e. cost variance is negative or positive. Use the S curve to diagrammatically illustrate your answer

Budgeted Cash Flow Amount Actual Cost variance
R 3,000.00 R 3,000.00 R 3,550.00 R 550.00
R 2,000.00 R 2,000.00 R 2,200.00 R 200.00
R 1,000.00 R 1,000.00 R 1,000.00 R 0.00
R 4,000.00 R 4,000.00 R 4,750.00 R 750.00
R 10,000.00 R 11,500.00 -R 11,500.00
Reply With Quote
  #2  
Old 05-31-2011, 11:23 AM
pmkb's Avatar
Administrator
 
Join Date: Aug 2005
Location: Cyberspace
Posts: 326
Not sure if MSP has a built in feature for it, but in general, to calculate an S-Curve, you want to graph the resources requirements for every time period.

For example, manhours/cost per day/week.

If your scheduling system can generate a histogram, you should be able to get the raw data you need for the graph.
__________________
"I love it when a plan comes together." - Colonel John "Hannibal" Smith, A-Team
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
It department mcupryk Estimating 13 12-11-2014 03:32 AM
PMP Certification Question Bank sudhirss Marketplace 0 03-17-2010 09:36 AM
Usage Scenarios of VISION Project Management MarkH Marketplace 0 03-17-2010 04:51 AM
project manager interview.please help me! ayien7 Project Management 0 10-01-2008 10:52 AM


All times are GMT -5. The time now is 03:08 AM.


Powered by: vBulletin - Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2009, Crawlability, Inc.
Copyright (c) 2005 Measuring Up. All rights reserved.