Tracking Cost of Contract Labour on a project, for 3/4 mth contrac

Hello,

I am trying to track Project Costs for a client 'after the fact' so to 
speak. The project has ended, and the client wishes to determine what their 
actual Costs for their Staff were. Over the course of the project which 
lasted from 2006 to 2008, the client hired some specialists for specific 
periods of time to work on various tasks.

So there are specific dates where these Staff members would be present as 
Resources, and others where they would not.

Sometimes this happens in the middle of a Task, and some of these tasks can 
be lengthy.

i.e. if Mark is assigned to the Task Develop Space Standards, and this task 
takes 5 months from 1st January to 1st of June. Mark comes into the Project 
on the 1st of February, and leaves on the 1st of May.

I want to track Mark's Cost on the project for that particular phase for the 
1st of February to the 1st of May.

On the 1st of May Jane entered the project, at a different Salary Rate. So I 
would need to track her from the 1st of May to the end of the project.

I know that there is Working Time, and Non Working time in the Resource 
Calendars. But I'm not sure that's the right way to go about it.

I can Assign both Mark and Jane as Resources for that task, and then add 
massive blocks of Exceptions between specific Dates.

For Mark that would be from the start of the project 1st January to when his 
contract started on the 1st of February . Then another massive exception from 
the 1st of May when his contract ended to 1st of Jan 2023 (past the end of 
the project)?

I thought there must be an elegant way to setup Temporary Resources for 
Staff, or to represent people on fixed length contracts, say three months or 
four months.

How would I do this quickly and easily? Is setting these massive Exception 
Periods really the best way to represent these 'Temporary' resources?
0
Utf
3/21/2010 1:13:01 PM
project 1276 articles. 0 followers. Follow

2 Replies
659 Views

Similar Articles

[PageSpeed] 8

Create a task.  Assign both Mark and Jane to the task.

Go to the Task Usage View.  Add Actual Work to the right by right-clicking 
and picking it from the available options.  Zoom out so that each cell represents 
a single month.  Plug in the Actual Work for each resource for the appropriate 
month.  Afterwards, go to the table on the left, and make sure that Remaining 
Work = 0 for each of the assignments.

You might be better off doing all of this in Excel however.  MS Project isn't 
really intended to be an acounting program.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

> Hello,
> 
> I am trying to track Project Costs for a client 'after the fact' so to
> speak. The project has ended, and the client wishes to determine what
> their actual Costs for their Staff were. Over the course of the
> project which lasted from 2006 to 2008, the client hired some
> specialists for specific periods of time to work on various tasks.
> 
> So there are specific dates where these Staff members would be present
> as Resources, and others where they would not.
> 
> Sometimes this happens in the middle of a Task, and some of these
> tasks can be lengthy.
> 
> i.e. if Mark is assigned to the Task Develop Space Standards, and this
> task takes 5 months from 1st January to 1st of June. Mark comes into
> the Project on the 1st of February, and leaves on the 1st of May.
> 
> I want to track Mark's Cost on the project for that particular phase
> for the 1st of February to the 1st of May.
> 
> On the 1st of May Jane entered the project, at a different Salary
> Rate. So I would need to track her from the 1st of May to the end of
> the project.
> 
> I know that there is Working Time, and Non Working time in the
> Resource Calendars. But I'm not sure that's the right way to go about
> it.
> 
> I can Assign both Mark and Jane as Resources for that task, and then
> add massive blocks of Exceptions between specific Dates.
> 
> For Mark that would be from the start of the project 1st January to
> when his contract started on the 1st of February . Then another
> massive exception from the 1st of May when his contract ended to 1st
> of Jan 2023 (past the end of the project)?
> 
> I thought there must be an elegant way to setup Temporary Resources
> for Staff, or to represent people on fixed length contracts, say three
> months or four months.
> 
> How would I do this quickly and easily? Is setting these massive
> Exception Periods really the best way to represent these 'Temporary'
> resources?
> 


0
Andrew
3/21/2010 2:48:08 PM
I've determined that if I create a single Task lasting for 3 months, and a 
resource that is only working for 1 month is assigned, Project tracks the 
Cost of that resource as though it worked for 3 months.

What I thought would happen is if I assign Three Resources to the project, 
and One of them, Mark, is available for 1 month that the Cost for Mark for 
that Task would be just 1 month.

Instead, Project is showing me a Cost for the Resource Mark as though Mark 
would work for a full 3 Months.

I have Mark's Availability set from the 1st of the month to the end of the 
month...so why is it calculating Cost for a full 3 months for the entire task?

0
Utf
3/21/2010 3:17:01 PM
Reply:

Similar Artilces:

CRM 4.0 Client Upgrade
Running Vista SP1 with Office 2007. CRM Outlook Client install runs fine then rolls back and gives error messge - "installation is not completed because of errors..." - here is the log file below - can anyone help ?? Log Name: Application Source: MsiInstaller Date: 5/20/2008 1:35:54 AM Event ID: 1033 Task Category: None Level: Information Keywords: Classic User: DK\Carl.D Computer: dkarhl123.dk.martin.local Description: Windows Installer installed the product. Product Name: Microsoft Dynamics CRM 4.0 for Microsoft Office Outloo...

