Cost Loaded Schedule

[Bernie]

Is there a simple way to create a cost loaded schedule in MS Project 2000?
Does someone have a small example?

I am trying to enter a the following columns:

1. Scheduled Value (this will be an input number)
2. % Complete (this will be an input decimal number)
3. Total Amount Complete to Date ( Col.1 X Col. 2)
4. Total Amount Completed on Prior Application ( this will be an input number)
5. Amount of This Application ( Col.3 - Col. 4)

These columns would be placed in the standard Gantt Chart View and submitted
every month.

I have alteady created these coulmns (fields) and input the formulas, but
nothing calculates.

Any help that you could provide would be greatly appreciated.

 

[Mike Glen]

Hi Bernie,

Welcome to this Microsoft Project newsgroup

What are the exact formulae you placed in the columns?

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

 

[Bernie]

Hello Mike,

Thanks for responding.

Column 1 has no formula, I want it to accept my scheduled value for the task.

Column 2: I want it to accept a decimal number to represent the % complete.

Column 3: I used the buttons in the dialog box to enter: column 1 x coulmn
2. It looks like this: [scheduled value]*[ % complete]. Basically it is field
1 x field 2.

Column 4: I want it to accept a number for the previous month's billing for
that task.

Column 5 looks like this: [Total complete to date]-[previous application for
payment]

For clarification the items in [ ] are the field names. I used/renamed the
fields Number1,2,3,4,5 and added them to the standard Gantt Chart view. I put
in 25,000 in coulmn 1 and .35 in column 2 and nothing calculated in column 3.

Hope this helps you help me.

Thanks again.

Regards,

Bernie

Hope you can help.

 

[Steve House [Project MVP]]

There is an existing field named % Complete that refers to the percentage of
a task's duration that has elapsed. Perhaps there's a conflict with your
new field names and the existing fields. When I tried your example but
without renaming the fields - just using Number1, Number2, and Number3 and
defining a formula the value of Number3 as [Number1]*[Number2] using the
Tools, Customize, Fields menu it worked just fine. Also, could it be that
recalculation (Tools, Options, Calculation) has been turned off?

Be very very cautious trying to use Project to manage billings and
revenues - it is not a billing or cost accounting application and does a
very poor job trying to replace one. It's very good at doing what it is
designed to do, estimating the costs of a task in order to prepare a
"bottom-up" cost projection and monitoring your internal costs of performing
the work on the tasks, but it doesn't really have the ability to accurately
track when costs are accrued versus when they are paid for and is totally
ignorant of any revenues generated by the project or any of its components,
hence it can't even come close to generating data required for an accurate
P&L. Always remember it's designed from the git'go to help you plan and
manage the task schedule and totally ignores whether the project makes any
economic sense.

--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

Hello Mike,

Thanks for responding.

Column 1 has no formula, I want it to accept my scheduled value for the
task.

Column 2: I want it to accept a decimal number to represent the %
complete.

Column 3: I used the buttons in the dialog box to enter: column 1 x coulmn
2. It looks like this: [scheduled value]*[ % complete]. Basically it is
field
1 x field 2.

Column 4: I want it to accept a number for the previous month's billing
for
that task.

Column 5 looks like this: [Total complete to date]-[previous application
for
payment]

For clarification the items in [ ] are the field names. I used/renamed the
fields Number1,2,3,4,5 and added them to the standard Gantt Chart view. I
put
in 25,000 in coulmn 1 and .35 in column 2 and nothing calculated in column
3.

Hope this helps you help me.

Thanks again.

Regards,

Bernie

Hope you can help.

Hi Bernie,

Welcome to this Microsoft Project newsgroup

What are the exact formulae you placed in the columns?

FAQs, companion products and other useful Project information can be seen
at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP