Re: Capital, Revenue & Capital Charge Costs

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In article <D4B2A266-5380-48B4-B7DA-665EE1101C9A@xxxxxxxxxxxxx>,
Chris <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Dear All,

I'd welcome any advice on the following please. I have to do a relatively
quick scheduling and costing exercise on a 40-50 project portfolio. I have
MS Project Professional but we are not a server environment yet.

I am going to use just a single line for each of the projects and give each
a (very rough I appreciate) estimate for their duration cost and then link
the dependencies between them to get a view of relative scheduling.

I know that the (very rough again) cost of all of them running in parallel
will be above budget for a single year but through some judicious
dependencies and scheduling across financial years they may be acceptable to
my sponsors.

An issue I have is that each project has an estimate for 3 cost types:
revenue
capital
capital charges (the cost of the loan on the capital - apologies if
teaching everyone to suck eggs - not intentional)

I'll assume that the costs are pro rata'd but am happy to be advised
otherwise.

I'm just wondering what the best way to do this might be to set this up so
that I get a relatively simple view on the overall programme costs for
revenue, capital and capital charges in each financial year.

Any advice will be heartfully received.

Cheers
Chris

Chris,
First of all Project is a planning and scheduling application, not a
spreadsheet or financial application. The basic cost fields in Project
are calculated by work effort x resource rate, material cost, and/or
fixed cost (e.g. negotiated contract). Beyond that you can factor the
rate for any given resource type by using one or more of Project's 25
cost rate tables, or you can customize one of Project's spare cost
fields with a formula.

You might just consider using Project for the scheduling graphics and
then put your costing data in a spreadsheet.

John
Project MVP
.

Relevant Pages

  • Re: [PATCH 2 of 4] Introduce i386 fibril scheduling
    ... schedule a kernel thread - but there are /huge/ benefits in it. ... Of course scheduling is fast. ... The cost has _never_ been scheduling. ... It's especially true since a lot of AIO actually ends up cached. ...
    (Linux-Kernel)
  • Re: Capital, Revenue & Capital Charge Costs
    ... using a task with a fixed cost of X prorata'd over a ... duration Y then in the Cash Flow Report I got a rough view of what I wanted. ... I'd welcome any advice on the following please. ... quick scheduling and costing exercise on a 40-50 project portfolio. ...
    (microsoft.public.project)
  • Re: Capital, Revenue & Capital Charge Costs
    ... Dear John - apologies for delay in response - have been in bed with 'man' flu! ... I'd welcome any advice on the following please. ... quick scheduling and costing exercise on a 40-50 project portfolio. ... a estimate for their duration cost and then link ...
    (microsoft.public.project)
  • Re: Catch-All Task to capture remaining work performed
    ... Remember that MS Projects prime function is not accounting, it is work scheduling and cost estimating. ... If there is unaccounted work that is actually part of the project, the project plan was not done properly. ...
    (microsoft.public.project)
  • Re: Help using MSP to effectively calculate costs and manage a project
    ... He gets $400 per day and regardless of whether he works 1 hour or 5 hours or the full day, the charge is the same. ... Since Project calculates costs based on scheduled man-hours, there's no easy mechanism to bump the $50 cost of the 1 hour of his time actually scheduled for Tuesday up to the $400 he's going to bill the client for Tuesday's work, all the while showing the 3 hours he's doing Wednesday and the full workday plus a bit of overtime he's doing Thursday all at the same $400 per day utilized rate. ... Use accounting programs to solve accounting problems and scheduling programs for solving scheduling problems, picking to optimum tool for the job at hand rather than trying to get creative and hammer nails with a screwdriver. ... situation where the resource hours are counted twice. ...
    (microsoft.public.project)