Template Wizard with Data Tracking
I have been using this add-in just fine for about a year, gathering data from about 20 users onto an Excel Database by having them all use the template. But I recently made some changes and then began having the following problem: After a worksheet has been created using the template, and saved as a new record in the database, and then we want to go back in to change the record and update it in the database, the option does not appear to update the database; the only options continue to be to create a new record or to proceed without saving to the database. It is as though the sys...

Message Tracking #6
What is the best way to check if your exchange sometimes doesn't accepts mail (delay) or doesn't send mails correctly (delay) Message Tracking ? But how do you actually do this Kind regards Guillaume Coign� "Guillaume Coign�" <guillaume.coigne@trust-it.be> wrote: >What is the best way to check if your exchange sometimes doesn't accepts >mail (delay) or doesn't send mails correctly (delay) Message Tracking ? >But how do you actually do this Assuming you're asking about messages leaving your organization, the SMTP protocol logs are the place to ...

Track Changes compatibility between versions of Excel
I'm planning to undertake a project which involves Excel sheets created in Excel 2003 and tracking the changes made to those sheets via Excel 97. Does anybody know of any problems with the compatibility of this function? This would help me out a lot. Thanks. ...

How do I track half days in the attendance tracking template?
I've just created an attendance tracking template in Excel, however realized that there isn't an option to track half or quarter days taken off. Does anyone have any suggestions? A lot depends on how you've laid out the data. Instead of tracking whole days, can you track hours? 8 for a full day, 4 for a half day, etc. ...

How #4
I'm coming to my third month now using MS Money 2006 and I must say I found it really great and interesting, tracking where my money is going. It is a fantastic tool, especially during the Christmas season. Here's my question..my wife and I contribute to RRSP (Canada, similar to 401K) and I track the contribution from the pay to the Investment Accounts. For these 3 months, the accounts were out of sync expect for the cash contributions. Last week, I organized all these accounts by using the Account Update to adjust the unit prices and quantities and assigning ticker symbols to the Inv...

Tracking GST/VAT in MSMoney Standard
I'm new to Money & processing small business accounts. Had no problems tracking & reporting VAT in Quicken & havegot Money to calculate VAT with each relevant entry. Somehow just not finding a report that shows VAT totals, taxable income etc. Please HELP!!!!! ...

Starting over #3
I have been using MM since 1996. Over the years, and after many corrupt files, I started opening a new Money file at the beginning of each year. I have been doing this for four years now. Any input on this approach, or other viable methods, would be greatly appreciated. Needless to say, this creates a lot of work. But after compiling four or five years worth of financial data on one Money file, and having it become corrupted, can also create a lot of work. Would it be better to create a new file and then import the data from the preceeding years file into it? Should I just continu...

Outlook 2000: Any way to track Calendar access
I've opened up my Calendar for anyone to read in Outlook 2000. Is there any way to track who accesses it? ...

How to track meetings for a task?
How would you suggest to charge meeting time to a my Timesheet task? TIA! Depends on if it's a planned meeting or informal. I typically just create a bucket task through the entire schedule for "Meetings" or book it to PM time. You may also opt to create a distinct line item bucket task for status meetings as opposed to other ad hoc meetings. If it's a big phase gate meeting, I may list that specifically as a line item, but for anything less than that, it becomes too granular for effective management. - Andrew Lavinsky Blog: http://blogs.catapultsystems...

4.0 VPC image expires April 2009
The latest Microsoft VPC image for CRM 4.0 is set to expire April 2009. This is invaluable for ISVs such as ourselves to demonstrate CRM to potential clients especially using customisations particular to that client. Are there plans to replace this with a new VPC image? regards, Paul. HI Paul, I believed Microsoft is already aware of this. :) Darren Liu, Microsoft CRM MVP Crowe Horwath http://www.crowecrm.com On Jan 13, 8:14=A0pm, Paul <lis...@gmail.com> wrote: > The latest Microsoft VPC image for CRM 4.0 is set to expire April > 2009. > > This is invaluable for ISVs s...

Error 30366 in VB code behind Visual Studio 2005 project
I'm new to using Visual Studio (2005) with VB and I've recently taken over a project started by someone else. The basic process is to retrieve a file from an ftp server, load the data into SQL Server (2005) tables, summarize the data - creating a new file to put on the mainframe. There are steps included that print reports as well. The problem is an error I get for each field when attempting to upload the data into the db tables. This is the error: Error 30366: 'Public Property BatchAgency() As String' and 'Public WriteOnly Property BatchAgency() As Stri...

track Shipment
Is it possible to set up the Track Shipment so when you click on TRACK it is automatically bring up a browser with the tracking information? For UPS what will be the URL to set up? ...

learning Excel #3
Hi, I was considering learning Excel as an additional tool for my data analysis work. Is it better to use data sets that I have previously used with SPSS and apply the same analysis tools as in SPSS? For applying the appropriate tools, I was considering using excel's online help. The second option I have is to use some excel book for data analysis and apply the techniques to data sets provided with the book. Any suggestions????? regards Metal ...

Unable to view Customizations in MSCRM 3.0 while working with IE 7
I have done the customizations on the quote entity.It works fine when i use MSCRM with IE 6.0.But when i logon to MSCRM using IE 7.0,am able to see the customizations but the the calculation part for the amount is not getting reflected.can any one help me in the subject. Thanks shashank ...

Calculate per minute cost of cell phone usage
I have a spreadsheet that I=92m trying to use to calculate the cost per minute of cellular calls. I have 3 plans (in rows 3, 4, and 5) that each provide a monthly cost (column a), and the number of minutes included in that cost (column b). There is also a cost per minute if you go over that allowance (cell E2). I have a field (cell C7) that I use to enter the average number of minutes used. I have a drop down list (cell C8) that allows you to select the plan you have. I have a formula that is currently written as: =3DSUM(((C7-C8)*E2)+A5)/C7 where: C7 =3D average number of ...

Cannot save Project file as MS Access file
I want a MS Access version of my Project file that is actively linked. I assume that since my project file consists of several sub-projects that I can get a linked Access file simply by saving the project file in MS Access format. I can save the project file as an Access file type, but then when I go to open it in Access it says unrecognizable format. I am using Access 97 and Project 2003. How can I get a linked version of my project file in database format? This being an Excel news group will probably lead to few answers about Project or Access. Here's a list to all microsoft...

3 simple(!?) problems: activate cell concequence / text formulas
Hey guys I have some minor issues on my board: 1) Are there any way to delete the cell value in range A1 when activating cell/range A2? - wanted effect is when user activates cell A2 (by click) the value / content inn cell A1 will be deleted. 2) When constructing coordinates as textstrings (X Y Z) by linking values from range B1, B2 and B3 ( the text string will not appear whit decimal format. #1. Right click sheet tab>view code>insert this. DOUBLE click to fire #2. More detail? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Address <&...

Migration fron Solomon 4.0 to Great Plains 8.0
We have a client that wants to migrate the financial applications from solomon 4.0 to Great Plains 8.0. Is there any migration tool to do this job ar any other helpful recommendations on how to do this. ...

Problem in message tracking center
when i use message tracking center to search some e-mail in our exchange 2003 server,i find that some e-mail cann't to be in the search result.For example,I sent 3 email to my stuff,and he received all. Then i tracked them in the message tracking center ,only the first email could be tracked. Thanks for ang reply! ...

excel form #3
how can i reference a row source in another excel file, has anyu one an ideas where i can find this inf -- alexander ----------------------------------------------------------------------- alexanderd's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=498 View this thread: http://www.excelforum.com/showthread.php?threadid=26586 A simple way is to allow XL to create the reference for you. And then if you wish, with the exact XL created syntax in front of you, you can revise and/or create additional ones. Open both files. Then go to <Window> <Arrange>, ...

Workflow for Supplier Costing inluding HQ
Hi, Ok lets say yo have the option chosen at your store to update the Supplier rder information from the last Purchase Order. That would mean that the Tax and Cost of the items from the last PO would update the supplier list table. You have average cost ticked so that you have as usual an average cost getting calculated and saved against the item and as you sell it. all things good. Then you do a worksheet 250 from HQ to update the discount options for an item and the next thing you know your supplier cost order details and costs have disapeared or rather have been over written from...

Service pack 3 #2
when I try to download and install service pack . receive error code Ox8007FOCC. Can not resolve problem This is too vague! What service pack? for what application? -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com "JYannucci" wrote: > when I try to download and install service pack . receive error code > Ox8007FOCC. Can not resolve problem ...

countif function #3
Hi, Would need your help with one issue. I want to count the all numbers between a range. I have used for instance this following formula =COUNTIF(O$5:O$104;">="&200) It gives me how many of my cells contain a number over 200. How would I do if I want to count cells between for instance 100 and 200? Using some IF and AND operators? Thank you so much in advance. best regards, Mark Mark, Two ways =COUNTIF(O$5:O$104;">=200")-COUNTIF(O$5:O$104;">=100") or =SUMPRODUCT((O$5:O$104;">=200")*(O$5:O$104;"<100")) -- HTH ...

Outlook calendar permissions #3
Exchange 2003 sp2 - users are a mixture of Outlook 2000-2003. We have had issues where calendar default views have been changed and users can see others calendar events. My manager wants to know if there is a way to extract all users calendar permissions so we can change those that may have this default view set to owner. Is there a 3rd party tool out there that may do this - ? Thanks NStevens@tycoint.com Get the free PFDavAdmin tool from = http://www.microsoft.com/downloads/details.aspx?FamilyID=3D635BE792-D8AD-= 49E3-ADA4-E2422C0AB424. It can manage mailbox folder permissions, as...